Project

General

Profile

[SOLVED] Getting Database Error connection

Added by Daniel Forsyth almost 11 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 11 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 11 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 11 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:

  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 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 11 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 11 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

    (1-5/5)
    Go to top