I started getting small periods of intermittent connection errors about once every hour, lasting for about 1 to 5 minutes each time:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'
I enabled the error log and did some other monitoring and established 2 things:
- the server doesn't crash/restart, it keeps running throughout the errors
- the errors do not match the load on the website, as sometimes when 500 users are online there are no errors, but when 300 are online they may by prolific
I checked many forums and then made 5 changes:
- changed the directory containing the mysql.sock file so only file owners or superusers can delete files from it
- I changed the default socket file setting in both my.cnf and php.ini
- I read about SELinux causing such a problem, so I disabled SELinux completely, rebooted the server and double-checked that it is indeed disabled.
- I changed the maximum amount of open files allowed by the operating system from 1024 to 30000.
Despite all these changes, I still get the errors. I then read that there is a workaround by using TCP/IP instead of the sock file. I tried that, but I still get the error intermittently in the form of:
Can't connect to MySQL server on 127.0.0.1
MySQL server 4.1.20, PHP 4.3.9, client API 4.1.20, CentOS 4.3, Intel P4 2.8GHz 1GB RAM
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did.
What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly.
Do you guys have any idea why this happen?
I do have a lot of connections coming in and out of my server. Would that mean anything?
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) /home/thesymbi/public_html/includes/class_core.php on line 274
I'm having problem with godaddy shared server. I've signup with godaddy since 2006. Within the 2years, godaddy has been having so many downtime. Replies from them were always pointing faults to my internet service provider, but everytime I could serve other websites with ease.
My employer hosts a website for a company that has a .co.uk site and a .com site. The .com site generally cannot be accessed but the .co.uk site can always be accessed. Both sites are on the same server (which we maintain), but an outside company hosts the DNS records and refuses to admit there is a problem.
Since one domain is accessible and one isn't and they are both on the same server I'm pretty sure it's a DNS issue. I did a report on www.dnsreport.com and it says there are lame nameservers on the .com domain, but the .co.uk domain doesn't show that issue.
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).
I saw following error in some of my site in my server.
Coppermine critical error: Unable to connect to database !
MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
or following error :
Invalid mysql server connection
Please help me how can I resolve this error !
/etc/my.cnf :
[mysqld] datadir=/var/lib/mysql skip-locking skip-innodb skip-networking safe-show-database query_cache_limit=1M query_cache_size=16M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=200 max_connections=500 interactive_timeout=10 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=64M ## 128MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=8 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 collation-server=latin1_general_ci
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.
It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.
I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.
I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.
All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.
I just added an hourly crontab so as to restart the MySQL server as a stop gap.
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB.
The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2.
server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times. server 2 is not very busy, around 30% CPU usage and 0.6 CPU load.
Yet, users on server 2 experience *much slower* response times than the ones on server 1.
The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1).
Why so many sleeping processes from server 2, and none or almost none from server 1 ? Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently?
What could be a reason for server 2 having problems to open connections on server 1, and how to solve it?
Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.
i then used a MD5 generator to input the hash in the password field of the roundcube user in mysql, with no luck...I even tried to delete roundcube user from mysql, then remove psa-roundcube, then go through the plesk update manager and install roundcube again, did not change nothing, it didn't even create the roundcube user.
Is there anyway i can reinstall roundcube from scratch?PPP 11.5 up to date on ubuntu 12.04
Code:
[05-Oct-2013 14:03:54 +0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)] [Native code: 1045] [Native message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/.../public_html/enhu.com/includes/connection.php on line 5
Database connection failed: Access denied for user 'root'@'localhost' (using password: YES)
After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.
The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !
Though, remote connections are allowed from any host in the settings.
During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery:
Quote:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
(The forums and the gallery are the main parts of the site).
I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference.
What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings?
my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
my vBulletin forum members start complaing about an intermittent forbidden error message:
Forbidden You don't have permission to access /vb/forumdisplay.php on this server.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request
i did tail -f /usr/local/apache/logs/error_log and find lot of lines like this:
[Fri May 9 17:13:33 2008] [crit] [client 217.69.189.2] (24)Too many open files: /.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable
i also found the vb folder and all folders inside it have permession of 775 and all files have permession of 664
