migration from all-in-one to separated web-dialer and mysql

[brando16]

Hi all,

i try to create an mysql server for use with goautodial CE 3.3. I have modified the configuration file (astguiclient.conf, goautodial.conf, dbconnect.php in agc, agent and vicidial folders) but when i try to open web gui i got this error:

Code: Select all

Error Number: 1364

Field 'user_data' doesn't have a default value

INSERT INTO `go_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('1c52099309b394685844ebf0ac073387', 'XXX.XXX.XX.XX', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebK', 1477474877)

i exported db with mysqldump and the dbs are asterisk,goautodial,limesurvey and information_schema, then i imported these dbs into mysql server but not work.

Anyone have some idea or procedure to pass from all-in-one solution to Web/Dialer and mysql separated solution?

Any help are appreciate.

[mflorell]

The easiest way is to use vicibox(http://www.vicibox.com), which was designed for multi-server installs. Aside from that, you have to do all of the steps manually using GoAutoDial.

[brando16]

yes i know that but there is a procedure can i study?

thanks mflorell

[brando16]

which steps i do? how to connect to remote database? what's wrong?

someone help me please!!!

thanks all

[Rogger]

Hello,

Look at this documentation is the easiest way to do what you want.

http://download.vicidial.com/iso/vicibo ... nstall.pdf

Good Luck

[williamconley]

which steps i do? how to connect to remote database? what's wrong?

someone help me please!!!

thanks all

1) How to connect to a remote database is a MySQL question. If you can't find the answer to that question, you should probably not be performing this task. But if you want to try, your best bet would be to install Vicidial on the target server ... first. Then move your present DB into that freshly installed server, and I bet connectivity is much easier.

2) There *is* a multi-server Vicidial Manual. Written by some Weirdo at PoundTeam, Inc., years ago.

http://www.poundteam.com/downloads/Vici ... Latest.pdf

It was actually a conglomeration of all the information available at the time of writing, and has stood the test of time fairly well. I will still warn you, however, that the best method has always started with a Fresh Vicibox Installation, in all circumstances.

3) In YOUR situation, you could start with a duplicate installation of Goautodial or Vicibox ... but I'd actually advise upgrading your present installation to the latest version of Vicidial, then moving that into the new server (as a standalone), and the wiping the old machine clean and installing it as the 2nd server. You'd have a very solid two-server system in the end. And the latest code. Seriously.

[brando16]

thanks William,

but the second new server is a virtual machine and doesn't work with goautodial. I have modified all configuration file for connect to remote db but the vicidial doesn't work anyway and the goautodial i can login but doesn't work sql query beacuse search asterisk.go_session but doesn't exists instead exists goautodial.go_session !!! help me!!!!