Remote database access

[eurekasoft]

Hi

We have several sites hosted with blacknight and was always happy with product/service.But when the packages all changed, one feature is lacking for me.

I require remote access to the hosted mysql databases. I can enable remote access in the control panel, but have to define specific ip addresses in the access list.

But the problem is, I have no guarantee that the ip address that I need to access the database from is static and will not change.
In the old control panel, I could define '%' as the IP which meant allow access from all hosts, but It wont allow me in the new control panel.

This feature is essential for me, is there any way around this limitation, as I dont want to go looking for a new hosting company.

PS. A vps would be too expensive for what I need it for.

[blacknight]

I think we've already flagged this issue with the software vendors, but I'll raise it with our CTO anyway

[IALPA]

And did they ever get back to you?

The lack of this is very frustrating! I don't want to leave either!

[janine]

I'd also like to know if there's any possibility of this feature becoming available in the future. It's a shame that the old plans had it and the new ones don't.
Even the ability to specify an IP range might do it.

Otherwise, can you recommend any decent tools for mapping a dynamic IP to a static one to workaround this limitation?

Thanks for your time,
Janine.

[blacknight]

You can add an IP to the control panel to access MySQL databases - the feature was added a while back

[janine]

Thanks for the quick reply, but my concern is about maintaining database access from a dynamic IP as per the original poster.

At the moment, each time my IP changes I have to update the IP in the control panel - very annoying, especially since Eircom seem to change my IP several times a week of late.

If it is never going to be possible to allow an IP range or all IPs access via the control panel, do you know of any good dynamic to static IP mapping tools that I could use to overcome this?

Thanks

[blacknight]

Janine

I'll see if anyone here has any ideas.

Michele

[IALPA]

Just got notified of this topic, hence why I'm back.

I actually had to leave Blacknight over this specific issue, I'm sorry to say. Your service was fine, but no-one seemed interested in finding/helping with a workround.

That and the VERY poor cron management system on the NON VPS plans. (eg Try to run a task once an hour between 9 and 17hrs on a friday)

Sorry guys I didn't want to leave....anyway good luck janine with your task, please post back here if you find a good workaround. It would be appreciated.

[blacknight]

Originally Posted by IALPA

That and the VERY poor cron management system on the NON VPS plans. (eg Try to run a task once an hour between 9 and 17hrs on a friday)

How do you mean exactly?

[IALPA]

Say I want to run a script every 30mins from 9am to 7pm every Friday.

In a standard unix cron, i could have:

*/30 9-19 * * 5 php /path/to/script.php

There is just no way to do that in the control panel.

The options are:
Minutely
Hourly
Daily
Weekly
Monthly

But you can't combine them. So you couldn't set up a cron job like specified above.