vicidial.org

by **ssin14** » Sun Oct 15, 2006 1:48 am

DBD::mysql::db do failed: Table 'asterisk.vicidial_hopper' doesn't exist at /usr/share/astguiclient/AST_VDhopper.pl line 288.

I am not able to figure it out whats wrong here.

Most appreciatable

by **kchung** » Sun Oct 15, 2006 11:04 pm

I don't think you follow the scratch_install carefully; specifically the part which creates the sql tables.

by **ssin14** » Tue Oct 17, 2006 10:01 pm

Please just let me know whats wrong with it.

we get this when agent logs in:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/agc/vicidial.php on line 617
Sorry, there are no leads in the hopper for this campaign

What I have to do. Please mate.

by **kchung** » Tue Oct 17, 2006 11:14 pm

You need to look through step 2 of Subphase 6.1.

by **ssin14** » Wed Oct 18, 2006 4:18 am

As far as I am concerned I followed the scratch install and it was working really well for a week. Its just one day I rebooted the server these messages started coming.

I just followed that instructions and I think I did it right and thats why it was working. I never went back and did any changes.

Problem now is I dont know how to go back and check as I am not that good linux. I learned but cant learn all overnight. My centre is stuck and if you can tell me how I can go back and check whats wrong

Matt told me to post results of
mysql
asterisk;
show tables;

how can I do this in the screen

I wrote exactly that and nothing came.
I have 2 servers
1=>Asterisk/vicidial
2=>MySQL

please mate just help me solve this problem

by **kchung** » Wed Oct 18, 2006 1:13 pm

basically, something went wrong with your mysql server.

all your data is stored in a database named 'asterisk'
within the database, the data is partitioned into tables, which is like a spreadsheet.

login to the shell of the mysql server
type in: mysql
type in: use asterisk
type in: show tables

by **ssin14** » Wed Oct 18, 2006 5:38 pm

my mysql server is runing this command at the moment

Starting mysdld daemon with database from /usr/local/mysql/var

when ever i put any commands like that nothing happens

Is there any special command i have to put log in to mysql.

by **ssin14** » Sun Oct 22, 2006 3:50 pm

any ideas..................

by **ssin14** » Sun Oct 22, 2006 5:58 pm

Can anyone please let me know why cant I see anything when a type things after I entered /etc/rc.local

It says
Starting mysqld daemon with database from /usr/local/mysql/var

and after this when I run any command it doesnt work.

Is this suppose to happen

by **ssin14** » Sun Oct 22, 2006 10:51 pm

Hi

Please anyone knows whats wrong here.

by **gardo** » Mon Oct 23, 2006 10:01 am

i would suggest you rebuild your mysql database by following the install from scratch document. you can start from "SUBPHASE 6.1: creating the MySQL asterisk database".

you can move your old asterisk mysql files by following these instructions:

login as root
#su -

enter root password
#

stop mysql (if you have centos)
#/etc/init.d/mysqd stop

if not
#ps ax | grep mysqld (you will see a list of mysql process and their pids)

kill the mysql process
#kill -9 {pid of mysql}

change directory to mysql database
#cd /var/lib/mysql (assumming this is your mysql database dir)

rename old asterisk directory
#mv asterisk asterisk.old

restart your mysql
#/usr/local/mysql/bin/mysqld_safe --user=mysql --skip-name-resolve --skip-host-cache &

rebuild your asterisk mysql files from SUBPHASE 6.1.

by **ssin14** » Mon Oct 23, 2006 5:47 pm

A very thank you to you.

Before rebuilding I want to let you know that I can log into .....vicidial/admin.php and .......astguiclient.admin.php.

I can add phones and users and all those.

Its just .....agc/vicidial.php where after logging to the phone and user prompt I see this:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/agc/vicidial.php on line 617
Sorry, there are no leads in the hopper for this campaign

DO I still have to build mysql server again?

by **gardo** » Tue Oct 24, 2006 5:03 am

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/agc/vicidial.php on line 617
Sorry, there are no leads in the hopper for this campaign

Most probably you haven't inserted any campaigns and lists yet. Go to "SUBPHASE 6.6: adding test leads to the VICIDIAL database and configuring a
VICIDIAL campaign and users" from install from scratch.

If you complete SUBPHASE 6.6, then you don't need to rebuild your mysql database.

by **gerski** » Tue Oct 24, 2006 4:07 pm

try to upload leads first and set an hopper before login.

by **ssin14** » Tue Oct 24, 2006 6:31 pm

very very thank to you all.

One thing I am bit confussed. after clicking /etc/rc.local (/usr/local/mysql/bin/mysqld_safe --user=mysql)

I see written on the screen
starting mysqld daemon with databases from /usr/local/mysql/var

after this when I want to put any commands should it start with
mysql> ?

of nothing ?

by **ssin14** » Tue Oct 24, 2006 11:03 pm

by **ssin14** » Tue Oct 24, 2006 11:28 pm

by **xuehan** » Wed Oct 25, 2006 2:59 pm

I started to learn vicidial yesterday. Till now I have not made a successful dial yet. I was following the install from scratch and then the tutorials section A in the free sample version of "Manager_Manual_LowRes_BW.pdf", then I met the problem "Sorry, there are no leads in the hopper for this campaign".

I checked the database and found "vicidial_hopper" has 0 records, it seems the perl cron jobs did not update the table.

Yes, The problem was sth related to the database. I rebuild the database as suggested by gardo, and the test user 7777 could login, but still I cound not dial out. Then I checked the table "servers", it has one record for "192.168.2.19" which is my linux, but seems I failed to telnet 192.168.2.19 at 5038 so I inserted another record into the table "servers" with serverip_ip "127.0.0.1". I still could not dial out with this change. But later on, the user 7777 could not login with the same error message "Sorry, there are no leads in the hopper for this campaign".

So the direct reason is that the table "vicidial_hopper" has 0 records for the campaign. But I don't know which perl script (AST_update.pl ?) does the update of vicidial_hopper. The perl/php scripts are too complicated for me to trace them.

by **ssin14** » Wed Oct 25, 2006 5:52 pm

what is vicidial_ hopper's purpose?

There is none in the table and where did it came from before. In scratch install doc , no entries have made or non infor about vicidial_hopper.

There it only tells about AST_VDVicidial.pl

I can see some of the tables values. I can see details of vicidial_statues
, vicidial_list etc.

But what went wrong. How to fix this?

Its no point doing it all over again. What happens if it happened again?

Thanks

by **Dion** » Wed Oct 25, 2006 7:07 pm

I also started installing and am reading forums would also like to know what this vicidial_hopper and other tables came from? Is vicidial_hopper gets created automatically?

by **mflorell** » Sat Oct 28, 2006 9:06 am

extras/MySQL_AST_CREATE_tables.sql

please re-read the SCRATCH_INSTALL document

by **ssin14** » Sun Oct 29, 2006 4:12 pm

I got solutions!!!!!

all i did was executed the \. /usr/share/astguiclient/MySQL_AST_CREATE_tables.sql It adds vicidial_hopper and the rest it says duplicate records.

I have no idea though how vicidia_hopper got deleted.

cheers matt

vicidial.org

DBD::mysql::db do failed:

DBD::mysql::db do failed:

Anyone know how to do this

I am having the same problem since yesterday

Who is online