(RADIATOR) RAdmin problems

[Hugh Irvine]

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.

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