vicidial.org

by **WorldFocus** » Mon Aug 29, 2011 2:52 am

I thought I would upgrade to version 2.1 over the weekend. Followed the instructions for "Upgrade Notes from Goautodial 2.0 to Goautodial 2.1"

My system is up and running sips registered but clearly I screwed something up because I can't access Vicidial Admin screen.

Agents can log in and resume dialling but no fields are being populated when a call comes through...

There is a list of problems.... I also noticed that where we were connecting to vicidial directory before it is now goautodial-admin and goautodial-agent??

I have tried to re-run the upgrade scripts again to no avail.

Has anyone else experienced any issues when upgrading?
Can I fix this or should I back up databases and do a scratch install?

Any help would be appreciated

by **WorldFocus** » Mon Aug 29, 2011 2:57 am

this was my system info:

Kernel Version 2.6.18-194.8.1.el5.goPAE (SMP)
Distro Name GoAutoDial CE 2.0
Single Server
VERSION: 2.2.1-237
BUILD: 100510-2015

Now reads like this?:

Kernel Version 2.6.18-194.8.1.el5.goPAE (SMP)
Distro Name GoAutoDial CE 2.0
Single Server
VICIDIAL VERSION: 2.4-325c
BUILD: 110430-1924

by **WorldFocus** » Mon Aug 29, 2011 6:31 am

anyone up for a challenge? I've spent about 72 hours mucking with this and there is not much information out there with regards to a fix...

this obviously means that no one has been as stupid as me whilst upgrading.

by **WorldFocus** » Mon Aug 29, 2011 9:43 am

These are the errors that I picked up whilst upgrading:

ERROR 1008 (HY000) at line 1 in file: './configs/mysqlconfig.file': Can't drop database 'goautodial'; database doesn't exist

DBI connect('database=goautodial;host=localhost;port=3306','goautodialu',...) failed: Access denied for user 'goautodialu'@'localhost' (using password: YES) at /usr/share/goautodial/go_httpd_conf_restore.pl line 42
Can't connect to
DBI:mysql:database=goautodial;host=localhost;port=3306: ->errstr

In case someone was going to ask

by **gardo** » Mon Aug 29, 2011 2:28 pm

Which did you follow?

1. Upgrade existing database

TO UPGRADE YOUR EXISTING DATABASE:

mysql -f -u root -p --database=asterisk < /usr/local/src/astguiclient-2.4-build-110430-1642/extras/upgrade_2.4.sql

or

2. Clean install

IF YOU WANT TO DO A CLEAN INSTALL:
WARNING: THIS WILL DELETE YOUR EXISTING DATABASE
ALL YOUR EXISTING CONFIGURATIONS WILL BE ERASED

by **WorldFocus** » Mon Aug 29, 2011 7:16 pm

I did:
TO UPGRADE YOUR EXISTING DATABASE:

mysql -f -u root -p --database=asterisk < /usr/local/src/astguiclient-2.4-build-110430-1642/extras/upgrade_2.4.sql

by **williamconley** » Mon Aug 29, 2011 7:40 pm

WorldFocus wrote:I did:
TO UPGRADE YOUR EXISTING DATABASE:

mysql -f -u root -p --database=asterisk < /usr/local/src/astguiclient-2.4-build-110430-1642/extras/upgrade_2.4.sql

what is your present db schema in system settings? (and what is the last db schema entry in upgrade_2.4.sql?)

by **WorldFocus** » Mon Aug 29, 2011 8:38 pm

Hi William,

I don't even know how to access this and I cannot access the Admin page to get to the settings.

I can access the data through PHPmyadmin page.

by **williamconley** » Mon Aug 29, 2011 8:45 pm

look in the system settings table for db schema.

