phpmyadmin

[Daz]

Hi everyone,

This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I need to edit a file which will
stop my login timing out after 3600 seconds. I've tried Googling for
it for some time now (weeks, on and off), and I've tried the
phpmyadmin docs to no avail.

I refuse to believe for one minute that the answer to my question is
not in the phpmyadmin docs, but I'll be damned if I can find it... I
think I might be looking in the wrong place, as the docs I am looking
through look sparse.

I've tried searching through the phpmyadmin wiki for:

time out
timeout
configuration

Basically, anything I come across are problems people have reported,
or about the actual web interface to phpmyadmin, rather than the
configuration.

If anyone can put me out of my misery, I would very much appreciate
it.

Many, many thanks in advance.

Daz.

[petersprc]

Re: phpmyadmin

Hi,

One thing you might check is the session timeout value. These settings
in a .htaccess would allow sessions to stay active for 24 hours or
longer:

php_value session.gc_maxl ifetime 86400
php_value session.cookie_ maxlifetime 86400

Regards,
John Peters

On May 7, 11:09 am, Daz <cutenfu...@gma il.comwrote:

Hi everyone,
>
This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I need to edit a file which will
stop my login timing out after 3600 seconds. I've tried Googling for
it for some time now (weeks, on and off), and I've tried the
phpmyadmin docs to no avail.
>
I refuse to believe for one minute that the answer to my question is
not in the phpmyadmin docs, but I'll be damned if I can find it... I
think I might be looking in the wrong place, as the docs I am looking
through look sparse.
>
I've tried searching through the phpmyadmin wiki for:
>
time out
timeout
configuration
>
Basically, anything I come across are problems people have reported,
or about the actual web interface to phpmyadmin, rather than the
configuration.
>
If anyone can put me out of my misery, I would very much appreciate
it.
>
Many, many thanks in advance.
>
Daz.

[Schraalhans Keukenmeester]

Re: phpmyadmin

At Mon, 07 May 2007 08:09:24 -0700, Daz let his monkeys type:

Hi everyone,
>
This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I need to edit a file which will
stop my login timing out after 3600 seconds. I've tried Googling for
it for some time now (weeks, on and off), and I've tried the
phpmyadmin docs to no avail.
>
I refuse to believe for one minute that the answer to my question is
not in the phpmyadmin docs, but I'll be damned if I can find it... I
think I might be looking in the wrong place, as the docs I am looking
through look sparse.
>
I've tried searching through the phpmyadmin wiki for:
>
time out
timeout
configuration
>
Basically, anything I come across are problems people have reported,
or about the actual web interface to phpmyadmin, rather than the
configuration.
>
If anyone can put me out of my misery, I would very much appreciate
it.
>
Many, many thanks in advance.
>
Daz.

Maybe a crude way, but have you tried grepping 3600 on all files in the
phpmyadmin dirs? Perhaps something pops up...
Alternatively, have a look at the phpmyadmin database/tables itself (IIRC
it has one, right?)

Checked the online docs, nothing on timeout AFAICT indeed. Just browser
time-out with large table dumps/imports and such.

HTH
Sh.

[rf]

Re: phpmyadmin


"Daz" <cutenfuzzy@gma il.comwrote in message
news:1178550564 .886249.154000@ e51g2000hsg.goo glegroups.com.. .

Hi everyone,
>
This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I need to edit a file which will
stop my login timing out after 3600 seconds. I've tried Googling for
it for some time now (weeks, on and off), and I've tried the
phpmyadmin docs to no avail.

It's quite obvious really :-)

In the folder where phpMyAdmin lives (on your web server) there is a file
called config.inc.php

In this file search for the line:
$cfg['LoginCookieVal idity'] = 3600;

Change the value accordingly.

--
Richard.

[Daz]

Re: phpmyadmin

On May 7, 6:43 pm, petersprc <peters...@gmai l.comwrote:

Hi,
>
One thing you might check is the session timeout value. These settings
in a .htaccess would allow sessions to stay active for 24 hours or
longer:
>
php_value session.gc_maxl ifetime 86400
php_value session.cookie_ maxlifetime 86400
>
Regards,
John Peters
>
On May 7, 11:09 am, Daz <cutenfu...@gma il.comwrote:
>

