vicidial.org

We are using Slackware 10.2. Our Apache has been installed successfully but we are unable to access http://61.156.208.11/astguiclient/admin.php in Sub-Phase 6.1 - Section 3. In addition, I think our MySql is running. We are getting the following error on the browser when we try to access http://61.156.208.11/astguiclient/admin.php (IP has been changed) - Please let us know how to troubleshoot and fix this:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache2/htdocs/astguiclient/dbconnect.php on line 7

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache2/htdocs/astguiclient/dbconnect.php on line 8

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

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

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

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

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

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

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache2/htdocs/astguiclient/dbconnect.php:7) in /usr/local/apache2/htdocs/astguiclient/admin.php on line 372
Invalid Username/Password: ||| |SELECT count(*) from vicidial_users where user='' and pass='' and user_level > '6' and ast_admin_access='1';|

do a "ps -A" and make sure that httpd and mysqld are running.

Then you can try this:
ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock

I was having the same troubles described here

In one of my other posts I listed your answer above as a solution to the mysql.sock problem:

ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock

but now when I access

http://xxx.xxx.xxx.xxx/astguiclient/admin.php

i get:

Code: Select all

Warning: fopen(./project_auth_entries.txt) [function.fopen]: failed to open stream: Permission denied in /usr/local/apache2/htdocs/astguiclient/admin.php on line 376

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache2/htdocs/astguiclient/admin.php:376) in /usr/local/apache2/htdocs/astguiclient/admin.php on line 383

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/apache2/htdocs/astguiclient/admin.php:376) in /usr/local/apache2/htdocs/astguiclient/admin.php on line 384
Invalid Username/Password: ||| |SELECT count(*) from vicidial_users where user='' and pass='' and user_level > '6' and ast_admin_access='1';|


what to do almighty astguiclient guru?

That bug was fixed in the install.pl for 2.0.1b2. You need to set the chmod 0777 on your astguiclient web directory.

Thanks for that. Worked like a champ.
I was using the 2.0.1b2 from the 2x svn server from last week.

I've chmod'ed 0777 the web directories etc, yet still
get the above error.
using
zenwalk 3.0 (slackware)
kernel 2.6.17.11
mysql 5.01
mysql> select * from vicidial_users;
+---------+------+------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+
| user_id | user | pass | full_name | user_level | user_group | phone_login | phone_pass | delete_users | delete_user_groups | delete_lists | delete_campaigns | delete_ingroups | delete_remote_agents | load_leads | campaign_detail | ast_admin_access | ast_delete_phones | delete_scripts | modify_leads | hotkeys_active | change_agent_campaign | agent_choose_ingroups | closer_campaigns | scheduled_callbacks | agentonly_callbacks | agentcall_manual | vicidial_recording | vicidial_transfers | delete_filters | alter_agent_interface_options | closer_default_blended | delete_call_times | modify_call_times |
+---------+------+------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+
| 1 | 6666 | 1234 | Admin | 9 | ADMIN | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
+---------+------+------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+
1 row in set (0.01 sec)




Warning: Cannot modify header information - headers already sent by (output started at /var/www/htdocs/astguiclient/admin.php:246) in /var/www/htdocs/astguiclient/admin.php on line 383

Warning: Cannot modify header information - headers already sent by (output started at /var/www/htdocs/astguiclient/admin.php:246) in /var/www/htdocs/astguiclient/admin.php on line 384
Invalid Username/Password: ||| |SELECT count(*) from vicidial_users where user='' and pass='' and user_level > '6' and ast_admin_access='1';|

WTF!!

somehow the user and password variables are not being passed to the astguiclient/admin.php script. What is it's build?

It's the latest. 2.0.1 from friday.
I've looked at line 246 of admin.php and it looks correct. No whitespaces that I read can cause problems.

are the database settings properly set in the dbconnect.php file or the /etc/astguiclient.php file?

All correct information in all the files.

What versions of PHP and Apache are you using?

PHP 5.1.4
mysql 5.0.21
apache-2 2.2.2

In the Apache error log I get this;
[Mon Sep 18 13:07:33 2006] [crit] (70023)This function has not been implemented on this platform: DBD: driver for not available
[Mon Sep 18 13:07:33 2006] [crit] (70023)This function has not been implemented on this platform: DBD: failed to initialise

I think something is wrong with the DBI/DBD process. I'm trying now to reinstall/force install in cpan

Now that is interesting. PHP doesn't use DBI, that a perl thing.

Is there any reason you are using PHP5 instead of PHP4?

I reinstalled everything. I'm using the verison from scratch install for mysql,apache and php. I'm able to get into vicidial now, but am experiencing the same problems in regards to park extension not working.
Nothing happens. No output to the asterisk command line. Also, if I manually transfer a call the caller hears music, but I can still hear the caller. Is this normal? I thought transferring the call to a park conference would allow the agent to be unheard by the caller.

do you see any park_CID.agi output in the agiout.date file in your logs directory?

Does anything show up in your Real Asterisk CLI at all? What about your messages logfile?

do you see any park_CID.agi output in the agiout.date file in your logs directory?

No park_CID.agi, but their is output from the inbound call getting transferred to 8600051.
here's the relevant extension.conf
8662619713' => 1. AGI(call_log.agi|${EXTEN}) [pbx_config]
2. Ringing() [pbx_config]
3. Wait(1) [pbx_config]
4. Answer() [pbx_config]
5. AGI(agi-VDADcloser_inboundCID.agi|SalesLine-----8662619713-----Closer---------------999-----1) [pbx_config]
6. Hangup() [pbx_config]
'h' => 1. DeadAGI(call_log.agi|${EXTEN}) [pbx_config]
2. DeadAGI(VD_hangup.agi|IAX2-----NODEBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME}) [pbx_config]
'i' => 1. Playback(invalid) [pbx_config]
't' => 1. Goto(#|1) [pbx_config]
e

'8301' => 1. Answer() [pbx_config]
2. AGI(park_CID.agi) [pbx_config]
3. Playback(park) [pbx_config]
4. Hangup() [pbx_config]
'8302' => 1. Answer() [pbx_config]
2. AGI(park_CID.agi) [pbx_config]
3. Playback(conf) [pbx_config]
4. Hangup() [pbx_config]
'8303' => 1. Answer() [pbx_config]
2. AGI(park_CID.agi) [pbx_config]
3. Playback(conf) [pbx_config]
4. Hangup()