then look in the aforementioned upgrade_2.4.sql file (read the file, it's a text file) and see that the last command tells the system to set db schema to, should be the Last Command)

by **WorldFocus** » Mon Aug 29, 2011 11:42 pm

I did'nt find the upgrade_2.4.sql file in the database itself but found it here---

/usr/local/src/astguiclient-2.4-build-110430-1642/extras/upgrade_2.4.sql

Last command:

UPDATE system_settings SET db_schema_version='1273',db_schema_update_date=NOW();

by **WorldFocus** » Mon Aug 29, 2011 11:46 pm

Database has `db_schema_version`

Rows db_schema_version
1 1273

by **williamconley** » Tue Aug 30, 2011 9:08 am

that's a good sign, your db schema matches your source code IF that is the source code presently installed in your system.

can you confirm that the installed code (on the admin screens, bottom right corner) are build 110430?

by **WorldFocus** » Tue Aug 30, 2011 10:43 am

Hi William,

I can access the Go Admin tab but not the Vicidial Admin tab.

The build number does not appear at the bottom of the pages I can access.
Is there a CLI command to get build version?

by **WorldFocus** » Tue Aug 30, 2011 10:48 am

Ahhh, I can access the agent login screen

Which has this:

VICIDIAL VERSION: 2.4-325c BUILD: 110430-1924

by **WorldFocus** » Tue Aug 30, 2011 11:08 pm

I did'nt mean it's working I just meant that the agent login screen has the build number..

There seem to be a whole lot wrong still, I can't access vicidial admin, agent screen not being populated when a call gets answered..ect ect..

Database is all there and sips registered but obviously there are links broken at various locations in the new files from the upgrade.

I need this sorted as it has been down for 4 days now so if anyone can help that would be appreciated.

by **WorldFocus** » Wed Aug 31, 2011 7:49 am

Ok, so I'm not getting anywhere with this.. and I have lost 4 days already. Time to wipe the slate clean and do a scratch install. Hopefully, that works.

Backed up database and config files so I guess my next post will be about how to restore everything

by **williamconley** » Wed Aug 31, 2011 1:33 pm

before scratch, use Vicibox.com.

or retry with goautodial.

back up your database (and get that data off the box) and get a new system up ... then we can work on getting your old data into your new system.

by **WorldFocus** » Wed Aug 31, 2011 4:56 pm

Too late...!
I did back everything up off the box tho:)

Did a fresh install of the lastest Goautodial 2.1 iso.

Used Mysqldumper to get the data back into the database and so far it seems good.

I have worked straight through the night tho and I'll have to wait for the telemarketers to get in so I can test it thoroughly.

By which time I will be suffering from serious sleep deprivation and probably break it again.

by **williamconley** » Wed Aug 31, 2011 7:12 pm

LOL. as long as you have a reasonable goal.

by **WorldFocus** » Fri Sep 02, 2011 1:36 am

So just thought I would update you on the outcome...

Everything working great after importing database, only issue I had was with internet explorer not populating agent screen when calls came in.

Easy fix - Just loaded Firefox on their workstations and now everything is sweet.

by **gardo** » Mon Sep 05, 2011 2:24 pm

Glad to hear everything is working good.

by **rgwilliams20** » Mon Oct 10, 2011 2:51 pm

Hi Gardo,

I have a simular issue. I have upgraded the system using the instructions on the wiki

However the system still shows version 2.0. When I ran the last command I get the error "ERROR 1008 (HY000) at line 1 in file: './configs/mysqlconfig.file': Can't drop database 'goautodial'; database doesn't exist"

This is the only error I have experienced during the upgrade.

Kernel Version showing as
2.6.18-194.8.1.el5.goPAE (SMP)

VERSION: 2.4-309a
BUILD: 110430-1642
© 2011 ViciDial Group

Any help you can offer would be appreciated

by **shanjay86** » Tue Oct 11, 2011 9:21 am

rgwilliams20 wrote:Hi Gardo,

I have a simular issue. I have upgraded the system using the instructions on the wiki

However the system still shows version 2.0. When I ran the last command I get the error "ERROR 1008 (HY000) at line 1 in file: './configs/mysqlconfig.file': Can't drop database 'goautodial'; database doesn't exist"

This is the only error I have experienced during the upgrade.

Kernel Version showing as
2.6.18-194.8.1.el5.goPAE (SMP)

VERSION: 2.4-309a
BUILD: 110430-1642
© 2011 ViciDial Group

Any help you can offer would be appreciated

dont waste time back up / do a clean install

vicidial.org

Goautodial CE 2.1 upgrade

Goautodial CE 2.1 upgrade

Same Issue

Re: Same Issue

Who is online