Vicibox Redux 3.0.6 Telephony Servers not added

[Trying]

Hi

I installed Vicibox Redux 3.0.6 following the clustering installation document. I see in the document that the telephony servers should show in the database, but I only see the database server in admin/servers and none of the 4 telephony servers that I installed. I did point all of them to the database IP during installation.

Another interesting thing is that on not one of the servers did SVN install and I did choose to use the latest SVN trunk. The version and build is still: v.2.4-283 Build 100929-1203. Surely that has changed since the 3.0.6 release?

[williamconley]

If SVN didn't install, you didn't have "Net" during the installation. If you didn't have net during the installation, they could not make contact with the database server and install themselves.

[Trying]

I am "pretty sure" I did have net because I also upgraded the OS and it downloaded just fine. I also made sure I set all the servers' IP addresses properly after the initial os-install and did a reboot. Let me reinstall again. Maybe, or rather likely, I did something wrong somewhere.

[Trying]

Hi

There is definitely something wrong here. I started all over again with the same results. I had our IT company here who double checked all my network settings and they are fine. The servers can all ping (see) each other and the internet connection is also fine. I followed the installation document to the t. When I did a zypper refresh && zypper up after the os-install it also downloaded the latest repositories which proves that the internet connection is working.

So first I install the DB server. I chose SVN but did not see it download anything or even attempt to at all. I then installed the Web Server with the same results. If I now go into the Web Server I can see DB1 is added to admin/servers with the correct IP address. But it is still v.2.4-283 Build 100929-1203 which means it simply installs the SVN off the disc and does not download the latest. I then installed the first dialer, however still ONLY see DB1 in admin/server. The dialer is not on the server list.

