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

[Hugh Irvine]

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.