unsubscribe

2003-10-20 Thread boggss
unsubscribe


  

-
Bringing First World Technology Closer to You.
http://www.1asialink.com
  


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-16 Thread boggss
guy, my reason of using fr 0.9.1 for pgsql 7.3.2 is that pgsql has
triggers and functions that i am using on. i am implementing a lot of
stored procedures on it. can you send me the config files of fr + pgsql?
i'll be delighted to study it.
thanksHiIdidhave0.8.1workingasatest,butlatelastweekIdecidedtoupgradeto0.9.1beforemodifyingdial-admintoworkwithPostgreSQL.Havingrunintoaproblemporting0.9.1toFreeBSDInolongerhaveafunctionalexampletoshowyou.UnlessyouhaveaspecificreasontousePostgreSQL,youareprobablybetteroffusingMySQL.ItappearsasthoughPostgreSQLisbarelysupported.Thesetupin0.9.1ismuchbetter,butthereisnosetupfordialup-admin,andIamnotsureifthereissetupinformationforsql_counterbecauseIhavenotlookedatityet.Iamstillusingcistron1.6.6thatIpatchedtoaccounttoPostgreSQL,anduntilIamsatisfiedwithPostgreSQLfunctionsinFreeRadiusIwillbetestingandhopefullyprovidingpatchesandsuggestingfixesfortheimplementationofPostgreSQL.[EMAIL PROTECTED]wrote:ididthatalready.itstillwont...doyouhaveworkingconfigs?alaboutFRandPGSQLMakesuretheuseryouhavesetuptoaccessthedatabasehasinsertandupdatepermissionsfortheradaccttable.-Listinfo/subscribe/unsubscribe?Seehttp://www.freeradius.org/list/users.html


  

