Page 1 of 1

Getting Database Error on new install

PostPosted: Sat Jul 13, 2013 12:25 pm
by hiadviser
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.

Re: Getting Database Error on new install

PostPosted: Sat Jul 13, 2013 1:53 pm
by williamconley
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 ...)

Re: Getting Database Error on new install

PostPosted: Tue Jul 16, 2013 2:23 am
by gardo
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)?

Re: Getting Database Error on new install

PostPosted: Sun Jul 21, 2013 8:16 pm
by nannoo33
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?

Re: Getting Database Error on new install

PostPosted: Sun Jul 21, 2013 9:52 pm
by gardo
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

Re: Getting Database Error on new install

PostPosted: Sun Jul 21, 2013 11:08 pm
by nannoo33
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