[Dxspider-support] Database question

[Lists]

I want my dxspider node to populate a database so I can use spiderweb but I’m having some issues getting it to work.

I keep reading about setting the database up to run on the same server, but I prefer to use a different server so I changed the setting in the DXVars.pm

$dsn = "dbi:mysql:dxcluster:10.10.10.16:3306”;

where 10.10.10.16 is the IP of my db server (Debian 12 server running MariaDB)

but on restarting the node it does not create the ‘spot’ table.
I can create the ’spot’ table manually but it never gets populated.
I have checked the db credentials are all working by manually connecting to the db.

Is there any reason why the db would have to be running on the same server as the node? or is this a red herring and I have another issue?

Thanks,
Chris - G1FEF