Can't connect to local MySQL server trough socket ....

[helper4cacti]

In the graph tree some graph couldn't open whith next meesage in console
ERROR 2002 (HY000) Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[danathane]

does you mysql service is active?
I had the same problem last night and it was just the service wich was activated.

[helper4cacti]

Sure, I can manage it's table via webmin. And restart mysql server several times, but error still persist

[gandalf]

Perhaps you're facing a max_connections problem. This /etc/php.ini setting defaults to 100. You may upper it to 500. Restart mysqld and httpd to take effect
Reinhard

[helper4cacti]

There is one settings in php.ini with max_connections

[FrontBase]
.....
;fbsql.max_connections = 128

But it's disabled by ; in beginnig

Could I use next string instead ?
fbsql.max_connections = 500

[fmangeant]

Hi

here's how to see if you've reached the maximum number of connections :

Code: Select all

mysql> show variables like '%max_connectio%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 4000  |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> show status like 'Max%';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Max_used_connections | 224   |
+----------------------+-------+
1 row in set (0.00 sec)

To change the maximum allowed connections, add this to my.cnf :

Code: Select all

set-variable = max_connections=4000

[helper4cacti]

Thx for advice. I setup max_connections to 500

I look carefully, but I have no Max_used_connections variable...

[rony]

Doesn't look like you are using mySQL.

[helper4cacti]

Cacti Version - 0.8.6i
Plugin Architecture - 1.0
Poller Type - Cactid v
Server Info - Linux 2.6.9-55.0.2.ELsmp
Web Server - Apache/2.0.52 (CentOS)
PHP - 4.3.9
PHP Extensions - yp, xml, wddx, tokenizer, sysvshm, sysvsem, standard, sockets, shmop, session, pspell, posix, pcre, overload, mime_magic, iconv, gmp, gettext, ftp, exif, dio, dbx, dba, curl, ctype, calendar, bz2, bcmath, zlib, openssl, apache2handler, gd, mysql, snmp, eAccelerator
MySQL - 4.1.20
RRDTool - 1.2.15
SNMP - 5.1.2
Plugins

• PHP Network Weathermap (weathermap - v0.92)
  Thresholds (thold - v0.3.0)
  Device Monitoring (monitor - v0.7)
  Network Discovery (discovery - v0.6)
  Network Tools (tools - v0.2)
  Syslog Monitoring (haloe - v0.4)
  Device Tracking (mactrack - v1.0)
  RRD Cleaner (rrdclean - v1.1)
  Update Checker (update - v0.3)
  FlowView (flowview - v0.3)
  Host Info (hostinfo - v0.1)
  Error Images (errorimage - v0.1)
  Simple Links page (links - v0.3)

[gandalf]

Please find docs concerning this issue at http://dev.mysql.com/doc/refman/4.1/en/ ... ables.html
Reinhard