Page 1 of 1

agc doesn't call agent

PostPosted: Wed Aug 23, 2006 5:10 pm
by Schw00d
I've gone through the scratch install twice now, and both times, when I get everything up and running...no problems installing...I log in my test agent, but my SIP extension never rings. Anyone know what to check to see why this isn't working? My SIP soft phone can call into the meetme conference no problem...it just seems like vicidial isn't able to interface with asterisk to make the call.

Thanks,
-Chris

PostPosted: Wed Aug 23, 2006 5:22 pm
by enjay
select * from vicidial_conferences

(make sure the conferences there are defined in the meetme.conf) sounds like they would be since you can dial into them.

also make sure in astguiclient/admin.php you have your asterisk servers confiured properly.. (IP address etc).

PostPosted: Wed Aug 23, 2006 7:56 pm
by mflorell
Please also post Asterisk CLI output from when you try to login.

PostPosted: Wed Aug 23, 2006 11:03 pm
by Schw00d
Thanks guys...but so far nothing. My dbconnect.php's look good...here's an example of one:

<?
#
# Copyright (C) 2006 Matt Florell <vicidial@gmail.com> LICENSE: GPLv2
#
$link=mysql_connect("127.0.0.1", "cron", "1234");
mysql_select_db("asterisk");

$local_DEF = 'Local/';
$conf_silent_prefix = '7';
$local_AMP = '@';
$ext_context = 'default';
$recording_exten = '8309';

#$WeBServeRRooT = '/home/www/htdocs';
$WeBServeRRooT = '/usr/local/apache2/htdocs';
$WeBRooTWritablE = '1';

?>

I know the cron user has the correct password.

I get NO output from agc/vicidial at all in the asterisk window.

Here is the output from select * from vicidial conferences...they all appear to be there, and 8600051 shows my correct extension as being joined.

mysql> select * from vicidial_conferences
-> ;
+------------+----------------+-----------+
| conf_exten | server_ip | extension |
+------------+----------------+-----------+
| 8600051 | 192.168.200.15 | SIP/100 |
| 8600052 | 192.168.200.15 | NULL |
| 8600053 | 192.168.200.15 | NULL |
| 8600054 | 192.168.200.15 | NULL |
| 8600055 | 192.168.200.15 | NULL |
| 8600056 | 192.168.200.15 | NULL |
| 8600057 | 192.168.200.15 | NULL |
| 8600058 | 192.168.200.15 | NULL |
| 8600059 | 192.168.200.15 | NULL |
| 8600060 | 192.168.200.15 | NULL |
| 8600061 | 192.168.200.15 | NULL |
| 8600062 | 192.168.200.15 | NULL |
| 8600063 | 192.168.200.15 | NULL |
| 8600064 | 192.168.200.15 | NULL |
| 8600065 | 192.168.200.15 | NULL |
| 8600066 | 192.168.200.15 | NULL |
| 8600067 | 192.168.200.15 | NULL |
| 8600068 | 192.168.200.15 | NULL |
| 8600069 | 192.168.200.15 | NULL |
| 8600070 | 192.168.200.15 | NULL |
| 8600071 | 192.168.200.15 | NULL |
| 8600072 | 192.168.200.15 | NULL |
| 8600073 | 192.168.200.15 | NULL |
| 8600074 | 192.168.200.15 | NULL |
| 8600075 | 192.168.200.15 | NULL |
| 8600076 | 192.168.200.15 | NULL |
| 8600077 | 192.168.200.15 | NULL |
| 8600078 | 192.168.200.15 | NULL |
| 8600079 | 192.168.200.15 | NULL |
| 8600080 | 192.168.200.15 | NULL |
| 8600081 | 192.168.200.15 | NULL |
| 8600082 | 192.168.200.15 | NULL |
| 8600083 | 192.168.200.15 | NULL |
| 8600084 | 192.168.200.15 | NULL |
| 8600085 | 192.168.200.15 | NULL |
| 8600086 | 192.168.200.15 | NULL |
| 8600087 | 192.168.200.15 | NULL |
| 8600088 | 192.168.200.15 | NULL |
| 8600089 | 192.168.200.15 | NULL |
| 8600090 | 192.168.200.15 | NULL |
| 8600091 | 192.168.200.15 | NULL |
| 8600092 | 192.168.200.15 | NULL |
| 8600093 | 192.168.200.15 | NULL |
| 8600094 | 192.168.200.15 | NULL |
| 8600095 | 192.168.200.15 | NULL |
| 8600096 | 192.168.200.15 | NULL |
| 8600097 | 192.168.200.15 | NULL |
| 8600098 | 192.168.200.15 | NULL |
| 8600099 | 192.168.200.15 | NULL |
| 8600100 | 192.168.200.15 | NULL |
+------------+----------------+-----------+
50 rows in set (0.00 sec)

