Hello, Michal! Rushan Sobar had the same problem as I had some months ago. I mean the colon at the end of %{Framed-IP-Address:} in raddb/postgresql.conf file from SQL Bill contrib sources. This is the link to message in archive: http://sourceforge.net/mailarchive/message.php?msg_id=13835883 I was talking about it at that time, but as i see in CVS version of SQL Bill nothing was changed. I don't have development access to CVS, so I should like to ask you about this. Farid >Farid > >you are right.... >after i remove the colon problem get solved.... >> 1. Re: SqlBill table voipcall Callingstationip (Farid Adigamov) >> >> --__--__-- >> >> Message: 1 >> Date: Thu, 1 Jun 2006 05:23:03 +0400 >> From: "Farid Adigamov" <lde4dl@xxxxx> >> To: openh323gk-users@xxxxx >> Subject: Re: SqlBill table voipcall Callingstationip >> Reply-To: openh323gk-users@xxxxx >> >> Hello, Rushan. >> I have this problem few months ago, and I told about it in mailing list: >> http://sourceforge.net/mailarchive/message.php?msg_id=13835883 >> >> Try these drugs: >> >> 1. Make 2 changes in raddb/postgresql.conf file. Use >> "%{Framed-IP-Address}" instead of "%{Framed-IP-Address:}" in >> accounting_start_query and accounting_stop_query_alt. ( Remove colon >> at the end ). >> >> 2. Check the log of PostgreSQL. Have you got the error during INSERT >> into voipcalltermtariff? ( i solve this by droping the CONSTRAINT on >> voipcalltermtariff table ) >> >> Please, report your result about this. May be I'm not right, cause in >> CVS version of the SQLBill there were no changes. >> >> Good luck ;) >> >> Farid Adigamov. >> >>> From: "Rushan Sobar" <Rushan@xxxxx> >>> To: <openh323gk-users@xxxxx> >>> Date: Tue, 30 May 2006 21:04:40 +0200 >>> Subject: SqlBill table voipcall Callingstationip >>> Reply-To: openh323gk-users@xxxxx >>> >>> Hi. >>> >>> in the sqlbill in the table voipcall Callingstationip shows my gnugk ip = >>> not the real callingstationip that register on my gnugk. >>> how i can log the real callstationip in the voipcall callingstationip = >>> not the openh323gk ip? >>> >>> i guess its in the gnugk.ini file but i cant reach the option that solve >>> = >>> this, any hints? >>> >>> Regards >>> Rushan _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/