[Asterisk-Users] Realtime and PostgreSQL

Matthew Boehm mboehm at cytelcom.com
Fri Dec 17 12:05:24 MST 2004 

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 at accxx.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Friday, December 17, 2004 12:50 PM
Subject: RE: [Asterisk-Users] Realtime and PostgreSQL


Entire console with debugging...

[root at 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 at 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 at lists.digium.com
[mailto:asterisk-users-bounces at 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 at accxx.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at 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 at 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 at 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

More information about the asterisk-users mailing list