Weird MySQL: User/pass Stops Working After A While
Mar 29, 2009
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each.
Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem.
Also on the server we have Fantastico.
View 8 Replies
ADVERTISEMENT
Jun 7, 2007
i have a VPS on which i host one of my Proxy site and nothing else (no databases, no emails, just the usual proxy files needed).
just today it stopped working it is showing the Centos Page .the URL is [url]
here are the steps that i have taken till now without success:
1. restarted the server
2. stopped and restarted some critical services like httpd etc.
3. restarted my free crappy control panel also Ravencore
but all without success
if u feel that u can help me out then can tell u my webmin root password also via PM (u must be a reputed member).
View 9 Replies
View Related
Jul 26, 2007
I have an account on my cPanel server with a cgi script in it wich works just fine under normal circumstances. I setup mod_perl and got it working just fine with the script. I edited the .htaccess file to do a 301 redirect and added the line “RewriteEngine on” and then whenever I try to access the cgi script I get:
Quote:
Forbidden
You don't have permission to access………..
If I disable mod_perl or remove the line “RewriteEngine on” from .htaccess it works fine.
In the cPanel error log I have:
Quote:
Options FollowSymLinks or SymLinksIfOwnerMatch is off which implies that RewriteRule directive is forbidden
But in htaccess I already have the line "Options +FollowSymLinks" which is part of the 301 redirect code.
View 2 Replies
View Related
Oct 1, 2007
Many, many people seem to be having the 2002 error over the past 24 hours on phpmyadmin with cpanel
Doing this edit to the config got it going for me:
[url]
View 2 Replies
View Related
Jul 21, 2014
Out of nowhere apache stops working, and I have to restart the httpd service that restablesca
The message it throws is "Service Unavailable"
The server is a CentOS Linux Centos 6.5
It has 24 cores and 24 GB RAM
These are the values ​​that I have in httpd.conf
Timeout 60
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
[Code]....
View 3 Replies
View Related
Apr 3, 2008
Recently I've upgraded my MySQL server. I connect to it via a conection from NIC to NIC (Internal IP addresses). Since the upgrade/format, I've managed to get everything back to the way it was. Everything works fine for 15-20 minutes. Then the PHP server can no longer access the MySQL server.
I tried logging in from the PHP server, I get access denied. I then tried logging in locally, on the MySQL server and I get in fine...
It's not like it's a firewall issue though, it's strange...
I tried updating PHP/MySQL to a few releases, even the RC's to no avail...
Something to note is that when I try restarting MySQL it can take 4-5 minutes, sometimes not even complete.
View 2 Replies
View Related
Jan 4, 2008
I have a phpBB forum, which uses MySQl database.
For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason.
What can cause such a frequent database failures?
Can someone attack the forum/database/server in a way that will cause the above problem?
(there is a good reason I consider this possibility very seriously)
How can I prevent futher database failures?
View 2 Replies
View Related
May 5, 2009
I keep getting weird characters such as .... in MySQL.
View 3 Replies
View Related
Apr 15, 2007
This morning my db server is acting weird.
sometime the query can go thru to the dbserver, but after refreshing 2-3 times i get mysql connect error.
any idea what is the problem, here's the link:
[url]
i dont know what to do... already restart the mysqld , reboot the server...
View 1 Replies
View Related
Jun 10, 2013
I'm using the isapi rewrite module for iis 6 which uses the exact same syntax as mod_rewrite in apache. I'm not very well versed in apache and need getting this to work asap. Basically I have a directory in our website: URL....
I need to forward this to an IP address, for example to this address:100.12.33.45/folder.While keeping the original URL (www.xyz.edu/folder). I'm unsure of the apache syntax for this.
View 3 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Jun 5, 2008
I'm trying to send mail from mysite.com (my own server), to a remote server that hosts user@remotesite.org.
From server1.myhost.com as root I ran:
Code:
exim -bt user@remotesite.org
user@remotesite.org is undeliverable: No Such User Here
From server2.myhost.com (that is located at the same rack as server1):
Code:
exim -bt user@remotesite.org
user@remotesite.org
router = lookuphost, transport = remote_smtp
host lobosuelto.arnet.com.ar [200.45.191.210] MX=5
host corderoatado.arnet.com.ar [200.45.191.211] MX=5
From server3.myhost.com (another server on another different rack):
Code:
exim -bt user@remotesite.org
user@remotesite.org
router = lookuphost, transport = remote_smtp
host lobosuelto.arnet.com.ar [200.45.191.210] MX=5
host corderoatado.arnet.com.ar [200.45.191.211] MX=5
On the three servers I'm using the exact same Exim configuration, the same name servers at /etc/resolv.conf, same cPanel Release version, but I still don't understand why at server1.myhost.comI got the error. The only difference is that at server1.myhost.comI'm running CentOS 5, instead of RHE 5.2 (server #2 and #3).
Already tried disabling Sender Verification/Callouts at Exim Config, resetting exim config to default but the error stills.
View 2 Replies
View Related
Jun 14, 2007
I was hoping someone could shed some light on a cron related issue I'm having.
I've been using linux for a while...but never really used crons.
My cron is supposed to dump a postgres db in tar.gz format every minute (for testing purposes) but it doesn't.
I opened my cron in vim via:
Code:
postgres@myhost:~$ crontab -e
And here's the cron:
Code:
* * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz
Also:
Code:
postgres@myhost:~$ ls -lah /var/www/test/postgres/
total 8.0K
drwxrwxrwx 2 postgres postgres 4.0K 2007-06-14 12:01 .
drwxr-xr-x 3 user user 4.0K 2007-06-14 11:47 ..
Running the backup command via CLI works fine.
View 5 Replies
View Related
May 5, 2009
I am having Virtuozzo vps with cpanel/WHM installed.I have created some accounts in it by setting disk quota . Now the issue is : some users are using space over the allocted one ,when i use the command quota -u (username),i can see that the users are used the space over the allocated one and they are still allowed to upload file . How to fix this issue ?
View 6 Replies
View Related
Apr 20, 2009
I am using cPanel 11 (stable release) on a CentOS 5 server and would like to make it so that a certain database can only be connected to from the cPanel user that it is under (ie. user1_db can only be connected to from the user "user1" on the same server).
View 9 Replies
View Related
Nov 13, 2008
31015 100 15 0 151m 35m 5156 S 28 0.4 379:34.10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
This is my top process, I have quad core server and because of this server load is over 10
I am using cPanel, is it possible to trace which user is using all this cpu?
View 6 Replies
View Related
Apr 21, 2009
I have installed PHP5 in my windows server (IIS6).But when I check with phpinfo() its not showing mysql extension or any details.
I have enabled the mysql extension in php.ini
View 1 Replies
View Related
May 25, 2009
How can see wich user have more mysql process?
View 2 Replies
View Related
Aug 15, 2008
how to allow user to remote mysql connection from his localhost ( in linux server with WHM )
my user wants to connect to the mysql from his localhost
View 7 Replies
View Related
Jul 5, 2007
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found.
[url]
I am running a VPS server with the following:
WHM 10.8.0 cPanel 10.9.1-S14304
RedHat 9 i686 - WHM X v3.1.0
phpMyAdmin - 2.9.0.2
MySQL client version: 4.1.10
mysql version: 5.0.27-standard
I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE".
Here's a look at the database permissions from phpMyAdmin.
Code:
User Host Password Global privileges Grant
hello localhost Yes ALL PRIVILEGES Yes
hello_ % No ALL PRIVILEGES Yes
hello_ localhost No ALL PRIVILEGES Yes
The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View 3 Replies
View Related
Jan 30, 2007
I am trying to start mysql but i am getting the following error
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]
I checked my hostname.err file in /var/lib/mysql and this is the error message it shows.
070130 17:59:41 mysqld started
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 mysqld ended
how I would repair that to get mysql to start again?
View 7 Replies
View Related
Jun 29, 2007
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security.
Here is a full list of permissions I can grant to the user (via Webmin):
-Select table data
-Insert table data
-Update table data
-Delete table data
-Create tables
-Drop tables
-Grant privileges
-Reference operations
-Manage indexes
-Alter tables
-Create temp tables
-Lock tables
View 3 Replies
View Related
Aug 26, 2007
how do i backup mysql user privileges?
this will only backup the databases:
mysqldump --opt -u root -p --all-databases > data.sql
i would like to backup mysql user privileges too.
View 1 Replies
View Related
Jun 5, 2007
I know about the general log but want to just log queries of a specific user. Our database does 400 queries/s on a slow day, so I think it would be a pain to grep though a huge log like that. And, im not sure if it would cause any preformance issues.
View 0 Replies
View Related
Aug 7, 2007
By default, mysql will create user with host as 'localhost'. Now, if I want the host is '1.2.3.4' by default, how to configure it?
View 3 Replies
View Related
Jun 8, 2005
Anyone know the commands to change a MySQL user's password via ssh?
I found stuff for changing the root password, and tried to adapt it for the user, but it didn't work.
View 12 Replies
View Related
Nov 6, 2008
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this.
I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to:
1. execute:
GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa';
[url]
2. Stop mysql server and Add in my.cnf:
[mysqld]
log-bin=mysql-bin
server-id=1
slave-compressed=1
binlog-do-db=user_main
start server[url]
3. execute:
SHOW MASTER STATUS;
we need values of colomns File and Position from output of above command[url]
So my questions are:
Is there any security risk?
Is there significant extra resource usage?
Is this even done on shared environments?
View 5 Replies
View Related
