Re: postgresql and freeradius accounting problem
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
>
-
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 and freeradius accounting problem
At 12:12 PM 9/10/2003, [EMAIL PROTECTED] wrote:
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
| @ @ |\ 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
Re: postgresql and freeradius accounting problem
here are attached files.
> At 10:38 AM 9/10/2003,[EMAIL PROTECTED]:
>>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.
>
> What does the debug output say? ( running the server 'radiusd -x -x' )
>
> -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
>
-
Bringing First World Technology Closer to You.
http://www.1asialink.com
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /usr/local/etc/raddb/proxy.conf
Config: including file: /usr/local/etc/raddb/clients.conf
Config: including file: /usr/local/etc/raddb/snmp.conf
Config: including file: /usr/local/etc/raddb/sql.conf
main: prefix = "/usr/local"
main: localstatedir = "/usr/local/var"
main: logdir = "/usr/local/var/log/radius"
main: libdir = "/usr/local/lib"
main: radacctdir = "/usr/local/var/log/radius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_file = "/usr/local/var/log/radius/radius.log"
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid"
main: user = "radius"
main: group = "radius"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: checkrad = "/usr/local/sbin/checkrad"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: post_proxy_authorize = yes
proxy: wake_all_if_all_dead = no
security: max_attributes = 200
security: reject_delay = 1
security: status_server = no
main: debug_level = 0
read_config_files: reading dictionary
read_config_files: reading naslist
Using deprecated naslist file. Support for this will go away soon.
read_config_files: reading clients
Using deprecated clients file. Support for this will go away soon.
read_config_files: reading realms
Using deprecated realms file. Support for this will go away soon.
radiusd: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
pap: encryption_scheme = "crypt"
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
Module: Instantiated mschap (mschap)
Module: Loaded preprocess
preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"
preprocess: hints = "/usr/local/etc/raddb/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded SQL
sql: driver = "rlm_sql_postgresql"
sql: server = "localhost"
sql: port = ""
sql: login = "radius"
sql: password = "radius2k3"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT id, UserName, Attribute, Value, Op ??FROM
radcheck ??WHERE Username = '%{SQL-User-Name}' ??ORDER BY id"
sql: authorize_reply_query = "SELECT id, UserName, Attribute, Value, Op ??FROM
radreply ??WHERE Username = '%{SQL-User-Name}' ??ORDER BY id"
sql: authorize_group_check_query = "SELECT radgroupcheck.id, radgroupcheck.GroupName,
??radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op ??FROM radgroupcheck,
usergroup ??WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName =
radgroupcheck.GroupName ??ORDER BY radgroupcheck.id"
sql: a
Re: postgresql and freeradius accounting problem
At 10:38 AM 9/10/2003, [EMAIL PROTECTED] wrote: 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. What does the debug output say? ( running the server 'radiusd -x -x' ) -Chris -- \\\|||/// \ StarNet Inc. \ Chris Parker \ ~ ~ / \ WX *is* Wireless!\ Director, Engineering | @ @ |\ 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
Re: postgresql and freeradius accounting problem
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 > - 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 and freeradius accounting problem
At 09:43 AM 9/10/2003, [EMAIL PROTECTED] wrote: 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 | @ @ |\ 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
postgresql and freeradius accounting problem
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 - Bringing First World Technology Closer to You. http://www.1asialink.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRADIUS accounting problem
On Tue, 30 Apr 2002 14:14:03 -0700, Joseph Liu wrote:
I had this problem with freeradius also... But with a portmaster3. I solved it
using mysql accounting and changing the table so that unique_id is really unique...
>Please help. This may have already been solved. If someone knows where I can
>find the answer in the mailing list, please let me know.
>
>I encounter a small problem with FreeRADIUS 0.5 release. The test
>environment is between a Cisco IOS 12.2 router and a RedHat 7.2 Linux
>FreeRADIUS server. FreeRADIUS was compiled on the RH Linux machine using the
>enclosed freeradius.spec by way of RPM.
>
>If I use the normal command line to start the radius server as in "radiusd"
>or "radiusd -y", the accounting information will be sent from Cisco router
>and recorded 3 times in the /var/log/radius/radacct/{NAS IP address}. It
>seems that the accounting information sent by the router did not get a reply
>from the radius server, so the router retries again and again.
>
>However, if I run the radius server in the debug mode such as "radiusd -xy"
>or "radius -xxy", the radius server indeed sends a reply to the router's
>accounting information. The accounting information gets to be registered
>only once.
>
>The above is true whether I run the radiusd in foreground or background
>daemon mode.
>
>I think I am missing something. Please enlighten me. Thanks,
>
>Joseph Liu
>JPL
>Pasadena, CA
>
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>
As opiniões formuladas neste e-mail são de caráter
exclusivamente pessoal. Minha opinião não necessariamente
representa a opinião do meu Moto Grupo nem da empresa onde
trabalho.
Mene Sakkhet ur-seveh
Alexandre Ganso - Diretor Steel Goose Moto Group
500 Four Vermelha
[EMAIL PROTECTED]
ICQ# 3778773
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRADIUS accounting problem
Please help. This may have already been solved. If someone knows where I can
find the answer in the mailing list, please let me know.
I encounter a small problem with FreeRADIUS 0.5 release. The test
environment is between a Cisco IOS 12.2 router and a RedHat 7.2 Linux
FreeRADIUS server. FreeRADIUS was compiled on the RH Linux machine using the
enclosed freeradius.spec by way of RPM.
If I use the normal command line to start the radius server as in "radiusd"
or "radiusd -y", the accounting information will be sent from Cisco router
and recorded 3 times in the /var/log/radius/radacct/{NAS IP address}. It
seems that the accounting information sent by the router did not get a reply
from the radius server, so the router retries again and again.
However, if I run the radius server in the debug mode such as "radiusd -xy"
or "radius -xxy", the radius server indeed sends a reply to the router's
accounting information. The accounting information gets to be registered
only once.
The above is true whether I run the radiusd in foreground or background
daemon mode.
I think I am missing something. Please enlighten me. Thanks,
Joseph Liu
JPL
Pasadena, CA
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
