New Feature: Start Remote Php-script

[uyuni]

In fact this feature is already possible by editing the SQLyogTunnel.php but this is rather complicated.

When I have an http-tunnel I could start a remote PHP-script in the Notification Service if you would not only allow SQL-commands there but also PHP-include-commands.

Then you can e.g.

– start a maintaining PHP-script

– start an SQL-script which gets some data

– do more PHP-maintaining

– …

Is this nice for others also?

Emilio

[uyuni]

Is nobody interested in this feature?

It would allow me to do things I can't do now.

[peterlaursen]

Did you consider writing a Stored Procedure?

[DonQuichote]

uyuni wrote on Jul 11 2007, 11:10 PM:

Is nobody interested in this feature?

It would allow me to do things I can't do now.

You could take a good look at the tunnel PHP file and implement it yourself. It should not be that difficult. At first glance, I would say that you would have to mofidy the ExecuteSingleQuery function. If your modified tunnel file then checks for an “sql commented pattern”, like “– SCRIPT “, you can easily run scripts on the server without having to modify SQLyog. Personally, I do not like to be able to run serverside scripts from a database backend. That would just be another possibility of attacking a web server.

[uyuni]

A stored procedure is not an option because the database is only Mysql 4.1

I've found where and how to change the PHP-script but it would be nice if it is really included.

Security is not such a big issue: The include-file can be outside of the webdirectory and you need to know the login of the database to start it this way.

[Author]

Posts