(RADIATOR) RAdmin problems

[Yehudi Binder]

Hi Hugh,

	Yes, I did.

Cheers,

Yehudi

-----Original Message-----
From: Hugh Irvine [mailto:hugh at open.com.au]
Sent: Wednesday, 11 August 2004 5:49 p.m.
To: Yehudi Binder
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) RAdmin problems



Hello Yehudi -

Have you created a system DSN?

regards

Hugh


On 11 Aug 2004, at 14:59, Yehudi Binder wrote:

> Hugh,
>
> 	Actually I'm using MySql. I created a database called RAdmin, a DSN 
> and the DSN can connect to the database using login "radmin" and 
> password "radminpw". Would you have a script to create this database 
> manually?
>
> Cheers,
>
> Yehudi.
>
> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: Wednesday, 11 August 2004 4:54 p.m.
> To: Yehudi Binder
> Cc: radiator at open.com.au
> Subject: Re: (RADIATOR) RAdmin problems
>
>
>
> Hello Yehudi -
>
> The error message indicates that the database has not yet been created.
>
> You will first of all need to create the database using the MS-SQL
> administration tool, then create a system DSN for it.
>
> Once this is done the script can be run to create the tables and load
> the data.
>
> regards
>
> Hugh
>
>
> On 11 Aug 2004, at 10:20, Yehudi Binder wrote:
>
>> Hi Hugh,
>>
>> 	I tried the commands separately, as you instructed me. They ran
>> without errors but the tables were not generated. Then I tried another
>> command I saw in your installmysql.sh script and this is the error it
>> showed me:
>>
>> C:\Radiator\Radmin-1.8>perl createdb.pl -create -dbsource
>> dbi:ODBC:radmin:localh
>> ost -dbuser radmin -dbauth radminpw basicdb.dat radattrs.dat
>> DBI connect('radmin:localhost','radmin',...) failed: [Microsoft][ODBC
>> Driver Man
>> ager] Data source name not found and no default driver specified
>> (SQL-IM002)(DBD
>> : db_login/SQLConnect err=-1) at Radmin/DBSQL.pm line 244
>> Could not connect to SQL database dbi:ODBC:radmin:localhost:
>> [Microsoft][ODBC Dr
>> iver Manager] Data source name not found and no default driver
>> specified (SQL-IM
>> 002)(DBD: db_login/SQLConnect err=-1) at Radmin/Util.pm line 43.
>>
>>
>> Do you have any idea of what could be happening?
>>
>> Thanks and Regards,
>>
>> Yehudi.
>>
>> -----Original Message-----
>> From: Hugh Irvine [mailto:hugh at open.com.au]
>> Sent: Tuesday, 10 August 2004 5:55 p.m.
>> To: Yehudi Binder
>> Cc: radiator at open.com.au
>> Subject: Re: (RADIATOR) RAdmin problems
>>
>>
>>
>> Hello Yehudi -
>>
>> I have seen this in the past and running the command as two seperate
>> commands seems to work correctly:
>>
>> 	perl createdb.pl -create basicdb.dat
>>
>> 	perl createdb.pl -create radattrs.dat
>>
>> Please let me know how you get on.
>>
>> regards
>>
>> Hugh
>>
>>
>> On 10 Aug 2004, at 15:22, Yehudi Binder wrote:
>>
>>> Hi guys,
>>>
>>> 	I'm trying the RAdmin product using a windows2003 with a MySQL 
>>> server
>>> database. I'm just starting the installation - I have perl, dbi and
>>> odbc modules installed to support the product, as well as Radiator. I
>>> also created a database called RAdmin in MySql and linked it to ODBC.
>>> So, when I try running the command "perl createdb.pl -create
>>> basicdb.dat radattrs.dat", it shows me the following error:
>>> C:\Radiator\Radmin-1.8>perl createdb.pl -create basicdb.dat
>>> radattrs.dat
>>> DBD::ODBC::db do failed: [MySQL][ODBC 3.51
>>> Driver][mysqld-4.0.20a-debug]Table 'radmin.radattrs' doesn't exist
>>> (SQL-42S02)(DBD: Execute immediate failed err=-1)
>>> at Radmin/DBSQL.pm line 619, <FILE> line 7.
>>>
>>> 	The errors keep going until the end of the script. Has anybody tried
>>> this configuration before? Has anybody know how to solve this 
>>> problem?
>>>
>>> Thanks and Regards,
>>>
>>> Yehudi.
>>>
>>>
>>> This electronic message together with any attachments is 
>>> confidential,
>>> and may be privileged. It is intended solely for the addressee. If 
>>> you
>>> are
>>>  not the intended recipient do not copy, disclose, or use the 
>>> contents
>>> in
>>> any way and please notify us by return e-mail immediately, then
>>> destroy the message. ETSL is not responsible for any changes made to
>>> this message and/or any attachments after sending by ETSL.
>>>
>>>
>>> --
>>> 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.
>>>
>>>
>>
>> NB: have you included a copy of your configuration file (no secrets),
>> together with a trace 4 debug showing what is happening?
>>
>> -- 
>> Radiator: the most portable, flexible and configurable RADIUS server
>> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>> -
>> Nets: internetwork inventory and management - graphical, extensible,
>> flexible with hardware, software, platform and database independence.
>> -
>> CATool: Private Certificate Authority for Unix and Unix-like systems.
>>
>>
>> This electronic message together with any attachments is confidential,
>> and may be privileged. It is intended solely for the addressee. If you
>> are
>>  not the intended recipient do not copy, disclose, or use the contents
>> in
>> any way and please notify us by return e-mail immediately, then
>> destroy the message. ETSL is not responsible for any changes made to
>> this message and/or any attachments after sending by ETSL.
>>
>>
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> -- 
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
>
>
> This electronic message together with any attachments is confidential,
> and may be privileged. It is intended solely for the addressee. If you 
> are
>  not the intended recipient do not copy, disclose, or use the contents 
> in
> any way and please notify us by return e-mail immediately, then
> destroy the message. ETSL is not responsible for any changes made to
> this message and/or any attachments after sending by ETSL.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


This electronic message together with any attachments is confidential, 
and may be privileged. It is intended solely for the addressee. If you are
 not the intended recipient do not copy, disclose, or use the contents in 
any way and please notify us by return e-mail immediately, then 
destroy the message. ETSL is not responsible for any changes made to 
this message and/or any attachments after sending by ETSL.


--
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.