Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - erm3nda

Pages: [1] 2 3 ... 13
1
MySQL / Re: problems with databases
« on: February 09, 2016, 04:29:07 PM »
In the SQL manager menu, you got:
 List Databases and Users | List Users | Create Database | Create Database and User

So, if you created a database, you'll see it on the list, and you'll have a link at right side with "create user".

Code: [Select]
Add New User for Database: information_schema
Username: information_ (max 7 characters)
Host:
Confirm New Password: (random generator)
Confirm New Password:

So, if you created a database from user admin, database will be admin_name, and the users would be admin_name too.
Just create the pair, DATABASE AND USER, then fill that data on the Prestashop.

2
CentOS 6 Problems / Re: problems with databases
« on: February 09, 2016, 03:55:59 PM »
Avoid multiple thread creation.
Avoid sending me PM with your question too.

As you is neew user I can ommit, but the next time I'll ignore your user forever and you'll receive no help.

Please, read rules before posting.

Best regards.

3
MySQL / Re: problems with databases
« on: February 09, 2016, 03:48:16 PM »
Create databases from the CWP menu.
Once you do that, simply fill the Prestashop data and everything should be ok.

That error about populate seems = you are not using a user with perms to list databases, or = you dont assign your user to any database.
That kind of operation are handled by the panel, and you don't really need phpmyadmin to install Prestashop on your CWP.

I've work a lot of times with Prestashop, if you need support for Prestashop go to it's forum.

4
MySQL / Re: problems with databases
« on: February 09, 2016, 03:28:22 PM »
U should set the type of every item you created on the table nova_test.
Also, phpmyadmin has a tab named "Operations" that allow you to modify AUTO_INCREMENT of id, when you set them as index (auto-increment explicit).

So, that's the full SQL to create table nova_test if do not exist, then create the structure and a data row.
U can try it in that phpmyadmin full working demo. Put root at user then press enter. No passwd. http://demo.phpmyadmin.net/master/
Click the SQL tab at upper bar then paste the following code. I added also the reg_date with TIMESTAMP to show you.
U can create a secondary table with same structure and it will be updated with current date, as login monitor.

* Note that ID is default and autoincrement. You have to pass "" or NULL to make it work auto. If you run a query adding a custom number it would get it and probably crash when the counter reachs it.

Code: [Select]
CREATE DATABASE IF NOT EXISTS `venci_sss`;
USE venci_sss;

CREATE TABLE IF NOT EXISTS `nova_test` (
  `id` int(11) NOT NULL,
  `fname` varchar(100) NOT NULL DEFAULT '',
  `lname` varchar(100) NOT NULL DEFAULT '',
  `reg_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Table for testing' AUTO_INCREMENT=0;

INSERT INTO nova_test (id, fname, lname)
VALUES ("", "Ventsislav", "Krustev");

5
Updates / Re: Disable auto-updater
« on: June 05, 2015, 03:58:05 PM »
interpreting this statement "main function of the cron script is to check updates" i can know that the cron.php does more than just update haha. Don't?

main has implicit the fact of more actions inside this file.

6
Installation / Re: [Tutorial] How to configure your server
« on: June 05, 2015, 03:54:57 PM »
If it's a private network connection my question does not apply to you unless you don't trust your own provider.

7
CentOS 6 Problems / Re: Unable to remove user
« on: May 24, 2015, 05:45:10 AM »
Glad you was able to solve it.

8
Installation / Re: [Tutorial] How to configure your server
« on: May 22, 2015, 05:23:49 PM »
Really do you send backup data over FTP? Unencrypted backup data?

9
CentOS 6 Problems / Re: Unable to remove user
« on: May 22, 2015, 05:18:52 PM »
If you really deleted user and it's files, go to PHPMyAdmin and delete it.

You can enter by navigating http://your_ip/phpMyAdmin or using the SQL Services menu from CWP

Database: root_cwp
Table: user

10
DNS / Re: Adding Domain No special characters are allowed! error
« on: May 22, 2015, 05:02:51 PM »
strtolower also is welcome :D

11
DNS / Re: Removing bind ?
« on: May 22, 2015, 05:00:10 PM »
Bind:

I guess that if you don't use Bind for serve DNS you still would appreciate it as a database of your "remote" DNS entries.
Think a second on catastrophic die of the remote DNS. How would you get back your DNS zones?

The only problem of a DNS server, is the RAM it ates if it's really working, and getting data into cache.
But, you can still running it locally with no prob.

Especial note: I wrote a few lines each day on a auto_commit DNS module for http://freedns.afraid.org and dondominio.com.
So you can manage all your entries from your server and the module does the remote commit for you.
It works, but need some tweaks to release because im a newbie and dont know all CWP code (joke, right?).
Just wanna make a module ;)

Monit:

Monit is included on the most of the CentOS. I've found installed on mine, but im not sure from where it comes (i guess form the SO ovz_template) if was not from cwp.

Stop named:
CentOS (RHEL) has also services manager and you can do that:
Code: [Select]
service named stopI guess
Code: [Select]
chkconfig named off would disable too, not only stop.
And you can stop also from your new and awesome CWP webpanel :D

12
Information / Re: Multiple Websites
« on: May 22, 2015, 04:45:21 PM »
Add more domains/subdomains then point them to the folder you want to serve.

You have to do that from admin panel.

13
Apache / Re: Dont wanted to use apache
« on: May 22, 2015, 04:44:26 PM »
Totally agree with igor.

When you said that:
Code: [Select]
but I dont wanted to use apache from the web panel, just for security reason..

you is assuming that you know about security.
If you know about security you know about config files and apache too.
If you know about that and don't like the actual config, is implied that you have to do by yourself.

I don't think you can make a better install than the actual offered by CWP: Apache + Nginx + suPHP + CSF/ldf


14
CentOS 6 Problems / Re: error send mail on postfix
« on: May 22, 2015, 04:33:43 PM »
But, disabling that policy you are fully disabling SPF on your server, don't?

15
CentOS-WebPanel Bugs / Re: Cannot see the domains in the account
« on: May 22, 2015, 04:29:53 PM »
That is because the domains are splited on the account_domains and addon_domains.
I usually click on the "add subdomain" menú to get a quick list of all of them.
You can do that on many other ways like building a module, looking for *.sh functions inside cwp but not on the domain_list.


Pages: [1] 2 3 ... 13