<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=984115517-17122004><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial size=2>Entire console
bootup output:<BR>[root@abox asterisk]# /usr/sbin/asterisk -vvvvvvc<BR> ==
Parsing '/etc/asterisk/asterisk.conf': Found<BR> == Parsing
'/etc/asterisk/extconfig.conf': Found<BR>Asterisk CVS-v1-0-12/08/04-16:50:05,
Copyright (C) 1999-2004 Digium.<BR>Written by Mark Spencer <<A
href="mailto:markster@digium.com">markster@digium.com</A>><BR>=========================================================================<BR>
== Parsing '/etc/asterisk/logger.conf': Found<BR>Asterisk Event Logger Started
/var/log/asterisk/event_log<BR> == Manager registered action
Ping<BR> == Manager registered action Events<BR> == Manager
registered action Logoff<BR> == Manager registered action Hangup<BR>
== Manager registered action Status<BR> == Manager registered action
Setvar<BR> == Manager registered action Getvar<BR> == Manager
registered action Redirect<BR> == Manager registered action
Originate<BR> == Manager registered action MailboxStatus<BR> ==
Manager registered action Command<BR> == Manager registered action
ExtensionState<BR> == Manager registered action AbsoluteTimeout<BR>
== Manager registered action MailboxCount<BR> == Manager registered action
ListCommands<BR> == Parsing '/etc/asterisk/manager.conf':
Found<BR>Asterisk Management interface listening on port 5038<BR> ==
Parsing '/etc/asterisk/rtp.conf': Found<BR> == RTP Allocating from port
range 10000 -> 20000<BR>Asterisk PBX Core Initializing<BR>Registering builtin
applications:<BR> [AbsoluteTimeout]<BR> == Registered application
'AbsoluteTimeout'<BR> [Answer]<BR> == Registered application
'Answer'<BR> [BackGround]<BR> == Registered application
'BackGround'<BR> [Busy]<BR> == Registered application
'Busy'<BR> [Congestion]<BR> == Registered application
'Congestion'<BR> [DigitTimeout]<BR> == Registered application
'DigitTimeout'<BR> [Goto]<BR> == Registered application
'Goto'<BR> [GotoIf]<BR> == Registered application
'GotoIf'<BR> [GotoIfTime]<BR> == Registered application
'GotoIfTime'<BR> [Hangup]<BR> == Registered application
'Hangup'<BR> [NoOp]<BR> == Registered application
'NoOp'<BR> [Prefix]<BR> == Registered application
'Prefix'<BR> [Progress]<BR> == Registered application
'Progress'<BR> [ResetCDR]<BR> == Registered application
'ResetCDR'<BR> [ResponseTimeout]<BR> == Registered application
'ResponseTimeout'<BR> [Ringing]<BR> == Registered application
'Ringing'<BR> [SayNumber]<BR> == Registered application
'SayNumber'<BR> [SayDigits]<BR> == Registered application
'SayDigits'<BR> [SayAlpha]<BR> == Registered application
'SayAlpha'<BR> [SayPhonetic]<BR> == Registered application
'SayPhonetic'<BR> [SetAccount]<BR> == Registered application
'SetAccount'<BR> [SetAMAFlags]<BR> == Registered application
'SetAMAFlags'<BR> [SetGlobalVar]<BR> == Registered application
'SetGlobalVar'<BR> [SetLanguage]<BR> == Registered application
'SetLanguage'<BR> [SetVar]<BR> == Registered application
'SetVar'<BR> [StripMSD]<BR> == Registered application
'StripMSD'<BR> [Suffix]<BR> == Registered application
'Suffix'<BR> [Wait]<BR> == Registered application
'Wait'<BR> [WaitExten]<BR> == Registered application
'WaitExten'<BR>Asterisk Dynamic Loader Starting:<BR> == Parsing
'/etc/asterisk/modules.conf': Found<BR> [chan_modem.so] => (Generic
Voice Modem Driver)<BR> == Parsing '/etc/asterisk/modem.conf':
Found<BR> == Loading modem driver chan_modem_aopen.so => (A/Open
(Rockwell Chipset) ITU-2 VoiceModem Driver)<BR> == Registered channel type
'Modem' (Generic Voice Modem Channel Driver)<BR> [res_musiconhold.so] =>
(Music On Hold Resource)<BR> == Parsing '/etc/asterisk/musiconhold.conf':
Found<BR>Dec 17 11:33:05 WARNING[21622]: res_musiconhold.c:564 moh_register:
Unable to open pseudo channel for timing... Sound may be choppy.<BR>
== Registered application 'MusicOnHold'<BR> == Registered application
'WaitMusicOnHold'<BR> == Registered application
'SetMusicOnHold'<BR> [res_crypto.so] => (Cryptographic Digital
Signatures)<BR> -- Loaded PUBLIC key
'iaxtel'<BR> -- Loaded PUBLIC key
'freeworlddialup'<BR> [res_monitor.so] => (Call Monitoring
Resource)<BR> == Registered application 'Monitor'<BR> == Registered
application 'StopMonitor'<BR> == Registered application
'ChangeMonitor'<BR> == Manager registered action Monitor<BR> ==
Manager registered action StopMonitor<BR> == Manager registered action
ChangeMonitor<BR> [res_agi.so] => (Asterisk Gateway Interface
(AGI))<BR> == Registered application 'DeadAGI'<BR> == Registered
application 'EAGI'<BR> == Registered application
'AGI'<BR> [res_adsi.so] => (ADSI Resource)<BR> == Parsing
'/etc/asterisk/adsi.conf': Found<BR> [res_indications.so] =>
(Indications Configuration)<BR> == Parsing
'/etc/asterisk/indications.conf': Found<BR> -- Registered
indication country 'cl'<BR> -- Registered indication country
'tw'<BR> -- Registered indication country
'us'<BR> -- Registered indication country
'au'<BR> -- Registered indication country
'fr'<BR> -- Registered indication country
'de'<BR> -- Registered indication country
'nl'<BR> -- Registered indication country
'uk'<BR> -- Registered indication country
'fi'<BR> -- Registered indication country
'no'<BR> -- Registered indication country
'br'<BR> -- Registered indication country
'za'<BR> -- Registered indication country
'it'<BR> -- Registered indication country
'us-o'<BR> -- Registered indication country
'gr'<BR> -- Registered indication country
'ru'<BR> -- Registered indication country
'nz'<BR> -- Setting default indication country to
'us'<BR> == Registered application 'Playtones'<BR> == Registered
application 'StopPlaytones'<BR> [res_odbc.so] => (ODBC
Resource)<BR> == Parsing '/etc/asterisk/res_odbc.conf': Found<BR>Dec 17
11:33:05 NOTICE[21622]: res_odbc.c:133 load_odbc_config: registered database
handle 'PostgreSQL' dsn->[PostgreSQL]<BR>Dec 17 11:33:05 NOTICE[21622]:
res_odbc.c:353 odbc_obj_connect: res_odbc: Connected to PostgreSQL
[PostgreSQL]<BR>Dec 17 11:33:05 NOTICE[21622]: res_odbc.c:379 load_module:
res_odbc loaded.<BR> [res_config_odbc.so] => (ODBC Configuration)<BR>Dec
17 11:33:05 NOTICE[21622]: config.c:888 ast_config_register: Registered Config
Engine odbc<BR> == Parsing '/etc/asterisk/extconfig.conf': Found<BR>Dec 17
11:33:05 NOTICE[21622]: res_config_odbc.c:190 load_module: res_config_odbc
loaded.<BR> [res_features.so] => (Call Parking Resource)<BR> ==
Parsing '/etc/asterisk/features.conf': Found<BR> -- Registered
extension context 'parkedcalls'<BR> -- Added extension '700'
priority 1 to parkedcalls<BR> == Registered application
'ParkedCall'<BR> == Registered application 'Park'<BR> == Manager
registered action ParkedCalls<BR> [app_milliwatt.so] => (Digital
Milliwatt (mu-law) Test Application)<BR> == Registered application
'Milliwatt'<BR> [app_cdr.so] => (Make sure asterisk doesn't save CDR for
a certain call)<BR> == Registered application
'NoCDR'<BR> [app_transfer.so] => (Transfer)<BR> == Registered
application 'Transfer'<BR> [app_waitforring.so] => (Waits until first
ring after time)<BR> == Registered application
'WaitForRing'<BR> [format_g726.so] => (Raw G.726 (16/24/32/40kbps)
data)<BR> == Registered file format g726-40, extension(s)
g726-40<BR> == Registered file format g726-32, extension(s)
g726-32<BR> == Registered file format g726-24, extension(s)
g726-24<BR> == Registered file format g726-16, extension(s)
g726-16<BR> [app_qcall.so] => (Call from Queue)<BR> [codec_alaw.so]
=> (A-law Coder/Decoder)<BR> == Registered translator 'alawtolin' from
format alaw to slin, cost 1<BR> == Registered translator 'lintoalaw' from
format slin to alaw, cost 1<BR> [app_mp3.so] => (Silly MP3
Application)<BR> == Registered application
'MP3Player'<BR> [app_queue.so] => (True Call Queueing)<BR> ==
Registered application 'Queue'<BR> == Manager registered action
Queues<BR> == Manager registered action QueueStatus<BR> == Manager
registered action QueueAdd<BR> == Manager registered action
QueueRemove<BR> == Registered application 'AddQueueMember'<BR> ==
Registered application 'RemoveQueueMember'<BR> == Parsing
'/etc/asterisk/queues.conf': Found<BR> [app_userevent.so] => (Custom
User Event Application)<BR> == Registered application
'UserEvent'<BR> [app_nbscat.so] => (Silly NBS Stream
Application)<BR> == Registered application 'NBScat'<BR> [cdr_odbc.so]
=> (ODBC CDR Backend)<BR> == Parsing '/etc/asterisk/cdr_odbc.conf':
Found<BR> [format_g729.so] => (Raw G729 data)<BR> == Registered
file format g729, extension(s) g729<BR> [codec_a_mu.so] => (A-law and
Mulaw direct Coder/Decoder)<BR> == Registered translator 'alawtoulaw' from
format alaw to ulaw, cost 1<BR> == Registered translator 'ulawtoalaw' from
format ulaw to alaw, cost 1<BR> [codec_adpcm.so] => (Adaptive
Differential PCM Coder/Decoder)<BR> == Registered translator 'adpcmtolin'
from format adpcm to slin, cost 1<BR> == Registered translator
'lintoadpcm' from format slin to adpcm, cost 1<BR> [app_alarmreceiver.so]
=> (Alarm Receiver for Asterisk)<BR> == Parsing
'/etc/asterisk/alarmreceiver.conf': Found<BR> == Registered application
'AlarmReceiver'<BR> [app_senddtmf.so] => (Send DTMF digits
Application)<BR> == Registered application
'SendDTMF'<BR> [app_parkandannounce.so] => (Call Parking and Announce
Application)<BR> == Registered application
'ParkAndAnnounce'<BR> [app_setcdruserfield.so] => (CDR user field
apps)<BR> == Registered application 'SetCDRUserField'<BR> ==
Registered application 'AppendCDRUserField'<BR> == Manager registered
action SetCDRUserField<BR> [format_jpeg.so] => (JPEG (Joint Picture
Experts Group) Image Format)<BR> == Registered format 'jpg' (JPEG (Joint
Picture Experts Group))<BR> [app_test.so] => (Interface Test
Application)<BR> == Registered application 'TestClient'<BR> ==
Registered application 'TestServer'<BR> [app_setcidnum.so] => (Set
CallerID Number)<BR> == Registered application
'SetCIDNum'<BR> [app_zapbarge.so] => (Barge in on Zap channel
application)<BR> == Registered application
'ZapBarge'<BR> [app_sendtext.so] => (Send Text Applications)<BR>
== Registered application 'SendText'<BR> [codec_gsm.so] => (GSM/PCM16
(signed linear) Codec Translator)<BR> == Registered translator 'gsmtolin'
from format gsm to slin, cost 1<BR> == Registered translator 'lintogsm'
from format slin to gsm, cost 1<BR> [app_image.so] => (Image
Transmission Application)<BR> == Registered application
'SendImage'<BR> [chan_local.so] => (Local Proxy Channel)<BR> ==
Registered channel type 'Local' (Local Proxy Channel
Driver)<BR> [format_sln.so] => (Raw Signed Linear Audio support
(SLN))<BR> == Registered file format sln, extension(s)
sln|raw<BR> [app_lookupcidname.so] => (Look up CallerID Name from local
database)<BR> == Registered application
'LookupCIDName'<BR> [chan_modem_bestdata.so] => (BestData (Conexant V.90
Chipset) VoiceModem Driver)<BR> [format_wav.so] => (Microsoft WAV format
(8000hz Signed Linear))<BR> == Registered file format wav, extension(s)
wav<BR> [app_cut.so] => (Cuts up variables)<BR> == Registered
application 'Cut'<BR> [app_softhangup.so] => (Hangs up the requested
channel)<BR> == Registered application
'SoftHangup'<BR> [cdr_pgsql.so] => (PostgreSQL CDR Backend)<BR> ==
Parsing '/etc/asterisk/cdr_pgsql.conf': Found<BR> [app_dial.so] =>
(Dialing Application)<BR> == Registered application
'Dial'<BR> [pbx_spool.so] => (Outgoing Spool
Support)<BR> [app_directory.so] => (Extension Directory)<BR> ==
Registered application 'Directory'<BR> [app_adsiprog.so] => (Asterisk
ADSI Programming Application)<BR> == Registered application
'ADSIProg'<BR> [app_forkcdr.so] => (Fork The CDR into 2 seperate
entities.)<BR> == Registered application
'ForkCDR'<BR> [format_pcm.so] => (Raw uLaw 8khz Audio support
(PCM))<BR> == Registered file format pcm, extension(s)
pcm|ulaw|ul|mu<BR> [chan_phone.so] => (Linux Telephony API
Support)<BR> == Parsing '/etc/asterisk/phone.conf': Found<BR> ==
Registered channel type 'Phone' (Standard Linux Telephony API
Driver)<BR> [format_gsm.so] => (Raw GSM data)<BR> == Registered
file format gsm, extension(s) gsm<BR> [app_enumlookup.so] => (ENUM
Lookup)<BR> == Registered application 'EnumLookup'<BR> == Parsing
'/etc/asterisk/enum.conf': Found<BR> [app_voicemail.so] => (Comedian
Mail (Voicemail System))<BR> == Registered application
'VoiceMail'<BR> == Registered application 'VoiceMail2'<BR> ==
Registered application 'VoiceMailMain'<BR> == Registered application
'VoiceMailMain2'<BR> == Registered application 'MailboxExists'<BR>
== Parsing '/etc/asterisk/voicemail.conf': Not found (No such file or
directory)<BR>Dec 17 11:33:05 WARNING[21622]: app_voicemail.c:4328 load_config:
Error reading voicemail config<BR>Dec 17 11:33:05 WARNING[21622]: loader.c:345
ast_load_resource: app_voicemail.so: load_module failed, returning -1<BR>
== Unregistered application 'VoiceMail'<BR> == Unregistered application
'VoiceMail2'<BR> == Unregistered application 'VoiceMailMain'<BR> ==
Unregistered application 'VoiceMailMain2'<BR> == Unregistered application
'MailboxExists'<BR>Dec 17 11:33:05 WARNING[21622]: loader.c:440 load_modules:
Loading module app_voicemail.so failed!<BR>[root@abox
asterisk]#</FONT></SPAN></DIV>
<DIV> </DIV><SPAN class=984115517-17122004>
<DIV><BR><FONT face=Arial size=2>extconfig.conf:<BR>[settings]</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>;uncomment to load queues.conf via the db
engine.<BR>;queues.conf => odbc,PostgreSQL,ast_config<BR>sip.conf =>
odbc,PostgreSQL,sip_conf<BR>extensions.conf =>
odbc,PostgreSQL,extensions_conf<BR>voicemail.conf =>
odbc,PostgreSQL,voicemail_conf<BR>~</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>res_odbc.conf:<BR>;;; odbc setup file</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[PostgreSQL]<BR>dsn => PostgreSQL<BR>username
=> abox<BR>password => ecom1091<BR>pre-connect => yes</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>res_config_odbc.conf:<BR>[settings]<BR>table =>
ast_config<BR>connection => PostgeSQL</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>odbcinst.ini:<BR># Example driver
definitinions<BR>#<BR>#</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># Included in the unixODBC
package<BR>[PostgreSQL]<BR>Description = ODBC for
PostgreSQL<BR>Driver =
/usr/lib/libodbcpsql.so<BR>Setup
= /usr/lib/libodbcpsqlS.so<BR>FileUsage =
1</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>odbc.ini:<BR>[PostgreSQL]<BR>Description
=
Postgres<BR>Driver
=
PostgreSQL<BR>Trace
= Yes<BR>TraceFile =
sql.log<BR>Database
= asterisk<BR>Servername =
localhost<BR>UserName
=
asterisk<BR>Password
= password<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial size=2>Thank
you!</FONT></SPAN></DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial size=2>Begging for
help,</FONT></SPAN></DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial size=2>Clay
Reiche</FONT></SPAN></DIV>
<DIV><SPAN class=984115517-17122004><FONT face=Arial
size=2></FONT></SPAN> </DIV></SPAN></BODY></HTML>