Once again, there is NO output from the asterisk CLI at all when I'm logging in as an agent.

Any more ideas?

Thanks,
-Chris

PostPosted: Wed Aug 23, 2006 11:37 pm
by mflorell
any reason you're using 127.0.0.1?

it's not a real IP address as far as most applications are concerned.

Your server_ip should be the same in all places if you have a single VICIDIAL server.

PostPosted: Wed Aug 23, 2006 11:41 pm
by Schw00d
Yes, I changed it from localhost everywhere because I was getting mysql errors when I originally tried to connect to the vicidial web pages...changing it to the localhost IP address resolved that issue. I'll try setting localhost to the IP address of my machine in the /etc/hosts file and then changing it in the configuration files.

PostPosted: Wed Aug 23, 2006 11:46 pm
by Schw00d
Yup...now I'm back to the mysql errors. When I try to open any of the admin.php's in my browser, I get the following now:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache2/htdocs/vicidial/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/vicidial/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/vicidial/dbconnect.php on line 8

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

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

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

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

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

PostPosted: Wed Aug 23, 2006 11:49 pm
by Schw00d
BTW, this is Fedora core 5, MySQL 5.0.22

PostPosted: Thu Aug 24, 2006 6:21 am
by mflorell
check that your dbconnect.php file is configured for your database IP address. You also might want to change the $WeBRooTWritablE variable to 0 if you aren't going to make those directories world writable.

Agent phone doesn't ring

PostPosted: Thu Sep 07, 2006 5:33 pm
by mayankanup
I am also having the similar problem.
My setup is as follows

A SIP softphone with extension 191 is connected to Asterisk. From 191 i am able to make a call to a PSTN phone (my cell phone) by dialing one of the peer asterisk gateway.

I have done all as mentioned in VICIDIAL Manager Manual Tutorial A. I have verified that there are two conference rooms and their configuration in database and asterisk configuration files.

However when i login on /agc/vicidial.php with phone 191 there is no ringing on my softphone and i don't see anything on Asterisk CLI. Please help.

PostPosted: Thu Sep 07, 2006 10:07 pm
by mflorell
Did you follow the SCRATCH_INSTALL document when you setup your server?

what is the output of "screen -r" on the Linux commandline?

PostPosted: Fri Sep 08, 2006 12:29 pm
by mayankanup
Hi ,
Here is the output from Asterisk CLI

