Weird MySQL: User/pass Stops Working After A While
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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Mod_perl Stops Working When I Use RewriteEngine On
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 Replies!
View Related
VPS Suddenly Stops Working
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 Replies!
View Related
MySQL Stops Allowing External Connections
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 Replies!
View Related
MySQL Database Service Stops From Running
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 Replies!
View Related
Mysql On The Dbserver Is Up And Down.. Weird
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 Replies!
View Related
Cron As Postgres User Not Working
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 Replies!
View Related
Disk Quota Not Working For User Accounts
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 Replies!
View Related
Weird "No Such User Here" Error
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 Replies!
View Related
MySQL Forgetting User Permissions
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 Replies!
View Related
Mysql/user Is Marked As Crashed
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 Replies!
View Related
What Are Common MySQL User Permissions
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 Replies!
View Related
MySQL Replication For User On Shared Server
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 Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
SSH Saving Login And Pass
I have 5 servers that I login to everyday and its annoying typing pass and username and server IP on putty every time I want to login. Is there client software that I can use to save Login so i can login using one click? I currently use putty
View Replies!
View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account. The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't. Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Replies!
View Related
Direct Admin :: Installation Didn't Pass, Halting Install
After installing in my vps the Direct Admin panel i got this at the end: 14:11:40 (156 MB/s) - `/etc/named.conf' saved [949/949] *** gcc is required for compiling, please install gcc (yum install gcc)*** *** g++ is required for compiling, please install g++ (yum install gcc-c++)*** *** cannot find /usr/bin/make. Please make sure that patch is installed (yum install make) *** Installation didn't pass, halting install. Cannot find /usr/local/bin/php Please recompile php with custombuild, eg: cd /usr/local/directadmin/custombuild ./build all d The first command that i was run was: yum install gcc-g++ *Default username and password for login?
View Replies!
View Related
Apache Stops Responding
I have a very strange problem. Yesterday morning I got a "server down" alert. Restarted httpd and everything run ok ... until today morning, the same problem again. Symptoms: 1. The webserver did not stop working, it just took too much time to respond. 2. I cannot find anything suspicious in the logs. 3. I started to log the number of apache processes in 4 minutes interval, it did not increase during the failure but remained at a very reasonable number. 4. Now, almost 3 hrs from the last failure, there are 36 apache processes, each eating 14M RAM, server has 4GB ram total, no swapping, almost 3GB are free (cached). The question is. How should I prepare for the expected tommorow failure, to be able finaly localise the problem?
View Replies!
View Related
Website Stops Responding
I have 3 servers ServerA(Web, mail), ServerB(MySQL+Master replication), ServerC(Mysqlslave+web) It happens that my website stops responding for few mins and then it comes back again automatically. I checked the server logs but I couldn't find any suspicious. Also, while the website is not accessible when I try to connect internally from ServerC to ServerA or ServerB using SSH. It takes lots of time (approx more than 60 seconds) to connect. When website starts working SSH is also working fine. This is very complicated for me. Can anyone let me know what should be the problem or how can I find root cause of this problem?
View Replies!
View Related
VPS Stops Running Randomly
The problem is that it switches from running to mounted without me having anything to do with it. It seems to be quite randomly, for example this morning at 1.42 am. This happens once a day and stops my vps and therefore my website - which is quite annoying. I checked for log files or anything, but there was nothing mentioning resources or anything. Does anyone have a clue what this might be? If I cannot fix the problem there is still the opportunity to just start the vps once it goes to status mounted. How would I automate this? I am using Virtuozzo and Plesk.
View Replies!
View Related
Attempt To Install RoR, Libsafe Stops Me
whenever I attempt to install RoR, libsafe stops me, how do I diable libsafe so I can install RoR, then re-enable libsafe. [root@server1 ~]# gem install rails --include-dependencies Libsafe version 2.0.16 Detected an attempt to write across stack boundary. Terminating /usr/bin/ruby-bin. uid=0 euid=0 pid=20960 Call stack: 0x4c0e6871 /lib/libsafe.so.2.0.16 0x4c0e6c5d /lib/libsafe.so.2.0.16 0x80549b8 /usr/bin/ruby-bin 0x8054a52 /usr/bin/ruby-bin 0x80556af /usr/bin/ruby-bin .....
View Replies!
View Related
Non-working Forwarding Email Account On Working Domain
I have a domain with a few forwarding email accounts that forward to mac.com email accounts... for some reason every once in a while these accounts stop working... This is the error I get when I email to that account: This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: ...
View Replies!
View Related
Weird Spamd
i have this really annoying issue i'm hoping you can help with. it seems the spamd child process gets stuck and causes 100% cpu usage. but this doens't just happen randomly, its only for this single user account. e.g. take a look at top output: 4581 <username> 93 40:58.87 1.3 82624 52m 2280 R spamd child the 93 is 93% cpu usage. 40:58 is how long the process has been running, 40 minutes and counting (i just killed it though). and all it tells me its running spamd child. it usually dies after a few hours but only after causing 200% cpu usage (100% on both cpus) and making my server load skyrocket. This happens at least twice daily at no set times. this user isn't a spammer. no scripts, no mail queue generation, no email accounts even. running cpanel 11, centos 4.
View Replies!
View Related
Weird Bind
I have a weird problem since the movement of our ip range with one of our servers. Bind doesn`t seem to react on any changes we make. For example, the server still resolves to the old ip adress while we changed all of those with ipswap.sh (directadmin) The weird thing is that all zone files are 100% Correct. Ip`s are all changed and no sign of the old ip whatsoever. Again, the nameserver still resolves to the old ip`s. Also when i create a new domain, named.conf is changed and the zone file is created sucessfully. Still the nameserver doesn`t seem to add the domain name. Restarting, reloading and even reinstalling named doesn`t help
View Replies!
View Related
Weird Characters
I'm seeing weird characters on my support home page: That's found right below "Home > Support" The source code shows the following... Quote: <tr> <td style="padding:0px"><p>Welcome to our Support Area.</p> I've checked the two template files (header.tpl and homepage.tpl) but did not find such characters. Its boggling me. Not even whitespace.
View Replies!
View Related
Weird Network
This is a very weird network issue that we are currently facing. There are 2 servers, 1.1.1.1 and 2.2.2.2; I can ping both IPs from my computer at the office or from anywhere else. BUT, I cannot ping each other. For example, I log into 1.1.1.1 and cannot ping 2.2.2.2 and vice-versa. This is very weird and I am thinking this is not OS related and something beyond that. I was wondering if anyone of you came across this type of issue and possible direct us in the right direction.
View Replies!
View Related
Weird Issue
It seems that i am facing some weird Apache issue. I cant access my forum.domain.com but can access forum.domain.com/admin I didnt found anything in Apache error logs,but found this in access logs IP HERE - - [26/Dec/2007:03:13:44 +0400] "GET / HTTP/1.0" 200 22435 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727)" Is there anything strange in that info and what does 22435 represent?
View Replies!
View Related
Weird Masked IP Result
On one of my Web sites I have it set to e-mail me whenever someone tries a SQL Injection attempt through the GET. (I find some of the results interesting and/or funny.) I also have it e-mail me the visitor's IP address and browser client. I recently got one with a result for the IP address that certainly got my interest. It read: Quote: <?php phpinfo(); echo "LOOOOL, X-FORWERD BUG"; ?> The PHP scripting I use to get the IP address is: Code: $visIP = isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR']; I guess I'm wondering how they may have done it, and if this indicates an issues where people can hack my site (for control or at least info) through this method?
View Replies!
View Related
Weird RSS Feed
I've got a vB site which has a RSS Poster Bot (fetches RSS Feeds then posts them). However, for some strange reason, it stopped working. Theres no errors in the error_log and when I do a manual run, it just times out after a minute or so. The only thing I can think of is that one of the RSS Feeds is down or one of the sites is blocking the server IP for some reason.
View Replies!
View Related
Weird Router Packet
We have a license application client(IBM/LUM) that connects to a license server outside our network. The clients works this way... it binds a random port and tries to connect to the remote IP with UDP port 1515. Through wireshark I could see that it reaches the destionation, although the way back is unreachable. If I add this random port to our router Port Forward rule, it works perfectly. Although this is not a solution cause the port is changing every time. Isnt this strange? Other applications open random ports as well and comunication is two-way reachable. If I connect directly to the internet, it works perfectly as well. What can I try to do with our ZyWall USG300 Router to fix this situation?
View Replies!
View Related
Sites Stats Seem Weird
I've a few similar video sites and haven't noticed much difference over the years with their stats. They usually average anywhere from 50-100mb downloaded per day. Suddenly this month, one site is practically going off the scale...600-700mb...up to 1gb downloaded per day...I'm like...wtf?! The other site is reporting normal BW. I'm using awstats with hotlink protection enabled. Is something or someone draining my bandwidth?
View Replies!
View Related
Weird And Yet Ironic Rebooting
I have compiled a RT kernel using 2.6.24 and it has been working great. All of our machines are runnin Centos 5. No issues like the previous configurations on Dual Quad Xeons 5335's and 8GB of RAM. As well as one box with Dual Core Xeon 5140's with 4GB of RAM. They have identical motherboards. My issue is that when you do a soft reboot, it doesn't "technically" reboot. It does, but it doesn't. Let me explain. It kills my ssh connection and you can't ping it for maybe say a minute or 2. When it comes back up, you get a new SSH key to login. You hit ok, and you try logging in. It doesn't accept any passwords. The server basically becomes inoperable. The only way to solve this is to do a hard reboot. Phsyically rebooting the server. What could be causing this? This only started to happened when using the RT kernel. Is there an option that may be conflicting with it, however our 3rd and 4th box, with the same configuration has no issues like this. Soft reboots work great. Here is the message log. Feb 19 04:00:02 server530 shutdown[25342]: shutting down for system reboot Feb 19 04:00:02 server530 init: Switching to runlevel: 6 Feb 19 04:00:03 server530 smartd[3037]: smartd received signal 15: Terminated Feb 19 04:00:03 server530 smartd[3037]: smartd is exiting (exit status 0) Feb 19 04:00:09 server530 ntpd[20917]: ntpd exiting on signal 15 Feb 19 04:00:09 server530 rpc.statd[2570]: Caught signal 15, un-registering and exiting. Feb 19 04:00:09 server530 portmap[25711]: connect from 127.0.0.1 to unset(status): request from unprivileged port Feb 19 04:00:10 server530 auditd[2469]: The audit daemon is exiting. Feb 19 04:00:10 server530 kernel: audit(1203415210.158:8204): audit_pid=0 old=2469 by auid=4294967295 Feb 19 04:00:10 server530 pcscd: pcscdaemon.c:529ignal_trap() Preparing for suicide Feb 19 04:00:10 server530 pcscd: hotplug_libusb.c:361:HPEstablishUSBNotifications() Hotplug stopped Feb 19 04:00:11 server530 pcscd: readerfactory.c:1350:RFCleanupReaders() entering cleaning function Feb 19 04:00:11 server530 pcscd: pcscdaemon.c:489:at_exit() cleaning /var/run Feb 19 04:00:11 server530 kernel: Kernel logging (proc) stopped. Feb 19 04:00:11 server530 kernel: Kernel log daemon terminating. Feb 19 04:00:12 server530 exiting on signal 15 Oh and this is to reboot the server nightly at 4am, when this issue occurs. 0 4 * * * /usr/bin/reboot > /dev/null 2>&1
View Replies!
View Related
Weird Example Of Blocking Port 25
I have a client who was sending email to another server with Cpanel, all of a sudden all emails are in the queue for a few days and we checked everything was ok on our side even the logs are able to find the domain name, just that it drops from there. Took me a while I finally telnet their port 25 and found it block, but somehow a few minutes later it was unblocked. Is there any mechanism in Cpanel that auto block port 25? I know the client uses a catchall so all rubbish went there, I cleared the catchall for him.
View Replies!
View Related
Weird VMware Network
I added a USB nic to my main server which also acts as VM server so I can bridge some VMs on a separate network then that actual server, for security purposes. This nic has no IP and is connected to another router. My private LAN router (router1) is connected to that router. (router2) In vmware server I made a new bridged network to eth1 which is the USB nic. now for whatever reason, there does not seem to be communication on that new nic. if I set a static IP on a VM sometimes I can ping the gateway, sometimes not. It's on and off. Also, DHCP won't work at all, but I know DHCP works on that network as if I plug a PC into that router I get an IP right away. that this is a home setup, not an internet setup, so I have full physical access.
View Replies!
View Related
Weird Panel Problem
I'm using CP+ panel. Here's the weird thing, when I look inside my domain name and to the A record to add a subdomain, it shows me another domain name (which is also mine). When I add a subdomain to that anyway, I get a subdomain.realdomain.anotherdomain.com entry instead of subdomain.realdomain.com Also in the list some domains are correct while most of them are pointing to each others. I've checked the named conf and also apache conf and I don't see anything wrong at all. They're all linked to their correct location. Anyone here have any inklings on what it might be? Never seen anything like it before.
View Replies!
View Related
|
TRACKER
