Entire console with debugging... [EMAIL PROTECTED] asterisk]# /usr/sbin/asterisk -vvvvvvc == Parsing '/etc/asterisk/asterisk.conf': Found == Parsing '/etc/asterisk/extconfig.conf': Found Asterisk CVS-v1-0-12/08/04-16:50:05, Copyright (C) 1999-2004 Digium. Written by Mark Spencer <[EMAIL PROTECTED]> ========================================================================= == Parsing '/etc/asterisk/logger.conf': Found Asterisk Event Logger Started /var/log/asterisk/event_log == Manager registered action Ping == Manager registered action Events == Manager registered action Logoff == Manager registered action Hangup == Manager registered action Status == Manager registered action Setvar == Manager registered action Getvar == Manager registered action Redirect == Manager registered action Originate == Manager registered action MailboxStatus == Manager registered action Command == Manager registered action ExtensionState == Manager registered action AbsoluteTimeout == Manager registered action MailboxCount == Manager registered action ListCommands == Parsing '/etc/asterisk/manager.conf': Found Asterisk Management interface listening on port 5038 == Parsing '/etc/asterisk/rtp.conf': Found == RTP Allocating from port range 10000 -> 20000 Asterisk PBX Core Initializing Registering builtin applications: [AbsoluteTimeout] == Registered application 'AbsoluteTimeout' [Answer] == Registered application 'Answer' [BackGround] == Registered application 'BackGround' [Busy] == Registered application 'Busy' [Congestion] == Registered application 'Congestion' [DigitTimeout] == Registered application 'DigitTimeout' [Goto] == Registered application 'Goto' [GotoIf] == Registered application 'GotoIf' [GotoIfTime] == Registered application 'GotoIfTime' [Hangup] == Registered application 'Hangup' [NoOp] == Registered application 'NoOp' [Prefix] == Registered application 'Prefix' [Progress] == Registered application 'Progress' [ResetCDR] == Registered application 'ResetCDR' [ResponseTimeout] == Registered application 'ResponseTimeout' [Ringing] == Registered application 'Ringing' [SayNumber] == Registered application 'SayNumber' [SayDigits] == Registered application 'SayDigits' [SayAlpha] == Registered application 'SayAlpha' [SayPhonetic] == Registered application 'SayPhonetic' [SetAccount] == Registered application 'SetAccount' [SetAMAFlags] == Registered application 'SetAMAFlags' [SetGlobalVar] == Registered application 'SetGlobalVar' [SetLanguage] == Registered application 'SetLanguage' [SetVar] == Registered application 'SetVar' [StripMSD] == Registered application 'StripMSD' [Suffix] == Registered application 'Suffix' [Wait] == Registered application 'Wait' [WaitExten] == Registered application 'WaitExten' Asterisk Dynamic Loader Starting: == Parsing '/etc/asterisk/modules.conf': Found [chan_modem.so] => (Generic Voice Modem Driver) == Parsing '/etc/asterisk/modem.conf': Found == Loading modem driver chan_modem_aopen.so => (A/Open (Rockwell Chipset) ITU-2 VoiceModem Driver) == Registered channel type 'Modem' (Generic Voice Modem Channel Driver) [res_musiconhold.so] => (Music On Hold Resource) == Parsing '/etc/asterisk/musiconhold.conf': Found Dec 17 13:36:10 WARNING[21866]: res_musiconhold.c:564 moh_register: Unable to open pseudo channel for timing... Sound may be choppy. == Registered application 'MusicOnHold' == Registered application 'WaitMusicOnHold' == Registered application 'SetMusicOnHold' [res_crypto.so] => (Cryptographic Digital Signatures) -- Loaded PUBLIC key 'iaxtel' -- Loaded PUBLIC key 'freeworlddialup' [res_monitor.so] => (Call Monitoring Resource) == Registered application 'Monitor' == Registered application 'StopMonitor' == Registered application 'ChangeMonitor' == Manager registered action Monitor == Manager registered action StopMonitor == Manager registered action ChangeMonitor [res_agi.so] => (Asterisk Gateway Interface (AGI)) == Registered application 'DeadAGI' == Registered application 'EAGI' == Registered application 'AGI' [res_adsi.so] => (ADSI Resource) == Parsing '/etc/asterisk/adsi.conf': Found [res_indications.so] => (Indications Configuration) == Parsing '/etc/asterisk/indications.conf': Found -- Registered indication country 'cl' -- Registered indication country 'tw' -- Registered indication country 'us' -- Registered indication country 'au' -- Registered indication country 'fr' -- Registered indication country 'de' -- Registered indication country 'nl' -- Registered indication country 'uk' -- Registered indication country 'fi' -- Registered indication country 'no' -- Registered indication country 'br' -- Registered indication country 'za' -- Registered indication country 'it' -- Registered indication country 'us-o' -- Registered indication country 'gr' -- Registered indication country 'ru' -- Registered indication country 'nz' -- Setting default indication country to 'us' == Registered application 'Playtones' == Registered application 'StopPlaytones' [res_odbc.so] => (ODBC Resource) == Parsing '/etc/asterisk/res_odbc.conf': Found Dec 17 13:36:10 NOTICE[21866]: res_odbc.c:133 load_odbc_config: registered database handle 'PostgreSQL' dsn->[PostgreSQL] Dec 17 13:36:10 NOTICE[21866]: res_odbc.c:353 odbc_obj_connect: res_odbc: Connected to PostgreSQL [PostgreSQL] Dec 17 13:36:10 NOTICE[21866]: res_odbc.c:379 load_module: res_odbc loaded. [res_config_odbc.so] => (ODBC Configuration) Dec 17 13:36:10 NOTICE[21866]: config.c:888 ast_config_register: Registered Config Engine odbc == Parsing '/etc/asterisk/extconfig.conf': Found Dec 17 13:36:10 NOTICE[21866]: res_config_odbc.c:190 load_module: res_config_odbc loaded. [res_features.so] => (Call Parking Resource) == Parsing '/etc/asterisk/features.conf': Found -- Registered extension context 'parkedcalls' -- Added extension '700' priority 1 to parkedcalls == Registered application 'ParkedCall' == Registered application 'Park' == Manager registered action ParkedCalls [app_milliwatt.so] => (Digital Milliwatt (mu-law) Test Application) == Registered application 'Milliwatt' [app_cdr.so] => (Make sure asterisk doesn't save CDR for a certain call) == Registered application 'NoCDR' [app_transfer.so] => (Transfer) == Registered application 'Transfer' [app_waitforring.so] => (Waits until first ring after time) == Registered application 'WaitForRing' [format_g726.so] => (Raw G.726 (16/24/32/40kbps) data) == Registered file format g726-40, extension(s) g726-40 == Registered file format g726-32, extension(s) g726-32 == Registered file format g726-24, extension(s) g726-24 == Registered file format g726-16, extension(s) g726-16 [app_qcall.so] => (Call from Queue) [codec_alaw.so] => (A-law Coder/Decoder) == Registered translator 'alawtolin' from format alaw to slin, cost 1 == Registered translator 'lintoalaw' from format slin to alaw, cost 1 [app_mp3.so] => (Silly MP3 Application) == Registered application 'MP3Player' [app_queue.so] => (True Call Queueing) == Registered application 'Queue' == Manager registered action Queues == Manager registered action QueueStatus == Manager registered action QueueAdd == Manager registered action QueueRemove == Registered application 'AddQueueMember' == Registered application 'RemoveQueueMember' == Parsing '/etc/asterisk/queues.conf': Found [app_userevent.so] => (Custom User Event Application) == Registered application 'UserEvent' [app_nbscat.so] => (Silly NBS Stream Application) == Registered application 'NBScat' [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found [format_g729.so] => (Raw G729 data) == Registered file format g729, extension(s) g729 [codec_a_mu.so] => (A-law and Mulaw direct Coder/Decoder) == Registered translator 'alawtoulaw' from format alaw to ulaw, cost 1 == Registered translator 'ulawtoalaw' from format ulaw to alaw, cost 1 [codec_adpcm.so] => (Adaptive Differential PCM Coder/Decoder) == Registered translator 'adpcmtolin' from format adpcm to slin, cost 1 == Registered translator 'lintoadpcm' from format slin to adpcm, cost 1 [app_alarmreceiver.so] => (Alarm Receiver for Asterisk) == Parsing '/etc/asterisk/alarmreceiver.conf': Found == Registered application 'AlarmReceiver' [app_senddtmf.so] => (Send DTMF digits Application) == Registered application 'SendDTMF' [app_parkandannounce.so] => (Call Parking and Announce Application) == Registered application 'ParkAndAnnounce' [app_setcdruserfield.so] => (CDR user field apps) == Registered application 'SetCDRUserField' == Registered application 'AppendCDRUserField' == Manager registered action SetCDRUserField [format_jpeg.so] => (JPEG (Joint Picture Experts Group) Image Format) == Registered format 'jpg' (JPEG (Joint Picture Experts Group)) [app_test.so] => (Interface Test Application) == Registered application 'TestClient' == Registered application 'TestServer' [app_setcidnum.so] => (Set CallerID Number) == Registered application 'SetCIDNum' [app_zapbarge.so] => (Barge in on Zap channel application) == Registered application 'ZapBarge' [app_sendtext.so] => (Send Text Applications) == Registered application 'SendText' [codec_gsm.so] => (GSM/PCM16 (signed linear) Codec Translator) == Registered translator 'gsmtolin' from format gsm to slin, cost 1 == Registered translator 'lintogsm' from format slin to gsm, cost 1 [app_image.so] => (Image Transmission Application) == Registered application 'SendImage' [chan_local.so] => (Local Proxy Channel) == Registered channel type 'Local' (Local Proxy Channel Driver) [format_sln.so] => (Raw Signed Linear Audio support (SLN)) == Registered file format sln, extension(s) sln|raw [app_lookupcidname.so] => (Look up CallerID Name from local database) == Registered application 'LookupCIDName' [chan_modem_bestdata.so] => (BestData (Conexant V.90 Chipset) VoiceModem Driver) [format_wav.so] => (Microsoft WAV format (8000hz Signed Linear)) == Registered file format wav, extension(s) wav [app_cut.so] => (Cuts up variables) == Registered application 'Cut' [app_softhangup.so] => (Hangs up the requested channel) == Registered application 'SoftHangup' [cdr_pgsql.so] => (PostgreSQL CDR Backend) == Parsing '/etc/asterisk/cdr_pgsql.conf': Found Dec 17 13:36:10 DEBUG[21866]: cdr_pgsql.c:276 process_my_load_module: cdr_pgsql: got hostname of localhost Dec 17 13:36:10 DEBUG[21866]: cdr_pgsql.c:277 process_my_load_module: cdr_pgsql: got port of 5432 Dec 17 13:36:10 DEBUG[21866]: cdr_pgsql.c:280 process_my_load_module: cdr_pgsql: got user of abox Dec 17 13:36:10 DEBUG[21866]: cdr_pgsql.c:281 process_my_load_module: cdr_pgsql: got dbname of asterisk Dec 17 13:36:10 DEBUG[21866]: cdr_pgsql.c:282 process_my_load_module: cdr_pgsql: got password of ecom1091 Dec 17 13:36:10 DEBUG[21866]: cdr_pgsql.c:286 process_my_load_module: Successfully connected to PostgreSQL database. [app_dial.so] => (Dialing Application) == Registered application 'Dial' [pbx_spool.so] => (Outgoing Spool Support) [app_directory.so] => (Extension Directory) == Registered application 'Directory' [app_adsiprog.so] => (Asterisk ADSI Programming Application) == Registered application 'ADSIProg' [app_forkcdr.so] => (Fork The CDR into 2 seperate entities.) == Registered application 'ForkCDR' [format_pcm.so] => (Raw uLaw 8khz Audio support (PCM)) == Registered file format pcm, extension(s) pcm|ulaw|ul|mu [chan_phone.so] => (Linux Telephony API Support) == Parsing '/etc/asterisk/phone.conf': Found == Registered channel type 'Phone' (Standard Linux Telephony API Driver) [format_gsm.so] => (Raw GSM data) == Registered file format gsm, extension(s) gsm [app_enumlookup.so] => (ENUM Lookup) == Registered application 'EnumLookup' == Parsing '/etc/asterisk/enum.conf': Found [app_voicemail.so] => (Comedian Mail (Voicemail System)) == Registered application 'VoiceMail' == Registered application 'VoiceMail2' == Registered application 'VoiceMailMain' == Registered application 'VoiceMailMain2' == Registered application 'MailboxExists' == Parsing '/etc/asterisk/voicemail.conf': Not found (No such file or directory) Dec 17 13:36:10 WARNING[21866]: app_voicemail.c:4328 load_config: Error reading voicemail config Dec 17 13:36:10 WARNING[21866]: loader.c:345 ast_load_resource: app_voicemail.so: load_module failed, returning -1 == Unregistered application 'VoiceMail' == Unregistered application 'VoiceMail2' == Unregistered application 'VoiceMailMain' == Unregistered application 'VoiceMailMain2' == Unregistered application 'MailboxExists' Dec 17 13:36:10 WARNING[21866]: loader.c:440 load_modules: Loading module app_voicemail.so failed!
-Clay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Boehm Sent: Friday, December 17, 2004 1:19 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime and PostgreSQL Turn on debugging and see if there is an SQL related issue. -Matthew ----- Original Message ----- From: "Clay Reiche" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Friday, December 17, 2004 11:58 AM Subject: [Asterisk-Users] Realtime and PostgreSQL Has anyone had any luck with PostgreSQL and Realtime? The realtime instructions on voip-info seem pretty straight forward... just not woking for me. I've included all of my config files below, and my console output. _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users