Sam,
In your Radiator directory there is a directory called 'goodies', in there you will find a file called 'ansiCreate.sql'. If you run that in you Oracle database it will create the default tables for Radiator. Read it carefully first so you understand what it does. Also download the manual: http://www.open.com.au/radiator/ref.html Its very well written and will answer most of your questions - as a user I have found it very useful :-) Good luck! Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hugh Irvine Sent: Thursday, November 29, 2001 8:26 AM To: Sam Cheung; [EMAIL PROTECTED] Subject: (RADIATOR) Re: (RADMIN) Re: Please help. Hello Sam - Please only post to the Radiator mailing list, we do not need to see your messages in mailing lists not intended for Radiator. It looks to me like you have not built the Oracle tables. You cannot write to a database without actually building the tables that you are going to use. Note that the table names are different for Radiator and Radmin. Radiator uses a table called SUBSCRIBERS for user definitions and Radmin uses a table called RADUSERS. There are other similar differences. You will have to build the tables that are appropriate to your requirements and then use the tools designed for those tables. regards Hugh At 15:18 +0800 01/11/29, Sam Cheung wrote: >Dear Genius, > >I am trying to config. a radiator (2.19-demo) using <AuthBy SQL> in >order to contact to a Oracle 8.1.7(the oracle and the radiator are on >the same machine.) However, I did not succeed. I've got the following >errors when performing a command "./buildsql -dbsource dbi:Oracle:rad >-dbusername sys -dbauth change_on_install -v -password /etc/passwd" > >. >. >. >. >.insert into SUBSCRIBERS >(USERNAME, >PASSWORD ) >values >('mailsrv', 'x' ) >DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD >ERROR: OCIStmtExecute) at ./buildsql line 204, <FILE> chunk 16. >Insert user mailsrv failed: ORA-00942: table or view does not exist (DBD >ERROR: OCIStmtExecute) >insert into SUBSCRIBERS >(USERNAME, >PASSWORD ) >values >('test', 'x' ) >DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD >ERROR: OCIStmtExecute) at ./buildsql line 204, <FILE> chunk 17. >Insert user test failed: ORA-00942: table or view does not exist (DBD >ERROR: OCIStmtExecute) >insert into SUBSCRIBERS >(USERNAME, >PASSWORD ) >values >('test1', 'x' ) >DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD >ERROR: OCIStmtExecute) at ./buildsql line 204, <FILE> chunk 18. >Insert user test1 failed: ORA-00942: table or view does not exist (DBD >ERROR: OCIStmtExecute) > >. >. >. > > >p.s. I've also complied and installed DBI (DBD-Oracle-1.12) and DBD ( >DBI-1.20) successfully using sunwork shop c compiler. > >Platform: Solaris 8 >Machine: Sun Microsystems Ultra 5 >cpu: 333 MHz >Ram: 128M > >Thanks a lot for paying attention and so much appreciate. > > >Best Regards, > >Sam Cheung >E-mail: [EMAIL PROTECTED] > > >=== >Archive at http://www.open.com.au/archives/radmin/ >To unsubscribe, email '[EMAIL PROTECTED]' with >'unsubscribe radmin' in the body of the message. -- NB: I am travelling this week, so there may be delays in our correspondence. 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.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
