configure mysql with plesk

[seans9]

I am running plesk and have installed Empresa through my plesk control panel.

When running the installation of Miva, I get stuck at the database setup part. I get this error:

Unable to connect to database: Database type 'MySQL' is unsupported or not configured

I did a lot of reading - none of which helped other than reading "run diag5.mvc". When I click on "Installed Database Libraries" in diag5.mvc, mysql does not appear on the list. I'm assuming its not configured. All my settings are correct (i've tried the db@localhost, db@127.0.0.1, db@localhost.localdomain).

Anyone else have this problem?

[ILoveHostasaurus]

Re: configure mysql with plesk

I don't believe the Plesk Empresa engine includes the mysql component due to license issues with including mysql code in commercial products. You'd need to add it in manually which may be more difficult than it sounds; the Plesk per-site config file vhost.conf and vhost_ssl.conf in the conf directory need to be modified to include the appropriate Empresa library after it has been installed on the server.

I recommend against using the built in Empresa support in Plesk regardless because we just don't know how they're going to handle upgrades to the engine and you may find a plesk update gets applied and then all your stores break.

[seans9]

Re: configure mysql with plesk

I thought the same thing but in /usr/lib/miva/databases there is a mysql.so file. How can I get empresa to recognize it?

[ILoveHostasaurus]

Re: configure mysql with plesk

That's surprising that it's there; hope someone didn't mess up by including that.

You'll want to check the /var/www/vhosts/<domain>/conf/httpd.include file to see if the mysql.so is being loaded; if it's there but still not working, well I'm not sure what to suggest :), but if it's not there, you'll need to load it in by adding a vhost.conf and vhost_ssl.conf to that same directory to cause it to be loaded via the apache config.

Alternatively, turn Empresa off for the site and re-do it using the cgi-style setup on a per-site basis.

[seans9]

Re: configure mysql with plesk

That's surprising that it's there; hope someone didn't mess up by including that.

You'll want to check the /var/www/vhosts/<domain>/conf/httpd.include file to see if the mysql.so is being loaded; if it's there but still not working, well I'm not sure what to suggest :), but if it's not there, you'll need to load it in by adding a vhost.conf and vhost_ssl.conf to that same directory to cause it to be loaded via the apache config.

Alternatively, turn Empresa off for the site and re-do it using the cgi-style setup on a per-site basis.

It wasn't loading mysql.so so I added a line from this page to the httpd.include. What do I put in the vhost.conf and vhost_ssl.conf file?

[ILoveHostasaurus]

Re: configure mysql with plesk

If what you added to the httpd.include file got it working, then you'll need to add the same thing to the vhost.conf and vhost_ssl.conf because httpd.include gets rebuilt on the fly when you make config changes to the site, such as turning a feature on and off. What I don't know is if you need to wrap the new line in some type of clause or if just the single line can go in there; it may take some experimentation.

[seans9]

Re: configure mysql with plesk

It didn't work when I added it to the httpd.include . The Miva diagnostics still didn't recognize it.

Any ideas?

[ILoveHostasaurus]

Re: configure mysql with plesk

There may be some begin and end parameters that need to be added around your new line, but you did do a full stop and start on apache right?

[seans9]

Re: configure mysql with plesk

There may be some begin and end parameters that need to be added around your new line, but you did do a full stop and start on apache right?

Yes I did do a full stop and restart on apache. One thing I did notice was that nothing happened when I erased the line linking to the mivasql.so file in httpd.include. The Miva diag5.mvc still passed the test for it.

[ILoveHostasaurus]

Re: configure mysql with plesk

Did you stlll have it in the vhost.conf?

[seans9]

Re: configure mysql with plesk

There is no vhost.conf inside that directory.