Re: [Phpwiki-talk] external userauth can't stand logedin, CVS 31 jan 2005

[Reini U. <ru...@x-...>]

Stefan schrieb:
> Here the Result of the ?action=upgrade. But how do i get the "describe 
> session" result?

Now it's too late :)

$ mysql -uwikiuser -p phpwiki
mysql> describe session;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| sess_id   | varchar(32)      |      | PRI |         |       |
| sess_data | blob             |      |     |         |       |
| sess_date | int(10) unsigned |      | MUL | 0       |       |
| sess_ip   | varchar(15)      |      |     |         |       |
+-----------+------------------+------+-----+---------+-------+
4 rows in set (0.03 sec)

This is the good result.

> There is another Problem i had in 1.3.10 also. When i http login to 
> enter an directory the login is also shown in phpwiki as logedin but not 
> authentificated. Now when i authentificate i was also logged out when i 
> change to an other page ....
> Only way to get a corect login is to stop start the browser and than to 
> login to phpwiki again (without authetification against any directory to 
> access it)

Thanks. I know. I didn't check HttpAuth that lately.
DanFr has a patch which I have to check.

>  Upgrading this PhpWiki
>      check for necessary database updates - SQL
>        Backend type: mysql
> check for table session ...OK
> check for table user ...OK
> check for table pref ...OK
> check for table member ...OK
> check for table accesslog ...OK
> check for table rating ...OK
> check for new session.sess_ip column ... OK
> check for mysql session.sess_id sanity ...
> check for mysql LOCK TABLE privilege ...OK
> check for mysql page.id auto_increment flag ...OK
> check for extra page.cached_html column ... OK

I had in my session table:
   sess_id => varchar(10),
   sess_data => varchar(5)
Which cannot work obviously.

> Reini Urban schrieb:
>> Stefan schrieb:
>>
>>> after login against external database the user is shown as 
>>> authentificated
>>> after changing to an other page the user is logged out again
>> A session problem which I was investigating yesterday.
>>
>> If it's mysql, could you please post your "DESCRIBE session" result?
>>
>> Then run ?action=upgrade which tries to fix two session columns, which 
>> got shortened somehow. (how?!?)
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/