(RADIATOR) Re: (RADMIN) Re: Please help.

[Paul]

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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au]On
Behalf Of Hugh Irvine
Sent: Thursday, November 29, 2001 8:26 AM
To: Sam Cheung; radiator at open.com.au
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: scheung at asl.com.hk
>
>
>===
>Archive at http://www.open.com.au/archives/radmin/
>To unsubscribe, email 'majordomo at open.com.au' 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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.