Compiled and installing freeradius 1.0.5 and freenibs-3.0.0-a4 without errors, but when running radiusd -A -xx have : SAL: Could not link symbol libsal_mysql: /usr/local/lib/libsal_mysql-1.0.0.so: undefined symbol: libsal_mysql
radiusd.conf[13]: nibs: Module instantiation failed.
What is the problem ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
rlm_nibs (nibs_fill_user): end for user `testuser' ------------
rlm_nibs (nibs_filter): begin for user 'testuser' ------------
rlm_nibs (nibs_filter): Total money limit filter for user 'testuser'
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `testuser' login failed%s%s%s [192.168.200.1:0]'
Segmentation fault
Radius server is down.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks.
Version alpha-6 working, but my pppoe conexion is disconected in 5 seconds.
pppd.log report :
rcvd [LCP TermAck id=0x4 "Traffic limit"]
Connection terminated.
Connect time 0.1 minutes.
and actions table terminate_cause is "User-Request". Why ?
PS
missing field definition "connect_info" from actions table.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
use freenibs-3.0.0-a6.tar.gz
and freeradius-1.1.0.tar.gz.
problems:
1. SAL - use -"Put path, where you installed rlm_*.so and libsal.so in /etc/ld.so.conf and restart system, if path not the same, as /usr/lib.
" - ok.
2. radiusd -X
[........]
nibs: allowed_service = "Framed-User"
nibs: bytes_per_megabyte = 1048576
nibs: round_to_minute = no
Bad value "1" for boolean variable set_max_octet_limit
radiusd.conf[13]: nibs: Module instantiation failed.
radiusd.conf[1582] Unknown module "nibs".
radiusd.conf[1562] Failed to parse authorize section.
need help:)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I need to save into table pppd reason for user is disconected:
/var/log/pppd.log
"Connect time expired" - is reason but in Actions table terminate_cause is "User-Request".
sent [LCP TermReq id=0x4 "Connect time expired"]
rcvd [LCP TermAck id=0x4 "Connect time expired"]
Connection terminated.
Connect time 13.4 minutes.
Sent 516 bytes, received 1090 bytes."
How ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello.
1. Freenibs 3.0.0-a8 is release but find one problem : userkill not working. :(
User must killed, /usr/local/sbin/userkill ise executed but user is not disconnected.
2. How save into mysql database authenticate user error.
Sample :
rlm_nibs (nibs_filter): Expire filter for user 'test3'
rlm_nibs (nibs_filter): Total time limit filter for user 'test3'
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]'
rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]. Called from <Unknow>
rlm_nibs (rlm_nibs_authenticate): Error=total limit of time is reached
modcall[post-auth]: module "nibs" returns reject for request 23
modcall: leaving group post-auth (returns reject) for request 23
I need to save "Error=total limit of time is reached" into mysql table (auth_errors).
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello.
I find a little problem :
rlm_nibs (nibs_filter): Expire filter for user 'test3'
rlm_nibs (nibs_filter): Total time limit filter for user 'test3'
radius_xlat: 'INSERT INTO invalid_attempts (who, reason, call_from) VALUES ('test3', '%s', '%s')'
sal_get_socket: Reserving sql socket id: 0
sal_mysql: query: total limit of time is reached
sal_mysql: MYSQL check_error: 1064 received
nibs_log_invalid_attempts: database query error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'total limit of time is reached' at line 1
sal_release_socket: Released sql socket id: 0
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]'
rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]. Called from <Unknow>
rlm_nibs (rlm_nibs_authenticate): Error=total limit of time is reached
.
Cannot save into invalid_attempts and passed values is incomplete.
:(
Thanks for help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Not working. :(
Cannot save into invalid_attempts;
Replace '%s' with '' (empty string) but not save. Error persist.
rlm_nibs (nibs_filter): Total time limit filter for user 'test3'
radius_xlat: 'INSERT INTO invalid_attempts (who, reason, call_from) VALUES ('test3', '', '')'
sal_get_socket: Reserving sql socket id: 0
sal_mysql: query: total limit of time is reached
sal_mysql: MYSQL check_error: 1064 received
nibs_log_invalid_attempts: database query error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'total limit of time is reached' at line 1
sal_release_socket: Released sql socket id: 0
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]'
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dear Stas Korsakov. I also have the same problem as alladin in first Posting:
"Compiled and installing freeradius 1.0.5 and freenibs-3.0.0-a4 without errors, but when running radiusd -A -xx have : SAL: Could not link symbol libsal_mysql: /usr/local/lib/libsal_mysql-1.0.0.so: undefined symbol: libsal_mysql
radiusd.conf[13]: nibs: Module instantiation failed.
What is the problem ?"
But i'm using freeradius 1.0.5 and freenibs-3.0.0-b1, and i have put path, where i installed rlm_*.so and libsal.so in /etc/ld.so.conf, but it still not working. Libs installed to the /usr/local/lib but there is not present libsal.so.
What is the problem?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Compiled and installing freeradius 1.0.5 and freenibs-3.0.0-a4 without errors, but when running radiusd -A -xx have : SAL: Could not link symbol libsal_mysql: /usr/local/lib/libsal_mysql-1.0.0.so: undefined symbol: libsal_mysql
radiusd.conf[13]: nibs: Module instantiation failed.
What is the problem ?
Thank you.
This bug fixed. Try freenibs-3.0.0-a5.
Put path, where you installed rlm_*.so and libsal.so in /etc/ld.so.conf and restart system, if path not the same, as /usr/lib.
Thanks.
Is working , but ..
rlm_nibs (nibs_fill_user): end for user `testuser' ------------
rlm_nibs (nibs_filter): begin for user 'testuser' ------------
rlm_nibs (nibs_filter): Total money limit filter for user 'testuser'
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `testuser' login failed%s%s%s [192.168.200.1:0]'
Segmentation fault
Radius server is down.
I fix this error in aplha-6. Please, email me in this case.
Thanks.
Version alpha-6 working, but my pppoe conexion is disconected in 5 seconds.
pppd.log report :
rcvd [LCP TermAck id=0x4 "Traffic limit"]
Connection terminated.
Connect time 0.1 minutes.
and actions table terminate_cause is "User-Request". Why ?
PS
missing field definition "connect_info" from actions table.
Please, set in NIBS.CONF
set_max_octet_limit='no' and restart radius.
If error exist - paste radiusd -X and pppd log
Thank you
Yes, it's ok.
I need if is possible tables fields descriptions on english.
I want testing freenibs with more users.
Thanks.
Hello.
PLease respond.
If user is forced disconected :
Thu Jan 26 17:36:06 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:09 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:12 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:15 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:18 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:21 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:24 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:27 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:30 2006 : Error: Discarding duplicate request from client localhost:1032 - ID: 249 due to unfinished request 3
Thu Jan 26 17:36:35 2006 : Error: WARNING: Unresponsive child (id 65541) for request 3
and trying conect another user radius server not responding.
Hi.
Can you paste radiusd -X and sqltrace.log file up to error here or email me (sta@net76.ru)?
(sqltrace='yes' in NIBS.CONF)
Thanks
use freenibs-3.0.0-a6.tar.gz
and freeradius-1.1.0.tar.gz.
problems:
1. SAL - use -"Put path, where you installed rlm_*.so and libsal.so in /etc/ld.so.conf and restart system, if path not the same, as /usr/lib.
" - ok.
2. radiusd -X
[........]
nibs: allowed_service = "Framed-User"
nibs: bytes_per_megabyte = 1048576
nibs: round_to_minute = no
Bad value "1" for boolean variable set_max_octet_limit
radiusd.conf[13]: nibs: Module instantiation failed.
radiusd.conf[1582] Unknown module "nibs".
radiusd.conf[1562] Failed to parse authorize section.
need help:)
Set variable set_max_octet_limit to 'no' in NIBS.CONF.
It's fixed. Try freenibs-3.0.0-a7
Yep, freenibs-3.0.0-a7 is working fine. :)
I need to save into table pppd reason for user is disconected:
/var/log/pppd.log
"Connect time expired" - is reason but in Actions table terminate_cause is "User-Request".
sent [LCP TermReq id=0x4 "Connect time expired"]
rcvd [LCP TermAck id=0x4 "Connect time expired"]
Connection terminated.
Connect time 13.4 minutes.
Sent 516 bytes, received 1090 bytes."
How ?
Hello.
1. Freenibs 3.0.0-a8 is release but find one problem : userkill not working. :(
User must killed, /usr/local/sbin/userkill ise executed but user is not disconnected.
2. How save into mysql database authenticate user error.
Sample :
rlm_nibs (nibs_filter): Expire filter for user 'test3'
rlm_nibs (nibs_filter): Total time limit filter for user 'test3'
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]'
rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]. Called from <Unknow>
rlm_nibs (rlm_nibs_authenticate): Error=total limit of time is reached
modcall[post-auth]: module "nibs" returns reject for request 23
modcall: leaving group post-auth (returns reject) for request 23
I need to save "Error=total limit of time is reached" into mysql table (auth_errors).
Thanks!
Hello.
I find a little problem :
rlm_nibs (nibs_filter): Expire filter for user 'test3'
rlm_nibs (nibs_filter): Total time limit filter for user 'test3'
radius_xlat: 'INSERT INTO invalid_attempts (who, reason, call_from) VALUES ('test3', '%s', '%s')'
sal_get_socket: Reserving sql socket id: 0
sal_mysql: query: total limit of time is reached
sal_mysql: MYSQL check_error: 1064 received
nibs_log_invalid_attempts: database query error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'total limit of time is reached' at line 1
sal_release_socket: Released sql socket id: 0
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]'
rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]. Called from <Unknow>
rlm_nibs (rlm_nibs_authenticate): Error=total limit of time is reached
.
Cannot save into invalid_attempts and passed values is incomplete.
:(
Thanks for help.
Please, edit in NIBS.CONF
Replace INSERT INTO ${info_table} (who, reason, call_from) VALUES ('%{SQL-User-Name}', '%%s', '%%s')
on
INSERT INTO ${info_table} (who, reason, call_from) VALUES ('%{SQL-User-Name}', '%s', '%s')
I refresh FreeNIBS-3.0.0-a9 today
Not working. :(
Cannot save into invalid_attempts;
Replace '%s' with '' (empty string) but not save. Error persist.
rlm_nibs (nibs_filter): Total time limit filter for user 'test3'
radius_xlat: 'INSERT INTO invalid_attempts (who, reason, call_from) VALUES ('test3', '', '')'
sal_get_socket: Reserving sql socket id: 0
sal_mysql: query: total limit of time is reached
sal_mysql: MYSQL check_error: 1064 received
nibs_log_invalid_attempts: database query error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'total limit of time is reached' at line 1
sal_release_socket: Released sql socket id: 0
radius_xlat: 'rlm_nibs (rlm_nibs_authenticate): User `test3' login failed [192.168.200.1:0]'
I'm stupid ..... (
I find error and corrected it. I refreshed distributive.
Sorry....
Question: Accounting on alive-packets is worked?
Yep, working accounting_on_alive and invalid_attempts.
Radius log :
Thread 1 handling request 5, (2 handled so far)
Acct-Session-Id = "43FCD1C950BE"
User-Name = "test2"
Acct-Status-Type = Interim-Update
Service-Type = Framed-User
Framed-Protocol = PPP
Acct-Authentic = RADIUS
Acct-Session-Time = 186
Acct-Output-Octets = 4120
Acct-Input-Octets = 3686
Acct-Output-Packets = 49
Acct-Input-Packets = 51
NAS-Port-Type = Async
Framed-IP-Address = 192.168.204.4
NAS-IP-Address = 192.168.200.1
NAS-Port = 0
Acct-Delay-Time = 0
Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 5
modcall[preacct]: module "preprocess" returns noop for request 5
rlm_acct_unique: Hashing 'NAS-Port = 0,Client-IP-Address = 127.0.0.1,NAS-IP-Address = 192.168.200.1,Acct-Session-Id = "43FCD1C950BE",User-Name = "test2"'
rlm_acct_unique: Acct-Unique-Session-ID = "febb67acf50c1949".
modcall[preacct]: module "acct_unique" returns ok for request 5
modcall: leaving group preacct (returns ok) for request 5
Processing the accounting section of radiusd.conf
modcall: entering group accounting for request 5
modcall[accounting]: module "acct_unique" returns noop for request 5
radius_xlat: '/usr/local/var/log/radius/radacct/127.0.0.1/detail'
rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail expands to /usr/local/var/log/radius/radacct/127.0.0.1/detail
modcall[accounting]: module "detail" returns ok for request 5
radius_xlat: '/usr/local/var/log/radius/radutmp'
radius_xlat: 'test2'
modcall[accounting]: module "radutmp" returns ok for request 5
radius_xlat: 'test2'
rlm_nibs (sql_set_user): sql_set_user escaped user --> 'test2'
rlm_nibs (nibs_fill_user): begin for user `test2' ------------
radius_xlat: 'SELECT user, password, auth_type, uid, gid, deposit, credit, unix_timestamp(add_date), blocked, activated, unix_timestamp(expired), total_time, total_traffic, total_money, unix_timestamp(last_connection), framed_ip, framed_mask, callback_number, tos, do_with_tos, direction, fixed, fixed_cost, activation_time, total_time_limit, month_time_limit, week_time_limit, day_time_limit, total_traffic_limit, month_traffic_limit, week_traffic_limit, day_traffic_limit, total_money_limit, month_money_limit, week_money_limit, day_money_limit, login_time, huntgroup_name, simultaneous_use, port_limit, session_timeout, idle_timeout, shape, no_pass, no_acct, allow_callback, other_params, allowed_servers, auth_info FROM users WHERE user = 'test2''
sal_get_socket: Reserving sql socket id: 35
sal_release_socket: Released sql socket id: 35
rlm_nibs (nibs_fill_user): end for user `test2' ------------
radius_xlat: 'SELECT time_on, in_bytes, out_bytes, unix_timestamp(start_time), billing_minus, hour_in_bytes, hour_out_bytes, hour_traffic_money, last_change FROM actions WHERE id = '43FCD1C950BE' AND unique_id = 'febb67acf50c1949' AND server = INET_ATON('192.168.200.1') AND port = 0 AND user = 'test2' AND terminate_cause='Online''
sal_get_socket: Reserving sql socket id: 34
sal_release_socket: Released sql socket id: 34
rlm_nibs (nibs_billing): ---== Starting NIBS Billing ==---
radius_xlat: 'SELECT to_days('2006-02-22 23:07:13'), to_days(last_connection) FROM users WHERE user = 'test2''
sal_get_socket: Reserving sql socket id: 33
sal_release_socket: Released sql socket id: 33
rlm_nibs (nibs_billing): Money after fixed billing ` 0.000000'
rlm_nibs (nibs_billing): Money after tos billing `0.000000'
rlm_nibs (nibs_billing): sub_total_time `0'
rlm_nibs (nibs_billing): sub_total_traffic `0'
rlm_nibs (nibs_billing): sub_total_money ` 0.000000'
rlm_nibs (nibs_billing): ---== NIBS Billing DONE! ==---
radius_xlat: 'UPDATE users SET deposit = deposit - %16.6f, total_traffic = total_traffic + %ld, total_time = total_time + %ld, total_money = total_money + %16.6f, last_connection = from_unixtime(1140642433) WHERE uid = '%lu''
sal_get_socket: Reserving sql socket id: 32
sal_release_socket: Released sql socket id: 32
radius_xlat: 'UPDATE actions SET time_on = if(186,186,time_on), in_bytes = if(3686,3686,in_bytes), out_bytes = if(4120,4120,out_bytes), last_change = 1140642433, billing_minus = billing_minus + %16.6f, ip = INET_ATON('192.168.204.4'), hour_in_bytes = %lu, hour_out_bytes = %lu, hour_traffic_money = %16.6f WHERE id='43FCD1C950BE' AND unique_id = 'febb67acf50c1949' AND server = INET_ATON('192.168.200.1') AND port = 0 AND uid = '%lu' AND terminate_cause = 'Online''
sal_get_socket: Reserving sql socket id: 31
sal_release_socket: Released sql socket id: 31
rlm_nibs (nibs_filter): begin for user 'test2' ------------
rlm_nibs (nibs_filter): Money filter for user 'test2'
rlm_nibs (nibs_filter): Expire filter for user 'test2'
rlm_nibs (nibs_find_in_blacklist): Blacklist filter for user 'test2'
rlm_nibs (nibs_find_in_blacklist): No telephone number for user 'test2'
rlm_nibs (nibs_filter): end for user 'test2' ------------
modcall[accounting]: module "nibs" returns ok for request 5
modcall: leaving group accounting (returns ok) for request 5
Sending Accounting-Response of id 93 to 127.0.0.1 port 1040
Finished request 5
Going to the next request
Thread 1 waiting to be assigned a request
--- Walking the entire request list ---
Cleaning up request 5 ID 93 with timestamp 43fcd281
Nothing to do. Sleeping until we see a request.
Dear Stas Korsakov. I also have the same problem as alladin in first Posting:
"Compiled and installing freeradius 1.0.5 and freenibs-3.0.0-a4 without errors, but when running radiusd -A -xx have : SAL: Could not link symbol libsal_mysql: /usr/local/lib/libsal_mysql-1.0.0.so: undefined symbol: libsal_mysql
radiusd.conf[13]: nibs: Module instantiation failed.
What is the problem ?"
But i'm using freeradius 1.0.5 and freenibs-3.0.0-b1, and i have put path, where i installed rlm_*.so and libsal.so in /etc/ld.so.conf, but it still not working. Libs installed to the /usr/local/lib but there is not present libsal.so.
What is the problem?