Scratch Installation Error: Accessing Vicidial Server

[cire_08]

Hi Guys,

In line with my scratch installation, im in Phase 6.1.3 Enter the Vicidial Administration Page ( http://192.168.0.12/vicidial/admin.php). Just after the mysql data entry.

Here are the errors when im accessing http://192.168.0.12/vicidial/admin.php :

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/apache2/htdocs/vicidial/dbconnect.php on line 42

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/apache2/htdocs/vicidial/dbconnect.php on line 43

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /usr/local/apache2/htdocs/vicidial/dbconnect.php on line 43

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/apache2/htdocs/vicidial/admin.php on line 791

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/vicidial/admin.php on line 793

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/apache2/htdocs/vicidial/admin.php on line 1375

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/vicidial/admin.php on line 1377

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/apache2/htdocs/vicidial/admin.php on line 1391

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/vicidial/admin.php on line 1392

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache2/htdocs/vicidial/dbconnect.php:42) in /usr/local/apache2/htdocs/vicidial/admin.php on line 1404

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache2/htdocs/vicidial/dbconnect.php:42) in /usr/local/apache2/htdocs/vicidial/admin.php on line 1405
Invalid Username/Password: |||

Please advice.

regards,

[codehaxor]

your mysql server is not started... please check if its running ....

[cire_08]

hi codehaxor,

thanks for your prompt reply.

i sure that mysql is running.. coz i just went to mysql client prompt as per SUBPHASE 6.1: creating the MySQL "asterisk" database and successfully entered/inserted data.

Btw, im using mysql 5.0.45 source distribution and Slackware 12.1

Pls. advisce.

[codehaxor]

also check your /etc/astguiclient.conf see the database login settings, also be sure to check if your running mysql database by doing a ps -aux | grep mysql

or a netstat -naptu | grep 3306

3306 is the port that mysql uses

[cire_08]

Hi Codehaxor,

here is my astguiclient.conf: I don't see any prob with the config as I just follow the scratch install. Also showed below the ps -aux | grep mysql output and netstat -naptu | grep 3306. Pls advice what's wrong with my config.

# astguiclient.conf - configuration elements for the astguiclient package
# this is the astguiclient configuration file
# all comments will be lost if you run install.pl again

# Paths used by astGUIclient
PATHhome => /usr/share/astguiclient
PATHlogs => /var/log/astguiclient
PATHagi => /var/lib/asterisk/agi-bin
PATHweb => /usr/local/apache2/htdocs
PATHsounds => /var/lib/asterisk/sounds
PATHmonitor => /var/spool/asterisk/monitor
PATHDONEmonitor => /var/spool/asterisk/monitorDONE

# The IP address of this machine
VARserver_ip => 192.168.0.12

# Database connection information
VARDB_server => localhost
VARDB_database => asterisk
VARDB_user => cron
VARDB_pass => 1234
VARDB_port => 3306

# Alpha-Numeric list of the astGUIclient processes to be kept running
# (value should be listing of characters with no spaces: 1234568)
# X - NO KEEPALIVE PROCESSES (use only if you want none to be keepalive)
# 1 - AST_update
# 2 - AST_send_listen
# 3 - AST_VDauto_dial
# 4 - AST_VDremote_agents
# 5 - AST_VDadapt (If multi-server system, this must only be on one server)
# 6 - FastAGI_log
# 7 - AST_VDauto_dial_FILL (only for multi-server, this must only be on one server)
# 8 - ip_relay (used for blind agent monitoring)
# 9 - Timeclock auto logout
VARactive_keepalives => 1234568

# FTP recording archive connection information
VARFTP_host => 192.168.0.14
VARFTP_user => cron
VARFTP_pass => test
VARFTP_port => 21
VARFTP_dir => RECORDINGS
VARHTTP_path => 192.168.0.14


# REPORT server connection information
VARREPORT_host => 192.168.0.14
VARREPORT_user => cron
VARREPORT_pass => test
VARREPORT_port => 21
VARREPORT_dir => REPORTS

# Settings for FastAGI logging server
VARfastagi_log_min_servers => 3
VARfastagi_log_max_servers => 16
VARfastagi_log_min_spare_servers => 2
VARfastagi_log_max_spare_servers => 8
VARfastagi_log_max_requests => 1000
VARfastagi_log_checkfordead => 30
VARfastagi_log_checkforwait => 60


root@vicidial:~# ps -aux | grep mysql

Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
root 2874 0.0 0.1 2764 1380 pts/0 S 09:51 0:00 /bin/sh /usr/lo cal/mysql/bin/mysqld_safe --user=mysql
mysql 2898 0.0 1.4 108368 15032 pts/0 Sl 09:51 0:00 /usr/local/mysq l/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --use r=mysql --pid-file=/usr/local/mysql/var/vicidial.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
root 2935 0.4 0.1 4896 1816 pts/0 T 10:13 0:00 mysql
root 2941 0.7 0.1 4896 1820 tty1 S+ 10:13 0:00 mysql
root 2977 0.0 0.0 2060 656 pts/1 S+ 10:14 0:00 grep mysql


root@vicidial:~# netstat -naptu | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2898/mysqld

[mflorell]

What is your Linux version?

Where is your MySQL putting it's mysql.sock file?

[cire_08]

thanks matt for your prompt reply.

Im using slackware 12.1.

i have mysql.sock file in /tmp/mysql.sock and also one in '/var/lib/mysql/mysql.sock'. I checked /etc/my.cnf file, the client and server sockets are set to /tmp/mysql.sock.

Pls advice.

regards,

[mflorell]

is /var/lib/mysql/mysql.sock a link to /tmp/mysql/mysql.sock ?

[cire_08]

Nope, before i did ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock because mysql.sock was missing in /tmp folder.. but i remove it again after sometime and run this command usr/local/mysql/bin/mysqld_safe --user=mysql & and /usr/local/mysql/bin/mysql then mysql works and verified that mysql.sock was there in tmp folder.

thanks for your untiring support.

[gardo]

You need to reconfigure mysql to use /var/lib/mysql/mysql.sock. The dbconnect.php page is connecting through that socket to access mysql.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/apache2/htdocs/vicidial/dbconnect.php on line 42

[cire_08]

gardo

pls help me at least how to reconfigure mysql to use /var/lib/mysql/mysql.sock.

I changed the my.cnf file socket value to var/lib/mysql/mysql.sock both for client and mysqld. After that run /usr/local/mysql/bin/mysql then went to mysql prompt without any error.

But accessing it to http://192.168.0.12/vicidial/admin.php page i got the said problem.. Pls advise.

regards

[cire_08]

hello any help

i'd been looking in the net for so long and unfortunately i could not find any solution related to my problem..

matt, any advise??

[gardo]

This is a single server setup right? Can you post your /etc/my.cnf file here?

[cire_08]

PRAISE GOD!

my problem was solved after i entered this command chmod 755 /var/lib/mysql, my problem was related to file permission..

anyway thanks gardo for your concern...

i hope you will not stop helping others especially newbie like me.