Again: Major impact on authentication!

[Guilherme Franco]

Hello,

Of course, I can test sqlippool with Oracle. I just need to do it after
midnight because the earlier problems with Freeradius were so dramatic
that I've received orders to remove freeradius and install some commercial
software. Also, those tests would need to be synthetic ones, since the
default allocate-find does not get nor fix the static IP's for me and the
current users would lose their static IPs.

With the cron.hourly job to do a "service radiusd restart", the environment
flows smooth. Removing the job and letting radiusd working for a few hours
creeps everything. Considering this, how come those problems could be
related to slow DB, if by simply reloading freeradius things start to work
good?

Now, even with the cron.hourly job, radiusd hanged sometimes, needing a kill
-9 to free it.

Some valgrind messages related to the oracle backend in radiusd
initialization:

==11562== Conditional jump or move depends on uninitialised value(s)
==11562==    at 0x615F6B2: ztvo5ke (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5EEC3DC: kpu8lgn (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5EEA628: kpuauthxa (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5EEA031: kpuauth (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5E179A0: kpulon (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5F45A3F: OCILogon (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5A6B131: sql_init_socket (sql_oracle.c:158)
==11562==    by 0x59667B1: connect_single_socket (sql.c:70)
==11562==    by 0x5966907: sql_init_socketpool (sql.c:131)
==11562==    by 0x5964EC5: rlm_sql_instantiate (rlm_sql.c:695)
==11562==    by 0x40C31A: find_module_instance (in /usr/local/sbin/radiusd)
==11562==    by 0x40DA4C: (within /usr/local/sbin/radiusd)
==11562== Syscall param write(buf) points to uninitialised byte(s)
==11562==    at 0x397270B012: __write_nocancel (in /lib64/tls/libpthread-
2.3.4.so)
==11562==    by 0x61FF1A9: snttwrite (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x61FBEBE: nttwr (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x6132971: nsntwrn (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x6138B41: nspsend (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x611A93C: nsdofls (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x611600E: nsdo (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x611543A: nsdosend (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x6151207: nioqrc (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x62BEB4E: ttcdrv (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x6159AD7: nioqwa (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5F80BA6: upirtrc (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==  Address 0x4F0AFE7 is 47 bytes inside a block of size 2,070
alloc'd
==11562==    at 0x490631D: calloc (vg_replace_malloc.c:279)
==11562==    by 0x61C52C1: nsbGet (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x61C50F8: nsballoc (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x615566C: niotns (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x61D63AA: nigcall (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x615A399: osncon (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5E168EF: kpuadef (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5F814E7: upiini (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5F5E619: upiah0 (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5E162EF: kpuatch (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5E17873: kpulon (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5F45A3F: OCILogon (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562== Use of uninitialised value of size 8
==11562==    at 0x61F5CFA: ztceaencbk (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x61F0193: ztcebn (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x61EE024: ztcen (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x61EDE14: ztceenc (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x615F72E: ztvo5ke (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5EEC3DC: kpu8lgn (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5EEA628: kpuauthxa (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5EEA031: kpuauth (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5E179A0: kpulon (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5F45A3F: OCILogon (in
/usr/local/instantclient_10_2/libclntsh.so.10.1)
==11562==    by 0x5A6B131: sql_init_socket (sql_oracle.c:158)
==11562==    by 0x59667B1: connect_single_socket (sql.c:70)

Thank you!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070207/da0a12cd/attachment.html>