Charlie Grosvenor
2009-May-03 12:30 UTC
[asterisk-users] Asterisk not starting up due to database problems
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'
Tzafrir Cohen
2009-May-03 13:11 UTC
[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
ContactTel Business
2009-May-03 23:30 UTC
[asterisk-users] Asterisk not starting up due to database problems
st_register_application: Already have an application 'VoiceMail' you should really stop copy pasting anything you see.. this means that you have 2 load modules for voicemail these are all warnings and notices, not errors... what is the error ? already running asterisk process ? killall -9 asterisk asterisk -vvvgcf reply ;)>>-----Original Message----- >>From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users- >>bounces at lists.digium.com] On Behalf Of Charlie Grosvenor >>Sent: May-03-09 8:31 AM >>To: asterisk-users at lists.digium.com >>Subject: [asterisk-users] Asterisk not starting up due to database >>problems >> >>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' >> >>_______________________________________________ >>-- 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