Re: oracle AND mysql module simultaniously
Robin Elfrink [EMAIL PROTECTED] wrote: sql: driver =3D rlm_sql_mysql rlm_sql: Driver rlm_sql_mysql loaded and linked rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/dbname Init: Oracle logon failed: 'Error while trying to retrieve text for ... Weird. It loads the MySQL driver, and then tries to connect via Oracle? That's *very* odd. The function used to open a connection to the database is closely related to the driver name (and is in the same data structure). So I don't see how that can happen, unless the dynamic linker is doing the wrong thing... Try grabbing the CVS snapshot from later tonight. I've updated a lot of the error messages in the SQL module to be more helpful. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
oracle AND mysql module simultaniously
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm trying to get the oracle and mysql module to work together simultaniously. Oracle for authentication, and mysql for accounting (do not ask me WHY, I cannot explain stupid upper-management decisions). When I have the oracle module loaded first, freeradius connects correctly to the oracle server and then tries to connect to the mysql server using the oracle module. When I have the mysql module loaded first, freeradius connects correctly to the mysql server and then tries to connect to the oracle server using the mysql module. Is this normal behaviour, or a bug, or a fault in my setup? - -- Have a nice day! -- Robin Elfrink [EMAIL PROTECTED] A3 Enschede B.V. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE9xqdjPgqgTHwUiEARAlO0AJwLd/RGAMtGZy0ewUzMDdNlp2jefwCgjjms w8dI54SOJNtcW9pYDp/vyyg= =Pfh+ -END PGP SIGNATURE- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: oracle AND mysql module simultaniously
Robin Elfrink [EMAIL PROTECTED] wrote: When I have the oracle module loaded first, freeradius connects correctly to the oracle server and then tries to connect to the mysql server using the oracle module. Do you have TWO instances of the SQL module set up? What does your configuration look like? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: oracle AND mysql module simultaniously
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 04 November 2002 18:03, Alan DeKok wrote:
Do you have TWO instances of the SQL module set up? What does your
configuration look like?
radiusd.conf has:
authenticate {
unix
oracle
}
accounting {
detail
unix
mysql
radutmp
}
sql.conf has:
sql mysql {
driver = rlm_sql_mysql
other configuration data
}
sql oracle {
driver = rlm_sql_oracle
other configuration data
}
- -- Have a nice day! --
Robin Elfrink [EMAIL PROTECTED]
A3 Enschede B.V.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE9xrYsPgqgTHwUiEARAlDOAKCHC19/76XkbaCjK4lIJ+DII6XujQCgkJgf
QUvdvy0QUo66W6FWh7DKv7M=
=oS1E
-END PGP SIGNATURE-
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: oracle AND mysql module simultaniously
Robin Elfrink [EMAIL PROTECTED] wrote:
sql.conf has:
sql mysql {
driver =3D rlm_sql_mysql
other configuration data
}
sql oracle {
driver =3D rlm_sql_oracle
other configuration data
}
That should be fine. So how does one SQL instance use another? Can
you post a sample of the debug messages, which shows the problem?
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: oracle AND mysql module simultaniously
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 04 November 2002 20:14, Alan DeKok wrote: That should be fine. So how does one SQL instance use another? Can you post a sample of the debug messages, which shows the problem? Sure: [ bla bla bla ] Module: Loaded SQL sql: driver = rlm_sql_oracle [ bla bla bla ] rlm_sql: Driver rlm_sql_oracle loaded and linked rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/instance rlm_sql: Connected new DB handle, #0 rlm_sql: Connected new DB handle, #1 rlm_sql: Connected new DB handle, #2 rlm_sql: Connected new DB handle, #3 rlm_sql: Connected new DB handle, #4 Module: Instantiated sql (oracle) Module: Loaded preprocess [ bla bla bla ] Module: Instantiated detail (detail) sql: driver = rlm_sql_mysql rlm_sql: Driver rlm_sql_mysql loaded and linked rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/dbname Init: Oracle logon failed: 'Error while trying to retrieve text for error ORA-12154 ' rlm_sql: Failed to connect DB handle #0 Module: Instantiated sql (mysql) Module: Loaded radutmp [ bla bla bla ] (names and addresses changed, of course) - -- Have a nice day! -- Robin Elfrink [EMAIL PROTECTED] A3 Enschede B.V. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE9xuvvPgqgTHwUiEARAmbpAKCogwa6OumPbORwFCDWjADwqXggbwCfX7BH dMQpxOi6BCtaf4tyFsWGj2g= =vC4I -END PGP SIGNATURE- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
