Installation Vicibox 3.1.15

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Installation Vicibox 3.1.15

Postby ennioj » Thu Mar 29, 2012 4:34 am

Hi ' im trying to install Vicibox 3.1.15 from iso (no SVN )

I've to install a multicluster environment
1 WEB/DATABASE
2 Asterisk server.

When I install web/db server all seems go fine but the vicidial_users is empty.

Where i can check, or is it normal ?
which entries are inserted by the first server and which by the other (like conferences phones ...)
I noticed that vicidial_campiagns is empty too.

All my specs are in my signature only change the version of Vicibox
Vicibox 3.1.12 Inst by ISO
VERSION: 2.4-334a
BUILD: 110831-2038
Multiserver 1 DATABASE 2 ASTERISK
Asterisk 1.4.28 vici
Manual to INSTALL multiserver READ
ennioj
 
Posts: 18
Joined: Thu Oct 13, 2011 9:30 am

Installation Vicibox 3.1.15

Postby xirin6 » Thu Mar 29, 2012 12:58 pm

Sounds like first_server_install.sql script did not successfully run during the install process. You can run it manually by copying and pasting the .sql text from /usr/src/astguiclient/trunk/extras/first_server_install.sql It is basically all of the default inserts needed for default entries including the 6666 user.
xirin6
 
Posts: 22
Joined: Wed Jun 07, 2006 3:24 pm
Location: Florida

Postby ennioj » Fri Mar 30, 2012 3:04 am

Thanks for your response.

What can be the cause of first_server_install.sql doesent run ?
Vicibox 3.1.12 Inst by ISO
VERSION: 2.4-334a
BUILD: 110831-2038
Multiserver 1 DATABASE 2 ASTERISK
Asterisk 1.4.28 vici
Manual to INSTALL multiserver READ
ennioj
 
Posts: 18
Joined: Thu Oct 13, 2011 9:30 am

Postby GaD » Wed Apr 11, 2012 9:11 pm

Honestly this happened to me A LOT! I can almost assure you that I get htat error every time I install... can't really remember what the problem was..., I am tempted to say that the insert statement has less fields than the database has therefore it fails.

Go ahead and check the first_server_install.sql, check how many fields are in the CREATE TABLE there are and compare to the ammount of fields the 'INSERT INTO users' statement. I believe I just add 3 commas in the INSERT statement and I can run that INSERT manually again.
GaD
 
Posts: 195
Joined: Fri Jul 08, 2011 3:56 pm

Postby spacejanitor » Thu Apr 12, 2012 10:37 am

Oh! I think I know :)

The instructions for installing the cluster (Installation for ViciBox Redux with Clustering) have a small mistake in them...

After the "Web Server Installation" portion, step 7 tells you "When you are done, you should be able to navigate a web browser to "//server/vicidial/admin.php"

Well... yes, you can navigate there, but you will not be able to login :)

Reason being that it's the Telephony Server installation that is the one that runs whichever script it is that inserts the users table into the DB. I don't know why, but the DB installation alone does not run it.

Once you install your telephony server with the proper credentials to connect to your DB, you should be fine.
spacejanitor
 
Posts: 178
Joined: Tue Feb 08, 2011 3:31 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 145 guests