-
Bringing First World Technology Closer to You.
http://www.1asialink.com
  


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-15 Thread boggss
EAcctSessionTime=-1ANDAcctStopTime=AcctStartTimeANDNASIPAddress='%{NAS-IP-Address}'ANDAcctStartTime='%S'"sql:accounting_update_query="UPDATEradacctSETFramedIPAddress='%{Framed-IP-Address}'WHEREAcctSessionId='%{Acct-Session-Id}'ANDUserName='%{User-Name}'ANDNASIPAddress='%{NAS-IP-Address}'andNASPortId='%{NAS-Port}'"sql:accounting_start_query="INSERTintoradacct(AcctSessionId,AcctUniqueId,UserName,Realm,NASIPAddress,NASPortId,NASPortType,AcctStartTime,AcctSessionTime,AcctAuthentic,ConnectInfo_start,ConnectInfo_stop,AcctInputOctets,AcctOutputOctets,CalledStationId,CallingStationId,AcctTerminateCause,ServiceType,FramedProtocol,FramedIPAddress,AcctStartDelay,AcctStopDelay)values('%{Acct-Session-Id}','%{Acct-Unique-Session-Id}','%{SQL-User-Name}','%{Realm}','%{NAS-IP-Address}','%{NAS-Port}','%{NAS-Port-Type}','%S','-1','%{Acct-Authentic}','%{Connect-Info}','','0','0','%{Called-Station-Id}','%{Calling-Station-Id}','','%{Service-Type}','%{Framed-Protocol}','%{Framed-IP-Address}','%{Acct-Delay-Time}','0')"sql:accounting_start_query_alt="UPDATEradacctSETAcctStartTime='%S',AcctStartDelay='%{Acct-Delay-Time}',ConnectInfo_start='%{Connect-Info}'WHEREAcctSessionId='%{Acct-Session-Id}'ANDUserName='%{SQL-User-Name}'ANDNASIPAddress='%{NAS-IP-Address}'"sql:accounting_stop_query="UPDATEradacctSETAcctStopTime='%S',AcctSessionTime='%{Acct-Session-Time}',AcctInputOctets='%{Acct-Input-Octets}',AcctOutputOctets='%{Acct-Output-Octets}',AcctTerminateCause='%{Acct-Terminate-Cause}',AcctStopDelay='%{Acct-Delay-Time}',FramedIPAddress='%{Framed-IP-Address}',ConnectInfo_stop='%{Connect-Info}'WHEREAcctSessionId='%{Acct-Session-Id}'ANDUserName='%{SQL-User-Name}'ANDNASIPAddress='%{NAS-IP-Address}'andNASPortId='%{NAS-Port}'andacctstarttime(now()-interval('2days'))"sql:accounting_stop_query_alt="INSERTintoradacct(AcctSessionId,AcctUniqueId,UserName,Realm,NASIPAddress,NASPortId,NASPortType,AcctStartTime,AcctStopTime,AcctSessionTime,AcctAuthentic,ConnectInfo_start,ConnectInfo_stop,AcctInputOctets,AcctOutputOctets,CalledStationId,CallingStationId,AcctTerminateCause,ServiceType,FramedProtocol,FramedIPAddress,AcctStartDelay,AcctStopDelay)values('%{Acct-Session-Id}','%{Acct-Unique-Session-Id}','%{SQL-User-Name}','%{Realm}','%{NAS-IP-Address}','%{NAS-Port}','%{NAS-Port-Type}','0','%S','%{Acct-Session-Time}','%{Acct-Authentic}','','%{Connect-Info}','%{Acct-Input-Octets}','%{Acct-Output-Octets}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Acct-Terminate-Cause}','%{Service-Type}','%{Framed-Protocol}','%{Framed-IP-Address}','0','%{Acct-Delay-Time}')"sql:group_membership_query=""sql:connect_failure_retry_delay=60sql:simul_count_query=""sql:simul_verify_query=""rlm_sql(sql):Driverrlm_sql_postgresql(modulerlm_sql_postgresql)loadedandlinkedrlm_sql(sql):Attemptingtoconnectto[EMAIL PROTECTED]:/radiusrlm_sql(sql):starting0rlm_sql(sql):Attemptingtoconnectrlm_sql_postgresql#0rlm_sql(sql):ConnectednewDBhandle,#0rlm_sql(sql):starting1rlm_sql(sql):Attemptingtoconnectrlm_sql_postgresql#1rlm_sql(sql):ConnectednewDBhandle,#1rlm_sql(sql):starting2rlm_sql(sql):Attemptingtoconnectrlm_sql_postgresql#2rlm_sql(sql):ConnectednewDBhandle,#2rlm_sql(sql):starting3rlm_sql(sql):Attemptingtoconnectrlm_sql_postgresql#3rlm_sql(sql):ConnectednewDBhandle,#3rlm_sql(sql):starting4rlm_sql(sql):Attemptingtoconnectrlm_sql_postgresql#4rlm_sql(sql):ConnectednewDBhandle,#4Module:Instantiatedsql(sql)Module:LoadedAcct-Unique-Session-Idacct_unique:key="User-Name,Acct-Session-Id,NAS-IP-Address,Client-IP-Address,NAS-Port-Id"Module:Instantiatedacct_unique(acct_unique)Module:Loadeddetaildetail:detailfile="/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"detail:detailperm=384detail:dirperm=493detail:locking=noModule:Instantiateddetail(detail)Module:LoadedSystemunix:cache=nounix:passwd="(null)"unix:shadow="(null)"unix:group="(null)"unix:radwtmp="/usr/local/var/log/radius/radwtmp"unix:usegroup=nounix:cache_reload=600Module:Instantiatedunix(unix)Module:Loadedradutmpradutmp:filename="/usr/local/var/log/radius/radutmp"radutmp:username="%{User-Name}"radutmp:case_sensitive=yesradutmp:check_with_nas=yesradutmp:perm=384radutmp:callerid=yesModule:Instantiatedradutmp(radutmp)Module:Loadedeapeap:default_eap_type="md5"eap:timer_expire=60eap:ignore_unknown_eap_types=norlm_eap:Loadedandinitializedtypemd5rlm_eap:LoadedandinitializedtypeleapModule:Instantiatedeap(eap)ListeningonIPaddress*,ports1812/udpand1813/udp,withproxyon1814/udp.Readytoprocessrequests.rad_recv:Access-Requestpacketfromhost10.10.80.23:2543,id=7,length=46
User-Name="boggss"
User-Password="test"modcall:enteringgroupauthorize
modcall[authorize]:module"preprocess"returnsok
modcall[authorize]:module"chap"returnsnoopradius_xlat:
'boggss'rlm_sql(sql):sql_set_userescapeduser--'boggss'radius_xlat:
'SEL

