sql: user lacks privilege or object not found

[iw2lsi]

Hi...

I would like to alter my subsonic db (basically in order to import some album's comments) using an sql client instead of the web interface and/or web access to the db (http://localhost:4040/db.view)...

So far I can access the database via "hsqldb-sqltool madsonic", but when I try to run a query it fails...

ie:
>sql: select * from artist;
>user lacks privilege or object not found: ARTIST

my sqltool.rc looks like:

urlid subsonic
url jdbc:hsqldb:file:/var/subsonic/db
username sa
password

any ideas ?

Best Regards,

Giampaolo

[Jägs]

This may not be the route you want to go, but you could simply build a program to alter the database through the web interface. I developed app in Perl to export playlists for the purpose of backing them up, but there's no reason you couldn't alter the SQL statements to do updates as well:

http://forum.subsonic.org/forum/viewtopic.php?f=5&t=17436

[iw2lsi]

Hi Jags,

thanks a lot for your suggestion... I'm still struggling with the error I'm having trying to follow my original approach, but yeah... your solution seems very good!

Best Regards,

Giampaolo

[iw2lsi]

Hi...

I found the problem... it was just the url...

urlid subsonic
url jdbc:hsqldb:file:/var/subsonic/db/subsonic
username SA
password

Best Regards,

Giampaolo