Code: Select all
[root@pbxmobile-0 asterisk]# screen asterisk -vvvvc
  == Registered translator 'alawtoulaw' from format alaw to ulaw, cost 1
  == Registered translator 'ulawtoalaw' from format ulaw to alaw, cost 1
 [codec_g726.so] => (ITU G.726-32kbps G726 Transcoder)
  == Parsing '/etc/asterisk/codecs.conf': Found
    -- codec_g726: using generic PLC
  == Registered translator 'g726tolin' from format g726 to slin, cost 2
  == Registered translator 'lintog726' from format slin to g726, cost 3
 [format_gsm.so] => (Raw GSM data)
  == Registered file format gsm, extension(s) gsm
 [format_wav.so] => (Microsoft WAV format (8000hz Signed Linear))
  == Registered file format wav, extension(s) wav
 [format_wav_gsm.so] => (Microsoft WAV format (Proprietary GSM))
  == Registered file format wav49, extension(s) WAV|wav49
 [format_vox.so] => (Dialogic VOX (ADPCM) File Format)
  == Registered file format vox, extension(s) vox
 [format_pcm.so] => (Raw uLaw 8khz Audio support (PCM))
  == Registered file format pcm, extension(s) pcm|ulaw|ul|mu
 [format_g729.so] => (Raw G729 data)
  == Registered file format g729, extension(s) g729
 [format_pcm_alaw.so] => (Raw aLaw 8khz PCM Audio support)
  == Registered file format alaw, extension(s) alaw|al
 [format_h263.so] => (Raw h263 data)
  == Registered file format h263, extension(s) h263
 [format_g726.so] => (Raw G.726 (16/24/32/40kbps) data)
  == Registered file format g726-40, extension(s) g726-40
  == Registered file format g726-32, extension(s) g726-32
  == Registered file format g726-24, extension(s) g726-24
  == Registered file format g726-16, extension(s) g726-16
 [format_ilbc.so] => (Raw iLBC data)
  == Registered file format iLBC, extension(s) ilbc
 [format_sln.so] => (Raw Signed Linear Audio support (SLN))
  == Registered file format sln, extension(s) sln|raw
 [format_au.so] => (Sun Microsystems AU format (signed linear))
  == Registered file format au, extension(s) au
 [format_jpeg.so] => (JPEG (Joint Picture Experts Group) Image Format)
  == Registered format 'jpg' (JPEG (Joint Picture Experts Group))
 [format_g723.so] => (G.723.1 Simple Timestamp File Format)
  == Registered file format g723sf, extension(s) g723|g723sf
 [format_ogg_vorbis.so] => (OGG/Vorbis audio)
  == Registered file format ogg_vorbis, extension(s) ogg
 [cdr_csv.so] => (Comma Separated Values CDR Backend)
 [cdr_manager.so] => (Asterisk Call Manager CDR Backend)
  == Parsing '/etc/asterisk/cdr_manager.conf': Found
 [cdr_custom.so] => (Customizable Comma Separated Values CDR Backend)
  == Parsing '/etc/asterisk/cdr_custom.conf': Found
 [cdr_pgsql.so] => (PostgreSQL CDR Backend)
  == Parsing '/etc/asterisk/cdr_pgsql.conf': Found
 [func_callerid.so] => (Caller ID related dialplan function)
  == Registered custom function CALLERID
 [func_enum.so] => (ENUM Related Functions)
  == Registered custom function ENUMLOOKUP
  == Registered custom function TXTCIDNAME
 [func_uri.so] => (URI encode/decode functions)
  == Registered custom function URIDECODE
  == Registered custom function URIENCODE
  ==Manager registered action DBGet
  == Manager registered action DBPut
  == Parsing '/etc/asterisk/enum.conf': Found
Asterisk Ready.
*CLI>

[/code]

PostPosted: Fri Sep 08, 2006 12:48 pm
by mayankanup
When i login to
http://myip/agc/vicidial.php

after a few minute i see following screen appearing on the webpage

Noone is in your session 860051.

PostPosted: Fri Sep 08, 2006 2:32 pm
by mtancoff
mmmm check this in Mysql:

Select * from vicidial_manager

If you see all recods with status "NEW", that means thats actions go into the queue and for some reason are not executed.

There could be several reasons:

Manager.conf missconfigured
astguiclient.conf misssconfigured
crontab missconfigured

IP missconfigured
What I did is put "127.0.0.1" everywhere, this means:

vicidial_conferences table
conferences table
servers table (web administrable)
vicidial_phones table
other tables
etc/atguiclient.conf




My MSN: matias_tancoff@hotmail.com

XARA TELECOMUNICACIONES
phones: 54-11-43287760/0085
Pte Perón 935 PB "3"
Capital Federal
República Argentina

PostPosted: Fri Sep 08, 2006 3:01 pm
by mayankanup
Hi,
I found out the problem. It was because Time::HiRes module was not correctly installed on my system. After getting the RPM for RHEL 3 (my linux) i ran
/home/cron/ADMIN_area_code_populate.pl

and after that things are working as they should. Thank you all for the support and help.