Page 1 of 1

ZM on Debian - can't open via web.

Posted: Mon May 05, 2008 10:25 am
by ramz
Hello,

I have a Debian 4.0_r3 system:

Code: Select all

debian:~# uname -a
Linux debian 2.6.18-6-686 #1 SMP Sun Feb 10 22:11:31 UTC 2008 i686 GNU/Linux
with Apache2 which was set up in the following way:

Code: Select all

 aptitude install apache2
MySQL with was installed from source

Code: Select all

debian:~# mysql -V
mysql  Ver 14.12 Distrib 5.0.51b, for pc-linux-gnu (i686) using  EditLine wrapper
and "aptitude install libmysqlclient15-dev" for mysql header files.

I have installed the ZM from source - ZoneMinder-1.23.3.tar.gz

And when I try to get access via web: http://192.168.1.103/zm/
I get the following error:

Code: Select all

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /var/www/zm/zm_db.php on line 27
Could not connect to database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
There is no mysql folder under /var/run/
according to /etc/my.cnf, socket file is in /tmp folder:

Code: Select all

.....
# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
........
What am I doing wrong ? Please advise.

Zoneminder on Debian

Posted: Mon May 05, 2008 5:19 pm
by theorganloft
I do not know exactly how to fix that problem but I have a suggestion:

Why not load Ubuntu 7.10 and run apt-get install zoneminder? After Zoneminder installs, you will have to take a few more steps to get it going but it would be so much easier.

Posted: Tue May 06, 2008 4:58 pm
by Lee Sharp
He is on Debian. He can just 'apt-get install zoneminder' right now.

As to your question, I do not know. I use the debs. :)

Posted: Tue May 06, 2008 10:25 pm
by betulichergutmensch
yeah sure he can!

i'd suggest you to change the folder to /var/run/mysqld and create it with following rights chown -R mysql:root /var/run/mysqld, because this is the standard path to the mysql socket file on debian systems... if you would have installed mysql through apt-get install mysql, it would be this way and you probably make a right ./configure with paths for your system... always remember to set right paths if compiling yourself, otherwise you will always get those messages with mixed up systems ;-)

Debian vs. Ubuntu Debian

Posted: Thu May 08, 2008 11:24 am
by theorganloft
Lee Sharp wrote:He is on Debian. He can just 'apt-get install zoneminder' right now.

As to your question, I do not know. I use the debs. :)


I tried the Debian Distro. I had problems with it. It works but the Ubuntu Debian teams seem to do a better job of keeping up with updates.