POSTGRESQL + FREERADIUS 0.9.1 configuration help

2003-09-13 Thread boggss
 AND NASIPAddress= '%{NAS-IP-Address}' AND
AcctStartTime = '%S'
 sql: accounting_update_query = UPDATE radacct SET FramedIPAddress =
'%{Framed-IP-Address}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND
UserName = '%{User-Name}' AND NASIPAddress= '%{NAS-IP-Address}' and
NASPortId='%{NAS-Port}' 
 sql: accounting_start_query = INSERT into radacct (AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,
ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,
CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol,
FramedIPAddress, AcctStartDelay, AcctStopDelay)
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
'%{NAS-Port-Type}', '%S', '-1', '%{Acct-Authentic}', '%{Connect-Info}',
'', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '',
'%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',
'%{Acct-Delay-Time}', '0')
 sql: accounting_start_query_alt = UPDATE radacct SET AcctStartTime =
'%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start =
'%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName
= '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'
 sql: accounting_stop_query = UPDATE radacct SET AcctStopTime = '%S',
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}',
AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay =
'%{Acct-Delay-Time}', FramedIPAddress = '%{Framed-IP-Address}',
ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId =
'%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress =
'%{NAS-IP-Address}' and NASPortId='%{NAS-Port}' and acctstarttime 
(now()-interval('2 days')) 
 sql: accounting_stop_query_alt = INSERT into radacct ( AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay)
values('%{Acct-Session-Id}',
'%{Acct-Unique-Session-Id}','%{SQL-User-Name}', '%{Realm}',
'%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '0', '%S',
'%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}',
'%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}',
'%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}',
'%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')
 sql: group_membership_query = 
 sql: connect_failure_retry_delay = 60
 sql: simul_count_query = 
 sql: simul_verify_query = 
rlm_sql (sql): Driver rlm_sql_postgresql (module rlm_sql_postgresql)
loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
 acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address,
Client-IP-Address, NAS-Port-Id
Module: Instantiated acct_unique (acct_unique)
Module: Loaded detail
 detail: detailfile =
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d
 detail: detailperm = 384
 detail: dirperm = 493
 detail: locking = no
Module: Instantiated detail (detail)
Module: Loaded System
 unix: cache = no
 unix: passwd = (null)
 unix: shadow = (null)
 unix: group = (null)
 unix: radwtmp = /usr/local/var/log/radius/radwtmp
 unix: usegroup = no
 unix: cache_reload = 600
Module: Instantiated unix (unix)
Module: Loaded radutmp
 radutmp: filename = /usr/local/var/log/radius/radutmp
 radutmp: username = %{User-Name}
 radutmp: case_sensitive = yes
 radutmp: check_with_nas = yes
 radutmp: perm = 384
 radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
Module: Loaded eap
 eap: default_eap_type = md5
 eap: timer_expire = 60
 eap: ignore_unknown_eap_types = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
Module: Instantiated eap (eap)
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
1814/udp.
Ready to process requests.
rad_recv: Access-Request packet from host 10.10.80.23:2543, id=7, length=46
User-Name = boggss
User

postgresql and freeradius accounting problem

2003-09-10 Thread boggss
hello list,

i am just new to this list. i know igor chen is on of those i have seen
posting some about postgresql and freeradius.

i am having problem with postgresql and freeradius on its accounting.
there seems to have no entries when i i try radtest using ntradping.

i am using postgresql 7.2.3 and freeradis 0.4 or the latest. my box is on
freebsd 4.8.

is anyone here having the same specs as mine as well as having problems?
if you do please let me know how you solved the same problem as i have.

if you happen to have a step by step notes on configuration of the
postgresql + freeradius, i would be honored to take it.

thanks,

francis ted a. seguerra
www.1asialink.com
brbr
table border=0 width=100% height=9
  tr
