[SOLVED] Getting Database Error connection
Added by Daniel Forsyth almost 12 years ago
I just installed a new instance of goautodial. I am getting this when trying to access the interface;
An Error Was Encountered
No database connection settings were found in the database config file.
Any help?
Replies (5)
RE: Getting Database Error connection
-
Added by Wilper Necesario almost 12 years ago
Hi Daniel,
Does your installation completed without any error? Is this a single setup or multi server setup?
Can you provide the output of this command in your server CLI.
1.service mysqld status
2.find / -name astguiclient.conf
Cheers
q^_^p
RE: Getting Database Error connection
-
Added by Daniel Forsyth almost 12 years ago
Sorry for the late reply!
1.mysqld (pid 1868) is running...
2. /etc/astguiclient.conf
The install finished with no errors at all.
RE: Getting Database Error connection
-
Added by Chris Braswell almost 12 years ago
I'm having the same exact issue. I did the scratch install on 2 separate machines following these directions step by step: http://goautodial.org/projects/goautodialce/wiki/64bit
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 http://xxx.xxx.xxx.xxx 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:
- 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
- Database connection information
VARDBserver => localhost
VARDBdatabase => goautodial
VARDBuser => goautodialu
VARDBpass => pancit888
VARDBport => 3306
MYSQL is running fine.
I can login to phpmyadmin at http://xxx.xxx.xxx.xxx/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 connection
-
Added by Demian Biscocho almost 12 years ago
First run "yum update" to apply the latest bugfixes and updates. Your /etc/goautodial.conf should look like this:
# 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
#nano /etc/httpd/conf/httpd.conf
Go to line 327
AllowOverride None
Change this to:
AllowOverride All
Save and exit. Reload or restart HTTPD
#service httpd restart
RE: Getting Database Error connection
-
Added by Chris Braswell almost 12 years ago
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