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

Sun May 3 10:41:48 CDT 2009

Then don't load the modules..

On 3 May 2009, at 16:03, Charlie Grosvenor wrote:

> I am just trying to start asterisk from the console by typing:
>
> asterisk -c
>
> What part of the config do you require me to post? I am not wanting  
> to store any of the config in a database and have the connections  
> commented out.
>
> Thanks
>
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com 
> ] On Behalf Of Tzafrir Cohen
> Sent: 03 May 2009 14:11
> To: asterisk-users at lists.digium.com
> Subject: Re: [asterisk-users] Asterisk not starting up due to  
> database problems
>
> 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
>
> _______________________________________________
> -- 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
>
>
> _______________________________________________
> -- 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