(RADIATOR) AuthBy SQL problem
Hi genius, I am using to authenticate users. However, I would like to verifiy the user's username, password and status=T. So, How, can I rewrite the statement in sq.cfg to make it works. Thanks so much for paying attention. --- Regards, Sam Cheung E-mail: [EMAIL PROTECTED] === 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.
(RADIATOR) Please help.
Dear all, Does anyone know how to get authentication info. from 1 external DB server and store DHCP client info. (e.g. ip address, ip pool, leased time, etc.) to another external DB server if I would like to configure the radiator to lease ip to dailup users. Thanks. -- Regards, Sam Cheung E-mail: [EMAIL PROTECTED]
(RADIATOR) Re: Please help.
Dear Genius, I am trying to config. a radiator (2.19-demo) allocating IP address dynamically using DB1 to get the authentication info. from DB1 (an mysql server stored username and password) and using DB2 (another mysql server) to log the dhcp client info., DHCP pool and leased IP, etc. using the database which created by a script called mysqlCreate.sql. Can you give me some suggestion what to put down in the config.cfg? Thanks so much for paying attention. Thanks a lot. Best Regards, Sam Cheung
(RADIATOR) Re: Please help.
Dear Genius, I am trying to config. a radiator (2.19-demo) using 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, 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, 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, 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/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Please help.
Dear My Friend, It works man. Thanks so so much. My boss will definitely kill me if you dont help me. Cheers, -- Regards, Sam Cheung E-mail: [EMAIL PROTECTED] Paul wrote: MIME-Version: 1.0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2526. X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2526. X-Virus-Scanned: by level9 networks ltd. Sender: [EMAIL PROTECTED] Precedence: bulk List-Id: Hi Sam, Pretty sure that you need to use a capital 'O' e.g. DBSource DBI:Oracle:sid Thanks, Paul Dear Genius, I am trying to config. a radiator (2.19-demo) using 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 oracle -dbauth passwd". Errors: [install_driver(oracle) failed: Can't locate DBD/oracle.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .) at (eval 21) line 3. Perhaps the DBD::oracle perl module hasn't been fully installed, or perhaps the capitalisation of 'oracle' isn't right. Available drivers: ExampleP, Oracle, Proxy. at ./buildsql line 82] 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/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- Regards, Sam Cheung E-mail: [EMAIL PROTECTED]
(RADIATOR) Please help.
Dear Genius, I am trying to config. a radiator (2.19-demo) using 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 oracle -dbauth passwd". Errors: [install_driver(oracle) failed: Can't locate DBD/oracle.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .) at (eval 21) line 3. Perhaps the DBD::oracle perl module hasn't been fully installed, or perhaps the capitalisation of 'oracle' isn't right. Available drivers: ExampleP, Oracle, Proxy. at ./buildsql line 82] 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]