Dotaz: Unable to establish connection to MySQL

[jany2]

Zdravim.

Na lokalnom stroji mam ubuntu server a nainstalovany aj LAMP a asi 4 roky funguje bezproblemovo. V /var/www mam ulozene subory (php fusion) a bezi mi na servery aj cacti. Vcera php fusion este normalne behalo, ale ak som chcel pozret cacti, tak vyskocilo len okno na prihlasenie a po zadani mena a hesla sa nic nedialo. Skusil som reboot, ale uz som sa nedostal ani na phpfusion, samozrejme ani na cacti a ani na phpmyadmin.

Ak chcem ist na php fusion dostanem hlasku

Unable to establish connection to MySQL
2002 : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Ak chcem ist na cacti, tak

FATAL: Cannot connect to MySQL server on ''. Please make sure you have  specified a valid MySQL database name in 'include/config.php'

A ak chcem na phpmyadmin, tak vyskoci aspon tabulka na prihlasenie, ale po zadani mena a hesla sa nic nedeje (nevypise ani chybu, ale ani sa neprihlasi).

Pozrel som cez ps ax v konzole, ale mysql som nevidel, aby bezalo. Je ho potrebne zapnut ? a ako ? :)

---

---

Odpovědi

[jany2]

Este nieco pridam :)

Ako laik mam nainstalovany aj webmin a tam vidim

MySQL is not running on your system - database list could not be retrieved.

Ak sa pokusim zapnut cez button, taktiez sa nic neudeje. A skusal som aj cez konzolu

/etc/init.d/mysql start >/dev/null 2>&1 &

ale tak isto neuspesne

[NN]

Dake logy nemame ?

NN

[jany2]

z /var/log/mysql/error.log je toto, dam sem len par poslednych riadkov, pretoze predosle riadky su datumovo stare

120212  6:51:10 [Note] Plugin 'FEDERATED' is disabled.
120212  6:51:10  InnoDB: Started; log sequence number 0 43685
120212  6:51:10 [Note] Event Scheduler: Loaded 0 events
120212  6:51:10 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.10'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
120212  7:02:01 [Note] /usr/sbin/mysqld: Normal shutdown

120212  7:02:01 [Note] Event Scheduler: Purging the queue. 0 events
120212  7:02:01  InnoDB: Starting shutdown...
120212  7:02:01  InnoDB: Shutdown completed; log sequence number 0 43685
120212  7:02:01 [Note] /usr/sbin/mysqld: Shutdown complete

120212  7:02:49 [Note] Plugin 'FEDERATED' is disabled.
120212  7:02:49  InnoDB: Started; log sequence number 0 43685
120212  7:02:49 [Note] Event Scheduler: Loaded 0 events
120212  7:02:49 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.10'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
120222 17:31:56 [ERROR] /usr/sbin/mysqld: Disk is full writing './cacti/user_log.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
120222 17:31:56 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
120222 17:41:56 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
120222 17:51:56 [ERROR] /usr/sbin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
120222 18:01:56 [ERR

[jany2]

takze podla logu to vypada na to ze disk je plny, len ako ho teraz uvolnit ./cacti/user_log.MYD

[MMMMMMMMM]

pre "/" mam vyhradene len 10GB a volne bolo 0 Bajtov, tak som vymazal jeden 5GB film co bol v "/" a uz to vsetko znova funguje. Myslel som si, ze problem je v tom, ze pre mysql je vyhradeny urcity priestor, ale to sa jednalo o cely "/" . Este budem musiet asi aj /var/log premazat

[Jesus Jimenez]

A co ten mysql datadir presunout na nejaky volnejsi oddil?

[jany2]

Uz mam tam teraz dost miesta (ale zisiel by sa asi novy vacsi HDD, lebo 120GB je malo, mam na nom aj NFS s filmamy)