On a cPanel server, running RHEL 4 I got the following error (from cpanel logs) while associating an user with a DB from the cPanel admin:
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa4a8768)') called at /usr/local/cpanel/bin/mysqladmin line 88
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268
In fact, from cPanel interface all privileges are added OK, but the MySQL itself is not connecting at all due to this error.
I'd want to create a user and set custom privileges using the standard mysql-client, ie. create user and grant privileges, but I know that sometimes Plesk overwrites my config files for other services.
I need a MySQL user that has the privileges to add routines and triggers. The default users that are created by Plesk do not have these rights. How would I be able to add these rights to a specific user, or all users, that doesn't care.
I already logged in over SSH as a root user:
Code: mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Then I tried to update the rights of the users:
Code: mysql >UPDATE db SET Create_view_priv = 'Y', Show_view_priv = 'Y', Create_routine_priv = 'Y', Alter_routine_priv = 'Y'; mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)
This didn't work. So I wanted to add super privileges by doing this:
Code: mysql> GRANT SUPER ON *.* TO 'user'@'%' IDENTIFIED BY 'mypassword'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)
i would like to update my CentOS Linux 5 but i don't want to update mysql and apache i need to use mysql 4. When i entered yum update i can see Total download size: 245 M i can see mysql i386 5.0.45-7.el5 base 4.1 M
how can update my server without updating mysql and apache
I can't seem to solve, perhaps you could give me some pointers or tips on how to fix this.
All the cPanel stats programs (Awstats etc..) haven't been updated since the 17th June but when I login to WHM it says the stats have been updated (within the past 24 hours).
On the 17th June I moved my hosting operations from the USA to the UK onto a new webserver.
How can I make sure these statistic programs are updated and shown from cPanel, even though I can tell it to update via SSH (completes) and claims in WHM with no problems (updated with in 24 hours), the new stats still fail to appear.
I'm trying to set permission for text file which is exists in Program Files (x86)MyFile directory. File should be accessible by psaadm and not accessible for psacln accounts. I've set permissions for psaadm Full Control Allow and for psacln Full Control Deny.
In my PHP script I'm checking file using is_readable function and no matter which user trying to read this file function always returns true (admin or customer account). I tried to find solution in Web but without success so I'd like to ask you about it.
Additionally, I've tried to create Plesk DiskSecurity XML with privileges settings. After Apply this settings privileges are correctly set for my file, but customers still can read this file.
Is there any other way to deny access to this file for customers and resellers?
I recently upgraded the Plesk to 11.5.30. Now I am not able to create new MySQL databases. I am getting below error.
Code: Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'localhost' (using password: YES)
MySQL admin details are correct in plesk database, also the admin has full privileges. I am manually able to create databases, users from mysql prompt. It's just the plesk interface that's giving error.
Code: C:Program Files (x86)ParallelsPleskMySQLbin>mysql -u admin -p*************** mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 68 Server version: 5.1.68-community MySQL Community Server (GPL)
I recently had Fantastico update issues, my fantistico was giving me errors such as "This feature is currently not availabel, please contact your host." lol
I tried lodging a CRON job to do the update ...but waited 72 hours and nothing ! lol
Later i found our that the Fantastico licensing server was down for a while lol
i just installed rpmforge repo and updated the my vps everything went fine now every thing is fine exept ftp i have tried both pure-ftp and pro-ftp both are not workingh the port 21 is used by xinetd i am not able to find out what to due the ftp installs successfully but after installations is done it give Failed on restarting stopping or starting
WHat can i do to remove this i used the status command to /etc/init.d/pureftpd status Pureftpd is dead this is what i got Pro-ftpd gives error unable to bind ip at port 21
