Getting Database Error on new install

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

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

Getting Database Error on new install

Postby hiadviser » Sat Jul 13, 2013 12:25 pm

I just installed goautodial 3.0

I am getting this error when accessing the interface:

An Error Was Encountered
No database connection settings were found in the database config file.


I'm thinking permissions issue perhaps? Because I can access the regular vici interface.

Thank you.
ViciDial VERSION: 2.14-583a | BUILD: 161226-2224 | Asterisk 11.22.0-vici | Cluster Setp - 3 Web, 1 DB| No Digium/Sangoma Hardware | No Extra Software | HP ProLiant DL360 G6, 48GB RAM, 16 x Intel Xeon X5550 2.67GHz, 480GB SSD
hiadviser
 
Posts: 71
Joined: Wed Dec 05, 2012 9:29 am

Re: Getting Database Error on new install

Postby williamconley » Sat Jul 13, 2013 1:53 pm

Did you have any errors during the install? is there a log file for the goauto install?

Were there any install options you could share? (I'm not even sure there are options ...)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Getting Database Error on new install

Postby gardo » Tue Jul 16, 2013 2:23 am

Is this a clean install from the latest ISO (RC1b)? Have you run "yum update" after installing the system to apply the latest updates? What's the build number of your GOadmin (can be found in the bottom of the login box)?
http://goautodial.com
Empowering the next generation contact centers
gardo
 
Posts: 1926
Joined: Fri Sep 15, 2006 10:24 am
Location: Manila, 1004

Re: Getting Database Error on new install

Postby nannoo33 » Sun Jul 21, 2013 8:16 pm

I'm having the same exact issue. I did the official scratch install on 2 separate machines following these directions step by step:

I used the 32 Bit Centos 5.9 on both machines.(instructions are for 32 bit also) Updated everything as per the instructions.

When I try to connect to login I get the message:

An Error Was Encountered
No database connection settings were found in the database config file


all settings in /etc/astguiclient.conf appear to be fine:
1.Goautodial Service Connection
VARSERVHOST => 127.0.0.1
VARSERVPORT => 707
VARSERVLISTEN => 20
VARSERVLOGGING => Y
VARSERVLOGS => /var/log/goautodial
VARUSRPATH => /usr/share/goautodial
VARWWWPATH => /var/www/html
VARKEEPALIVE => 1
1.Database connection information
VARDBserver => localhost
VARDBdatabase => goautodial
VARDBuser => goautodialu
VARDBpass => pancit888
VARDBport => 3306

MYSQL is running fine.

I can login to phpmyadmin and see the databases and MySQL users are all there.

I can login to MySQL via ssh using the different users and their corresponding passwords.

Any ideas?
nannoo33
 
Posts: 2
Joined: Sun Jul 21, 2013 8:14 pm

Re: Getting Database Error on new install

Postby gardo » Sun Jul 21, 2013 9:52 pm

First run "yum update" to apply the latest bugfixes and updates. Your /etc/goautodial.conf should look like this:

Code: Select all
# Goautodial Service Connection
VARSERVHOST => 127.0.0.1
VARSERVPORT => 707
VARSERVLISTEN => 20
VARSERVLOGGING => Y
VARSERVLOGS => /var/log/goautodial
VARUSRPATH => /usr/share/goautodial
VARKEEPALIVE => 1

# Database connection information
VARDBserver => localhost
VARDBdatabase => goautodial
VARDBuser => goautodialu
VARDBpass => pancit888
VARDBport => 3306

#CIconfig
# database configuration for goautodial database
&db[goautodialdb][hostname]=localhost
&db[goautodialdb][username]=goautodialu
&db[goautodialdb][password]=pancit888
&db[goautodialdb][database]=goautodial
&db[goautodialdb][dbdriver]=mysql
&db[goautodialdb][dbprefix]=
&db[goautodialdb][pconnect]=FALSE
&db[goautodialdb][db_debug]=TRUE
&db[goautodialdb][cache_on]=FALSE
&db[goautodialdb][cachedir]=
&db[goautodialdb][char_set]=utf8
&db[goautodialdb][dbcollat]=utf8_general_ci

# database configuration for asterisk
&db[dialerdb][hostname]=localhost
&db[dialerdb][username]=cron
&db[dialerdb][password]=1234
&db[dialerdb][database]=asterisk
&db[dialerdb][dbdriver]=mysql
&db[dialerdb][dbprefix]=
&db[dialerdb][pconnect]=FALSE
&db[dialerdb][db_debug]=TRUE
&db[dialerdb][cache_on]=FALSE
&db[dialerdb][cachedir]=
&db[dialerdb][char_set]=utf8
&db[dialerdb][dbcollat]=utf8_general_ci

# database configuration for customdialerdb
&db[customdialerdb][hostname]=localhost
&db[customdialerdb][username]=custom
&db[customdialerdb][password]=custom1234
&db[customdialerdb][database]=asterisk
&db[customdialerdb][dbdriver]=mysql
&db[customdialerdb][dbprefix]=
&db[customdialerdb][pconnect]=FALSE
&db[customdialerdb][db_debug]=TRUE
&db[customdialerdb][cache_on]=FALSE
&db[customdialerdb][cachedir]=
&db[customdialerdb][char_set]=utf8
&db[customdialerdb][dbcollat]=utf8_general_ci

# database configuration for limesurvey
&db[limesurveydb][hostname]=localhost
&db[limesurveydb][username]=goautodialu
&db[limesurveydb][password]=pancit888
&db[limesurveydb][database]=limesurvey
&db[limesurveydb][dbdriver]=mysql
&db[limesurveydb][dbprefix]=
&db[limesurveydb][pconnect]=FALSE
&db[limesurveydb][db_debug]=TRUE
&db[limesurveydb][cache_on]=FALSE
&db[limesurveydb][cachedir]=
&db[limesurveydb][char_set]=utf8
&db[limesurveydb][dbcollat]=utf8_general_ci&


Edit httpd.conf

Code: Select all
#nano /etc/httpd/conf/httpd.conf


Go to line 327

Code: Select all
AllowOverride None


Change this to:

Code: Select all
AllowOverride All


Save and exit. Reload or restart HTTPD

Code: Select all
#service httpd restart
http://goautodial.com
Empowering the next generation contact centers
gardo
 
Posts: 1926
Joined: Fri Sep 15, 2006 10:24 am
Location: Manila, 1004

Re: Getting Database Error on new install

Postby nannoo33 » Sun Jul 21, 2013 11:08 pm

Thanks so much for your help!

For some reason, everything from #CIconfig on down was missing from /etc/goautodial.conf when it installed. After adding everything from that on down, it works fine.

Chris
nannoo33
 
Posts: 2
Joined: Sun Jul 21, 2013 8:14 pm


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: Google [Bot] and 76 guests