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

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

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

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

Postby brando16 » Wed Oct 26, 2016 4:48 am

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.
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: migration from all-in-one to separated web-dialer and my

Postby mflorell » Wed Oct 26, 2016 5:39 am

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.
mflorell
Site Admin
 
Posts: 18334
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: migration from all-in-one to separated web-dialer and my

Postby brando16 » Wed Oct 26, 2016 5:47 am

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

thanks mflorell
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: migration from all-in-one to separated web-dialer and my

Postby brando16 » Wed Oct 26, 2016 9:51 am

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

someone help me please!!!

thanks all
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am

Re: migration from all-in-one to separated web-dialer and my

Postby Rogger » Wed Oct 26, 2016 8:32 pm

Hello,

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

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

Good Luck
Rogger
 
Posts: 41
Joined: Fri Nov 27, 2015 9:53 am
Location: Brazil

Re: migration from all-in-one to separated web-dialer and my

Postby williamconley » Thu Oct 27, 2016 11:40 pm

brando16 wrote: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. 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: migration from all-in-one to separated web-dialer and my

Postby brando16 » Mon Oct 31, 2016 4:45 am

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!!!!
Vicibox VERSION: 2.14-580a | BUILD: 161029-2304 | OpenSuSE v.42.1 64-bit | Kernel v.4.1.13 | Asterisk v.11.25.1-vici | DAHDI v.2.10.2 | LibPRI v.1.4.14 | Amfletec VoiceSync v.1.3.8 | ViciDial SVN Trunk v.2.12-533a build 161205-1650 revision 2461
brando16
 
Posts: 88
Joined: Tue Jul 30, 2013 11:00 am


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: No registered users and 53 guests