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
-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
-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