Mediabin 4.5.3 uses ODBC or DSN-Less?

What exactly is the MediaBin Server confguration for connecting to the database?

It has something to do with an ODBC connection and a "System DSN?"

Can it be a trusted connection?

What registry entries should be needed?

Blaa blaa blaa, any information anyone has would be great!

I need to document how to rebuild a server and this information is critical to us.

Find more posts tagged with

Comments

msrinivas

The installation process creates a System DSN. This is the same that you see in the Enterprise Manager. You should be able to see it on the asset server ODBC System DSN screen.

Migrateduser

Hi Srinivas,

Yes, that's what I thought too. However, we had an accident where our server lost connection to the Domain Controller. No big deal, a reroute on the network and reboot fixed that. However, when I logged onto Windows my profile was gone and Windows recreated a new one for me.

Very strange. Then, MediaBin stopped working. After a little investigation between my test server and Production, the system DSN where I thought it should be was missing. I created a new one called "MediaBin Repository" and restarted the service.

Why, why, why, why? So now, I'm on a quest to know if I setup the system DSN correctly and also, why was the old one associated to my personal account and not a System DSN?

Thanks.
Stacy

lyman

If you look at the registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\MediaBin, Inc.\MediaBin\Platform\CurrentVersion\Repository

You can see the LocalOdbcDataSourceName

which will be how MediaBin finds the DSN and therefore must be consistent (i.e., you are free to rename it so long as the DSN and this registry setting agree).

The password is stored in LocalOdbsPassword and LocalOdbcPasswordEx. Specifically at start-up the password is in cleartext in LocalOdbcPassword and the server at start-up encrypts the password and leaves the result in LocalOdbcPasswordEx. Therefore, to change ODBC passwords simply add the new password to LocalOdbcPassword, blank LocalOdbcPasswordEx and immediately start the MediaBin service.

The Windows interface for managing ODBC connections provides the means to test an ODBC connection.

Hope this helps,

Lyman Hurd

Migrateduser

Does HKEY_LOCAL_MACHINE\SOFTWARE\MediaBin, Inc.\MediaBin\Platform\CurrentVersion\Repository\LocalOdbcUserName mean anything?

Our value is "MediaBinSQLUser" but, that is not an account in our Windows Groups or Users.

msrinivas

That is the SQL server user id that is being used to authenticate with the DB.

Migrateduser

That's very interesting. That account is in the sysadmin SQL group. I don't like that.

Also, can I simply change the registry to use a domain service account and remove the local sql account?

lyman

The MbSQLUser account needs read and write access to the DB but it certainly does not have to be a SQL admin. That is probably due to a miscommunication because the installer requires an account to create tables with sa access but not the account we actually run under.

I am looking into the second question as I have not tried it. I will let you know.

Cheers,

Lyman Hurd