Re: (RADIATOR) mysql and I'm lazy.
Hi all, I had the same problem yesterday, try this one. cu, - Joost. Hugh Irvine wrote: Hello Chris and Jason - On Thu, 23 Mar 2000, Chris M wrote: Hello Jason - On Tue, 21 Mar 2000, Jason Godsey wrote: Hello again, I've discovered I'm quite lazy and am looking for a simple way to setup SQL tables for all the records I want out of the detail file. Are there any utils to parse a detail file and generate a proper sql dump to hold all the information contained in the detail file? Other wise, do I just look up the attribute I want in the detail file to see if it is text/int? Is there a simply way to tell how long the field is? There is a sample SQL creation script in goodies/mysqlCreate.sql. And really the simplest way to write the database is with Radiator and an AuthBy SQL. hth Hugh -- I think what he's asking for is whether there is a way to parse detail files, and poke them into a new database (import existing data to mySQL). The short answer is no, which is why I was suggesting starting with the existing mysqlCreate.sql to use as a basis for developing your own database schema. As to a utility, there is an example "warehouse" perl program that was contributed by one of our customers. This utility currently reads an SQL table and writes another, but perhaps you could use it as a place to start. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- Joost Stegeman Service Developer KPN OVN BBT/IP Integration Services tel. 070 - 371 37 83 fax. 070 - 371 26 38 E-mail: [EMAIL PROTECTED] acct2sql.pl
Re: (RADIATOR) mysql and I'm lazy.
Hello Joost - On Thu, 23 Mar 2000, Joost Stegeman wrote: Hi all, I had the same problem yesterday, try this one. What an excellent fellow you are! I've asked Mike to put this in the goodies directory for the next release. many thanks Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) mysql and I'm lazy.
By the way, this script is for Ascend NASses and the RAdmin tables, you'll probably have to adjust some harcoded things ;-) - Joost. Joost Stegeman wrote: Hi all, I had the same problem yesterday, try this one. cu, - Joost. Hugh Irvine wrote: Hello Chris and Jason - On Thu, 23 Mar 2000, Chris M wrote: Hello Jason - On Tue, 21 Mar 2000, Jason Godsey wrote: Hello again, I've discovered I'm quite lazy and am looking for a simple way to setup SQL tables for all the records I want out of the detail file. Are there any utils to parse a detail file and generate a proper sql dump to hold all the information contained in the detail file? Other wise, do I just look up the attribute I want in the detail file to see if it is text/int? Is there a simply way to tell how long the field is? There is a sample SQL creation script in goodies/mysqlCreate.sql. And really the simplest way to write the database is with Radiator and an AuthBy SQL. hth Hugh -- I think what he's asking for is whether there is a way to parse detail files, and poke them into a new database (import existing data to mySQL). The short answer is no, which is why I was suggesting starting with the existing mysqlCreate.sql to use as a basis for developing your own database schema. As to a utility, there is an example "warehouse" perl program that was contributed by one of our customers. This utility currently reads an SQL table and writes another, but perhaps you could use it as a place to start. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- Joost Stegeman Service Developer KPN OVN BBT/IP Integration Services tel. 070 - 371 37 83 fax. 070 - 371 26 38 E-mail: [EMAIL PROTECTED] Name: acct2sql.pl acct2sql.plType: Perl Program (application/x-perl) Encoding: 7bit -- Joost Stegeman Service Developer Integration Services KPN OVN BBT/IP Integration Services tel. 070 - 371 37 83 fax. 070 - 371 26 38 E-mail: [EMAIL PROTECTED] === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) mysql and I'm lazy.
Hello Jason - On Tue, 21 Mar 2000, Jason Godsey wrote: Hello again, I've discovered I'm quite lazy and am looking for a simple way to setup SQL tables for all the records I want out of the detail file. Are there any utils to parse a detail file and generate a proper sql dump to hold all the information contained in the detail file? Other wise, do I just look up the attribute I want in the detail file to see if it is text/int? Is there a simply way to tell how long the field is? There is a sample SQL creation script in goodies/mysqlCreate.sql. And really the simplest way to write the database is with Radiator and an AuthBy SQL. hth Hugh -- I think what he's asking for is whether there is a way to parse detail files, and poke them into a new database (import existing data to mySQL). Chris === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) mysql and I'm lazy.
Hello Chris and Jason - On Thu, 23 Mar 2000, Chris M wrote: Hello Jason - On Tue, 21 Mar 2000, Jason Godsey wrote: Hello again, I've discovered I'm quite lazy and am looking for a simple way to setup SQL tables for all the records I want out of the detail file. Are there any utils to parse a detail file and generate a proper sql dump to hold all the information contained in the detail file? Other wise, do I just look up the attribute I want in the detail file to see if it is text/int? Is there a simply way to tell how long the field is? There is a sample SQL creation script in goodies/mysqlCreate.sql. And really the simplest way to write the database is with Radiator and an AuthBy SQL. hth Hugh -- I think what he's asking for is whether there is a way to parse detail files, and poke them into a new database (import existing data to mySQL). The short answer is no, which is why I was suggesting starting with the existing mysqlCreate.sql to use as a basis for developing your own database schema. As to a utility, there is an example "warehouse" perl program that was contributed by one of our customers. This utility currently reads an SQL table and writes another, but perhaps you could use it as a place to start. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) mysql and I'm lazy.
I have read the goodies, however we would like to log EVERYTHING not just the limited entries in the example. one thing I'm having trouble with is I need to migrate our detail files from 1997+ into the database also. This gives me the problem of not knowing the int value of le-terminate-detail etc.. Thanks! On Tue, 21 Mar 2000, Hugh Irvine wrote: Date: Tue, 21 Mar 2000 14:44:22 +1100 From: Hugh Irvine [EMAIL PROTECTED] To: Jason Godsey [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: (RADIATOR) mysql and I'm lazy. Hello Jason - On Tue, 21 Mar 2000, Jason Godsey wrote: Hello again, I've discovered I'm quite lazy and am looking for a simple way to setup SQL tables for all the records I want out of the detail file. Are there any utils to parse a detail file and generate a proper sql dump to hold all the information contained in the detail file? Other wise, do I just look up the attribute I want in the detail file to see if it is text/int? Is there a simply way to tell how long the field is? There is a sample SQL creation script in goodies/mysqlCreate.sql. And really the simplest way to write the database is with Radiator and an AuthBy SQL. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) mysql and I'm lazy.
Hello Jason - On Tue, 21 Mar 2000, Jason Godsey wrote: Hello again, I've discovered I'm quite lazy and am looking for a simple way to setup SQL tables for all the records I want out of the detail file. Are there any utils to parse a detail file and generate a proper sql dump to hold all the information contained in the detail file? Other wise, do I just look up the attribute I want in the detail file to see if it is text/int? Is there a simply way to tell how long the field is? There is a sample SQL creation script in goodies/mysqlCreate.sql. And really the simplest way to write the database is with Radiator and an AuthBy SQL. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
