phpwiki-talk

Re: [Phpwiki-talk] Phpwiki and Mysql slowness

[Manuel V. <man...@gm...>]

2007/1/13, Reini Urban <ru...@x-...>:
> 2007/1/12, Manuel Vacelet <man...@gm...>:
> > 2007/1/9, Reini Urban <ru...@x-...>:
> > > 2007/1/8, Manuel Vacelet <man...@gm...>:
> > > > I noticed than, sometimes, mysql based phpwikis become slow when there
> > > > are several concurrent access.
> > > >
> > > > I guess it's due to table locking for update operation (phpwiki locks
> > > > whole table).
> > > >
> > > > I'm wondering if it could be a good idea to use innodb table type when
> > > > available and replace table locks by transactions as other ACID
> > > > complient engines (pgsql, ...) do ?
> > >
> > > postgresql, oracle or innodb are much better than myisam on crowded
> > > servers, yes.
> >
> > Ok, we will have look on this approach.
> > Obviously, we will keep the list informed.
>
> The fastest connect by far has berkeley ("dba - db3 or db4"), but time sorting
> (e.g. RecentChanges) and other advanced queries are very slow.
> I recommend dba on small wikis < 500 pages, and then postgresql.

FYI, today there is 29000+ pages in our wiki_page table (even if most
of them are automaticatly created from pgsrc).

> For the next release I will work for sql db's on extracting the standard
> page and version data properties from serialized blobs into real
> table columns.
> This will require more sql schema updates, but I hope action=upgrade
> will be good enough to do that automatically.

This is very intresting, do you exepect any performances enhancement
with this upgrade ?
It could be an opportunity for us to contribute our patch to allow
several wiki instances to be stored in one table.

> > > BTW: can I expect an updated french translation for the new 1.3.13 features?
> >
> > I think Sabri (who's working with me on the subject) already gave to
> > you the small work he did on the subject.
>
> Thanks.
> I checked it in and will do the 1.3.13 release after the remaining
> php-5.2.0 checks hopefully tommorrow.
>
> The new 5.2 constructor strictness or the new __toString method can be
> the culprit.
>
> Next week I'll be offline in Koeln for some days.

Have a nice trip !

-- Manuel

[Phpwiki-talk] maybe a signin bug in phpwiki - need help for a workarround

[Stefan <son...@ba...>]

To use our wiki all users have to signin first to make changes but 
sometimes there are users without userid. Only the ip is logged when 
they do changes. After a while of testing i found the reason when this 
happens.

The user looks at a couple of pages and then enters uid and pwd to 
signin. After signin he clicks to the browser back button and switches 
to a page where he isn't signed in before (cache). At this page he 
clicks again on the signin button with no userid inserted in the uid 
field. Now he is signed in without having an uid.

I need a quick and dirty solution to solf this problem. It's easy to 
check if the user do have an uid when he is signed in. As solution: When 
i see he has no uid and is signedin, i want to sign him off. I found the 
code (java script) to do it with a button. Is there also a function call 
which i can implement to do this in the main template?

I wrote this in an email before but it was a little bit confused - sorry 
for this.
Regards Stefan

Re: [Phpwiki-talk] Few questions on phpwiki setup.

[George M. <ms...@ho...>]

Thanks, I thought the same as I'm not using a Flat file db either.

> From: li...@gm...> To: php...@li...> Date: Tue,=
 16 Jan 2007 15:46:08 +0100> Subject: Re: [Phpwiki-talk] Few questions on p=
hpwiki setup.> > Reini Urban wrote:> > [mkdir(/tmp/cache/toolbarcache/): Pe=
rmission denied]> > > For optimization you'd need to define the PLUGIN_CACH=
ED_CACHE_DIR> > option (section 8), where cached settings are stored.> > > =
> ; This is only used if database is set to file.> > database is dba/gdbm, =
not file, so I didn't think this could help - > but it did.> > Thanks, Rein=
i!> > Oliver> -- > Oliver Betz, Muenchen> > > -----------------------------=
--------------------------------------------> Take Surveys. Earn Cash. Infl=
uence the Future of IT> Join SourceForge.net's Techsay panel and you'll get=
 the chance to share your> opinions on IT & business topics through brief s=
urveys - and earn cash> http://www.techsay.com/default.php?page=3Djoin.php&=
p=3Dsourceforge&CID=3DDEVDEV> _____________________________________________=
__> Phpwiki-talk mailing list> Php...@li...> https://=
lists.sourceforge.net/lists/listinfo/phpwiki-talk
_________________________________________________________________
Get the Live.com Holiday Page for recipes, gift-giving ideas, and more.
www.live.com/?addtemplate=3Dholiday=

[Phpwiki-talk] pdf issues

[John C. <joh...@ua...>]

Reini,
  Trying out the pdf stuff again, I have finally gotten a pdf out using the
internal library :-), but it made a pdf with one page per line (168 pages).

  Trying to use the external pdf generator, I can get it to work from the
