Directadmin i mysql

[maly90 8]

Cześc mam problem ponieważ nie miałem opłaconego serwera VPS-a bo byłem na wyjezdzie dzisiaj został opłacony i wali się MYSQL ciągle ze proces wstrzymany, nic nie reaguje na wciśnięcie "Uruchom" a w sekcji "Zarządzanie bazami MYSQL" jest komunikat "Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" Właściciel freecast umywa się i mówi ze to nie ich winna, jak to naprawić bez utraty baz bo to kolejny raz się wydarzyło.

[FilipS 7]

Możesz spróbować stworzyć plik etc/my.cnf z danymi:

[mysqld]

socket=/var/lib/mysql/mysql.sock

[regdos 1848]

1. Jeżeli Twój VPS to root VPS to Ty odpowiadasz za oprogramowanie i freecast nie ma nic do tego

2. Spróbuj wystartować mysql-a /etc/init/d/mysqld start i zobacz co wypluwa i co mówią logi ?

[maly90 8]

wywaliło mi:

 

-bash: /etc/init/d/mysqld: No such file or directory

Edytowano Czerwiec 30, 2012 przez maly90 (zobacz historię edycji)

[ArabSmall 118]

wywaliło mi:

 

-bash: /etc/init/d/mysqld: No such file or directory

/etc/init.d/mysqld start

kropka zamiast /

[maly90 8]

wywalilo:

 

Starting mysqld: [ OK ]

 

 

mimo to i tak jest dalej w stan "ZATRZYMANIA" :/

[maly90 8]

ciągle pada jak nie opłaci się w terminie.

[ArabSmall 118]

ciągle pada jak nie opłaci się w terminie.

 

@regdos napisał, abyś sprawdził logi sprawdziłeś?

 

2. Spróbuj wystartować mysql-a /etc/init/d/mysqld start i zobacz co wypluwa i co mówią logi ?

[maly90 8]

dałem 2. Spróbuj wystartować mysql-a /etc/init/d/mysqld start i zobacz co wypluwa i co mówią logi ?

i wypluło Starting mysqld: [ OK ]

 

Niestety nie wiem gdzie logi sprawdzić, jest tylko "Przeglądarka Logów" w DA, ale na liscie nie ma nic z MYSQL.

[ArabSmall 118]

http://help.directadmin.com/item.php?id=11

[maly90 8]

oto logi

120604 21:33:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

120604 21:33:35 [Note] Plugin 'FEDERATED' is disabled.

120604 21:33:35 InnoDB: The InnoDB memory heap is disabled

120604 21:33:35 InnoDB: Mutexes and rw_locks use InnoDB's own implementation

120604 21:33:35 InnoDB: Compressed tables use zlib 1.2.3

120604 21:33:35 InnoDB: Using Linux native AIO

120604 21:33:35 InnoDB: Initializing buffer pool, size = 128.0M

120604 21:33:35 InnoDB: Completed initialization of buffer pool

InnoDB: The first specified data file ./ibdata1 did not exist:

InnoDB: a new database to be created!

120604 21:33:35 InnoDB: Setting file ./ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

120604 21:33:35 InnoDB: Log file ./ib_logfile0 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

120604 21:33:35 InnoDB: Log file ./ib_logfile1 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: 127 rollback segment(s) active.

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

120604 21:33:35 InnoDB: Waiting for the background threads to start

120604 21:33:36 InnoDB: 1.1.5 started; log sequence number 0

120604 21:33:36 [Note] Event Scheduler: Loaded 0 events

120604 21:33:36 [Note] /usr/local/mysql/bin/mysqld: ready for connections.

Version: '5.5.9' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)

120604 21:35:36 [Warning] IP address '193.9.123.61' could not be resolved: no reverse address mapping.

120604 23:36:14 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

 

120604 23:36:14 [Note] Event Scheduler: Purging the queue. 0 events

120604 23:36:14 InnoDB: Starting shutdown...

120604 23:36:15 InnoDB: Shutdown completed; log sequence number 1660759

120604 23:36:15 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

 

120604 23:36:15 mysqld_safe mysqld from pid file /usr/local/mysql/data/core.pid ended

120604 23:36:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

120604 23:36:19 [Note] Plugin 'FEDERATED' is disabled.

120604 23:36:19 [Warning] option 'innodb-buffer-pool-size': signed value 1048576 adjusted to 5242880

120604 23:36:19 InnoDB: The InnoDB memory heap is disabled

120604 23:36:19 InnoDB: Mutexes and rw_locks use InnoDB's own implementation

120604 23:36:19 InnoDB: Compressed tables use zlib 1.2.3

120604 23:36:19 InnoDB: Using Linux native AIO

120604 23:36:19 InnoDB: Initializing buffer pool, size = 5.0M

