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

Sun May 3 08:11:19 CDT 2009

On Sun, May 03, 2009 at 01:30:49PM +0100, Charlie Grosvenor wrote:
> 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?

What are you trying to do?

What fails?

What are the relevant parts of the configuration files?

> 
> 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'
> 
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
               Tzafrir Cohen
icq#16849755              jabber:tzafrir.cohen at xorcom.com
+972-50-7952406           mailto:tzafrir.cohen at xorcom.com
http://www.xorcom.com  iax:guest at local.xorcom.com/tzafrir