unable to select the specified database
Added by derek boucher over 10 years ago
Built a new cluster to replace goadmin single server. New setup is: db/web server 192.168.2.40 / asterisk server 192.168.2.41. Imported databases etc.. from old server without issues.Cluster seems setup correctly (astguiclient etc.. setup accordingly, servers are showing as synced in cluster server settings). Both servers are running goadmin 3.3 and everything seems fine except in the goadmin dashboard if I choose either campaigns or lists under telephony I get the following: Unable to select the specified database: asterisk. Other selections work fine.
No issues if I use the vicidial admin instead of the dashboard. Any ideas what file I need to change to fix this? What is the difference between choosing campaigns in the dashboard vs campaigns in the vicidial/admin section?
thanks
DF
Replies (4)
RE: unable to select the specified database
-
Added by Demian Biscocho over 10 years ago
Did you edit /etc/goautodial.conf to point to your database server?
RE: unable to select the specified database
-
Added by derek boucher over 10 years ago
thanks for replying. I did look at it, as this is the server which is acting as both the DB server and web server (192.168.2.40) shouldn't it remain as localhost?(asterisk server is 192.168.2.41) I did try putting in the 192.168.2.40 instead of localhost for VARDBserver but same results.
here is my /etc/goautodial.conf with the db ip instead of localhost:
- 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
VARDBserver => 192.168.2.40
VARDBdatabase => goautodial
VARDBuser => goautodialu
VARDBpass => pancit888
VARDBport => 3306
- GOautodial 3.0 and up only
- Server type (public/private)
VARSERVTYPE => public
- 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 - 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
VARDBserver => 192.168.2.40
VARDBdatabase => goautodial
VARDBuser => goautodialu
VARDBpass => pancit888
VARDBport => 3306
- GOautodial 3.0 and up only
- Server type (public/private)
VARSERVTYPE => public
- 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&
thanks again for the help.
RE: unable to select the specified database
-
Added by derek boucher over 10 years ago
FYI not sure why it pasted as it did, but in the config above there is a # in front of VARDBserver => localhost
RE: unable to select the specified database ** SOLVED **
-
Added by derek boucher over 10 years ago
- SOLVED **
Incase someone else runs into same issue, problem was in the "customdialerdb", needed proper user/pwd (changed it to cron user/pwd and now working).
DF