Miva 9 database access

[tleah1]

We have a hosted Miva 9 storefront. What type of database is this built on and do we have permission to access the database with the hosted plan?

[Brennan]

Re: Miva 9 database access

Yes you have full access to the database. Miva is built on a MySQL database. You should have a website control panel (most likely PLESK) where you can use PHPMyAdmin to view the database.

The only limitation of a shared hosted plan (vs a dedicated server) is you don't have SSH access to the server.

[Bruce - PhosphorMedia]

Re: Miva 9 database access

We have a hosted Miva 9 storefront. What type of database is this built on and do we have permission to access the database with the hosted plan?

HOWEVER, unless you are very familiar with the Merchant data relationships, its not advisable to manually change data.

[sbronstad]

Re: Miva 9 database access

My IT manager was asking if accessing data via mySQL constituted a "seat"

[Rick Wilson]

Re: Miva 9 database access

No, it doesn't.

[tleah1]

Re: Miva 9 database access

Thanks! I am not planning on changing any of the data, I just want to be able to read some of the data directly from the database. Where is the information about how to get to phpMyAdmin or look at the database? I do not see this in the main Miva control panel (admin.mvc) or on the Hosting Information Sheet we got after signing up, but maybe I am missing something.

[Brennan]

Re: Miva 9 database access

If you are hosted with us, which sounds like you are, the link should be in the hosting pdf you got when you signed up.

However you can get to it by adding :8443 to the end of your domain:

https://www.domain.com:8443

This should redirect you to your PLESK control panel.

[tleah1]

Re: Miva 9 database access

Thank you Brennan! I see it now. Do we have permission to access the database with a php page coming from a different website, or just local access through phpMyAdmin?

[Brennan]

Re: Miva 9 database access

Yes but I would strongly recommend against it. If you have a php file directly connecting to the database, that means you need your database username/password (unencrypted) saved in the php file. This is a bad security practice because if your FTP credentials got compromised, someone could get full access to your database. This will also get you in trouble with PCI.

Miva has a suite of tools available which allow you to import and export any data from Miva without directly connecting to the database. This is going to be a much safer and secure option. Contact our sales team if you are interested in learning some more about whats available.

[tleah1]

Re: Miva 9 database access

OK, thank you for your help. We will not connect remotely for security reasons as you have advised.

[Bruce - PhosphorMedia]

I believe Tool Belt has the ability to do MySQL queries (which would be the easiest). You could also do it by creating a module and using either the Miva API calls or your own to do queries, but that's not an 'easy' option.

We have a DB "Reader" module if you just want to look at the databases and see format and values. Contact me off list if this is all you need. (bruce a_t phosphormedia.com)

[PCINET - Andreas]

Correct tool-belt allows to run non-destructive queries on the database.