(RADIATOR) RAdmin problems

[Hugh Irvine]

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.

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