[Asterisk-Users] Realtime and PostgreSQL
Clay Reiche
creiche at accxx.com
Fri Dec 17 10:58:49 MST 2004
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 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 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 at 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
More information about the asterisk-users
mailing list