iMediaTouch MySQL Database Management Info

[RomanPort]

Hi! Recently, I've been working to repair the iMediaTouch database at my college radio station to fix a problem we've been having where a good chunk of our songs had their names overwritten. I wanted to write a script to automatically Shazam tracks and update their metadata, but for a while I couldn't figure out how to access the database programmatically. Last night, after injecting my own code into the iMediaTouch application, I was able to finally figure out the information it uses to connect to it's MySQL database.

It appears that iMediaTouch is hardcoded to use the following login credentials:
Username: "root"
Password: "$4omtsql"
The database is only configured to be accessible from the local machine, so this isn't a security risk.

Logging in, you can see table mtaudio.audioitem contains a list of all tracks:



Hopefully somebody will find this useful at some point whilst trying to make changes to their own database. Sure is a lifesaver for me!

 

[Kelly A]

That's a great tip! Especially since iMediatouch support is pretty much nonexistent.

 

[bossbill]

I've found iMediaTouch has good support when you have a support agreement, and Rick Landry has been extremely helpful.

 

[SomeRadioGuy]

That's a great tip! Especially since iMediatouch support is pretty much nonexistent.

Thats news to me, we run IMT here at KSKO and I've gotten support every time ive called or emailed.. and the replies come in a time frame appropriate to the level of seriousness of my question