[RADIATOR] ODBC Connection Error

[Hugh Irvine]

Hello -

I am guessing there is something in your terminal session environment that is not available to your script.

regards

Hugh


> On 15 Mar 2015, at 19:38, Mohammed Alhaj Ali <m.alhaj at itc.sa> wrote:
> 
> Hi Hugh,
> 
> 
> Issue fixed!!
> Actually I ran the below command, there was no error, before that when I use radiator startup script then then I get the error, but when run radiusd it's working fine, I don't know what the problem with startup command on the startup script?!
> 
> I add option I for the startup script:
> 
> [ -z "${RADIUSD_ARGS}" ] && RADIUSD_ARGS="-I -pid_file $RADIUSD_PIDFILE -config_file $RADIATOR_CONFIG -daemon $RADIATOR_ARGS".
> 
> Any  idea ?!
> 
> 
> Thank you,
> Regards,
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au] 
> Sent: Friday, March 13, 2015 1:27 AM
> To: Mohammed Alhaj Ali
> Cc: radiator at open.com.au
> Subject: Re: [RADIATOR] ODBC Connection Error
> 
> 
> Hello again -
> 
> If you run “radiusd” from the command line you will see any Perl error messages:
> 
> 	cd /your/Radiator/distribution/directory
> 
> 	perl radiusd -foreground -log_stdout -trace 4 -config_file …..
> 
> regards
> 
> Hugh
> 
> 
>> On 12 Mar 2015, at 20:18, Mohammed Alhaj Ali <m.alhaj at itc.sa> wrote:
>> 
>> Hi Hugh, but this lib file actually is there, and when I try to connect with other DBD ie. Oracle it also failed, how can I check if there any wrong with perl and  perl modules..
>> 
>> Thank you!
>> 
>> 
>> 
>> -----Original Message-----
>> From: Hugh Irvine [mailto:hugh at open.com.au]
>> Sent: Thursday, March 12, 2015 11:17 AM
>> To: Mohammed Alhaj Ali
>> Cc: radiator at open.com.au
>> Subject: Re: [RADIATOR] ODBC Connection Error
>> 
>> 
>> Hello -
>> 
>> As the error message says, this shared library is not found:  '/usr/lib/libsqora.so.11.1’ 
>> 
>> A quick Google search on "Can't open lib '/usr/lib/libsqora.so.11.1’” brings up lots of useful hits.
>> 
>> regards
>> 
>> Hugh
>> 
>> 
>>> On 12 Mar 2015, at 18:46, Mohammed Alhaj Ali <m.alhaj at itc.sa> wrote:
>>> 
>>> Hi
>>> Need help; I'm getting this error log when try to connect to remote DB:
>>> 
>>> ERR: Could not connect to SQL database with DBI->connect 
>>> dbi:ODBC:DSLDB, zoouser, zoopass2009: [unixODBC][Driver Manager]Can't 
>>> open lib '/usr/lib/libsqora.so.11.1' : file not found (SQL-01000
>>> 
>>> However odbc connection seems to be fine, please check below:
>>> 
>>> 
>>> [root at radiator03 ~]# isql -v DSLDB
>>> +---------------------------------------+
>>> | Connected!                            |
>>> |                                       |
>>> | sql-statement                         |
>>> | help [tablename]                      |
>>> | quit                                  |
>>> |                                       |
>>> +---------------------------------------+
>>> SQL>
>>> 
>>> 
>>> Lookup forward to your help..
>>> 
>>> Thank you!
>>> Regards.
>>> 
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> radiator mailing list
>>> radiator at open.com.au
>>> http://www.open.com.au/mailman/listinfo/radiator
>> 
>> 
>> --
>> 
>> Hugh Irvine
>> hugh at open.com.au
>> 
>> Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER, SIM, etc. 
>> Full source on Unix, Linux, Windows, MacOSX, Solaris, VMS, NetWare etc.
>> 
> 
> 
> --
> 
> Hugh Irvine
> hugh at open.com.au
> 
> Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER, SIM, etc. 
> Full source on Unix, Linux, Windows, MacOSX, Solaris, VMS, NetWare etc.
> 


--

Hugh Irvine
hugh at open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER, SIM, etc. 
Full source on Unix, Linux, Windows, MacOSX, Solaris, VMS, NetWare etc.