vicidial.org

by D » Sun Sep 10, 2006 7:13 am

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';|

by **mflorell** » Sun Sep 10, 2006 7:39 am

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

by **convertec** » Sun Sep 10, 2006 3:51 pm

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?

by **mflorell** » Sun Sep 10, 2006 7:28 pm

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

by **convertec** » Sun Sep 10, 2006 7:56 pm

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

by **SuPrSluG** » Sat Sep 16, 2006 12:29 pm

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!!

by **mflorell** » Sat Sep 16, 2006 8:16 pm

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

by **SuPrSluG** » Sun Sep 17, 2006 11:00 am

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.

by **mflorell** » Mon Sep 18, 2006 9:00 am

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

by **SuPrSluG** » Mon Sep 18, 2006 11:12 am

All correct information in all the files.

by **mflorell** » Mon Sep 18, 2006 11:56 am

What versions of PHP and Apache are you using?

by **SuPrSluG** » Mon Sep 18, 2006 12:16 pm

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

by **mflorell** » Mon Sep 18, 2006 2:50 pm

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

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

by **SuPrSluG** » Tue Sep 19, 2006 9:59 am

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.

by **mflorell** » Tue Sep 19, 2006 10:51 am

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?

by **SuPrSluG** » Tue Sep 19, 2006 11:27 am

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()

vicidial.org

Can't Access astguiclient/admin.php

Can't Access astguiclient/admin.php

Who is online