td width=100% height=9
font face=Arial 
color=#006600-br
iBringing First World Technology Closer to You./ibr
bhttp://www.1asialink.com/b/font/td
  /tr
/table

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: postgresql and freeradius accounting problem

2003-09-10 Thread boggss
sorry i made a mistake, i am using the latest snapshot for freeradius. but
still i got errors on accounting. it doesnt insert any on the db when i
try to use accounting start.


 At 09:43 AM 9/10/2003,[EMAIL PROTECTED]:
hello list,

i am just new to this list. i know igor chen is on of those i have seen
posting some about postgresql and freeradius.

i am having problem with postgresql and freeradius on its accounting.
there seems to have no entries when i i try radtest using ntradping.

i am using postgresql 7.2.3 and freeradis 0.4 or the latest. my box is on
freebsd 4.8.
 
 Please consider upgrading, the lastest release is 0.9.1.   The version
 0.4 is *very* *very* old and have many known bugs and memory leaks which
 are fixed in the current release.
 
 -Chris
 
 --
 \\\|||///  \  StarNet Inc.  \ Chris Parker
 \ ~   ~ /   \   WX *is* Wireless!    \   Director, Engineering
 | @  [EMAIL PROTECTED]|    \   http://www.starnetwx.net \  (847) 963-0116
 oOo---(_)---oOo--\--
    \ Wholesale Internet Services - http://www.megapop.net
 
 
 
 -
 List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html
 

brbr
table border=0 width=100% height=9
  tr
td width=100% height=9
font face=Arial 
color=#006600-br
iBringing First World Technology Closer to You./ibr
bhttp://www.1asialink.com/b/font/td
  /tr
/table

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: postgresql and freeradius accounting problem

2003-09-10 Thread boggss
/local/var/log/radius/radutmp
 radutmp: username = %{User-Name}
 radutmp: case_sensitive = yes
 radutmp: check_with_nas = yes
 radutmp: perm = 384
 radutmp: callerid = yes
Module: Instantiated radutmp (radutmp) 
Module: Loaded eap 
 eap: default_eap_type = md5
 eap: timer_expire = 60
 eap: ignore_unknown_eap_types = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
Module: Instantiated eap (eap) 
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on 1814/udp.
Ready to process requests.
rad_recv: Access-Request packet from host 10.10.80.23:2543, id=7, length=46
User-Name = boggss
User-Password = test
modcall: entering group authorize
  modcall[authorize]: module preprocess returns ok
  modcall[authorize]: module chap returns noop
radius_xlat:  'boggss'
rlm_sql (sql): sql_set_user escaped user -- 'boggss'
radius_xlat:  'SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE 
Username = 'boggss' ??ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radcheck 
??WHERE Username = 'boggss' ??ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows = 
radius_xlat:  'SELECT radgroupcheck.id, radgroupcheck.GroupName, 
??radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op ??FROM radgroupcheck, 
usergroup ??WHERE usergroup.Username = 'boggss' AND usergroup.GroupName = 
radgroupcheck.GroupName ??ORDER BY radgroupcheck.id'
rlm_sql_postgresql: query: SELECT radgroupcheck.id, radgroupcheck.GroupName, 
??radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op ??FROM radgroupcheck, 
usergroup ??WHERE usergroup.Username = 'boggss' AND usergroup.GroupName = 
radgroupcheck.GroupName ??ORDER BY radgroupcheck.id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows = 
radius_xlat:  'SELECT id, UserName, Attribute, Value, Op ??FROM radreply ??WHERE 
Username = 'boggss' ??ORDER BY id'
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radreply 
??WHERE Username = 'boggss' ??ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows = 
radius_xlat:  'SELECT radgroupreply.id, radgroupreply.GroupName, 
radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op ??FROM 
radgroupreply,usergroup ??WHERE usergroup.Username = 'boggss' AND usergroup.GroupName 
= radgroupreply.GroupName ??ORDER BY radgroupreply.id'
rlm_sql_postgresql: query: SELECT radgroupreply.id, radgroupreply.GroupName, 
radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op ??FROM 
radgroupreply,usergroup ??WHERE usergroup.Username = 'boggss' AND usergroup.GroupName 
= radgroupreply.GroupName ??ORDER BY radgroupreply.id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows = 
rlm_sql (sql): Released sql socket id: 4
  modcall[authorize]: module sql returns ok
  modcall[authorize]: module mschap returns noop
