Database errors? Cannot connect to databases?

Discussion in 'General' started by netizen, Apr 16, 2010.

  1. netizen

    Joined:
    Mar 14, 2009
    Messages:
    40
    Likes Received:
    0
    Hello,

    I just realised that the console shows errors regarding databases.
    This most probably happened after the last update although I didn't experience any problems with phones and trunks eversince I updated to latest version.
    Even today the system seems to be ok.


    I am seeing the following however in the logs! :

    ------------------------------------------------------
    Apr 16 09:31:07] NOTICE[22397] chan_ooh323.c: Unable to load config ooh323.conf, OOH323 disabled
    [Apr 16 09:31:07] VERBOSE[22397] logger.c: chan_ooh323.so => (Objective Systems H323 Channel)

    [Apr 16 09:31:07] VERBOSE[22397] logger.c: == Parsing '/etc/asterisk/res_mysql.conf': [Apr 16 09:31:07] VERBOSE[22397] logger.c: Found
    [Apr 16 09:31:07] WARNING[22397] res_config_mysql.c: MySQL RealTime: No database port found, using 3306 as default.
    [Apr 16 09:31:07] WARNING[22397] res_config_mysql.c: MySQL RealTime: No database socket found, using '/tmp/mysql.sock' as default.
    [Apr 16 09:31:07] DEBUG[22397] res_config_mysql.c: MySQL RealTime Host: 127.0.0.1
    [Apr 16 09:31:07] DEBUG[22397] res_config_mysql.c: MySQL RealTime Port: 3306
    [Apr 16 09:31:07] DEBUG[22397] res_config_mysql.c: MySQL RealTime User: asteriskuser
    [Apr 16 09:31:07] DEBUG[22397] res_config_mysql.c: MySQL RealTime Password: eLaStIx.asteriskuser.2oo7
    [Apr 16 09:31:07] ERROR[22397] res_config_mysql.c: MySQL RealTime: Failed to connect database server asteriskrealtime on 127.0.0.1 (err 1049). Check debug for more info.
    [Apr 16 09:31:07] DEBUG[22397] res_config_mysql.c: MySQL RealTime: Cannot Connect (1049): Unknown database 'asteriskrealtime'
    [Apr 16 09:31:07] WARNING[22397] res_config_mysql.c: MySQL RealTime: Couldn't establish connection. Check debug.
    [Apr 16 09:31:07] DEBUG[22397] res_config_mysql.c: MySQL RealTime: Cannot Connect: Unknown database 'asteriskrealtime'
    [Apr 16 09:31:07] NOTICE[22397] config.c: Registered Config Engine mysql
    [Apr 16 09:31:07] VERBOSE[22397] logger.c: MySQL RealTime driver loaded.
    [Apr 16 09:31:07] VERBOSE[22397] logger.c: res_config_mysql.so => (MySQL RealTime Configuration Driver)

    -----------------------------------------------

    Also this one:

    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: Postgresql RealTime Host: 127.0.0.1
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: Postgresql RealTime Port: 5432
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: Postgresql RealTime User: asterisk
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: Postgresql RealTime Password: password
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: Postgresql RealTime DBName: asterisk
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: 133 connInfo=host=127.0.0.1 port=5432 dbname=asterisk user=asterisk password=password
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: 133 connInfo=host=127.0.0.1 port=5432 dbname=asterisk user=asterisk password=password
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: pgsqlConn=0xb7b09b90
    [Apr 16 09:22:49] ERROR[20439] res_config_pgsql.c: Postgresql RealTime: Failed to connect database server asterisk on 127.0.0.1. Check debug for more info.
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: Postgresql RealTime: Cannot Connect:
    [Apr 16 09:22:49] WARNING[20439] res_config_pgsql.c: Postgresql RealTime: Couldn't establish connection. Check debug.
    [Apr 16 09:22:49] DEBUG[20439] res_config_pgsql.c: Postgresql RealTime: Cannot Connect: FATAL: Ident authentication failed for user "asterisk"

    [Apr 16 09:22:49] VERBOSE[20439] logger.c: == Postgresql RealTime reloaded.


    -------------------------------


    Any suggestions where to start looking?
    Please advise,

    Thank you
    N
     
  2. ramoncio

    Joined:
    May 12, 2010
    Messages:
    1,663
    Likes Received:
    0
    Don't worry about this, these are unused modules.

    You can remove them with:
    Code:
    echo "noload => res_config_mysql.so
    noload => res_config_pgsql.so" > /etc/asterisk/modules.conf
    amportal restart
    
     
  3. dicko

    Joined:
    Oct 24, 2008
    Messages:
    4,099
    Likes Received:
    0
    Careful there, it's probably the board code but that > should be >> (two of them > thingies), or you will overwrite the whole file, and not append to it as ramoncio intended.

    dicko
     
  4. netizen

    Joined:
    Mar 14, 2009
    Messages:
    40
    Likes Received:
    0
    Thank you for the answers.
    I always open files with vi anyway as I like to see what's in there and edit as needed! :)
    Thank you
     

Share This Page