by stevers » Sat Dec 09, 2006 7:47 am
Having started out from scratch with the db, I got a "PHONE NOT ADDED - Please go back and look at the data you entered" msg when I try to add an extension. All fields are blank.
Having executed the grant statements I thought I'd check on the passwords. They are all recorded as an encrypted pw.
Running "UPDATE mysql.user set password=OLD_PASSWORD('1234') where user='cron';"
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
Mysql is V. 4.1.20
I think that under an earlier install (which was Trixbox) I had to make it read 1234 in plain text, which I thought the above command would do. (Current is plain CentOS.) So it looks like I have to overcome that one, but I'm not sure.
The setup does show default server and phones. Asterisk server admin does let me update the server, but not add phones.
I have two sql scripts which I run to create my vicidial db that I can share if needed, (And yes I do update the DB line in admin.php to say vicidial instead of asterisk.)
Starting with a even more minimalistic db setup I only have a default phone (102) and I add the server. Looks good.
I add a list and leads. Restart the hopper and 5 leads goes in it. I login as 102 and user 6666 and when the client screen loads I press the dial next number button which then populates the fields with data. Shortly thereafter it times out, probably as it has not connected me to the phone.
Asterisk sees the two phones connected (one being 102) which is registered. The correct IP is in the admin config. Ditto with all other data as far as I can see. (IP, login, pwd, active etc.)
I noticed that it tried to use a non existent conference # (8600051) so I added it. Restarting hopper and so on I still get the PHONE NOT ADDED message from the vicidial client. Lead is loaded, all looks good except no connect to the phone.
Three dbconnects are all updated with correct info.
(I'm certainly learning more in depth than I knew before, but I still cannot debug this fully.)