command line, but not from the wiki.

  Also,  I'm getting the following output a lot:

<html><body><div style="font-weight:bold; color:red">Fatal Error:</div> <div
class="errors"><p>f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-erro
rhandler.inc.php:76 Error[256]: mysql error: [1062: Duplicate entry
'c1b1d8e83bb8ac00a9c544d8f4a55bb2' for key 1] in EXECUTE(&quot;INSERT INTO
session (sess_id, sess_data, sess_date, sess_ip) VALUES
('c1b1d8e83bb8ac00a9c544d8f4a55bb2',
'wiki_user|O:10:\&quot;_adminuser\&quot;:11:{s:7:\&quot;_userid\&quot;;s:5:\
&quot;admin\&quot;;s:6:\&quot;_level\&quot;;i:10;s:6:\&quot;_prefs\&quot;;O:
15:\&quot;userpreferences\&quot;:4:{s:6:\&quot;_prefs\&quot;;a:14:{s:6:\&quo
t;userid\&quot;;O:15:\&quot;_userpreference\&quot;:2:{s:13:\&quot;default_va
lue\&quot;;s:0:\&quot;\&quot;;s:6:\&quot;userid\&quot;;s:5:\&quot;admin\&quo
t;;}s:6:\&quot;passwd\&quot;;O:15:\&quot;_userpreference\&quot;:1:{s:13:\&qu
ot;default_value\&quot;;s:0:\&quot;\&quot;;}s:9:\&quot;autologin\&quot;;O:20
:\&quot;_userpreference_bool\&quot;:1:{s:13:\&quot;default_value\&quot;;b:0;
}s:5:\&quot;email\&quot;;O:21:\&quot;_userpreference_email\&quot;:1:{s:13:\&
quot;default_value\&quot;;s:0:\&quot;\&quot;;}s:11:\&quot;notifyPages\&quot;
;O:22:\&quot;_userpreference_notify\&quot;:1:{s:13:\&quot;default_value\&quo
t;;s:0:\&quot;\&quot;;}s:5:\&quot;theme\&quot;;O:21:\&quot;_userpreference_t
heme\&quot;:1:{s:13:\&quot;default_value\&quot;;s:4:\&quot;Crao\&quot;;}s:4:
\&quot;lang\&quot;;O:24:\&quot;_userpreference_language\&quot;:1:{s:13:\&quo
t;default_value\&quot;;s:0:\&quot;\&quot;;}s:9:\&quot;editWidth\&quot;;O:19:
\&quot;_userpreference_int\&quot;:3:{s:13:\&quot;default_value\&quot;;d:80
</p> </div>

To get the internal library to work, I had to delete this row before trying
to create the pdf.

Any suggestions on how to get the external one to work, and to get rid of
that error?

Thanks,

John

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

[Phpwiki-talk] pdf issues...

[John C. <joh...@ua...>]

Renin,
  Trying out the pdf stuff again, I have finally gotten a pdf out using the
internal library :-), but it made a pdf with one page per line (168 pages).

  Trying to use the external pdf generator, I can get it to work from the
command line, but not from the wiki.

  Also,  I'm getting the following output a lot:

<html><body><div style="font-weight:bold; color:red">Fatal Error:</div>
<div
class="errors"><p>f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-erro
rhandler.inc.php:76 Error[256]: mysql error: [1062: Duplicate entry
'c1b1d8e83bb8ac00a9c544d8f4a55bb2' for key 1] in EXECUTE(&quot;INSERT INTO
session (sess_id, sess_data, sess_date, sess_ip) VALUES
('c1b1d8e83bb8ac00a9c544d8f4a55bb2',
'wiki_user|O:10:\&quot;_adminuser\&quot;:11:{s:7:\&quot;_userid\&quot;;s:5:\
&quot;admin\&quot;;s:6:\&quot;_level\&quot;;i:10;s:6:\&quot;_prefs\&quot;;O:
15:\&quot;userpreferences\&quot;:4:{s:6:\&quot;_prefs\&quot;;a:14:{s:6:\&quo
t;userid\&quot;;O:15:\&quot;_userpreference\&quot;:2:{s:13:\&quot;default_va
lue\&quot;;s:0:\&quot;\&quot;;s:6:\&quot;userid\&quot;;s:5:\&quot;admin\&quo
t;;}s:6:\&quot;passwd\&quot;;O:15:\&quot;_userpreference\&quot;:1:{s:13:\&qu
ot;default_value\&quot;;s:0:\&quot;\&quot;;}s:9:\&quot;autologin\&quot;;O:20
:\&quot;_userpreference_bool\&quot;:1:{s:13:\&quot;default_value\&quot;;b:0;
}s:5:\&quot;email\&quot;;O:21:\&quot;_userpreference_email\&quot;:1:{s:13:\&
quot;default_value\&quot;;s:0:\&quot;\&quot;;}s:11:\&quot;notifyPages\&quot;
;O:22:\&quot;_userpreference_notify\&quot;:1:{s:13:\&quot;default_value\&quo
t;;s:0:\&quot;\&quot;;}s:5:\&quot;theme\&quot;;O:21:\&quot;_userpreference_t
heme\&quot;:1:{s:13:\&quot;default_value\&quot;;s:4:\&quot;Crao\&quot;;}s:4:
\&quot;lang\&quot;;O:24:\&quot;_userpreference_language\&quot;:1:{s:13:\&quo
t;default_value\&quot;;s:0:\&quot;\&quot;;}s:9:\&quot;editWidth\&quot;;O:19:
\&quot;_userpreference_int\&quot;:3:{s:13:\&quot;default_value\&quot;;d:80
</p>
</div>

To get the internal library to work, I had to delete this row before trying
to create the pdf.

Any suggestions on how to get the external one to work, and to get rid of
that error?

Thanks,

John

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

[Phpwiki-talk] How to automatic logout from wiki

[Stefan <son...@ba...>]

Hallo,

there is a bug in phpwiki where users can edit pages without showing 
there userid.
Now i need a solution to log users out which do not have a userid. it 
should be done automatic like a call like these

$user->logout();

i want to add the function within a template file. Is there a function 
to do this?

Background:
When you login as a user in phpwiki and then click on the back button of 
your browser to get a page where you are not authentificated and then 
press the login button, you are authentificated without userid.

Whould be nice to get a fast solution for this
Regards Stefan

Re: [Phpwiki-talk] Few questions on phpwiki setup.

[Oliver B. <li...@gm...>]

Reini Urban wrote:

[mkdir(/tmp/cache/toolbarcache/): Permission denied]

> For optimization you'd need to define the PLUGIN_CACHED_CACHE_DIR
> option (section 8), where cached settings are stored.
> 
> ; This is only used if database is set to file.

database is dba/gdbm, not file, so I didn't think this could help - 
but it did.

Thanks, Reini!

Oliver
-- 
Oliver Betz, Muenchen

Re: [Phpwiki-talk] Phpwiki and Mysql slowness

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

In PhpWikiAdministration:
  ZIP Dump - Restore

The "Zip Dump" best as full dump to keep all revisions.

2007/1/16, John Cole <joh...@ua...>:
> Reini,
>  If I wanted to convert my wiki from mysql to postgres, what would the
> procedures be?
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of Reini Urban
> Sent: Saturday, January 13, 2007 11:31 AM
> To: Discussion on PhpWiki features, bugs, development.
> Subject: Re: [Phpwiki-talk] Phpwiki and Mysql slowness
>
> 2007/1/12, Manuel Vacelet <man...@gm...>:
> > 2007/1/9, Reini Urban <ru...@x-...>:
> > > 2007/1/8, Manuel Vacelet <man...@gm...>:
> > > > I noticed than, sometimes, mysql based phpwikis become slow when there
> > > > are several concurrent access.
> > > >
> > > > I guess it's due to table locking for update operation (phpwiki locks
> > > > whole table).
> > > >
> > > > I'm wondering if it could be a good idea to use innodb table type when
> > > > available and replace table locks by transactions as other ACID
> > > > complient engines (pgsql, ...) do ?
> > >
> > > postgresql, oracle or innodb are much better than myisam on crowded
> > > servers, yes.
> >
> > Ok, we will have look on this approach.
> > Obviously, we will keep the list informed.
>
> The fastest connect by far has berkeley ("dba - db3 or db4"), but time
> sorting
> (e.g. RecentChanges) and other advanced queries are very slow.
> I recommend dba on small wikis < 500 pages, and then postgresql.
> Both, ADODB and PearDB behave fine now. PDO is not that well tested.
> dba has serious locking issues with sessions.
> >From time to time you'll have to delete the session.db(3,4) file when
> it is OS locked. But still better than with gdbm.
>
> For the next release I will work for sql db's on extracting the standard
> page and version data properties from serialized blobs into real
> table columns.
> This will require more sql schema updates, but I hope action=upgrade
> will be good enough to do that automatically.
>
> > > BTW: can I expect an updated french translation for the new 1.3.13
> features?
> >
> > I think Sabri (who's working with me on the subject) already gave to
> > you the small work he did on the subject.
>
> Thanks.
> I checked it in and will do the 1.3.13 release after the remaining
> php-5.2.0 checks hopefully tommorrow.
>
> The new 5.2 constructor strictness or the new __toString method can be
> the culprit.
>
> Next week I'll be offline in Koeln for some days.

well, I'm not really offline, thanksfully.
but I cannot do the final release from here.

-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

Re: [Phpwiki-talk] Phpwiki and Mysql slowness

[John C. <joh...@ua...>]

Reini,
  If I wanted to convert my wiki from mysql to postgres, what would the
procedures be?

Thanks,

John

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Reini Urban
Sent: Saturday, January 13, 2007 11:31 AM
To: Discussion on PhpWiki features, bugs, development.
Subject: Re: [Phpwiki-talk] Phpwiki and Mysql slowness

2007/1/12, Manuel Vacelet <man...@gm...>:
> 2007/1/9, Reini Urban <ru...@x-...>:
> > 2007/1/8, Manuel Vacelet <man...@gm...>:
> > > I noticed than, sometimes, mysql based phpwikis become slow when there
> > > are several concurrent access.
> > >
> > > I guess it's due to table locking for update operation (phpwiki locks
> > > whole table).
> > >
> > > I'm wondering if it could be a good idea to use innodb table type when
> > > available and replace table locks by transactions as other ACID
> > > complient engines (pgsql, ...) do ?
> >
> > postgresql, oracle or innodb are much better than myisam on crowded
> > servers, yes.
>
> Ok, we will have look on this approach.
> Obviously, we will keep the list informed.

The fastest connect by far has berkeley ("dba - db3 or db4"), but time
sorting
(e.g. RecentChanges) and other advanced queries are very slow.
I recommend dba on small wikis < 500 pages, and then postgresql.
Both, ADODB and PearDB behave fine now. PDO is not that well tested.
dba has serious locking issues with sessions.
>From time to time you'll have to delete the session.db(3,4) file when
it is OS locked. But still better than with gdbm.

For the next release I will work for sql db's on extracting the standard
page and version data properties from serialized blobs into real
table columns.
This will require more sql schema updates, but I hope action=upgrade
will be good enough to do that automatically.

> > BTW: can I expect an updated french translation for the new 1.3.13
features?
>
> I think Sabri (who's working with me on the subject) already gave to
> you the small work he did on the subject.

Thanks.
I checked it in and will do the 1.3.13 release after the remaining
php-5.2.0 checks hopefully tommorrow.

The new 5.2 constructor strictness or the new __toString method can be
the culprit.

Next week I'll be offline in Koeln for some days.
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Phpwiki-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

Re: [Phpwiki-talk] Few questions on phpwiki setup.

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

2007/1/14, Oliver Betz <li...@gm...>:
> George Mills wrote:
>
> [...]
>
> > /usr/local/lib/php/Cache/Container/file.php:339: Warning:
> > mkdir(/tmp/cache/toolbarcache/): Permission denied
>
> any information about this?
>
> I also see this error but didn't take the time to look at the code
> since I casn live with it.

For optimization you'd need to define the PLUGIN_CACHED_CACHE_DIR
option (section 8), where cached settings are stored.

; This is only used if database is set to file.
; The webserver must have write access to this dir!
;PLUGIN_CACHED_CACHE_DIR = /tmp/cache

The server cannot write to /tmp/cache/toolbarcache/
This is needed to speed up action=edit.
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

Re: [Phpwiki-talk] Few questions on phpwiki setup.

[Oliver B. <li...@gm...>]

George Mills wrote:

[quoting order and line breaks adjusted)

>>> /usr/local/lib/php/Cache/Container/file.php:339: Warning:
>> mkdir(/tmp/cache/toolbarcache/): Permission denied
>> any information about this?

> I worked around it see my post here
>  
> http://sourceforge.net/forum/forum.php?thread_id=1648805&forum_id=18929

this doesn't mention the "mkdir(/tmp/cache/toolbarcache/): Permission 
denied" error but an upload problem.

Oliver
-- 
Oliver Betz, Muenchen

Re: [Phpwiki-talk] Few questions on phpwiki setup.

[George M. <ms...@ho...>]

I worked around it see my post here
=20
http://sourceforge.net/forum/forum.php?thread_id=3D1648805&forum_id=3D18929



> From: li...@gm...> To: php...@li...> Date: Sun,=
 14 Jan 2007 12:11:20 +0100> Subject: Re: [Phpwiki-talk] Few questions on p=
hpwiki setup.> > George Mills wrote:> > [...]> > > /usr/local/lib/php/Cache=
/Container/file.php:339: Warning:> > mkdir(/tmp/cache/toolbarcache/): Permi=
ssion denied > > any information about this?> > I also see this error but d=
idn't take the time to look at the code > since I casn live with it.> > Oli=
ver> -- > Oliver Betz, Muenchen> > > --------------------------------------=
-----------------------------------> Take Surveys. Earn Cash. Influence the=
 Future of IT> Join SourceForge.net's Techsay panel and you'll get the chan=
ce to share your> opinions on IT & business topics through brief surveys - =
and earn cash> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourc=
eforge&CID=3DDEVDEV> _______________________________________________> Phpwi=
ki-talk mailing list> Php...@li...> https://lists.sou=
rceforge.net/lists/listinfo/phpwiki-talk
_________________________________________________________________
Fixing up the home? Live Search can help.
http://imagine-windowslive.com/search/kits/default.aspx?kit=3Dimprove&local=
e=3Den-US&source=3Dwlmemailtaglinenov06=

Re: [Phpwiki-talk] Few questions on phpwiki setup.

[Oliver B. <li...@gm...>]

George Mills wrote:

[...]

> /usr/local/lib/php/Cache/Container/file.php:339: Warning:
> mkdir(/tmp/cache/toolbarcache/): Permission denied 

any information about this?

I also see this error but didn't take the time to look at the code 
since I casn live with it.

Oliver
-- 
Oliver Betz, Muenchen

[Phpwiki-talk] 1.3.13rc1 release candiate uploaded

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

When final testing tommorrow goes well I will release this
as final 1.3.13:

http://sourceforge.net/project/showfiles.php?group_id=6121&package_id=31289&release_id=478264

I found and fixed the php-5.2 problem.
Some minor issues I see are the actionbuttons with mozilla and MonoBook. 
The selected and hover tabbar underline is suddenly wrong.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/

Re: [Phpwiki-talk] Phpwiki and Mysql slowness

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

2007/1/12, Manuel Vacelet <man...@gm...>:
> 2007/1/9, Reini Urban <ru...@x-...>:
> > 2007/1/8, Manuel Vacelet <man...@gm...>:
> > > I noticed than, sometimes, mysql based phpwikis become slow when there
> > > are several concurrent access.
> > >
> > > I guess it's due to table locking for update operation (phpwiki locks
> > > whole table).
> > >
> > > I'm wondering if it could be a good idea to use innodb table type when
> > > available and replace table locks by transactions as other ACID
> > > complient engines (pgsql, ...) do ?
> >
> > postgresql, oracle or innodb are much better than myisam on crowded
> > servers, yes.
>
> Ok, we will have look on this approach.
> Obviously, we will keep the list informed.

The fastest connect by far has berkeley ("dba - db3 or db4"), but time sorting
(e.g. RecentChanges) and other advanced queries are very slow.
I recommend dba on small wikis < 500 pages, and then postgresql.
Both, ADODB and PearDB behave fine now. PDO is not that well tested.
dba has serious locking issues with sessions.
>From time to time you'll have to delete the session.db(3,4) file when
it is OS locked. But still better than with gdbm.

For the next release I will work for sql db's on extracting the standard
page and version data properties from serialized blobs into real
table columns.
This will require more sql schema updates, but I hope action=upgrade
will be good enough to do that automatically.

> > BTW: can I expect an updated french translation for the new 1.3.13 features?
>
> I think Sabri (who's working with me on the subject) already gave to
> you the small work he did on the subject.

Thanks.
I checked it in and will do the 1.3.13 release after the remaining
php-5.2.0 checks hopefully tommorrow.

The new 5.2 constructor strictness or the new __toString method can be
the culprit.

Next week I'll be offline in Koeln for some days.
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

Re: [Phpwiki-talk] Phpwiki and Mysql slowness

[Manuel V. <man...@gm...>]

2007/1/9, Reini Urban <ru...@x-...>:
> 2007/1/8, Manuel Vacelet <man...@gm...>:
> > Hello all,
> >
> > I noticed than, sometimes, mysql based phpwikis become slow when there
> > are several concurrent access.
> >
> > I guess it's due to table locking for update operation (phpwiki locks
> > whole table).
> >
> > I'm wondering if it could be a good idea to use innodb table type when
> > available and replace table locks by transactions as other ACID
> > complient engines (pgsql, ...) do ?
>
> postgresql, oracle or innodb are much better than myisam on crowded
> servers, yes.

Ok, we will have look on this approach.
Obviously, we will keep the list informed.

> BTW: can I expect an updated french translation for the new 1.3.13 features?

I think Sabri (who's working with me on the subject) already gave to
you the small work he did on the subject.

-- Manuel

Re: [Phpwiki-talk] Phpwiki and Mysql slowness

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

2007/1/8, Manuel Vacelet <man...@gm...>:
> Hello all,
>
> I noticed than, sometimes, mysql based phpwikis become slow when there
> are several concurrent access.
>
> I guess it's due to table locking for update operation (phpwiki locks
> whole table).
>
> I'm wondering if it could be a good idea to use innodb table type when
> available and replace table locks by transactions as other ACID
> complient engines (pgsql, ...) do ?

postgresql, oracle or innodb are much better than myisam on crowded
servers, yes.

BTW: can I expect an updated french translation for the new 1.3.13 features?

> What do you think ?
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

[Phpwiki-talk] Phpwiki and Mysql slowness

[Manuel V. <man...@gm...>]

Hello all,

I noticed than, sometimes, mysql based phpwikis become slow when there
are several concurrent access.

I guess it's due to table locking for update operation (phpwiki locks
whole table).

I'm wondering if it could be a good idea to use innodb table type when
available and replace table locks by transactions as other ACID
complient engines (pgsql, ...) do ?

What do you think ?

-- Manuel

[Phpwiki-talk] Few questions on phpwiki setup.

[George M. <ms...@ho...>]

My server is a shared provider so I must configure everything through FTP a=
nd I believe my scripts have no write access to /tmp

How to set security such that anyone can create an account and view all pag=
es but not be allowed to edit by default. I wish only "super users" (i.e. a=
dmins or what ever) to be able to grant permission to others to edit?
How to remove clear text password on MySQL DB connection DSN string? Can't =
figure out how to crypt it.=20
How can I get EMail Validation as a requirement for an account?=20
Why does phpwiki require dba privs for normal operation (If I just grant re=
ad/write it fails)?=20
I can't get rid of PHP /tmp write warning while editing. See below.

PHP Warning

/usr/local/lib/php/Cache/Container/file.php:339: Warning: mkdir(/tmp/cache/=
toolbarcache/): Permission denied=20
=20
=20
Thanks for any help.
=20
_________________________________________________________________
Get into the holiday spirit, chat with Santa on Messenger.
http://imagine-windowslive.com/minisites/santabot/default.aspx?locale=3Den-=
us=

Re: [Phpwiki-talk] 1.3.13 soon out

[Matt B. <ma...@ma...>]

Hi Reini,

Reini Urban wrote:

> All new bugs (from August) by Matt Brown (debian).
> Matt, do you want to cvs write access to fix these by your own?
> This would be much faster.

Sorry for my slow response, I've been away on holiday :)

Commit access would be appreciated, although I'm not sure that I'll have
any time to look at these again until late January...

Cheers

--=20
Matt Brown
ma...@ma...
Mob +64 21 611 544 www.mattb.net.nz

Re: [Phpwiki-talk] 1.3.13 soon out

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

2006/12/30, Reini Urban <ru...@x-...>:
> Some good news to my release plan:
> Clean-house development without internet connection here in morrocco
> works that good, that I already finished my 1.4.0 plans also.
>
> moacdropdown is now fully integrated into WikiFormRich.
> xmlrpc support was written from scratch,
> and the search template will feature the LiveSearch via xmlrpc.
> SemanticSearch also.
>
> I added a lot of more useful xmlrpc methods and a seperate
> XmlRpcClient library. Now we have one in php and one in javascript for
> the ajax methods.
> I also tried to add a file post method to HttpClient.php for SyncWiki
> (see below), to be able to upload to remote servers automatically.
>
> I have added a plugin SyncWiki to update automatically from/to a
> master replication wiki. For some offline work.
>
> MonoBook looks even better.
>
> upgrade now supports the 1.3.13 necessary updates and stores a
> db_version marker. This will speed up things. db->rebuild now really
> rebuild the whole database. this lasts a lot.
>
> WikiWys still has some problems, with roundtrips and with prettyurl setups.
> I hope that I can fix that by myself. Plugins args get distorted.
>
> The next will be ModeratedPages.
>
> Unfortunately I will not be able to commit all this work from here.

Well, I just did. (committing the work from here)
Those who read phpwiki-commit will have noticed :)

Please test the nightly from tomorrow.
Some Help:*Plugin pages and ModeratedPages plugin need work.
But esp. the new SemanticSearch is cool.
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

Re: [Phpwiki-talk] CreateToc not createing a Table Of Contents

[Peter C. <pe...@pe...>]

> Sorry, i am just in morocco on a surf trip and will be back at the
> 10th of january.

!  Well get back to surfing and don't worry about the wiki!

> CreateToc has one option in  config.ini which you can try to switch.
>

That has no effect.

> Did your php version change?

No.

Pete

Re: [Phpwiki-talk] 1.3.13 soon out

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

Some good news to my release plan:
Clean-house development without internet connection here in morrocco
works that good, that I already finished my 1.4.0 plans also.

moacdropdown is now fully integrated into WikiFormRich.
xmlrpc support was written from scratch,
and the search template will feature the LiveSearch via xmlrpc.
SemanticSearch also.

I added a lot of more useful xmlrpc methods and a seperate
XmlRpcClient library. Now we have one in php and one in javascript for
the ajax methods.
I also tried to add a file post method to HttpClient.php for SyncWiki
(see below), to be able to upload to remote servers automatically.

I have added a plugin SyncWiki to update automatically from/to a
master replication wiki. For some offline work.

MonoBook looks even better.

upgrade now supports the 1.3.13 necessary updates and stores a
db_version marker. This will speed up things. db->rebuild now really
rebuild the whole database. this lasts a lot.

WikiWys still has some problems, with roundtrips and with prettyurl setups.
I hope that I can fix that by myself. Plugins args get distorted.

The next will be ModeratedPages.

Unfortunately I will not be able to commit all this work from here.

2006/12/21, Reini Urban <ru...@x-...>:
> Sorry, I cannot hold my deadline.
> At least I found some more severy problems, and installed it at a
> lot more servers than previously.
>
> Loading virgin pages with a charset different to latin1 will most likely
> destroy the database (pagename problems).
> With dba and utf-8 for example it's impossible to search for pages and
> list all pages. On redhat with an utf-8 system charset ($LANG) it is
> enough to
> disable all these features regardless of the phpwiki charset.
>
> There's an easy fix, but a lot of work.
> Similar for the new WikiWys.
> The php-5.1x session lossage is also a blocking problem not yet solved.
>
> So I will try to get it out in the middle of January.
>
> 2006/12/18, umfan866 <mh...@so...>:
> >
> > Reini--
> >
> > I downloaded the nightly build and started to install it but the main
> > problem I have
> > is that I have an internal company deadline for this week Friday (dec 22) to
> > roll something
> > else out...as soon as I have that deadline met I will return to testing
> > phpwiki... I
> > am checking to see if another person can also test/investigate in the
> > meantime,
> > as it appears your deadline is the 21st.
> >
> > I appreciate all your work and I LOVE phpwiki -- keep up the great work!!!!
> >
> >
> > Reini Urban wrote:
> > >
> > > 2006/12/12, umfan866 <mh...@so...>:
> > >> Hi Reini --glad version 1.3.13 is almost out. I am willing to test an
> > >> advance
> > >> copy
> > >> with Oracle just send me an email.
> > >
> > > Please take the nightly snapshot.
> > > http://phpwiki.sf.net/nightly/
> > >
> > > During testing I found some more blocking bugs, which I haven't solved
> > > yet.
> > > htmldump, and more.
> > > And right now i'm in munich, so I will try to fix them this weekend,
> > > when I'm back.
> > >
> > > I have v 1.3.12.p3 working right now
> > >> using
> > >> both MySQL and Oracle 10.2.0.2 (with minor hacks). The DATABASE_DSN
> > >> needs to be in the form of "oci8://phpwiki:<phpwiki_passwd>@<ORACLE_SID>"
> > >> perhaps you can update this in the config-default.ini.
> > >>
> > >> I have it working fine using DATABASE_TYPE=SQL and the minor hacks to
> > >> some
> > >> of the other files (see other thread).
> > >>
> > >> I know ADODB is "better" but  If you set it to ADODB, it gives this
> > >> error.
> > >> lib/WikiDB/adodb/adodb-errorhandler.inc.php:76: Error[256]: oci8 error:
> > >> [911: ORA-00911: invalid character] in EXECUTE("UPDATE phpwiki_page SET
> > >> hits=?, pagedata=? WHERE pagename=?")
> > >>
> > >>
> > >>
> > >>
> > >> Reini Urban wrote:
> > >> >
> > >> > I've finished now most of the fixes for 1.3.13.
> > >> > My plan is to bring out a release candidate at the end of this week,
> > >> > (Dec 9) and the final week after. (Dec 16)
> > >> > My own big phpwiki project goes online at about the same date and I
> > >> want
> > >> > to go to holidays at about Dec 21.
> > >> >
> > >> > This was/is the TODO list for 1.3.13 (now also in CVS)
> > >> >
> > >> > * bring 1.3.x to sf.net again. request loops, proxy issues?
> > >> >
> > >> > TODO for 1.3.13:
> > >> > * fix postgresql WARNING: there is no transaction in progress (done)
> > >> > * format=printable (not terribly important)
> > >> > * WatchPage, WatchList or back out Watch from Monobook
> > >> > * finish ModeratedPages (hmm...)
> > >> > * FileInfoPlugin (done)
> > >> > * add Help: and Relation: interwiki map entries. (done)
> > >> > * via upgrade also
> > >> > * add Help/ prefix to all documention pages, via upgrade also. (done)
> > >> >
> > >> > Open issues:
> > >> > - #1569424 Is Oracle ok now with ADODB? I believe pear db is too
> > >> broken.
> > >> >    Just the Oracle specific to_date workaround is required.
> > >> > - #1570577 "Wikiwyg wrong charset" Convenience
> > >> >
> > >> > All new bugs (from August) by Matt Brown (debian).
> > >> > Matt, do you want to cvs write access to fix these by your own?
> > >> > This would be much faster.

-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

Re: [Phpwiki-talk] CreateToc not createing a Table Of Contents

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

2006/12/28, Peter Chant <pe...@pe...>:
> I've added <?plugin CreateToc ?> to the home directory of a wiki I have
> created using phpwiki to store useful reference information.  Originally the
> CreateToc plugin produced an index based on the names of the various pages I
> created.  It no longer does so, even if I revert to versions of the home page
> that worked earlier.  I've tried cleaning things up using the admin tools but
> it still does not work.
>
> Any suggestions?

Sorry, i am just in morocco on a surf trip and will be back at the
10th of january.
CreateToc has one option in  config.ini which you can try to switch.

Did your php version change?
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

Re: [Phpwiki-talk] Username/Password Trouble with newly-installed phpWiki

[Phil C. <ph...@ph...>]

Cory McConnell inscribed the following text on 28/12/2006 20:30:
> I recently installed phpWiki through Fantastico, which is provided by 
> my host--SiteGround. 
>
> It requests that you create a username/password for admin before 
> installation which I did.
>
> It even sends an email containing that same username/password.
>
> But upon trying to enter this username/password combination when 
> logging into the admin area, it doesn't recognize it.

This is the same problem that I had about a month ago or so...  The 
problem is that your host is probably, like mine, running PHP as a CGI 
script rather than as an apache handler.  This means that the variables 
used in the 'login' are not present. 

Reini made a suggestion: "Use $_ENV instead of $_SERVER", but I've not 
been able to verify if that does solve the problem or not...

Phil