Did anyone else actually do a full multi server installation using 3.0.6 with latest SVN and it worked 100%? Please help guys as this is very frustrating. (I am not sure if it is supposed to ask somewhere if you want to go online to download the latest SVN but it doesn't. It just asks if you want to install SVN and makes no mention of downloading it.)

[williamconley]

SVN is downloading. the system does not have "svn on the disk", it may have the latest trunk as of the release of the disk, but SVN is a web-based function. so saying "use latest SVN" is you giving it permission to "go get it from the net".

[Trying]

It can also not be a problem with the download itself because I am using the 3.0.6 DB version for the DB and normal 3.0.6 for the rest. Meaning that if something went wrong with the download at least one disc should work properly.

[williamconley]

if the download doesn't work, it won't work for either disk. the ability to download does not reside within the disk but is a connection between your computer and The Vicidial Group's servers. If that link is broken for some reason, a new disk will not fix it.

I would expect that your logs or some other method will be necessary to resolve why the system is not connecting as it should.

[Trying]

I meant maybe something went wrong with me initially downloading the 3.0.6 discs but then at least one of the two should have worked.

We ran constant pings today between our servers and to the eflo download site and there is nothing wrong with the connection at all. My suspicion remains that the Vicibox discs do not actually initiate download. That is why I asked if anyone actually installed multi servers using the 3.0.6 discs and can confirm that it did in fact download the latest SVN.

The second question also remains as to why the Dialer does not show up on the servers list but the DB does. We also pinged between the Dialer and DB before and after installing the Dialer and there are no issues.

[williamconley]

Sorry, I haven't experienced any of these problems. We use 3.0.6 for installs and it always succeeds in getting the latest SVN download. What version/build of vicidial is on the box when installation is complete?

[Trying]

v.2.4-283 Build 100929-1203 which is included in the cd.

[Kumba]

When doing the multi-server install, are you putting in the connection information for the database then the installer is asking for it? Or are you going into astguiclient.conf after the fact and changing it? Does all your machines have a unique hostname? Are you telling the dialers that it is not the database?

Simply telling the install disk to use SVN does not mean it connects and downloads latest SVN. It just means it uses the SVN code packaged with the disk. You need to select yes to the update option when it prompts. This will cause the disk to attempt to update the OS, download new perl modules, and download an updated SVN version.

I can't really duplicate the issue you are having. It seems like you are feeding something the wrong information.

[Trying]

Yes, as far as I know I am doing exactly what the document says. When the installer asks for the database information I enter the IP address, username, password. Yes, they all have a unique hostname like db1, apache1, dialer1, etc. Yes, I tell the dialers that they are ONLY telephony servers and not web or db servers.

You need to select yes to the update option when it prompts.

This is the interesting part. I can remember the prompt "use SVN" but I cannot remember seeing an update prompt at all. I will check again.

[Kumba]

Don't enter a username or password for the database. This is set to use the defaults. Just enter the database IP.

[Trying]

I just reinstalled our first dialer. Underneath is how it went. I didn't see any update prompt. The server also still doesn't show in admin/servers. Only DB1.

Use SVN Code : y
Install Core DB : n
Install Web App : n
Install Telephony : y
- Additional Server : y
- Install Wanpipe : y
- Install Voicetime : n

If you plan to install and boot from a new kernel you will need
to recompile libPRI, DAHDI, Wanpipe, and Asterisk after installation.

The system will give you instructions as it progresses on certain key
combinations to enter for proper installation. This installer will
automatically pause at those instructions.

--- Press Enter to continue or CTRL-C to exit ---

Configuring general system
Configuring Firewall
Installing required PERL modules
|
Installing general requirements -Installing Telephony Server (This may take some time)
/

Installing Telephony Server (This may take some time)
|mkdir: cannot create directory `/var/lib/asterisk/quiet-mp3': File exists \
This server is about to connect to the database to configure it's server
entry in ViciDial. Please make sure that the Database server is installed
and that it is reachable from the dialer before continuing.

Please do not change the old server IP as it is the default value.

--- Press Enter to continue or CTRL-C to exit ---
CLI defined old server IP: 10.10.10.16
CLI defined server IP: 192.168.0.241
Previous astGUIclient configuration file found at: /etc/astguiclient.conf
Writing change to astguiclient.conf file: /etc/astguiclient.conf

STARTING DATABASE TABLES UPDATES PHASE...
Updating servers table...
|0E0|UPDATE servers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating phones table...
|0E0|UPDATE phones SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating inbound_numbers table...
|0E0|UPDATE inbound_numbers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating server_updater table...
|0E0|UPDATE server_updater SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating conferences table...
|0E0|UPDATE conferences SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_conferences table...
|0E0|UPDATE vicidial_conferences SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_stations table...
|0E0|UPDATE vicidial_stations SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_remote_agents table...
|0E0|UPDATE vicidial_remote_agents SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating phone_favorites table...
|0E0|UPDATE phone_favorites SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_server_trunks table...
|0E0|UPDATE vicidial_server_trunks SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_server_carriers table...
|0E0|UPDATE vicidial_server_carriers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_inbound_dids table...
|0E0|UPDATE vicidial_inbound_dids SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_process_triggers table...
|0E0|UPDATE vicidial_process_triggers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Setting servers to rebuild conf files...
|1|UPDATE servers SET rebuild_conf_files='Y' where generate_vicidial_conf='Y' and active_asterisk_server='Y';|

SERVER IP ADDRESS CHANGE FOR VICIDIAL FINISHED!


- process runtime (0 sec) (0 minutes)


If the server was updated successfully, you should see it listed in your
ViciDial admin interface with the corrected IP that you entered. Please make
sure this server has a unique name so that it won't conflict with any other
ViciDial servers before continuing.

--- Press Enter to continue or CTRL-C to exit ---
You have new mail in /var/mail/root
dialer1:~ #

[Trying]

Sorry, yes I only used the IP address and left the username and password the defaults.

[williamconley]

Sorry, yes I only used the IP address and left the username and password the defaults.

i don't suppose you still have that screen available?

[Trying]

No but I will reinstall again and post it here.

[Trying]

Here is what is within astguiclient/conf

# The IP address of this machine
VARserver_ip => 192.168.0.241

# Database connection information
VARDB_server => 192.168.0.236
VARDB_database => asterisk
VARDB_user => cron
VARDB_pass => 1234
VARDB_custom_user => custom
VARDB_custom_pass => custom1234
VARDB_port => 3306

[Trying]

One problem is sorted. When I installed this time I chose to upgrade the OS. Then only does it download the latest SVN as well.

[williamconley]

Sorry, yes I only used the IP address and left the username and password the defaults.

i don't suppose you still have that screen available?

and this?

[Trying]

I am reinstalling the complete set up now. Will post that information as soon as I get to the first dialer.

[williamconley]

One problem is sorted. When I installed this time I chose to upgrade the OS. Then only does it download the latest SVN as well.

I've installed many times and Never update the OS (reflex: that function used to crash the install! LOL). But I always get latest SVN. Are you sure that was the only difference? (Have you tried not updating the OS again to see if that breaks SVN again?)

[Trying]

Yes, that is definitely the only thing I changed. Haha, no I don't want to break it again! I am now sick and tired of installing!

[Trying]

I have installed again but yet again the Dialer is not showing in admin/servers. Here is the install:

By default, all new installs of ViciBox have the firewall enabled.
You will either need to disable the firewall or open up ports in order to do
multi-server configurations or access services externally. Unless this server
is going to be directly connected to the internet we recommend disabling the
firewall.

Would you like to turn the built-in firewall off? (y/N) : y

ViciDial currently has two standard codebases. Version 2.2.1 is the latest
stable release of the software. There is also the SVN Trunk branch which
includes any new features and/or bugfixes. Any custom development or other
bug fixes done after the last stable release will be in SVN Trunk. We
normally recommend our customers use the SVN Trunk code base.

Do you want to use the SVN Trunk codebase? (y/N) : y

ViciBox can be installed in varying rolls depending upon your needs.
The following questions will ask you what role this particular server
is to play within your environment. If this server is NOT acting as the
DataBase then you need to wait until the Database server is up and
properly provisioned. This install WILL FAIL if the database is not
installed and provisioned prior to this installation. Please have the
DataBase IP available to complete the install.

Will this server be used as the Database? (y/N) : n

Will this server be used as a Web server? (y/N) : n

Will this server be used as a Telephony server? (y/N) : y
---> Is this an additional telephony server in a cluster? (y/N) : y
---> Do you have a Sangoma T1/E1 card installed? (y/N) : y

Your ViciBox Redux system will be configured as follows:

OS Update : y
Stop Firewall : y
Use SVN Code : y
Install Core DB : n
Install Web App : n
Install Telephony : y
- Additional Server : y
- Install Wanpipe : y
- Install Voicetime : n

If you plan to install and boot from a new kernel you will need
to recompile libPRI, DAHDI, Wanpipe, and Asterisk after installation.

The system will give you instructions as it progresses on certain key
combinations to enter for proper installation. This installer will
automatically pause at those instructions.
Updating SVN

Updating OS
/
Updating PERL modules (This may take some time)
\
Installing general requirements
Installing Telephony Server (This may take some time)
/no crontab for root \
CLI defined webroot path: /srv/www/htdocs
CLI active keepalive procs: 123468
CLI copy conf files: YES

Would you like to use manual configuration and installation(y/n): [y]
STARTING ASTGUICLIENT MANUAL CONFIGURATION PHASE...

astguiclient home path or press enter for default: [/usr/share/astguiclient]
/usr/share/astguiclient does not exist, would you like me to create it?(y/n) [y]
/usr/share/astguiclient directory created

astguiclient logs path or press enter for default: [/var/log/astguiclient]
/var/log/astguiclient does not exist, would you like me to create it?(y/n) [y]
/var/log/astguiclient directory created

asterisk agi-bin path or press enter for default: [/var/lib/asterisk/agi-bin]

server webroot path or press enter for default: [/srv/www/htdocs]

asterisk sounds path or press enter for default: [/var/lib/asterisk/sounds]

asterisk monitor path or press enter for default: [/var/spool/asterisk/monitor]

asterisk DONEmonitor path or press enter for default: [/var/spool/asterisk/monitorDONE]

server IP address or press enter for default: [192.168.0.241]

DB server address or press enter for default: [localhost] 192.168.0.236

DB database name or press enter for default: [asterisk]

DB user login or press enter for default: [cron]

DB user password or press enter for default: [1234]

DB custom user login or press enter for default: [custom]

DB custom password login or press enter for default: [custom1234]

DB connection port or press enter for default: [3306]

Numeric list of the astGUIclient processes to be kept running
(value should be listing of characters with no spaces: 123456)
X - NO KEEPALIVE PROCESSES (use only if you want none to be keepalive)
1 - AST_update
2 - AST_send_listen
3 - AST_VDauto_dial
4 - AST_VDremote_agents
5 - AST_VDadapt (If multi-server system, this must only be on one server)
6 - FastAGI_log
7 - AST_VDauto_dial_FILL (only for multi-server, this must only be on one server)
8 - ip_relay (used for blind agent monitoring)
9 - Timeclock auto logout
Enter active keepalives or press enter for default: [123468]
Enter the Asterisk version that you are installing VICIDIAL for
(value should be listing of characters with no spaces: 123456)
1.2
1.4
Enter asterisk version or press enter for default: [1.4]

Copy sample configuration files to /etc/asterisk/ ? [y]

FTP host address or press enter for default: [10.0.0.4] 192.168.0.237

FTP user login or press enter for default: [cron] archive

FTP user password or press enter for default: [test] Cancer4139#

FTP connection port or press enter for default: [21]

FTP directory or press enter for default: [RECORDINGS]

HTTP path for archive or press enter for default: [http://10.0.0.4] 192.168.0.237

REPORT host address or press enter for default: [10.0.0.4] http://192.168.0.237

REPORT user login or press enter for default: [cron] archive

REPORT user password or press enter for default: [test] Cancer4139#

REPORT connection port or press enter for default: [21]

REPORT directory or press enter for default: [REPORTS]

FastAGI log minimum child servers: [3]

FastAGI log maximum child servers: [16]

FastAGI log minimum spare child servers: [2]

FastAGI log maximum spare child servers: [8]

FastAGI log maximum requests per child server: [1000]

FastAGI log check-for-dead seconds: [30]
FastAGI log check-for-wait seconds: [60]

defined home path: /usr/share/astguiclient
defined logs path: /var/log/astguiclient
defined agi-bin path: /var/lib/asterisk/agi-bin
defined webroot path: /srv/www/htdocs
defined sounds path: /var/lib/asterisk/sounds
defined monitor path: /var/spool/asterisk/monitor
defined DONEmonitor path: /var/spool/asterisk/monitorDONE
defined server_ip: 192.168.0.241
defined DB_server: 192.168.0.236
defined DB_database: asterisk
defined DB_user: cron
defined DB_pass: 1234
defined DB_custom_user: custom
defined DB_custom_pass: custom1234
defined DB_port: 3306
defined active_keepalives: 123468
defined asterisk_version: 1.4
defined copying conf files: y
defined FTP_host: 192.168.0.237
defined FTP_user: archive
defined FTP_pass: Cancer4139#
defined FTP_port: 21
defined FTP_dir: RECORDINGS
defined HTTP_path: 192.168.0.237
defined REPORT_host: http://192.168.0.237
defined REPORT_user: archive
defined REPORT_pass: Cancer4139#
defined REPORT_port: 21
defined REPORT_dir: REPORTS
defined fastagi_log_min_servers: 3
defined fastagi_log_max_servers: 16
defined fastagi_log_min_spare_servers: 2
defined fastagi_log_max_spare_servers: 8
defined fastagi_log_max_requests: 1000
defined fastagi_log_checkfordead: 30
defined fastagi_log_checkforwait: 60

Are these settings correct?(y/n): [y]
Writing to astguiclient.conf file: /etc/astguiclient.conf

STARTING ASTGUICLIENT INSTALLATION PHASE...
Creating /usr/share/astguiclient/LEADS_IN directories...
Creating /var/spool/asterisk/monitor directories...
Creating /var/log/astguiclient/archive directory for backups...
Copying bin scripts to /usr/share/astguiclient ...
Copying libs to /usr/share/astguiclient ...
setting cron scripts to executable...
Copying extras files to /usr/share/astguiclient ...
Copying agi-bin scripts to /var/lib/asterisk/agi-bin ...
setting agi-bin scripts to executable...
Copying sounds to /var/lib/asterisk/sounds...
Copying ip_relay scripts to /usr/share/astguiclient...
Setting ip_relay scripts to executable...
Starting ip_relay port forwarding for IAX on 40569 and 41569
Creating /srv/www/htdocs web directories...
Copying web files...
setting web scripts to executable...
Copying sample conf files to /etc/asterisk/...
Creating auto-generated placeholder conf files in /etc/asterisk/...

ASTGUICLIENT INSTALLATION FINISHED! ENJOY!

- process runtime (774 sec) (12.9 minutes)
This server is about to connect to the database to configure it's server
entry in ViciDial. Please make sure that the Database server is installed
and that it is reachable from the dialer before continuing.

Please do not change the old server IP as it is the default value.

--- Press Enter to continue or CTRL-C to exit ---
CLI defined old server IP: 10.10.10.16
CLI defined server IP: 192.168.0.241
Previous astGUIclient configuration file found at: /etc/astguiclient.conf
Writing change to astguiclient.conf file: /etc/astguiclient.conf

STARTING DATABASE TABLES UPDATES PHASE...
Updating servers table...
|0E0|UPDATE servers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating phones table...
|0E0|UPDATE phones SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating inbound_numbers table...
|0E0|UPDATE inbound_numbers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating server_updater table...
|0E0|UPDATE server_updater SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating conferences table...
|0E0|UPDATE conferences SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_conferences table...
|0E0|UPDATE vicidial_conferences SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_stations table...
|0E0|UPDATE vicidial_stations SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_remote_agents table...
|0E0|UPDATE vicidial_remote_agents SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating phone_favorites table...
|0E0|UPDATE phone_favorites SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_server_trunks table...
|0E0|UPDATE vicidial_server_trunks SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_server_carriers table...
|0E0|UPDATE vicidial_server_carriers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_inbound_dids table...
|0E0|UPDATE vicidial_inbound_dids SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Updating vicidial_process_triggers table...
|0E0|UPDATE vicidial_process_triggers SET server_ip='192.168.0.241' where server_ip='10.10.10.16';|
Setting servers to rebuild conf files...
|1|UPDATE servers SET rebuild_conf_files='Y' where generate_vicidial_conf='Y' and active_asterisk_server='Y';|

SERVER IP ADDRESS CHANGE FOR VICIDIAL FINISHED!


- process runtime (1 sec) (0.0166666666666667 minutes)


If the server was updated successfully, you should see it listed in your
ViciDial admin interface with the corrected IP that you entered. Please make
sure this server has a unique name so that it won't conflict with any other
ViciDial servers before continuing.

[williamconley]

can you validate your ability to log in with those standard credentials from this console to the mysql on the mysql server?

[Trying]

Yes, I can connect just fine:

dialer1:~ # mysql -h 192.168.0.236 -u cron -p1234
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10632
Server version: 5.1.46-log SUSE MySQL RPM

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[Trying]

Something else that doesn't look right......... in Admin/System Settings there are no entries next to the fields below:

Version:
DB Schema Version:
DB Schema Update Date:
Auto User-add Value:
Install Date:

[Trying]

Here is an error constantly showing in the DB mail:

From root@db1.affinity.co.za Thu Nov 11 23:33:01 2010
Return-Path: <root@db1.affinity.co.za>
X-Original-To: root
Delivered-To: root@db1.affinity.co.za
Received: by db1.affinity.co.za (Postfix, from userid 0)
id CA7F0B46289; Thu, 11 Nov 2010 23:33:01 +0200 (SAST)
From: root@db1.affinity.co.za
To: root@db1.affinity.co.za
Subject: Cron <root@db1> /usr/share/astguiclient/ADMIN_keepalive_ALL.pl
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>
Message-Id: <20101111213301.CA7F0B46289@db1.affinity.co.za>
Date: Thu, 11 Nov 2010 23:33:01 +0200 (SAST)

DBD::mysql::st execute failed: Unknown column 'generate_cross_server_exten' in 'field list' at /usr/share/astguiclient/ADMIN_keepalive_ALL.pl line 858.
executing: SELECT sounds_central_control_active,active_voicemail_server,custom_dialplan_entry,default_codecs,generate_cross_server_exten FROM system_settings; Unknown column 'generate_cross_server_exten' in 'field list' at /usr/share/astguiclient/ADMIN_keepalive_ALL.pl line 858.

From root@db1.affinity.co.za Thu Nov 11 23:34:01 2010

This one from the first dialer. I only installed one dialer until I find the problem.

From root@dialer1.affinity.co.za Thu Nov 11 22:53:02 2010
Return-Path: <root@dialer1.affinity.co.za>
X-Original-To: root
Delivered-To: root@dialer1.affinity.co.za
Received: by dialer1.affinity.co.za (Postfix, from userid 0)
id B32C87E8B75; Thu, 11 Nov 2010 22:53:02 +0200 (SAST)
From: root@dialer1.affinity.co.za
To: root@dialer1.affinity.co.za
Subject: Cron <root@dialer1> /usr/share/astguiclient/ADMIN_keepalive_ALL.pl
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>
Message-Id: <20101111205302.B32C87E8B75@dialer1.affinity.co.za>
Date: Thu, 11 Nov 2010 22:53:02 +0200 (SAST)

DBD::mysql::st execute failed: Unknown column 'generate_cross_server_exten' in 'field list' at /usr/share/astguiclient/ADMIN_keepalive_ALL.pl line 858.
executing: SELECT sounds_central_control_active,active_voicemail_server,custom_dialplan_entry,default_codecs,generate_cross_server_exten FROM system_settings; Unknown column 'generate_cross_server_exten' in 'field list' at /usr/share/astguiclient/ADMIN_keepalive_ALL.pl line 858.

From root@dialer1.affinity.co.za Thu Nov 11 22:54:01 2010

[mflorell]

Looks like you updated to latest svn trunk, but you didn't update your DB

[Trying]

I wonder what I missed. For the DB I used the DB cd and installed it exactly the same way as with the other cd so the SVN should have updated. I guess I will have to reinstall again.

[mflorell]

No, update your ViciDial DB schema, not the DB software itself.

[Trying]

I updated the DB schema:

Version: 2.4b0.5
DB Schema Version: 1252
DB Schema Update Date: 2010-11-13 12:20:17
Auto User-add Value: 101
Install Date: 2010-02-08

The dialer is still not showing in admin/servers. Should I just add the other servers manually? Any advice will be highly appreciated.

[mflorell]

If entries are not there then you need to add them, as well as vicidial_conferences for each server.

[Trying]

I am almost ready to give up I updated the DB schema and then tried to add the dialers manually but it does not accept the default MySQL password when I want to add phones and conferences: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) - During the installation I went with the default username and password.

Thinking that I perhaps did something wrong updating the schema I yet again (must have been at least 10 times now) installed Vicibox 3.0.6 on all our servers. Yet again the schema doesn't show in server settings and none of the dialers are showing in admin/servers. Also, yet again, the default MySQL password is not accepted when I want to configure the servers manually.

It is probably something very obvious that I am missing somewhere. If you think the only way is for me to request for consultation then I will continue there.

[Op3r]

use cron and 1234 for password on the mysql

then add the entries for conferences.

Here's what I use.

Change the ip and the phones when adding additional servers.

INSERT INTO servers (server_id,server_description,server_ip,active,asterisk_version)values('Asterisk3','Asterisk 3 server', '10.10.10.22','Y','1.2.30.2');

INSERT INTO server_updater SET server_ip='10.10.10.22', last_update='';

INSERT INTO conferences values('8600001','10.10.10.22','');
INSERT INTO conferences values('8600002','10.10.10.22','');
INSERT INTO conferences values('8600003','10.10.10.22','');
INSERT INTO conferences values('8600004','10.10.10.22','');
INSERT INTO conferences values('8600005','10.10.10.22','');
INSERT INTO conferences values('8600006','10.10.10.22','');
INSERT INTO conferences values('8600007','10.10.10.22','');
INSERT INTO conferences values('8600008','10.10.10.22','');
INSERT INTO conferences values('8600009','10.10.10.22','');
INSERT INTO conferences values('8600010','10.10.10.22','');
INSERT INTO conferences values('8600011','10.10.10.22','');
INSERT INTO conferences values('8600012','10.10.10.22','');
INSERT INTO conferences values('8600013','10.10.10.22','');
INSERT INTO conferences values('8600014','10.10.10.22','');
INSERT INTO conferences values('8600015','10.10.10.22','');
INSERT INTO conferences values('8600016','10.10.10.22','');
INSERT INTO conferences values('8600017','10.10.10.22','');
INSERT INTO conferences values('8600018','10.10.10.22','');
INSERT INTO conferences values('8600019','10.10.10.22','');
INSERT INTO conferences values('8600020','10.10.10.22','');
INSERT INTO conferences values('8600021','10.10.10.22','');
INSERT INTO conferences values('8600022','10.10.10.22','');
INSERT INTO conferences values('8600023','10.10.10.22','');
INSERT INTO conferences values('8600024','10.10.10.22','');
INSERT INTO conferences values('8600025','10.10.10.22','');
INSERT INTO conferences values('8600026','10.10.10.22','');
INSERT INTO conferences values('8600027','10.10.10.22','');
INSERT INTO conferences values('8600028','10.10.10.22','');
INSERT INTO conferences values('8600029','10.10.10.22','');
INSERT INTO conferences values('8600030','10.10.10.22','');
INSERT INTO conferences values('8600031','10.10.10.22','');
INSERT INTO conferences values('8600032','10.10.10.22','');
INSERT INTO conferences values('8600033','10.10.10.22','');
INSERT INTO conferences values('8600034','10.10.10.22','');
INSERT INTO conferences values('8600035','10.10.10.22','');
INSERT INTO conferences values('8600036','10.10.10.22','');
INSERT INTO conferences values('8600037','10.10.10.22','');
INSERT INTO conferences values('8600038','10.10.10.22','');
INSERT INTO conferences values('8600039','10.10.10.22','');
INSERT INTO conferences values('8600040','10.10.10.22','');
INSERT INTO conferences values('8600041','10.10.10.22','');
INSERT INTO conferences values('8600042','10.10.10.22','');
INSERT INTO conferences values('8600043','10.10.10.22','');
INSERT INTO conferences values('8600044','10.10.10.22','');
INSERT INTO conferences values('8600045','10.10.10.22','');
INSERT INTO conferences values('8600046','10.10.10.22','');
INSERT INTO conferences values('8600047','10.10.10.22','');
INSERT INTO conferences values('8600048','10.10.10.22','');
INSERT INTO conferences values('8600049','10.10.10.22','');

INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600051','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600052','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600053','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600054','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600055','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600056','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600057','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600058','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600059','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600060','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600061','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600062','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600063','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600064','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600065','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600066','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600067','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600068','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600069','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600070','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600071','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600072','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600073','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600074','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600075','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600076','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600077','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600078','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600079','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600080','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600081','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600082','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600083','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600084','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600085','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600086','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600087','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600088','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600089','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600090','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600091','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600092','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600093','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600094','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600095','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600096','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600097','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600098','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600099','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600100','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600101','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600102','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600103','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600104','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600105','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600106','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600107','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600108','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600109','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600110','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600111','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600112','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600113','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600114','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600115','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600116','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600117','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600118','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600119','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600120','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600121','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600122','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600123','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600124','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600125','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600126','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600127','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600128','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600129','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600130','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600131','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600132','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600133','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600134','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600135','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600136','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600137','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600138','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600139','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600140','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600141','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600142','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600143','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600144','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600145','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600146','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600147','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600148','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600149','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600150','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600151','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600152','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600153','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600154','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600155','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600156','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600157','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600158','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600159','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600160','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600161','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600162','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600163','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600164','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600165','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600166','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600167','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600168','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600169','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600170','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600171','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600172','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600173','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600174','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600175','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600176','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600177','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600178','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600179','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600180','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600181','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600182','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600183','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600184','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600185','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600186','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600187','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600188','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600189','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600190','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600191','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600192','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600193','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600194','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600195','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600196','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600197','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600198','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600199','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600200','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600201','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600202','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600203','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600204','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600205','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600206','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600207','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600208','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600209','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600210','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600211','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600212','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600213','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600214','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600215','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600216','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600217','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600218','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600219','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600220','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600221','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600222','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600223','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600224','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600225','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600226','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600227','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600228','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600229','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600230','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600231','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600232','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600233','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600234','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600235','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600236','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600237','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600238','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600239','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600240','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600241','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600242','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600243','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600244','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600245','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600246','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600247','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600248','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600249','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600250','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600251','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600252','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600253','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600254','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600255','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600256','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600257','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600258','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600259','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600260','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600261','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600262','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600263','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600264','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600265','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600266','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600267','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600268','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600269','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600270','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600271','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600272','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600273','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600274','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600275','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600276','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600277','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600278','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600279','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600280','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600281','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600282','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600283','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600284','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600285','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600286','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600287','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600288','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600289','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600290','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600291','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600292','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600293','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600294','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600295','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600296','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600297','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600298','10.10.10.22');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600299','10.10.10.22');


INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc300','300','300','10.10.10.22','300','test','ACTIVE','Y','CCagent','station 200','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc301','301','301','10.10.10.22','301','test','ACTIVE','Y','CCagent','station 201','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc302','302','302','10.10.10.22','302','test','ACTIVE','Y','CCagent','station 202','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc303','303','303','10.10.10.22','303','test','ACTIVE','Y','CCagent','station 203','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc304','304','304','10.10.10.22','304','test','ACTIVE','Y','CCagent','station 204','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc305','305','305','10.10.10.22','305','test','ACTIVE','Y','CCagent','station 205','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc306','306','306','10.10.10.22','306','test','ACTIVE','Y','CCagent','station 206','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc307','307','307','10.10.10.22','307','test','ACTIVE','Y','CCagent','station 207','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc308','308','308','10.10.10.22','308','test','ACTIVE','Y','CCagent','station 208','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc309','309','309','10.10.10.22','309','test','ACTIVE','Y','CCagent','station 209','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc310','310','310','10.10.10.22','310','test','ACTIVE','Y','CCagent','station 210','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc311','311','311','10.10.10.22','311','test','ACTIVE','Y','CCagent','station 211','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc312','312','312','10.10.10.22','312','test','ACTIVE','Y','CCagent','station 212','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc313','313','313','10.10.10.22','313','test','ACTIVE','Y','CCagent','station 213','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc314','314','314','10.10.10.22','314','test','ACTIVE','Y','CCagent','station 214','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc315','315','315','10.10.10.22','315','test','ACTIVE','Y','CCagent','station 215','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc316','316','316','10.10.10.22','316','test','ACTIVE','Y','CCagent','station 216','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc317','317','317','10.10.10.22','317','test','ACTIVE','Y','CCagent','station 217','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc318','318','318','10.10.10.22','318','test','ACTIVE','Y','CCagent','station 218','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc319','319','319','10.10.10.22','319','test','ACTIVE','Y','CCagent','station 219','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc320','320','320','10.10.10.22','320','test','ACTIVE','Y','CCagent','station 220','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc321','321','321','10.10.10.22','321','test','ACTIVE','Y','CCagent','station 221','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc322','322','322','10.10.10.22','322','test','ACTIVE','Y','CCagent','station 222','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc323','323','323','10.10.10.22','323','test','ACTIVE','Y','CCagent','station 223','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc324','324','324','10.10.10.22','324','test','ACTIVE','Y','CCagent','station 224','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc325','325','325','10.10.10.22','325','test','ACTIVE','Y','CCagent','station 225','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc326','326','326','10.10.10.22','326','test','ACTIVE','Y','CCagent','station 226','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc327','327','327','10.10.10.22','327','test','ACTIVE','Y','CCagent','station 227','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc328','328','328','10.10.10.22','328','test','ACTIVE','Y','CCagent','station 228','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc329','329','329','10.10.10.22','329','test','ACTIVE','Y','CCagent','station 229','SIP','-5','0000000000');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid) values('cc330','330','330','10.10.10.22','330','test','ACTIVE','Y','CCagent','station 230','SIP','-5','0000000000');

[Trying]

Hi Op3r

Thank you for the response. That is exactly what I did. I used William's load balance document - I installed a couple of servers successfully in the past from it. The problem is that during the installation I do confirm the default username and password of cron and 1234 it gives a wrong password error. I am going to install the DB today from the 32bit disc and see if that makes a difference. It seems I always get the weirdest problems

[Kumba]

I'm not able to duplicate this issue. There is a good chance that the order of which things are being done or something being typed in is wrong, but without seeing what you are doing I don't really know.

[Trying]

I hate to admit defeat but I have to I will post in the request for consultation forum for someone to do the install for me.

[Op3r]

after reading some of your post here it seems you have a broken database and cant login to mysql.

change the root password like this

mysqladmin -u root password NEWPASSWORD

then rebuild your vicidial database by using the upgrade database sql for the version you are installing.

[Trying]

You are a star! Immediately my dialer also popped up in admin/servers. I just wonder why it kept breaking after I retried the installation so many times. When it came to db username cron and password 1234 I just entered to accept the default values.

Do I only have to run \. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql in MySql to rebuild the database to the very latest SVN?