Hi everyone,

>

This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I need to edit a file which will
stop my login timing out after 3600 seconds. I've tried Googling for
it for some time now (weeks, on and off), and I've tried the
phpmyadmin docs to no avail.

>

I refuse to believe for one minute that the answer to my question is
not in the phpmyadmin docs, but I'll be damned if I can find it... I
think I might be looking in the wrong place, as the docs I am looking
through look sparse.

>

I've tried searching through the phpmyadmin wiki for:

>

time out
timeout
configuration

>

Basically, anything I come across are problems people have reported,
or about the actual web interface to phpmyadmin, rather than the
configuration.

>

If anyone can put me out of my misery, I would very much appreciate
it.

>

Many, many thanks in advance.

>

Daz.

Wonderful. That's the last place I expected to look for these
settings... Thanks.

[Daz]

Re: phpmyadmin

On May 7, 6:50 pm, Schraalhans Keukenmeester <inva...@invali d.spam>
wrote:

Maybe a crude way, but have you tried grepping 3600 on all files in the
phpmyadmin dirs? Perhaps something pops up...

I had thought about it, but I am fairly new to Linux, and the
phpmyadmin files appear to be scattered in various places. Some of the
places to look for certain files are obvious, others don't seem to be
quite as obvious.

Alternatively, have a look at the phpmyadmin database/tables itself (IIRC
it has one, right?)

Yes, you are correct, but I believe they are the settings for the
MySQL database, rather than anything to do with the inner-workings of
phpmyadmin. I seem to remember checking them a while back, but just to
be certain, I checked them again, and nothing.

Thanks for your input.

[Daz]

Re: phpmyadmin

On May 8, 4:31 am, "rf" <r...@invalid.c omwrote:

"Daz" <cutenfu...@gma il.comwrote in message
>
news:1178550564 .886249.154000@ e51g2000hsg.goo glegroups.com.. .
>

Hi everyone,

>

This may be seen as being off-topic, but I am not sure where I need to
look for the appropriate documentation/tutorial. All I would like to
know, if where (on a Linux system), I need to edit a file which will
stop my login timing out after 3600 seconds. I've tried Googling for
it for some time now (weeks, on and off), and I've tried the
phpmyadmin docs to no avail.

>
It's quite obvious really :-)
>
In the folder where phpMyAdmin lives (on your web server) there is a file
called config.inc.php
>
In this file search for the line:
$cfg['LoginCookieVal idity'] = 3600;
>
Change the value accordingly.
>
--
Richard.

Strangely enough, I've search this file many times in the past, and
checked through all the options. Here are the contents of the file,
with the comments stripped out.

//$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['port'] = '';
//$cfg['Servers'][$i]['socket'] = '';
//$cfg['Servers'][$i]['connect_type'] = 'socket';
//$cfg['Servers'][$i]['extension'] = 'mysql';
//$cfg['Servers'][$i]['compress'] = FALSE;
//$cfg['Servers'][$i]['controluser'] = '';
//$cfg['Servers'][$i]['controlpass'] = '';
//$cfg['Servers'][$i]['user'] = 'root';
//$cfg['Servers'][$i]['password'] = '';
//$cfg['Servers'][$i]['only_db'] = '';
//$cfg['Servers'][$i]['verbose'] = '';
//$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
//$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
//$cfg['Servers'][$i]['relation'] = 'pma_relation';
//$cfg['Servers'][$i]['table_info'] = 'pma_table_info ';
//$cfg['Servers'][$i]['table_coords'] = 'pma_table_coor ds';
//$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages' ;
//$cfg['Servers'][$i]['column_info'] = 'pma_column_inf o';
//$cfg['Servers'][$i]['history'] = 'pma_history';
//$cfg['Servers'][$i]['verbose_check'] = TRUE;
//$cfg['Servers'][$i]['AllowRoot'] = TRUE;
//$cfg['Servers'][$i]['AllowDeny']['order'] = '';
//$cfg['Servers'][$i]['AllowDeny']['rules'] = array();

All of these lines are commented out as everything seems to work fine,
apart from the timeout aspect. I was pretty certain that the setting I
needed should go in there somewhere, I just couldn't find what the key
name for the array should be.

Many thanks for your input.