RE: Simultaneous use of two DBs
Define 2 db instances. Use one for autentication and the other for accounting. Joao Frade -Original Message- From: Ali Gunduz [mailto:[EMAIL PROTECTED] Sent: quinta-feira, 17 de Julho de 2003 14:59 To: [EMAIL PROTECTED] Subject: RE: Simultaneous use of two DBs Well, I'm sure there are some migration utilities but I can't stop using DB2 (management's decision).. I can't use DB2 for start/stop packet logging (that's another issue that can't be solved) So I have to use DB2 for authentication purposes and I have to use postgresql (or any other lightweight DB) for logging purposes.. Any more suggestions? :) Thanks Ali > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Tim McCracken > Sent: Thursday, July 17, 2003 16:51 > To: [EMAIL PROTECTED] > Subject: RE: Simultaneous use of two DBs > > > > I don't know for sure about DB2 and Postgres but databases I > am familiar > with (Oracle, SqlServer, MySql) have the ability to export and import > tables via csv files. That would let you move the data. There are > also some commercial utilities to let you do it, and there are ODBC > drivers available for most databases as well. > > Depending on the referential integrity that is implemented and the > features of your particular database, the order that you import them > may be important. > > Tim > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf > Of Ali Gunduz > > Sent: Thursday, July 17, 2003 8:25 AM > > To: [EMAIL PROTECTED] > > Subject: Simultaneous use of two DBs > > > > > > Hi, > > > > I want to log start/stop packets in postgresql and use DB2 for > > authentication information. All my user information resides in DB2.. > > I cannot migrate it to postgresql. > > > > I couldn't figure out how I could do this in sql.conf.. > > > > Anyone has any suggestions or documents about this? > > > > Thanks > > > > Ali Gunduz > > > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Simultaneous use of two DBs
Well, I'm sure there are some migration utilities but I can't stop using DB2 (management's decision).. I can't use DB2 for start/stop packet logging (that's another issue that can't be solved) So I have to use DB2 for authentication purposes and I have to use postgresql (or any other lightweight DB) for logging purposes.. Any more suggestions? :) Thanks Ali > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Tim McCracken > Sent: Thursday, July 17, 2003 16:51 > To: [EMAIL PROTECTED] > Subject: RE: Simultaneous use of two DBs > > > > I don't know for sure about DB2 and Postgres but databases I > am familiar > with (Oracle, SqlServer, MySql) have the ability to export and import > tables via csv files. That would let you move the data. There are > also some commercial utilities to let you do it, and there are ODBC > drivers available for most databases as well. > > Depending on the referential integrity that is implemented and the > features of your particular database, the order that you import them > may be important. > > Tim > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf > Of Ali Gunduz > > Sent: Thursday, July 17, 2003 8:25 AM > > To: [EMAIL PROTECTED] > > Subject: Simultaneous use of two DBs > > > > > > Hi, > > > > I want to log start/stop packets in postgresql and use DB2 for > > authentication information. > > All my user information resides in DB2.. I cannot migrate it to > > postgresql. > > > > I couldn't figure out how I could do this in sql.conf.. > > > > Anyone has any suggestions or documents about this? > > > > Thanks > > > > Ali Gunduz > > > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Simultaneous use of two DBs
I don't know for sure about DB2 and Postgres but databases I am familiar with (Oracle, SqlServer, MySql) have the ability to export and import tables via csv files. That would let you move the data. There are also some commercial utilities to let you do it, and there are ODBC drivers available for most databases as well. Depending on the referential integrity that is implemented and the features of your particular database, the order that you import them may be important. Tim > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ali Gunduz > Sent: Thursday, July 17, 2003 8:25 AM > To: [EMAIL PROTECTED] > Subject: Simultaneous use of two DBs > > > Hi, > > I want to log start/stop packets in postgresql and use DB2 for > authentication information. > All my user information resides in DB2.. I cannot migrate it to > postgresql. > > I couldn't figure out how I could do this in sql.conf.. > > Anyone has any suggestions or documents about this? > > Thanks > > Ali Gunduz > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