120604 23:36:19 InnoDB: Completed initialization of buffer pool

120604 23:36:19 InnoDB: highest supported file format is Barracuda.

120604 23:36:19 InnoDB: Waiting for the background threads to start

120604 23:36:20 InnoDB: 1.1.5 started; log sequence number 1660759

120604 23:36:20 [Note] Event Scheduler: Loaded 0 events

120604 23:36:20 [Note] /usr/local/mysql/bin/mysqld: ready for connections.

Version: '5.5.9' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)

120604 23:40:52 [Warning] IP address '193.9.123.61' could not be resolved: no reverse address mapping.

120605 1:50:38 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

 

120605 1:50:38 [Note] Event Scheduler: Purging the queue. 0 events

120605 1:50:38 InnoDB: Starting shutdown...

120605 1:50:39 InnoDB: Shutdown completed; log sequence number 1660759

120605 1:50:39 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

 

120605 01:50:39 mysqld_safe mysqld from pid file /usr/local/mysql/data/core.pid ended

120605 01:51:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

120605 1:51:12 [Note] Plugin 'FEDERATED' is disabled.

120605 1:51:12 [Warning] option 'innodb-buffer-pool-size': signed value 1048576 adjusted to 5242880

120605 1:51:12 InnoDB: The InnoDB memory heap is disabled

120605 1:51:12 InnoDB: Mutexes and rw_locks use InnoDB's own implementation

120605 1:51:12 InnoDB: Compressed tables use zlib 1.2.3

120605 1:51:12 InnoDB: Using Linux native AIO

120605 1:51:12 InnoDB: Initializing buffer pool, size = 5.0M

120605 1:51:12 InnoDB: Completed initialization of buffer pool

120605 1:51:12 InnoDB: highest supported file format is Barracuda.

120605 1:51:12 InnoDB: Waiting for the background threads to start

120605 1:51:13 InnoDB: 1.1.8 started; log sequence number 1660759

120605 1:51:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

120605 1:51:13 [Note] - '0.0.0.0' resolves to '0.0.0.0';

120605 1:51:13 [Note] Server socket created on IP: '0.0.0.0'.

120605 1:51:13 [Note] Event Scheduler: Loaded 0 events

120605 1:51:13 [Note] /usr/local/mysql/bin/mysqld: ready for connections.

Version: '5.5.25' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)

120605 1:51:18 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

 

120605 1:51:18 [Note] Event Scheduler: Purging the queue. 0 events

120605 1:51:18 InnoDB: Starting shutdown...

120605 1:51:18 InnoDB: Shutdown completed; log sequence number 1660769

120605 1:51:18 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

 

120605 01:51:18 mysqld_safe mysqld from pid file /usr/local/mysql/data/core.pid ended

120605 01:51:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

120605 1:51:23 [Note] Plugin 'FEDERATED' is disabled.

120605 1:51:23 [Warning] option 'innodb-buffer-pool-size': signed value 1048576 adjusted to 5242880

120605 1:51:23 InnoDB: The InnoDB memory heap is disabled

120605 1:51:23 InnoDB: Mutexes and rw_locks use InnoDB's own implementation

120605 1:51:23 InnoDB: Compressed tables use zlib 1.2.3

120605 1:51:23 InnoDB: Using Linux native AIO

120605 1:51:23 InnoDB: Initializing buffer pool, size = 5.0M

120605 1:51:23 InnoDB: Completed initialization of buffer pool

120605 1:51:23 InnoDB: highest supported file format is Barracuda.

120605 1:51:23 InnoDB: Waiting for the background threads to start

120605 1:51:24 InnoDB: 1.1.8 started; log sequence number 1660769

120605 1:51:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

120605 1:51:24 [Note] - '0.0.0.0' resolves to '0.0.0.0';

120605 1:51:24 [Note] Server socket created on IP: '0.0.0.0'.

120605 1:51:24 [Note] Event Scheduler: Loaded 0 events

120605 1:51:24 [Note] /usr/local/mysql/bin/mysqld: ready for connections.

Version: '5.5.25' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)

120605 1:51:36 [Warning] IP address '193.9.123.61' could not be resolved: Name or service not known

120610 12:45:21 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

 

120610 12:45:21 [Note] Event Scheduler: Purging the queue. 0 events

120610 12:45:21 InnoDB: Starting shutdown...

120610 12:45:22 InnoDB: Shutdown completed; log sequence number 10387799

120610 12:45:22 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

 

120610 12:45:22 mysqld_safe mysqld from pid file /usr/local/mysql/data/core.pid ended

[maly90 8]

Właściciel freecast skontaktował się ze mną telefonicznie, i zaproponował ze pomoże za darmo w naprawieniu. Bardzo szybko i sprawnie pomógł. Godne naśladowania.

 

PS. Temat można już zamknąć.