modcall: group authorize returns ok
  rad_check_password:  Found Auth-Type Local
auth: type Local
auth: user supplied User-Password matches local User-Password
Sending Access-Accept of id 7 to 10.10.80.23:2543
Framed-IP-Address := 10.10.70.10
Framed-Compression := Van-Jacobson-TCP-IP
Framed-Protocol := PPP
Service-Type := Framed-User
Framed-MTU := 1500
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 7 with timestamp 3f5f4d5c
Nothing to do.  Sleeping until we see a request.
rad_recv: Accounting-Request packet from host 10.10.80.23:2544, id=8, length=40
User-Name = boggss
Acct-Status-Type = Start
Acct-Session-Id = 2836
modcall: entering group preacct
  modcall[preacct]: module preprocess returns noop
modcall: group preacct returns noop
modcall: entering group accounting
rlm_acct_unique: WARNING: Attribute NAS-Port-Id was not found in request, unique ID 
MAY be inconsistent
rlm_acct_unique: Hashing ',Client-IP-Address = 10.10.80.23,NAS-IP-Address = 
10.10.80.23,Acct-Session-Id = 2836,User-Name = boggss'
rlm_acct_unique: Acct-Unique-Session-ID = 3879d6b9c94adcc6.
  modcall[accounting]: module acct_unique returns ok
radius_xla t:  '/usr/local/var/log/radius/radacct/10.10.80.23/detail-20030911'
rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d 
expands to /usr/local/var/log/radius/radacct/10.10.80.23/detail-20030911
  modcall[accounting]: module detail returns ok
  modcall[accounting]: module unix returns noop
radius_xlat:  'boggss'
rlm_sql (sql): sql_set_user escaped user -- 'boggss'
radius_xlat:  'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, 
NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic, 
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, 
CalledStationId

Re: postgresql and freeradius accounting problem

2003-09-10 Thread boggss
sorry but i really dont know what your trying to say...please do some
suggestions to what i should do...

do you have a howto for this?


 At 12:12 PM 9/10/2003,[EMAIL PROTECTED]:
here are attached files.
 
 Did you read the debug output, your error and the reason for it are
 explained:
 
 
 rlm_sql_postgresql: query: INSERT into radacct (AcctSessionId,
 AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
 AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,
 ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,
 CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol,
 FramedIPAddress, AcctStartDelay, AcctStopDelay) values('2836',
 '3879d6b9c94adcc6', 'boggss', '', '10.10.80.23', '', '', '2003-09-11
 00:12:19', '-1', '', '', '', '0', '0', '', '', '', '', '', '', '', '0')
 rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
 rlm_sql_postgresql: affected rows =
 rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
 SQL_DOWN
 rlm_sql (sql): failed after re-connect
 rlm_sql (sql): Couldn't update SQL accounting for START packet -
 ERROR:  pg_atoi: zero-length string
 
 
 You are 'faking' a start record with incomplete information.  Send it
 a real start packet, or one with more complete information.  IE, you
 need to include more information than just:
 
  User-Name = boggss
  Acct-Status-Type = Start
  Acct-Session-Id = 2836
 
 -Chris
 --
 \\\|||///  \  StarNet Inc.  \ Chris Parker
 \ ~   ~ /   \   WX *is* Wireless!    \   Director, Engineering
 | @  [EMAIL PROTECTED]|    \   http://www.starnetwx.net \  (847) 963-0116
 oOo---(_)---oOo--\--
    \ Wholesale Internet Services - http://www.megapop.net
 
 
 
 -
 List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html
 

brbr
table border=0 width=100% height=9
  tr
td width=100% height=9
font face=Arial 
color=#006600-br
iBringing First World Technology Closer to You./ibr
bhttp://www.1asialink.com/b/font/td
  /tr
/table

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html