[asterisk-users] Asterisk not starting up due to database problems

Sun May 3 07:30:49 CDT 2009

When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off?

Thanks

Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others.
Created by Mark Spencer <markster at digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
This package has been modified for the Debian GNU/Linux distribution
Please report all bugs to http://bugs.debian.org/asterisk
=========================================================================
[ Booting...
[ Reading Master Configuration ]
[ Initializing Custom Configuration Options ]
[May  3 13:29:14] NOTICE[7477]: cdr.c:1373 do_reload: CDR simple logging enabled.
[May  3 13:29:14] NOTICE[7477]: loader.c:859 load_modules: 175 modules will be loaded.
..[May  3 13:29:14] NOTICE[7477]: res_odbc.c:235 load_odbc_config: Adding ENV var: INFORMIXSERVER=my_special_database
[May  3 13:29:14] NOTICE[7477]: res_odbc.c:235 load_odbc_config: Adding ENV var: INFORMIXDIR=/opt/informix
[May  3 13:29:14] NOTICE[7477]: res_odbc.c:530 odbc_obj_connect: Connecting asterisk
[May  3 13:29:14] WARNING[7477]: res_odbc.c:541 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Data source name not found, and no default driver specified
[May  3 13:29:14] WARNING[7477]: res_odbc.c:463 ast_odbc_request_obj: Failed to connect to asterisk
[May  3 13:29:14] NOTICE[7477]: res_odbc.c:316 load_odbc_config: Registered ODBC class 'asterisk' dsn->[asterisk]
[May  3 13:29:14] NOTICE[7477]: res_odbc.c:716 load_module: res_odbc loaded.
.[May  3 13:29:14] WARNING[7477]: res_smdi.c:1335 load_module: No SMDI interfaces are available to listen on, not starting SMDI listener.
.[May  3 13:29:14] NOTICE[7477]: config.c:1274 ast_config_engine_register: Registered Config Engine odbc
. Loading [Sub]Agent Module
.[May  3 13:29:14] WARNING[7477]: res_config_pgsql.c:683 parse_config: Postgresql RealTime: No database user found, using 'asterisk' as default.
[May  3 13:29:14] WARNING[7477]: res_config_pgsql.c:691 parse_config: Postgresql RealTime: No database password found, using 'asterisk' as default.
[May  3 13:29:14] WARNING[7477]: res_config_pgsql.c:699 parse_config: Postgresql RealTime: No database host found, using localhost via socket.
[May  3 13:29:14] WARNING[7477]: res_config_pgsql.c:707 parse_config: Postgresql RealTime: No database name found, using 'asterisk' as default.
[May  3 13:29:14] WARNING[7477]: res_config_pgsql.c:715 parse_config: Postgresql RealTime: No database port found, using 5432 as default.
[May  3 13:29:14] WARNING[7477]: res_config_pgsql.c:725 parse_config: Postgresql RealTime: No database socket found, using '/tmp/pgsql.sock' as default.
[May  3 13:29:14] ERROR[7477]: res_config_pgsql.c:782 pgsql_reconnect: Postgresql RealTime: Failed to connect database server asterisk on . Check debug for more info.
[May  3 13:29:14] WARNING[7477]: res_config_pgsql.c:605 load_module: Postgresql RealTime: Couldn't establish connection. Check debug.
[May  3 13:29:14] NOTICE[7477]: config.c:1274 ast_config_engine_register: Registered Config Engine pgsql
..................[May  3 13:29:14] WARNING[7477]: res_config_mysql.c:542 parse_config: MySQL RealTime: No database user found, using 'asterisk' as default.
[May  3 13:29:14] WARNING[7477]: res_config_mysql.c:549 parse_config: MySQL RealTime: No database password found, using 'asterisk' as default.
[May  3 13:29:14] WARNING[7477]: res_config_mysql.c:556 parse_config: MySQL RealTime: No database host found, using localhost via socket.
[May  3 13:29:14] WARNING[7477]: res_config_mysql.c:563 parse_config: MySQL RealTime: No database name found, using 'asterisk' as default.
[May  3 13:29:14] WARNING[7477]: res_config_mysql.c:570 parse_config: MySQL RealTime: No database port found, using 3306 as default.
[May  3 13:29:14] WARNING[7477]: res_config_mysql.c:577 parse_config: MySQL RealTime: No database socket found, using '/tmp/mysql.sock' as default.
[May  3 13:29:14] ERROR[7477]: res_config_mysql.c:629 mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on  (err 2002). Check debug for more info.
[May  3 13:29:14] WARNING[7477]: res_config_mysql.c:476 load_module: MySQL RealTime: Couldn't establish connection. Check debug.
[May  3 13:29:14] NOTICE[7477]: config.c:1274 ast_config_engine_register: Registered Config Engine mysql
..[May  3 13:29:14] NOTICE[7477]: pbx_ael.c:4131 pbx_load_module: Starting AEL load process.
[May  3 13:29:14] NOTICE[7477]: pbx_ael.c:4138 pbx_load_module: AEL load process: calculated config file name '/etc/asterisk/extensions.ael'.
[May  3 13:29:14] NOTICE[7477]: pbx_ael.c:4146 pbx_load_module: AEL load process: parsed config file name '/etc/asterisk/extensions.ael'.
[May  3 13:29:14] WARNING[7477]: pbx_ael.c:838 check_includes: Warning: file /etc/asterisk/extensions.ael, line 276-283: The included context 'ael-parkedcalls' cannot be found.
 (You may ignore this warning if 'ael-parkedcalls' exists in extensions.conf, or is created by another module. I cannot check for those.)
[May  3 13:29:14] NOTICE[7477]: pbx_ael.c:4149 pbx_load_module: AEL load process: checked config file name '/etc/asterisk/extensions.ael'.
[May  3 13:29:14] NOTICE[7477]: pbx_ael.c:4151 pbx_load_module: AEL load process: compiled config file name '/etc/asterisk/extensions.ael'.
[May  3 13:29:14] NOTICE[7477]: pbx_ael.c:4154 pbx_load_module: AEL load process: merged config file name '/etc/asterisk/extensions.ael'.
[May  3 13:29:14] WARNING[7477]: pbx.c:6352 ast_context_verify_includes: Context 'ael-local' tries to include nonexistent context 'ael-parkedcalls'
[May  3 13:29:14] NOTICE[7477]: pbx_ael.c:4157 pbx_load_module: AEL load process: verified config file name '/etc/asterisk/extensions.ael'.
.............................  == No hardware transcoders found.
....[May  3 13:29:14] WARNING[7477]: pbx.c:2981 ast_register_application: Already have an application 'VoiceMail'
[May  3 13:29:14] WARNING[7477]: pbx.c:2981 ast_register_application: Already have an application 'VoiceMailMain'
[May  3 13:29:14] WARNING[7477]: pbx.c:2981 ast_register_application: Already have an application 'MailboxExists'
[May  3 13:29:14] WARNING[7477]: pbx.c:2981 ast_register_application: Already have an application 'VMAuthenticate'