[Dxspider-support] DBI interface error

[IZ5FSA]

Nope... error still remain the same.

Is there a documentation around the mysql/sqlite dxspider support?

reading source all seems to be nice...


Il 25/03/2022 00:20, Dirk Koopman via Dxspider-support ha scritto:
> Try changing the $dsn strings to be the same (i.e. lose the ':3306').
>
> On 24/03/2022 23:04, IZ5FSA via Dxspider-support wrote:
>> Hi OMs,
>>
>> I have this error on access to MariaDB.
>>
>>> DBI connect('dxcluster:localhost:3306','sysop',...) failed: Access 
>>> denied for user 'sysop'@'localhost' (using password: YES )  at 
>>> /spider/perl/DXSql.pm line 63.
>> In  /spider/local-new/DXVars.pm I have:
>>
>>> # the SQL database DBI dsn
>>> #$dsn = "dbi:SQLite:dbname=$root/data/dxspider.db";
>>> #$dbuser = "";
>>> #$dbpass = "";
>>>
>>> # the SQL database DBI dsn
>>> $dsn = "dbi:mysql:dxcluster:localhost:3306";
>>> $dbuser = "sysop";
>>> $dbpass = "MyPassword";
>> In MariaDB the user "sysop" have grant full access to the dxcluster 
>> database.
>>
>>
>> If I use this script, access is fine...
>>
>>> #!/usr/bin/perl
>>>
>>> use DBI;
>>>
>>> $source = "DBI:mysql:dxcluster:localhost";
>>> $username = "sysop";
>>> $password = "MyPassword";
>>>
>>> $dbc = DBI->connect($source, $username, $password)
>>> or die "Unable to connect to mysql: $DBI::errstr\n";
>>>
>>> $sql = $dbc->prepare("SELECT count(*) FROM spot_backup");
>>>
>>> $out = $sql->execute()
>>> or die "Unable to execute sql: $sql->errstr";
>>>
>>> while (($id, $name) = $sql->fetchrow_array())
>>> {
>>>  print "Id: $id Name: $name\n";
>>> }
>> ...and obviously it return
>>
>>> Id: 0 Name:
>> because table is empty.
>>
>> I cannot find any documentation of this DBI feature in docs.
>>
>> Where is the trick? In the MariaDB parameters? Anyone have tryed this 
>> kind of error?
>>
>> best 73 de Leo IZ5FSA
>>
>>
>>
>>
>> _______________________________________________
>> Dxspider-support mailing list
>> Dxspider-support at tobit.co.uk
>> https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support
>
>
> _______________________________________________
> Dxspider-support mailing list
> Dxspider-support at tobit.co.uk
> https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support