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

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

after login against external database the user is shown as authentificated
after changing to an other page the user is logged out again

Regards Stefan

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/

Hello Reini,

Here the Result of the ?action=upgrade. But how do i get the "describe 
session" 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)

Regards Stefan

  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

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?!?)

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/

Hello Reini,

thats the same as i have.

 Field      Type     Charset     Attributes     Null     Default     
Extra     Action
 sess_id      varchar(32)                 No                  Change     
Drop     Primary     Index     Unique     Fulltext
 sess_data      blob           BINARY     No                  Change     
Drop     Primary     Index     Unique     Fulltext
 sess_date      int(10)           UNSIGNED     No      0            
Change     Drop     Primary     Index     Unique     Fulltext
 sess_ip      varchar(15)                 No                  Change     
Drop     Primary     Index     Unique     Fulltext

but the problem is the same :-(

--------

Second question

should named interwikilinks like 
[Bild200:Agardit-001.jpg|Bild:Agardit-001.jpg] now work in RichTable Plugin?

Mapping:
Bild http://www.mineralienatlas.de/upload/
Bild200 http://www.mineralienatlas.de/thumb200.php?image=http://www.mineralienatlas.de/upload/

I have tried it but it did'nt work again

[Bild200:Agardit-001.jpg] works

Regards Stefan :-)

Reini Urban schrieb:

> 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 schrieb:

> Stefan schrieb:
>
>> thats the same as i have.
>>
>> Field      Type     Charset     Attributes     Null     Default     
>> Extra     Action
>> sess_id      varchar(32)                 No                  
>> Change     Drop     Primary     Index     Unique     Fulltext
>> sess_data      blob           BINARY     No                  
>> Change     Drop     Primary     Index     Unique     Fulltext
>> sess_date      int(10)           UNSIGNED     No      0            
>> Change     Drop     Primary     Index     Unique     Fulltext
>> sess_ip      varchar(15)                 No                  
>> Change     Drop     Primary     Index     Unique     Fulltext
>>
>> but the problem is the same :-(
>
>
> Problem persists? Ok, I'll investigate.
>
Thank you

>> Second question
>>
>> should named interwikilinks like 
>> [Bild200:Agardit-001.jpg|Bild:Agardit-001.jpg] now work in RichTable 
>> Plugin?
>
>
> Not yet. Soon.
> I just found more errors with TransformText within the RichTable plugin.
>

thats fine, not the error but that they will be fixed soon :-)

I found some other problems in the CVS Version. On some pages it shows
an old Version of the page
here are two links to show the difference. They both go to the same
mysql databse as backend

mostly wiki 1.3.10
http://www.mineralienatlas.de/lexikon/index.php/SandKasten

cvs Version
http://www.mineralienatlas.de/lex1/index.php/SandKasten

During the tests i had to restart my server several times because it
wouldnt answer anymore. can't find why it is so but it seems to be a
problem in conjunction with the new wiki. But its no memory problem and
no cpu. the server stops answering requests. I only can reproduce the
problem when testing with new cvs version :-(

Here the apache error log result

[client 80.140.170.186] PHP Fatal error:  session_start(): Failed to
initialize storage module: user (path: /tmp) in
/www/mineralienatlas/htdocs/lexikon/lib/Request.php on line 543
[client 80.140.170.186] PHP Fatal error:  session_start(): Failed to
initialize storage module: user (path: /tmp) in
/www/mineralienatlas/htdocs/lexikon/lib/Request.php on line 543
[client 80.140.170.186] PHP Fatal error:  session_start(): Failed to
initialize storage module: user (path: /tmp) in
/www/mineralienatlas/htdocs/lexikon/lib/Request.php on line 543

Here the php log

[31-Jan-2005 15:56:20] PHP Warning:  Unknown(): A session is active. You 
cannot change the session module's ini settings
  at this time. in Unknown on line 0
[31-Jan-2005 15:56:21] PHP Fatal error:  Call to undefined function: 
affected_rows() in /www/mineralienatlas/htdocs/lex
1/lib/DbSession.php on line 207

Regards Stefan

>> Mapping:
>> Bild http://www.mineralienatlas.de/upload/
>> Bild200 
>> http://www.mineralienatlas.de/thumb200.php?image=http://www.mineralienatlas.de/upload/ 
>>
>> I have tried it but it did'nt work again
>> [Bild200:Agardit-001.jpg] works
>

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

phpwiki-talk