[Nelug] phpmyadmin and timeouts

[Dougie Nisbet]

Richard Mortimer wrote:
> On Mon, 2006-02-13 at 18:47 +0000, Dougie Nisbet wrote:
>   
>> I've been looking to see if there's a way that I can stop this 
>> happening, or at least to get a warning before commiting that the 
>> session has timed out, or even somehow retrieving the SQL statement that 
>> had failed and re-running it. I got hopeful when I found a tab that said 
>> 'SQL History' but it was empty. I've found that my clicking on Home I 
>> can a load of system variables but no way of changing them.
>>
>> Can someone point me in the right direction and tell me if it's possible 
>> to change the timeout or, ideally, disable it completely? Or if there's 
>> a way of retrieving and Insert statement so that I can re-submit it?
>>     
> Not sure if I have the same version as you but you might try looking at
>
> config.inc.php - specifically... (in /var/www/phpmyadmin)
>
> $cfg['LoginCookieValidity']     = 1800;   // validity of cookie login
> (in seconds)
>
>
> That value is 30 mins. bumping it up higher should help.
>
> Richard
>
>
>   
Ah, thanks. That looks promising. 30 minutes sounds about right too. I 
mean, that's what it said when it told me I'd been timed out. I was too 
busy cursing to remember the exact message though.

Nothing about the parameter on the documentation website. I'm going to 
set it to zero and see what happens, then try huge numbers if that 
doesn't disable it.

Dougie