Accessing Madsonic database
-
- Contributor
- Posts: 323
- Joined: 02 Jan 2013, 04:56
- Has thanked: 11 times
- Been thanked: 105 times
Accessing Madsonic database
Just wondering if there's a way to directly access the database through a 3rd party utility, such as Crystal Reports or Business Objects. Can anyone point me towards being able to do this? Looking for something to keep me busy for this weekend, since it's gonna snow, and I may be "trapped" in my house... LOL
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Accessing Madsonic database
hi, i used this Tool for SQL Tasks
http://www.razorsql.com/
to access your subsonic db you must shutdown your service before.
best regards
![Image](http://www.razorsql.com/images/razorsql/main45.jpg)
http://www.razorsql.com/
to access your subsonic db you must shutdown your service before.
best regards
![Image](http://www.razorsql.com/images/razorsql/main45.jpg)
-
- Contributor
- Posts: 323
- Joined: 02 Jan 2013, 04:56
- Has thanked: 11 times
- Been thanked: 105 times
Re: Accessing Madsonic database
Will def. check this out! Thanks!
Getting error "Cannot find user ADMIN".... Using the Subsonic.Data file - is that the correct one? It's under /var/subsonic/db
Getting error "Cannot find user ADMIN".... Using the Subsonic.Data file - is that the correct one? It's under /var/subsonic/db
- Madsonic
- Administrator
- Posts: 984
- Joined: 07 Dec 2012, 03:58
- Has thanked: 1201 times
- Been thanked: 470 times
Re: Accessing Madsonic database
hi,
Database File: /var/subsonic/db/subsonic.script
User: sa
no Password!
this should work!
Database File: /var/subsonic/db/subsonic.script
User: sa
no Password!
this should work!
-
- Contributor
- Posts: 323
- Joined: 02 Jan 2013, 04:56
- Has thanked: 11 times
- Been thanked: 105 times
Re: Accessing Madsonic database
I've connected to the db, but I am not seeing any data. I can see table names, but that's about it.
See attachment, I have highlighted "username (pk)" on the left, but nothing shows on the right. Same for anything I highlight.
See attachment, I have highlighted "username (pk)" on the left, but nothing shows on the right. Same for anything I highlight.
Re: Accessing Madsonic database
I know this post is old as hell but I am interested in trying to look at/edit the madsonic database.
Are you guys accessing your database locally? I currently have my madsonic installations on headless Ubuntu VMs and administer them remotely from my Windows machine. I am not sure how to get RazorSQL to connect remotely.
Any help is appreciated.
Thanks
Are you guys accessing your database locally? I currently have my madsonic installations on headless Ubuntu VMs and administer them remotely from my Windows machine. I am not sure how to get RazorSQL to connect remotely.
Any help is appreciated.
Thanks