phpMyAdmin Module

Hi,

I have the following ’problem’.
The timeout of the sessions or cookies or whatever keeps you logged in on phpMyAdmin on the server I use is very short, like 5 minutes.
When I’m working on a website, half of my time is lost because of I have to log in over and over again. I contacted my provider but they said there was nothing they could do.
Now I’m wondering if there is some kind of phpMyAdmin module for ModX, so I can acces the database and add/remove stuff directly from the manager.
This would save me a lot of time (and frustation).

thanx,

Marc

I don’t think there is a phpMyAdmin module excatly. You can try the dbEdit or SQLquerry modules or you can always install phpMyAdmin in its own directory and use it from there.

Quote from: Duggel at May 30, 2009, 12:57 AM

The timeout of the sessions or cookies or whatever keeps you logged in on phpMyAdmin on the server I use is very short, like 5 minutes.

What does phpMyAdmin have to do with working on a site with MODx? Regardless, you can configure your session variables in php.ini OR .htaccess (using php_value/php_flag directives). See http://us.php.net/manual/en/session.configuration.php for details of the available configuration variables. You’ll probably be most interested in session.gc_maxlifetime.

Now and then I hace to build modules for customers.
These modules need tables in the database to store data.

When I start to build the module I switch from coding to making chages in the database ’every minute’.
But when I’m doing this, I often have to login on the server again because my login-session or whatever is history.
When I have a phpMyAdmin-module, i just have to click on the module, make the changes and go on with programming...

So it’s not a must-have, but for me it makes life a litle easyer

I don’t know what version of MODx you’re using, but for a long time now it’s included a javascript function that requests an image every few minutes, thus keeping the session open. You could edit the manager/media/script/session.js to shorten the time between requests; it’s a pretty simple script.

A workaround for sites with very short session times is to use this Firefox extension: https://addons.mozilla.org/en-US/firefox/addon/115
Just open a new browser tab, login to phpMyAdmin, and select "reload every 4 minutes". Do the actual DB updates in another tab though, so that the reloading mechanism doesn’t accidentally interfere with your queries.