[Asterisk-Users] HELP! With Postresql
I am having some real problems with getting CDR records to go to a Postresql database. I think I have followed every post and instruction available and Asterisk still happily writes to a text file. Postresql is installed and working on a Redhat 9.0 box, the same one as Asterisk. I have created the CDR table in a database called Asterisk. Conf files etc are set. I even recompiled Asterisk. Any pointers would be greatly appreciated. Martin ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] HELP! With Postresql
Martin Keding wrote: I am having some real problems with getting CDR records to go to a Postresql database. I think I have followed every post and instruction available and Asterisk still happily writes to a text file. Postresql is installed and working on a Redhat 9.0 box, the same one as Asterisk. I have created the CDR table in a database called Asterisk. Conf files etc are set. I even recompiled Asterisk. Any pointers would be greatly appreciated. In file /var/lib/pgsql/data/pg_hba.conf uncomment the line: hostall all 127.0.0.1 255.255.255.255 trust In file /var/lib/pgsql/data/postgresql.conf change line to: tcpip_socket = true Add -i to option in your /etc/init.d/postgresql export PGOPTS=-i Not sure if all that is needed, but it did get my FC2 linux 2.6.6 running. -- Bob Knight [-w] the work option [EMAIL PROTECTED] 925-449-9163 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] HELP! With Postresql
Have you actually compiled the pgsql CDR module in to Asterisk? On Wed, 2004-07-28 at 09:43, Martin Keding wrote: > I am having some real problems with getting CDR records to go to a Postresql > database. I think I have followed every post and instruction available and > Asterisk still happily writes to a text file. Postresql is installed and > working on a Redhat 9.0 box, the same one as Asterisk. I have created the > CDR table in a database called Asterisk. Conf files etc are set. I even > recompiled Asterisk. Any pointers would be greatly appreciated. > > Martin > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users -- Stephen Darragh Technical Director Informed Technology Ph: +61 8 9380 4244 Fax: +61 8 9380 4354 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] HELP! With Postresql
I installed Postresql and then recompiled Asterisk. I understood that Asterisk would see Postresql on the recompile and add it. Is there a way of checking? Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen R. Darragh Sent: Tuesday, July 27, 2004 10:54 PM To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] HELP! With Postresql Have you actually compiled the pgsql CDR module in to Asterisk? On Wed, 2004-07-28 at 09:43, Martin Keding wrote: > I am having some real problems with getting CDR records to go to a > Postresql database. I think I have followed every post and instruction > available and Asterisk still happily writes to a text file. Postresql > is installed and working on a Redhat 9.0 box, the same one as > Asterisk. I have created the CDR table in a database called Asterisk. > Conf files etc are set. I even recompiled Asterisk. Any pointers would > be greatly appreciated. > > Martin > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users -- Stephen Darragh Technical Director Informed Technology Ph: +61 8 9380 4244 Fax: +61 8 9380 4354 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] HELP! With Postresql
> Subject: [Asterisk-Users] HELP! With Postresql > > > I am having some real problems with getting CDR records to go to > a Postresql > database. I think I have followed every post and instruction available and > Asterisk still happily writes to a text file. Postresql is installed and > working on a Redhat 9.0 box, the same one as Asterisk. I have created the > CDR table in a database called Asterisk. Conf files etc are set. I even > recompiled Asterisk. Any pointers would be greatly appreciated. > > Martin Could you provide any details to your configuration and details on the errors that you see? It is a little hard to intuit from a blank page ;) dboyd(at)fullmoonsoft.com ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] HELP! With Postresql
Have you edited the MODS line in asterisk/cdr/Makefile ? The docs seem to suggest there's some sort of auto-configuration that occurs, but in my experimentation it appeared that it was necessary to change the MODS definition to include cdr_pgsql.so as described in the comments above the MODS definition. -- Greg Broiles, JD, EA [EMAIL PROTECTED] (Lists only. Not for confidential communications.) Law Office of Gregory A. Broiles San Jose, CA ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] HELP! With Postresql
Hi - Check /usr/lib/modules to see if cdr_pgsql.so is in there. If not, edit the Makefile in the asterisk/cdr directory and add "cdr_pgsql.so" to the MODS= line near the top of the file and then rebuild. You may need to edit some files if your postgresql headers aren't where the source expects. Is asterisk going to get an autoconf script any time soon? On Wed, 2004-07-28 at 22:52, Martin Keding wrote: > I installed Postresql and then recompiled Asterisk. I understood that > Asterisk would see Postresql on the recompile and add it. Is there a way of > checking? > > Martin > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Stephen R. > Darragh > Sent: Tuesday, July 27, 2004 10:54 PM > To: [EMAIL PROTECTED] > Subject: Re: [Asterisk-Users] HELP! With Postresql > > > Have you actually compiled the pgsql CDR module in to Asterisk? > > > On Wed, 2004-07-28 at 09:43, Martin Keding wrote: > > I am having some real problems with getting CDR records to go to a > > Postresql database. I think I have followed every post and instruction > > available and Asterisk still happily writes to a text file. Postresql > > is installed and working on a Redhat 9.0 box, the same one as > > Asterisk. I have created the CDR table in a database called Asterisk. > > Conf files etc are set. I even recompiled Asterisk. Any pointers would > > be greatly appreciated. > > > > Martin > > > > ___ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > >http://lists.digium.com/mailman/listinfo/asterisk-users -- Stephen Darragh Technical Director Informed Technology Ph: +61 8 9380 4244 Fax: +61 8 9380 4354 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] HELP! With Postresql
Thanks for your help The cdr_pgsql.so was not there. Do I change the mods line to MODS=cdr_csv.so; cdr_pgsql.so Ie. Do I add a semi-colon or not. Thanks Martin Hi - Check /usr/lib/modules to see if cdr_pgsql.so is in there. If not, edit the Makefile in the asterisk/cdr directory and add "cdr_pgsql.so" to the MODS= line near the top of the file and then rebuild. You may need to edit some files if your postgresql headers aren't where the source expects. Is asterisk going to get an autoconf script any time soon? On Wed, 2004-07-28 at 22:52, Martin Keding wrote: > I installed Postresql and then recompiled Asterisk. I understood that > Asterisk would see Postresql on the recompile and add it. Is there a > way of checking? > > Martin > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Stephen R. > Darragh > Sent: Tuesday, July 27, 2004 10:54 PM > To: [EMAIL PROTECTED] > Subject: Re: [Asterisk-Users] HELP! With Postresql > > > Have you actually compiled the pgsql CDR module in to Asterisk? > > > On Wed, 2004-07-28 at 09:43, Martin Keding wrote: > > I am having some real problems with getting CDR records to go to a > > Postresql database. I think I have followed every post and instruction > > available and Asterisk still happily writes to a text file. Postresql > > is installed and working on a Redhat 9.0 box, the same one as > > Asterisk. I have created the CDR table in a database called Asterisk. > > Conf files etc are set. I even recompiled Asterisk. Any pointers would > > be greatly appreciated. > > > > Martin > > > > ___ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > >http://lists.digium.com/mailman/listinfo/asterisk-users -- Stephen Darragh Technical Director Informed Technology Ph: +61 8 9380 4244 Fax: +61 8 9380 4354 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] HELP! With Postresql
Mine looks like this: MODS=cdr_csv.so cdr_manager.so -- Greg Broiles, JD, EA [EMAIL PROTECTED] (Lists only. Not for confidential communications.) Law Office of Gregory A. Broiles San Jose, CA ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users