Database errors? Cannot connect to databases?

netizen

Joined
Mar 14, 2009
Messages
40
Likes
0
Points
0
#1
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
 

ramoncio

Joined
May 12, 2010
Messages
1,663
Likes
0
Points
0
#2
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
 

dicko

Joined
Oct 24, 2008
Messages
4,099
Likes
0
Points
0
#3
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
 

netizen

Joined
Mar 14, 2009
Messages
40
Likes
0
Points
0
#4
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
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,915
Messages
130,920
Members
17,594
Latest member
knethardsolutions
Top