hi, i'm getting this error message, got any idea on how to fix it ?
Do i just have to restart the configuration process of zm ?
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/netbijoux/zm-1.21.3/web/zm_db.php on line 21
Could not connect to database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mysql_connect
mysql_connect
Regards,
Sophak
-------------------------------------------------------
Debian stable 2.6.8-4-k7 kernel - logitech pro 4000 X 3 - zoneminder 1.21.3
Learning Php / Mysql / Java /
Sophak
-------------------------------------------------------
Debian stable 2.6.8-4-k7 kernel - logitech pro 4000 X 3 - zoneminder 1.21.3
Learning Php / Mysql / Java /
Did you make sure that mysql is started?
Regards,
Corey
Regards,
Corey
3939663646337
It's better to keep your mouth shut and appear stupid than open it and remove all doubt.
-Mark Twain
user@host:/root$ /usr/sbin/mysqld
051229 14:11:02 [Warning] Can't create test file /var/lib/mysql/netbijoux.lower-test
051229 14:11:02 [Warning] One can only use the --user switch if running as root
/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.1' not found (Errcode: 13)
051229 14:11:02 [ERROR] Could not use /var/log/mysql/mysql-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
051229 14:11:02 [ERROR] Aborting
051229 14:11:02 [Note] /usr/sbin/mysqld: Shutdown complete
so... yes, it's not started and it doesn't want to
051229 14:11:02 [Warning] Can't create test file /var/lib/mysql/netbijoux.lower-test
051229 14:11:02 [Warning] One can only use the --user switch if running as root
/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.1' not found (Errcode: 13)
051229 14:11:02 [ERROR] Could not use /var/log/mysql/mysql-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
051229 14:11:02 [ERROR] Aborting
051229 14:11:02 [Note] /usr/sbin/mysqld: Shutdown complete
so... yes, it's not started and it doesn't want to
Regards,
Sophak
-------------------------------------------------------
Debian stable 2.6.8-4-k7 kernel - logitech pro 4000 X 3 - zoneminder 1.21.3
Learning Php / Mysql / Java /
Sophak
-------------------------------------------------------
Debian stable 2.6.8-4-k7 kernel - logitech pro 4000 X 3 - zoneminder 1.21.3
Learning Php / Mysql / Java /
ok, i'm trying with mysql 4.0.25
after unpacking i launch that mysqld it's give me :
host:~# /usr/bin/mysqldumpslow
/usr/share/man/man1/mysqldumpslow.1.gz
Can't find '/var/lib/mysql/*-slow.log'
host:~# /usr/sbin/mysqld
060102 12:53:21 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060102 12:53:21 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 44812.
InnoDB: Doing recovery: scanned up to log sequence number 0 44858
InnoDB: Last MySQL binlog file position 0 79, file name /var/log/mysql/mysql-bin .000099
060102 12:53:21 InnoDB: Flushing modified pages from the buffer pool...
060102 12:53:21 InnoDB: Started; log sequence number 0 44858
060102 12:53:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' was created with a different version of MySQL and cannot be read
after unpacking i launch that mysqld it's give me :
host:~# /usr/bin/mysqldumpslow
/usr/share/man/man1/mysqldumpslow.1.gz
Can't find '/var/lib/mysql/*-slow.log'
host:~# /usr/sbin/mysqld
060102 12:53:21 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060102 12:53:21 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 44812.
InnoDB: Doing recovery: scanned up to log sequence number 0 44858
InnoDB: Last MySQL binlog file position 0 79, file name /var/log/mysql/mysql-bin .000099
060102 12:53:21 InnoDB: Flushing modified pages from the buffer pool...
060102 12:53:21 InnoDB: Started; log sequence number 0 44858
060102 12:53:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' was created with a different version of MySQL and cannot be read
Regards,
Sophak
-------------------------------------------------------
Debian stable 2.6.8-4-k7 kernel - logitech pro 4000 X 3 - zoneminder 1.21.3
Learning Php / Mysql / Java /
Sophak
-------------------------------------------------------
Debian stable 2.6.8-4-k7 kernel - logitech pro 4000 X 3 - zoneminder 1.21.3
Learning Php / Mysql / Java /