Location of lead list

[infinitegary]

Hi i have an issue my list is to large to download from the admin interface when i click on download the file is just blank. (700k leads in the list) my question is can i just use winscp to download my lists from there? If so where are the leads and lists stored at on the server in what file directories? Any help is appreciated.

[geoff3dmg]

How are you with SQL? The only way to get a list of this size out is to stop dialing and then use a MySQL client to pull out what you want from the database table.

[infinitegary]

Thanks for the reply i have used it in the past but not for the dialer server how would i access it?

[infinitegary]

Ok i figured it out im in mysql now i see the datbases now. Do you know which datbase name has the lists?

[geoff3dmg]

lists are defined in asterisk.vicidial_lists. The actual data is in asterisk.vicidial_list.

[infinitegary]

It appears the list i need is not on the mysql server i was able to access its on the other one however when i type 192.168.1.200/phpmyadmin it says not found but works on other server ? What could i be doing wrong?

[DomeDan]

try 192.168.1.200/phpMyAdmin/ (notice the upper case letters)

[infinitegary]

thanks that seems to bring up a login box. But i guess default passwords are not working now where can i go to recover that info or reset it? Thanks for all your help here

[DomeDan]

login info for the database can be found in /etc/astguiclient.conf on the server (do not edit the file)

[infinitegary]

None of that info worked

[DomeDan]

that info is what the system uses, if it dont work then the system wont work.
I suggest you make someone with knowledge do this for you. then ask that person to modify the export scripts to save them to the server disk so you can use winscp to copy them over