Project

General

Profile

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:

  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
  2. VARDBserver => localhost
    VARDBserver => 192.168.2.40
    VARDBdatabase => goautodial
    VARDBuser => goautodialu
    VARDBpass => pancit888
    VARDBport => 3306
  1. GOautodial 3.0 and up only
  2. Server type (public/private)
    VARSERVTYPE => public
#CIconfig
  1. 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
  1. 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
  2. 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
  2. VARDBserver => localhost
    VARDBserver => 192.168.2.40
    VARDBdatabase => goautodial
    VARDBuser => goautodialu
    VARDBpass => pancit888
    VARDBport => 3306
  1. GOautodial 3.0 and up only
  2. Server type (public/private)
    VARSERVTYPE => public
#CIconfig
  1. 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
  1. 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
  1. 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
  1. 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

    (1-4/4)
    Go to top