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.
Entire console bootup output:
[root@abox 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 <markster@digium.com>
======================================================================== ==
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 11:33:05 WARNING[21622]: 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 11:33:05 NOTICE[21622]: res_odbc.c:133 load_odbc_config: registered
database handle 'PostgreSQL' dsn->[PostgreSQL]
Dec 17 11:33:05 NOTICE[21622]: res_odbc.c:353 odbc_obj_connect: res_odbc:
Connected to PostgreSQL [PostgreSQL]
Dec 17 11:33:05 NOTICE[21622]: res_odbc.c:379 load_module: res_odbc loaded.
[res_config_odbc.so] => (ODBC Configuration)
Dec 17 11:33:05 NOTICE[21622]: config.c:888 ast_config_register: Registered
Config Engine odbc
== Parsing '/etc/asterisk/extconfig.conf': Found
Dec 17 11:33:05 NOTICE[21622]: 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
[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 11:33:05 WARNING[21622]: app_voicemail.c:4328 load_config: Error
reading voicemail config
Dec 17 11:33:05 WARNING[21622]: 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 11:33:05 WARNING[21622]: loader.c:440 load_modules: Loading module
app_voicemail.so failed!
[root@abox asterisk]#
extconfig.conf:
[settings]
;uncomment to load queues.conf via the db engine.
;queues.conf => odbc,PostgreSQL,ast_config
sip.conf => odbc,PostgreSQL,sip_conf
extensions.conf => odbc,PostgreSQL,extensions_conf
voicemail.conf => odbc,PostgreSQL,voicemail_conf
~
res_odbc.conf:
;;; odbc setup file
[PostgreSQL]
dsn => PostgreSQL
username => abox
password => ecom1091
pre-connect => yes
res_config_odbc.conf:
[settings]
table => ast_config
connection => PostgeSQL
odbcinst.ini:
# Example driver definitinions
#
#
# Included in the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
odbc.ini:
[PostgreSQL]
Description = Postgres
Driver = PostgreSQL
Trace = Yes
TraceFile = sql.log
Database = asterisk
Servername = localhost
UserName = asterisk
Password = password
Thank you!
Begging for help,
Clay Reiche
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20041217/1c82f421/attachment.htm
Turn on debugging and see if there is an SQL related issue. -Matthew ----- Original Message ----- From: "Clay Reiche" <creiche@accxx.com> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> 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.
Here is the only Debugging related console entries. Seemingly not related to the Realtime setup. My CDRs write just fine to PostgreSQL... [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. -Clay -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] 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" <creiche@accxx.com> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> 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 Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Entire console with debugging...
[root@abox 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 <markster@digium.com>
======================================================================== ==
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: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] 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" <creiche@accxx.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
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
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
I thought I did... On Dec 8th... Was there no realtime code Dec 8th or am I
checking it out incorrectly? (or checking out the wrong stuff...) I did:
cd /usr/src
export CVSROOT=:pserver:anoncvs@cvs.digium.com:/usr/cvsroot
cvs login
cvs checkout asterisk
Then:
cd /usr/src/asterisk
make clean
make install
I did this over the top of a previous stable release.
Thanks for all your help Matthew.
-Clay
-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Matthew Boehm
Sent: Friday, December 17, 2004 2:05 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Realtime and PostgreSQL
Its hard to use RealTime when the version of Asterisk that you are using
doesn't contain any RealTime code. You need to upgrade to latest version.
-Matthew
----- Original Message -----
From: "Clay Reiche" <creiche@accxx.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Friday, December 17, 2004 12:50 PM
Subject: RE: [Asterisk-Users] Realtime and PostgreSQL
Entire console with debugging...
[root@abox 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 <markster@digium.com>
======================================================================== ==
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: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] 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" <creiche@accxx.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
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
Asterisk-Users@lists.digium.com
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
Asterisk-Users@lists.digium.com
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
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
I was dloading cvs over the top of a stable branch... (Matthew told me that
was a no-no...)
I've made progress but I'm still havng some troubles. I can get my
devices to
register but when I try to make a call, I get silence and some SQL failures.
Below is console output from bootup to registration to placing a call. Thanks
in advance!
Console bootup:
[res_odbc.so] => (ODBC Resource)
== Parsing '/etc/asterisk/res_odbc.conf': Found Dec 18 10:58:26
NOTICE[9982]: res_odbc.c:133 load_odbc_config: registered database handle
'PostgreSQL' dsn->[PostgreSQL] Dec 18 10:58:26 NOTICE[9982]:
res_odbc.c:345
odbc_obj_connect: Calling 0x8bbf070/0x8bbf080 Dec 18 10:58:26 NOTICE[9982]:
res_odbc.c:359 odbc_obj_connect: res_odbc: Connected to PostgreSQL
[PostgreSQL] Dec 18 10:58:26 NOTICE[9982]: res_odbc.c:385 load_module:
res_odbc loaded.
[res_config_odbc.so] => (ODBC Configuration) Dec 18 10:58:26 NOTICE[9982]:
config.c:641 ast_config_register: Registered Config Engine odbc
== Parsing '/etc/asterisk/extconfig.conf': Found
== Binding sipfriends to odbc/PostgreSQL/sip_conf
== Binding extensions to odbc/PostgreSQL/extensions_conf
== Binding voicemail to odbc/PostgreSQL/voicemail_conf res_config_odbc
loaded.
[pbx_config.so] => (Text Extension Configuration)
== Parsing '/etc/asterisk/extensions.conf': Found
-- Setting global variable 'CONSOLE' to 'Console/dsp'
-- Setting global variable 'IAXINFO' to 'guest'
-- Setting global variable 'TRUNK' to 'Zap/g2'
-- Setting global variable 'TRUNKMSD' to '1'
-- Registered extension context 'iaxtel700'
-- Added extension '_91700XXXXXXX' priority 1 to iaxtel700
-- Registered extension context 'iaxprovider'
-- Registered extension context 'trunkint'
-- Added extension '_9011.' priority 1 to trunkint
-- Added extension '_9011.' priority 2 to trunkint
-- Registered extension context 'trunkld'
-- Added extension '_91NXXNXXXXXX' priority 1 to trunkld
-- Added extension '_91NXXNXXXXXX' priority 2 to trunkld
-- Registered extension context 'trunklocal'
-- Added extension '_9NXXXXXX' priority 1 to trunklocal
-- Added extension '_9NXXXXXX' priority 2 to trunklocal
-- Registered extension context 'trunktollfree'
-- Added extension '_91800NXXXXXX' priority 1 to trunktollfree
-- Added extension '_91800NXXXXXX' priority 2 to trunktollfree
-- Added extension '_91888NXXXXXX' priority 1 to trunktollfree
-- Added extension '_91888NXXXXXX' priority 2 to trunktollfree
-- Added extension '_91877NXXXXXX' priority 1 to trunktollfree
-- Added extension '_91877NXXXXXX' priority 2 to trunktollfree
-- Added extension '_91866NXXXXXX' priority 1 to trunktollfree
-- Added extension '_91866NXXXXXX' priority 2 to trunktollfree
-- Registered extension context 'international'
-- Including context 'longdistance' in context
'international'
-- Including context 'trunkint' in context 'international'
-- Registered extension context 'longdistance'
-- Including context 'local' in context 'longdistance'
-- Including context 'trunkld' in context 'longdistance'
-- Registered extension context 'local'
-- Including context 'default' in context 'local'
-- Including context 'parkedcalls' in context 'local'
-- Including context 'trunklocal' in context 'local'
-- Including context 'iaxtel700' in context 'local'
-- Including context 'trunktollfree' in context 'local'
-- Including context 'iaxprovider' in context 'local'
-- Including context 'from-sip' in context 'local'
-- Registered extension context 'macro-stdexten'
-- Added extension 's' priority 1 to macro-stdexten
-- Added extension 's' priority 2 to macro-stdexten
-- Added extension 's-NOANSWER' priority 1 to macro-stdexten
-- Added extension 's-NOANSWER' priority 2 to macro-stdexten
-- Added extension 's-BUSY' priority 1 to macro-stdexten
-- Added extension 's-BUSY' priority 2 to macro-stdexten
-- Added extension '_s-.' priority 1 to macro-stdexten
-- Added extension 'a' priority 1 to macro-stdexten
-- Registered extension context 'demo'
-- Added extension 's' priority 1 to demo
-- Added extension 's' priority 2 to demo
-- Added extension 's' priority 3 to demo
-- Added extension 's' priority 4 to demo
-- Added extension 's' priority 5 to demo
-- Added extension 's' priority 6 to demo
-- Added extension '2' priority 1 to demo
-- Added extension '2' priority 2 to demo
-- Added extension '3' priority 1 to demo
-- Added extension '3' priority 2 to demo
-- Added extension '1000' priority 1 to demo
-- Added extension '1234' priority 1 to demo
-- Added extension '1234' priority 2 to demo
-- Added extension '1235' priority 1 to demo
-- Added extension '1236' priority 1 to demo
-- Added extension '1236' priority 2 to demo
-- Added extension '#' priority 1 to demo
-- Added extension '#' priority 2 to demo
-- Added extension 't' priority 1 to demo
-- Added extension 'i' priority 1 to demo
-- Added extension '500' priority 1 to demo
-- Added extension '500' priority 2 to demo
-- Added extension '500' priority 3 to demo
-- Added extension '500' priority 4 to demo
-- Added extension '600' priority 1 to demo
-- Added extension '600' priority 2 to demo
-- Added extension '600' priority 3 to demo
-- Added extension '600' priority 4 to demo
-- Added extension '8500' priority 1 to demo
-- Added extension '8500' priority 2 to demo
-- Registered extension context 'default'
-- Including context 'demo' in context 'default'
-- Added extension '8500' priority 1 to default
-- Added extension '8500' priority 2 to default
-- Registered extension context 'outboundmsg1'
-- Added extension 's' priority 1 to outboundmsg1
-- Added extension 's' priority 2 to outboundmsg1
-- Added extension 's' priority 3 to outboundmsg1
-- Added extension 's' priority 4 to outboundmsg1
-- Added extension 's' priority 5 to outboundmsg1
-- Added extension 's' priority 6 to outboundmsg1
-- Added extension '1' priority 1 to outboundmsg1
-- Added extension '2' priority 1 to outboundmsg1
-- Added extension 't' priority 1 to outboundmsg1
-- Added extension 't' priority 2 to outboundmsg1
-- Registered extension context 'outboundmsg2'
-- Added extension 's' priority 1 to outboundmsg2
-- Added extension 's' priority 2 to outboundmsg2
-- Added extension 's' priority 3 to outboundmsg2
-- Added extension 's' priority 4 to outboundmsg2
-- Added extension 's' priority 5 to outboundmsg2
-- Added extension 's' priority 6 to outboundmsg2
-- Added extension '1' priority 1 to outboundmsg2
-- Added extension '2' priority 1 to outboundmsg2
-- Added extension 't' priority 1 to outboundmsg2
-- Added extension 't' priority 2 to outboundmsg2
-- Registered extension context 'msgack'
-- Added extension 's' priority 1 to msgack
-- Added extension 's' priority 2 to msgack
-- Added extension 's' priority 3 to msgack
-- Registered extension context 'record-outboundmsgs'
-- Added extension '2051' priority 1 to record-outboundmsgs
-- Added extension '2051' priority 2 to record-outboundmsgs
-- Added extension '2051' priority 3 to record-outboundmsgs
-- Added extension '2051' priority 4 to record-outboundmsgs
-- Added extension '2051' priority 5 to record-outboundmsgs
-- Added extension '2051' priority 6 to record-outboundmsgs
-- Added extension '2052' priority 1 to record-outboundmsgs
-- Added extension '2052' priority 2 to record-outboundmsgs
-- Added extension '2052' priority 3 to record-outboundmsgs
-- Added extension '2052' priority 4 to record-outboundmsgs
-- Added extension '2052' priority 5 to record-outboundmsgs
-- Added extension '2052' priority 6 to record-outboundmsgs
-- Added extension '2061' priority 1 to record-outboundmsgs
-- Added extension '2061' priority 2 to record-outboundmsgs
-- Added extension '2061' priority 3 to record-outboundmsgs
-- Added extension '2061' priority 4 to record-outboundmsgs
-- Added extension '2061' priority 5 to record-outboundmsgs
-- Added extension '2061' priority 6 to record-outboundmsgs
-- Added extension '2062' priority 1 to record-outboundmsgs
-- Added extension '2062' priority 2 to record-outboundmsgs
-- Added extension '2062' priority 3 to record-outboundmsgs
-- Added extension '2062' priority 4 to record-outboundmsgs
-- Added extension '2062' priority 5 to record-outboundmsgs
-- Added extension '2062' priority 6 to record-outboundmsgs
-- Registered extension context 'from-sip'
-- Including switch 'Realtime/from-sip@extensions' in context
'from-sip'
[pbx_loopback.so] => (Loopback Switch)
[cdr_odbc.so] => (ODBC CDR Backend)
== Parsing '/etc/asterisk/cdr_odbc.conf': Found [format_g729.so]
=> (Raw
G729 data)
[cdr_pgsql.so] => (PostgreSQL CDR Backend)
== Parsing '/etc/asterisk/cdr_pgsql.conf': Found Dec 18 10:58:27
WARNING[9982]: cdr_pgsql.c:298 process_my_load_module: CDR table not
specified. Assuming cdr Dec 18 10:58:27 DEBUG[9982]: cdr_pgsql.c:302
process_my_load_module: cdr_pgsql: got hostname of localhost Dec 18 10:58:27
DEBUG[9982]: cdr_pgsql.c:303 process_my_load_module: cdr_pgsql: got port of
5432 Dec 18 10:58:27 DEBUG[9982]: cdr_pgsql.c:306 process_my_load_module:
cdr_pgsql: got user of abox Dec 18 10:58:27 DEBUG[9982]: cdr_pgsql.c:307
process_my_load_module: cdr_pgsql: got dbname of asterisk Dec 18 10:58:27
DEBUG[9982]: cdr_pgsql.c:308 process_my_load_module: cdr_pgsql: got password
of ecom1091 Dec 18 10:58:27 DEBUG[9982]: cdr_pgsql.c:309
process_my_load_module: cdr_pgsql: got sql table name of cdr Dec 18 10:58:27
DEBUG[9982]: cdr_pgsql.c:313 process_my_load_module: Successfully connected
to PostgreSQL database.
[format_pcm.so] => (Raw uLaw 8khz Audio support (PCM))
== Registered file format pcm, extension(s) pcm|ulaw|ul|mu [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 'VoiceMailMain'
== Registered application 'MailboxExists'
== Registered application 'VMAuthenticate'
== Parsing '/etc/asterisk/voicemail.conf': Found Dec 18 10:58:27
DEBUG[9982]: app_voicemail.c:5139 load_config: VM Review Option disabled
globally Dec 18 10:58:27 DEBUG[9982]: app_voicemail.c:5146 load_config: VM
Operator break disabled globally Dec 18 10:58:27 DEBUG[9982]:
app_voicemail.c:5153 load_config: VM CID Info before msg disabled globally
Dec 18 10:58:27 DEBUG[9982]: app_voicemail.c:5167 load_config: ENVELOPE
before msg enabled globally Dec 18 10:58:27 DEBUG[9982]: app_voicemail.c:5174
load_config: Duration info before msg enabled globally Dec 18 10:58:27
DEBUG[9982]: app_voicemail.c:5190 load_config: We are not going to skip to
the next msg after save/delete [app_dumpchan.so] => (Dump Info About The
Calling Channel)
== Registered application 'DumpChan'
[app_addon_sql_mysql.so] => (Simple Mysql Interface)
== Registered application 'MYSQL'
[cdr_addon_mysql.so] => (MySQL CDR Backend)
== Parsing '/etc/asterisk/cdr_mysql.conf': Found [app_meetme.so]
=>
(MeetMe conference bridge)
== Registered application 'MeetMeAdmin'
== Registered application 'MeetMeCount'
== Registered application 'MeetMe'
*CLI>
==================================================================================================
Device registration:
*CLI> -- SIP Seeding '5555' at 5555@65.35.190.238:5060 for 660
-- SIP Seeding '5556' at 5556@65.35.190.238:5060 for 660
-- SIP Seeding '5555' at 5555@65.35.190.238:5060 for 660 Dec 18
11:07:43
NOTICE[9982]: chan_sip.c:8094 sip_poke_peer: Still have a call...
-- Registered SIP '5555' at 65.35.190.238 port 5060 expires 660
-- Saved useragent "WATA200 Callctrl/1.5.1.1 MxSF/v3.2.6.26" for
peer
5555 Dec 18 11:07:43 WARNING[9982]: res_config_odbc.c:374 update_odbc: SQL
Prepare failed![UPDATE sip_conf SET ipaddr=?, port=?, regseconds=?,
username=? WHERE name=?]
-- SIP Seeding '5555' at 5555@65.35.190.238:5060 for 660 Dec 18
11:07:43
DEBUG[9982]: app_queue.c:371 changethread: Device 'SIP/5555' changed to
state
'5'
Dec 18 11:07:43 DEBUG[9982]: chan_sip.c:7311 handle_request: That's odd...
Got a response on a call we dont know about.
-- SIP Seeding '5556' at 5556@65.35.190.238:5060 for 660 Dec 18
11:07:43
NOTICE[9982]: chan_sip.c:8094 sip_poke_peer: Still have a call...
-- Registered SIP '5556' at 65.35.190.238 port 5060 expires 660
-- Saved useragent "WATA200 Callctrl/1.5.1.1 MxSF/v3.2.6.26" for
peer
5556 Dec 18 11:07:43 WARNING[9982]: res_config_odbc.c:374 update_odbc: SQL
Prepare failed![UPDATE sip_conf SET ipaddr=?, port=?, regseconds=?,
username=? WHERE name=?]
-- SIP Seeding '5556' at 5556@65.35.190.238:5060 for 660 Dec 18
11:07:43
DEBUG[9982]: app_queue.c:371 changethread: Device 'SIP/5556' changed to
state
'5'
Dec 18 11:07:43 DEBUG[9982]: chan_sip.c:7311 handle_request: That's odd...
Got a response on a call we dont know about.
Dec 18 11:07:43 DEBUG[9982]: chan_sip.c:7311 handle_request: That's odd...
Got a response on a call we dont know about.
Dec 18 11:07:43 DEBUG[9982]: chan_sip.c:7311 handle_request: That's odd...
Got a response on a call we dont know about.
Dec 18 11:07:43 DEBUG[9982]: chan_sip.c:7311 handle_request: That's odd...
Got a response on a call we dont know about.
Dec 18 11:07:43 DEBUG[9982]: chan_sip.c:7311 handle_request: That's odd...
Got a response on a call we dont know about.
Dec 18 11:07:58 DEBUG[9982]: chan_sip.c:783 __sip_autodestruct: Auto
destroying call '171698e7c4cd268eb23213d5cf945e84@192.168.1.101'
Dec 18 11:07:58 DEBUG[9982]: chan_sip.c:783 __sip_autodestruct: Auto
destroying call 'b6bcbbccf5fd4022b3577bc6d7be5486@192.168.1.101'
=======================================================================================================================================
Phone Call attempt:
*CLI> Dec 18 11:10:59 DEBUG[9982]: chan_sip.c:5449 check_user_full: Setting
NAT on RTP to 4 Dec 18 11:10:59 DEBUG[9982]: chan_sip.c:852 __sip_ack:
Stopping retransmission on
'124078fd2b2f1c66485d4040fe5dab68@192.168.1.101'
of Response 823061699: Found Dec 18 11:10:59 DEBUG[9982]: chan_sip.c:5449
check_user_full: Setting NAT on RTP to 4 Dec 18 11:10:59 DEBUG[9982]:
chan_sip.c:7398 handle_request: Check for res for 5555 Dec 18 11:10:59
DEBUG[9982]: chan_sip.c:1586 update_user_counter: Call from user '5555'
is 1
out of 0 Dec 18 11:10:59 DEBUG[9982]: chan_sip.c:4659 build_route:
build_route: Contact hop: Accxx <sip:5555@192.168.1.101>
-- SIP Seeding '5555' at 5555@65.35.190.238:5060 for 660 Dec 18
11:10:59
DEBUG[9982]: app_queue.c:371 changethread: Device 'SIP/5555' changed to
state
'5'
-- Executing Dial("SIP/5555-5e1b", "SIP/5556,20") Dec 18
11:10:59
WARNING[9982]: chan_sip.c:1357 create_addr: No such host: 5556,20 Dec 18
11:10:59 NOTICE[9982]: app_dial.c:803 dial_exec: Unable to create channel of
type 'SIP' (cause 3)
== Everyone is busy/congested at this time (1:0/1/0) Dec 18 11:10:59
WARNING[9982]: res_config_odbc.c:250 realtime_multi_odbc: SQL Execute error!
[SELECT * FROM extensions_conf WHERE exten RLIKE ? AND context = ? AND
priority = ? ORDER BY exten]
Dec 18 11:10:59 DEBUG[9982]: app_dial.c:1167 dial_exec: Exiting with
DIALSTATUS=CONGESTION.
-- Executing Voicemail("SIP/5555-5e1b", "u5556") Dec 18
11:10:59
WARNING[9982]: app_voicemail.c:2208 leave_voicemail: No entry in voicemail
config file for '5556'
Dec 18 11:10:59 WARNING[9982]: res_config_odbc.c:250 realtime_multi_odbc: SQL
Execute error!
[SELECT * FROM extensions_conf WHERE exten RLIKE ? AND context = ? AND
priority = ? ORDER BY exten]
Dec 18 11:10:59 WARNING[9982]: res_config_odbc.c:250 realtime_multi_odbc: SQL
Execute error!
[SELECT * FROM extensions_conf WHERE exten RLIKE ? AND context = ? AND
priority = ? ORDER BY exten]
Dec 18 11:10:59 DEBUG[9982]: chan_sip.c:852 __sip_ack: Stopping
retransmission on '124078fd2b2f1c66485d4040fe5dab68@192.168.1.101' of
Response 823061700: Found Dec 18 11:11:00 DEBUG[9982]: chan_sip.c:7311
handle_request: That's odd... Got a response on a call we dont know about.
Dec 18 11:11:00 DEBUG[9982]: rtp.c:471 ast_rtp_read: RTP NAT: Using address
65.35.190.238:27000 Dec 18 11:11:00 DEBUG[9982]: rtp.c:391 ast_rtcp_read: RTP
NAT: Using address 192.168.1.101:27001 Dec 18 11:11:00 DEBUG[9982]: rtp.c:471
ast_rtp_read: RTP NAT: Using address 65.35.190.238:27000 Dec 18 11:11:03
DEBUG[9982]: rtp.c:391 ast_rtcp_read: RTP NAT: Using address
192.168.1.101:27001 Dec 18 11:11:03 DEBUG[9982]: rtp.c:471 ast_rtp_read: RTP
NAT: Using address 65.35.190.238:27000 Dec 18 11:11:06 DEBUG[9982]: rtp.c:391
ast_rtcp_read: RTP NAT: Using address 192.168.1.101:27001 Dec 18 11:11:06
DEBUG[9982]: rtp.c:471 ast_rtp_read: RTP NAT: Using address
65.35.190.238:27000 Dec 18 11:11:09 DEBUG[9982]: rtp.c:391 ast_rtcp_read: RTP
NAT: Using address 192.168.1.101:27001 Dec 18 11:11:09 DEBUG[9982]: rtp.c:471
ast_rtp_read: RTP NAT: Using address 65.35.190.238:27000 Dec 18 11:11:10
WARNING[9982]: res_config_odbc.c:250 realtime_multi_odbc: SQL Execute error!
[SELECT * FROM extensions_conf WHERE exten RLIKE ? AND context = ? AND
priority = ? ORDER BY exten]
Dec 18 11:11:10 WARNING[9982]: res_config_odbc.c:250 realtime_multi_odbc: SQL
Execute error!
[SELECT * FROM extensions_conf WHERE exten RLIKE ? AND context = ? AND
priority = ? ORDER BY exten]
Dec 18 11:11:10 WARNING[9982]: pbx.c:2000 ast_pbx_run: Timeout, but no rule
't' in context 'from-sip'
Dec 18 11:11:10 WARNING[9982]: res_config_odbc.c:250 realtime_multi_odbc: SQL
Execute error!
[SELECT * FROM extensions_conf WHERE exten RLIKE ? AND context = ? AND
priority = ? ORDER BY exten]
Dec 18 11:11:10 DEBUG[9982]: cdr_pgsql.c:100 pgsql_log: cdr_pgsql: inserting
a CDR record.
Dec 18 11:11:10 DEBUG[9982]: cdr_pgsql.c:108 pgsql_log: cdr_pgsql: SQL
command executed: INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,
billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES
('2004-12-18 11:10:59','"Clay 5555"
<5555>','5555','5556','from-sip',
'SIP/5555-5e1b','','VoiceMail','u5556',11,11,'ANSWERED',3,'DEFAULT_GROUP','11
03386259.0','')
Dec 18 11:11:10 DEBUG[9982]: chan_sip.c:1691 sip_hangup:
update_user_counter(5555) - decrement inUse counter
-- SIP Seeding '5555' at 5555@65.35.190.238:5060 for 660 Dec 18
11:11:10
DEBUG[9982]: app_queue.c:371 changethread: Device 'SIP/5555' changed to
state
'5'
Dec 18 11:11:10 DEBUG[9982]: chan_sip.c:852 __sip_ack: Stopping
retransmission on '124078fd2b2f1c66485d4040fe5dab68@192.168.1.101' of
Request
102: Found Dec 18 11:11:10 DEBUG[9982]: chan_sip.c:7311 handle_request:
That's odd... Got a response on a call we dont know about.
Thanks again!
-Clay
I'm sorry Matthew, I understood what you meant, I should have been more clear in my follow-up post. Thanks for your help. Clay -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Matthew Boehm Sent: Sunday, December 19, 2004 4:55 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime and PostgreSQL> I was dloading cvs over the top of a stable branch... (Matthew told methat> was a no-no...)No. That is not what I said. I said that when you do "cvs update" inside a previously CVS'd download of STABLE you are NOT getting the most recent version of asterisk. There are two ways to download STABLE asterisk: Grab the tarball or use CVS (cvs co -r v1-0 asterisk) If you use CVS to download the STABLE release, all future executions of "cvs update" will update your STABLE code only. If you go into another dir and do 'cvs co asterisk' you will get the most recent version possible.> register but when I try to make a call, I get silence and some SQLfailures. The SQL failures I saw where related to prepared statements. I would check to make sure you have most recent PGSql and try some test connections. I don't use PGSql so I can't help past this. -Matthew _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users