phpwiki-talk Mailing List for PhpWiki (Page 19)

Alastair Weller schrieb:
> I've tried to send this meesage to the sourceforge list but it doesn't
> seem like it got their. Is there a problem or does sourceforge hate
> gmail as much as gmail seems to hate mailing lists?
 From time to time gmail as any other major webmail site is blocked there.
> ---------- Forwarded message ----------
> From: Alastair Weller <lis...@al...>
> Date: 19 Nov 2007 13:48
> Subject: Fwd: [Phpwiki-talk] Fwd: User Authentication
> To: "Discussion on PhpWiki features, bugs, development."
> <php...@li...>
> 
> Have you any idea on how I could move to the MYSQL groups rather than
> CategoryGroups
Sure, I do have. But unfortunately I'm on a business trip in the states 
for the whole week without a lot of computer access.
fill the group table with your names and check out the sql templates.
it should work out of the box.
> ---------- Forwarded message ----------
> From: Alastair Weller <lis...@al... >
> Date: 23 Oct 2007 09:31
> Subject: Re: [Phpwiki-talk] Fwd: User Authentication
> To: "Discussion on PhpWiki features, bugs, development."
> <php...@li... >
> 
> 
> Ok no worries - I'll have a play and follow up in 2 weeks.
> I seem to have sussed the ACL when using CategoryGroups
> 
> Alastair
> 
> On 23/10/2007, Reini Urban <ru...@x-...> wrote:
>> 2007年10月20日, Alastair Weller < lis...@al... >:
>>> I sent this message a few days ago - but it hasn't shown up on the
>>> sourceforge.net Email Archive.
>>> Is the mailing list playing up and does anyone know how to use DB for group
>>> management?
>>>
>>> Alastair
>> I would know, but I'm for the next two weeks on holidays. Sorry.
>>
>>> ---------- Forwarded message ----------
>>> From: Alastair Weller
>>> < lis...@al... >
>>> Date: 17 Oct 2007 18:47
>>> Subject: Re: [Phpwiki-talk] User Authentication
>>> To: "Discussion on PhpWiki features, bugs, development."
>>> < php...@li... >
>>>
>>>
>>>
>>>
>>> I've tried using the CategoryGroup page, and I can get the groups to appear
>>> in the setacl page - but I can't seem to get the acl to work.
>>> Really I want to use the DB option for the groups as well as the users -
>>> that way it will hopefully be a lot easier to manage.
>>>
>>> I'm looking to be running one wiki with mutliple sections ie Company1,
>>> Company2, Org1, Charity1 - most people will only be in one group ie
>>> Company1Group, Company2Group, Org1Group, Charity1Group vut some will be in
>>> more than one (they won't necessarily be administrators either)
>>> I'd then like to define that further, so Company1Group is actualyl
>>> Company1View, Company1Edit, Company1Create etc etc.
>>>
>>> Alastair
>>>
>>>
>>>
>>> On 16/10/2007, Reini Urban < ru...@x-...> wrote:
>>>> Alastair Weller schrieb:
>>>>> I've solved the user issue - however I now can't get my head around
>>>>> the groups issue.
>>>> Do you still need help about the groups?
>>>>
>>>> "CategoryGroup" has this:
>>>>
>>>> All links in this page will be used to find user groups for the
>>>> WIKIPAGE group method. User group pages must contain a list of
>>>> usernames, and then for consistency after four hyphens a link to this
>>>> page.
>>>>
>>>> * [Administrators]
>>>>
>>>> So you have to create the page "Administrators"
>>>> and list the names of users there.
>>>> Like:
>>>>
>>>> * [MyTestUser]
>>>> * [Real Name]
>>>>
>>>>
>>>> and lock the pages.
>> --
>> Reini Urban
>> http://phpwiki.org/ http://murbreak.at/
>> http://spacemovie.mur.at/ http://helsinki.at/
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems? Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>> _______________________________________________
>> Phpwiki-talk mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>>
> 
> 
> 
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://helsinki.at/ http://spacemovie.mur.at/

Reini
Have you any idea on how I could move to the MYSQL groups rather than
CategoryGroups
Alastair
---------- Forwarded message ----------
From: Alastair Weller <lis...@al...>
Date: 23 Oct 2007 09:31
Subject: Re: [Phpwiki-talk] Fwd: User Authentication
To: "Discussion on PhpWiki features, bugs, development." <
php...@li...>
Ok no worries - I'll have a play and follow up in 2 weeks.
I seem to have sussed the ACL when using CategoryGroups
Alastair
 On 23/10/2007, Reini Urban <ru...@x-...> wrote:
>
> 2007年10月20日, Alastair Weller <lis...@al... >:
> > I sent this message a few days ago - but it hasn't shown up on the
> > sourceforge.net Email Archive.
> > Is the mailing list playing up and does anyone know how to use DB for
> group
> > management?
> >
> > Alastair
>
> I would know, but I'm for the next two weeks on holidays. Sorry.
>
> > ---------- Forwarded message ----------
> > From: Alastair Weller
> > < lis...@al... >
> > Date: 17 Oct 2007 18:47
> > Subject: Re: [Phpwiki-talk] User Authentication
> > To: "Discussion on PhpWiki features, bugs, development."
> > < php...@li... >
> >
> >
> >
> >
> > I've tried using the CategoryGroup page, and I can get the groups to
> appear
> > in the setacl page - but I can't seem to get the acl to work.
> > Really I want to use the DB option for the groups as well as the users -
> > that way it will hopefully be a lot easier to manage.
> >
> > I'm looking to be running one wiki with mutliple sections ie Company1,
> > Company2, Org1, Charity1 - most people will only be in one group ie
> > Company1Group, Company2Group, Org1Group, Charity1Group vut some will be
> in
> > more than one (they won't necessarily be administrators either)
> > I'd then like to define that further, so Company1Group is actualyl
> > Company1View, Company1Edit, Company1Create etc etc.
> >
> > Alastair
> >
> >
> >
> > On 16/10/2007, Reini Urban < ru...@x-...> wrote:
> > > Alastair Weller schrieb:
> > > > I've solved the user issue - however I now can't get my head around
> > > > the groups issue.
> > >
> > > Do you still need help about the groups?
> > >
> > > "CategoryGroup" has this:
> > >
> > > All links in this page will be used to find user groups for the
> > > WIKIPAGE group method. User group pages must contain a list of
> > > usernames, and then for consistency after four hyphens a link to this
> > > page.
> > >
> > > * [Administrators]
> > >
> > > So you have to create the page "Administrators"
> > > and list the names of users there.
> > > Like:
> > >
> > > * [MyTestUser]
> > > * [Real Name]
> > >
> > >
> > > and lock the pages.
> --
> Reini Urban
> http://phpwiki.org/ http://murbreak.at/
> http://spacemovie.mur.at/ http://helsinki.at/
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
-- 
P Before you print think about the ENVIRONMENT
-- 
P Before you print think about the ENVIRONMENT

Hi,
FYI
At Triple-I in Graz I attended some talks about NEPOMUK, the social
semantic desktop project. This projekt is more about PIM, but also
very wiki related.
http://nepomuk.semanticdesktop.org
gnowsis is there reference implementation (java)
http://www.gnowsis.org/
Regards,
Walter
-- 
Researcher
---------------------------------------------------
MODUL University Vienna
Department of New Media Technology
Am Kahlenberg 1
1190 Vienna, Austria
(p) +43 (0)1 320 3555-520
(f) +43 (0)1 320 3555-903
(e) wal...@mo...
(w) http://www.modul.ac.at/nmt
(w) http://www.idiom.at

2007年11月19日, Walter Rafelsberger:
> have you seen semantic mediawiki's HALO extension?
> the interface looks promising!
> could be inspiring for further phpwiki development ;)
http://halowiki.ontoprise.de/halowiki/
Yes, the graphical Ontology Browser and Query Interface come close to
what the other semantic toolsets have.
Gardening is also very nice.
http://halowiki.ontoprise.de/halowiki/index.php/Special:Gardening
This is needed for checking the status of the various offline tasks.
With such CPU and
time intensive operations as in semantic extensions or e.g. our
recommendation optimizers
you need some kind of status UI.
But I would rather finish first the exporters (easy) and importers (harder).
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://spacemovie.mur.at/ http://helsinki.at/

hi,
have you seen semantic mediawiki's HALO extension?
the interface looks promising!
could be inspiring for further phpwiki development ;)
regards,
walter

Ok no worries - I'll have a play and follow up in 2 weeks.
I seem to have sussed the ACL when using CategoryGroups
Alastair
On 23/10/2007, Reini Urban <ru...@x-...> wrote:
>
> 2007年10月20日, Alastair Weller <lis...@al...>:
> > I sent this message a few days ago - but it hasn't shown up on the
> > sourceforge.net Email Archive.
> > Is the mailing list playing up and does anyone know how to use DB for
> group
> > management?
> >
> > Alastair
>
> I would know, but I'm for the next two weeks on holidays. Sorry.
>
> > ---------- Forwarded message ----------
> > From: Alastair Weller
> > <lis...@al... >
> > Date: 17 Oct 2007 18:47
> > Subject: Re: [Phpwiki-talk] User Authentication
> > To: "Discussion on PhpWiki features, bugs, development."
> > <php...@li... >
> >
> >
> >
> >
> > I've tried using the CategoryGroup page, and I can get the groups to
> appear
> > in the setacl page - but I can't seem to get the acl to work.
> > Really I want to use the DB option for the groups as well as the users -
> > that way it will hopefully be a lot easier to manage.
> >
> > I'm looking to be running one wiki with mutliple sections ie Company1,
> > Company2, Org1, Charity1 - most people will only be in one group ie
> > Company1Group, Company2Group, Org1Group, Charity1Group vut some will be
> in
> > more than one (they won't necessarily be administrators either)
> > I'd then like to define that further, so Company1Group is actualyl
> > Company1View, Company1Edit, Company1Create etc etc.
> >
> > Alastair
> >
> >
> >
> > On 16/10/2007, Reini Urban <ru...@x-...> wrote:
> > > Alastair Weller schrieb:
> > > > I've solved the user issue - however I now can't get my head around
> > > > the groups issue.
> > >
> > > Do you still need help about the groups?
> > >
> > > "CategoryGroup" has this:
> > >
> > > All links in this page will be used to find user groups for the
> > > WIKIPAGE group method. User group pages must contain a list of
> > > usernames, and then for consistency after four hyphens a link to this
> > > page.
> > >
> > > * [Administrators]
> > >
> > > So you have to create the page "Administrators"
> > > and list the names of users there.
> > > Like:
> > >
> > > * [MyTestUser]
> > > * [Real Name]
> > >
> > >
> > > and lock the pages.
> --
> Reini Urban
> http://phpwiki.org/ http://murbreak.at/
> http://spacemovie.mur.at/ http://helsinki.at/
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
-- 
P Before you print think about the ENVIRONMENT

2007年10月20日, Alastair Weller <lis...@al...>:
> I sent this message a few days ago - but it hasn't shown up on the
> sourceforge.net Email Archive.
> Is the mailing list playing up and does anyone know how to use DB for group
> management?
>
> Alastair
I would know, but I'm for the next two weeks on holidays. Sorry.
> ---------- Forwarded message ----------
> From: Alastair Weller
> <lis...@al... >
> Date: 17 Oct 2007 18:47
> Subject: Re: [Phpwiki-talk] User Authentication
> To: "Discussion on PhpWiki features, bugs, development."
> <php...@li... >
>
>
>
>
> I've tried using the CategoryGroup page, and I can get the groups to appear
> in the setacl page - but I can't seem to get the acl to work.
> Really I want to use the DB option for the groups as well as the users -
> that way it will hopefully be a lot easier to manage.
>
> I'm looking to be running one wiki with mutliple sections ie Company1,
> Company2, Org1, Charity1 - most people will only be in one group ie
> Company1Group, Company2Group, Org1Group, Charity1Group vut some will be in
> more than one (they won't necessarily be administrators either)
> I'd then like to define that further, so Company1Group is actualyl
> Company1View, Company1Edit, Company1Create etc etc.
>
> Alastair
>
>
>
> On 16/10/2007, Reini Urban <ru...@x-...> wrote:
> > Alastair Weller schrieb:
> > > I've solved the user issue - however I now can't get my head around
> > > the groups issue.
> >
> > Do you still need help about the groups?
> >
> > "CategoryGroup" has this:
> >
> > All links in this page will be used to find user groups for the
> > WIKIPAGE group method. User group pages must contain a list of
> > usernames, and then for consistency after four hyphens a link to this
> > page.
> >
> > * [Administrators]
> >
> > So you have to create the page "Administrators"
> > and list the names of users there.
> > Like:
> >
> > * [MyTestUser]
> > * [Real Name]
> >
> >
> > and lock the pages.
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://spacemovie.mur.at/ http://helsinki.at/

Hi all,
I want to know which is the correct function I have to call in order to =
get a create toc plugin markup rendered.
For example:
I have the following in a var:
$plugin =3D '<?plugin CreateToc jshide||=3D0 with_toclink||=3D1 ?>';
Now I need to have the html version of the toc with titles formatted and =
correctly linked/anchored.
I imagine that there is some function I have to call and just pass to it =
the plugin markup to have the html toc. The RichTable plugin for =
instance could be rendered like I described:
Require_once("lib/BlockParser.php");
$xml_table =3D TransformText($plugin, 2.0, $the_pagename);
$html_table =3D $xml_table->AsXML();
Is it possible to have the html toc that way?
Thanks in advance,
-- Sabri.

Harold Hallikainen wrote:
>I'm getting a warning that the upload log file is not 
>writable. I don't see a config setting for this log, but do 
>see some stuff defining it in UpLoad.php . I DID modify 
>UpLoad.php to get uploaded files properly in user directories. 
>The revision I made was:
>
> // $file_dir = getUploadFilePath();
> $file_dir = getUploadFilePath() . '/'; // added 
>slash. hh 9/8/07
Yes, I had the same issue sometimes ago. That slash is indeed missing.
>So, did I mess up the log file location? What do I do to make 
>the log work? I'd suspect the log would be in /var/log/... .
>
-- Sabri.

I sent this message a few days ago - but it hasn't shown up on the
sourceforge.net Email Archive.
Is the mailing list playing up and does anyone know how to use DB for group
management?
Alastair
---------- Forwarded message ----------
From: Alastair Weller <lis...@al...>
Date: 17 Oct 2007 18:47
Subject: Re: [Phpwiki-talk] User Authentication
To: "Discussion on PhpWiki features, bugs, development." <
php...@li...>
 I've tried using the CategoryGroup page, and I can get the groups to appear
in the setacl page - but I can't seem to get the acl to work.
Really I want to use the DB option for the groups as well as the users -
that way it will hopefully be a lot easier to manage.
I'm looking to be running one wiki with mutliple sections ie Company1,
Company2, Org1, Charity1 - most people will only be in one group ie
Company1Group, Company2Group, Org1Group, Charity1Group vut some will be in
more than one (they won't necessarily be administrators either)
I'd then like to define that further, so Company1Group is actualyl
Company1View, Company1Edit, Company1Create etc etc.
Alastair
 On 16/10/2007, Reini Urban <ru...@x-...> wrote:
>
> Alastair Weller schrieb:
> > I've solved the user issue - however I now can't get my head around
> > the groups issue.
>
> Do you still need help about the groups?
>
> "CategoryGroup" has this:
>
> All links in this page will be used to find user groups for the
> WIKIPAGE group method. User group pages must contain a list of
> usernames, and then for consistency after four hyphens a link to this
> page.
>
> * [Administrators]
>
> So you have to create the page "Administrators"
> and list the names of users there.
> Like:
>
> * [MyTestUser]
> * [Real Name]
>
>
> and lock the pages.
> --
> Reini Urban
> http://phpwiki.org/ http://murbreak.at/
> http://helsinki.at/ http://spacemovie.mur.at/
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
-- 
P Before you print think about the ENVIRONMENT
-- 
P Before you print think about the ENVIRONMENT
-- 
P Before you print think about the ENVIRONMENT

2007年10月19日, mcb_34 <mar...@ub...>:
> i've seen tools to convert one html page to wiki. But what if you have more
> than 2000 html pages grouped into a folder and many sub folders ? A CHM file
> is built from these pages.
> But i can't find any way to import a CHM or html pages from a folder.
You convert the html folder pages to a folder with wiki pages - offline.
And then you import the folder in one go.
PhpWikiAdministration#Restore
action=loadfile
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://spacemovie.mur.at/ http://helsinki.at/

I'm getting a warning that the upload log file is not writable. I don't
see a config setting for this log, but do see some stuff defining it in
UpLoad.php . I DID modify UpLoad.php to get uploaded files properly in
user directories. The revision I made was:
 // $file_dir = getUploadFilePath();
 $file_dir = getUploadFilePath() . '/'; // added slash. hh 9/8/07
So, did I mess up the log file location? What do I do to make the log
work? I'd suspect the log would be in /var/log/... .
Thanks!
Harold
-- 
FCC Rules Updated Daily at http://www.hallikainen.com - Advertising
opportunities available!

hi all,
i've seen tools to convert one html page to wiki. But what if you have more
than 2000 html pages grouped into a folder and many sub folders ? A CHM file
is built from these pages.
But i can't find any way to import a CHM or html pages from a folder.
Anyone ? Thanks.
 Marianne
-- 
View this message in context: http://www.nabble.com/import-a-CHM-or-a-set-of-folders-to-Wiki---tf4654076.html#a13297120
Sent from the phpwiki-talk mailing list archive at Nabble.com.

After some try and error it works as follows
//$old = array with one line of text in each array element
$old=array("abcd","defg","zzz");
//$new = array with one line of text in each array element
$new=array("abcd","decg","zzz");
$pagedata = HTML(array());
require_once('lib/diff.php');
$diff = new Diff($old, $new);
$fmt = new HtmlUnifiedDiffFormatter;
$pagedata->pushContent($fmt->format($diff));
return HTML($pagedata);
Thats only for information
Stefan schrieb:
> hello,
>
> can someone tell me how i can use difflib.php the internal phpwiki diff 
> library to compare two kind of text. I need something like
>
> wiki_result_page_in_diff_style = diff($text1,$text2)
>
> whould be happy if someone could help
>
> Stefan
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
>
> 

 I've tried using the CategoryGroup page, and I can get the groups to appear
in the setacl page - but I can't seem to get the acl to work.
Really I want to use the DB option for the groups as well as the users -
that way it will hopefully be a lot easier to manage.
I'm looking to be running one wiki with mutliple sections ie Company1,
Company2, Org1, Charity1 - most people will only be in one group ie
Company1Group, Company2Group, Org1Group, Charity1Group vut some will be in
more than one (they won't necessarily be administrators either)
I'd then like to define that further, so Company1Group is actualyl
Company1View, Company1Edit, Company1Create etc etc.
Alastair
 On 16/10/2007, Reini Urban <ru...@x-...> wrote:
>
> Alastair Weller schrieb:
> > I've solved the user issue - however I now can't get my head around
> > the groups issue.
>
> Do you still need help about the groups?
>
> "CategoryGroup" has this:
>
> All links in this page will be used to find user groups for the
> WIKIPAGE group method. User group pages must contain a list of
> usernames, and then for consistency after four hyphens a link to this
> page.
>
> * [Administrators]
>
> So you have to create the page "Administrators"
> and list the names of users there.
> Like:
>
> * [MyTestUser]
> * [Real Name]
>
>
> and lock the pages.
> --
> Reini Urban
> http://phpwiki.org/ http://murbreak.at/
> http://helsinki.at/ http://spacemovie.mur.at/
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
-- 
P Before you print think about the ENVIRONMENT
-- 
P Before you print think about the ENVIRONMENT

hello,
can someone tell me how i can use difflib.php the internal phpwiki diff 
library to compare two kind of text. I need something like
wiki_result_page_in_diff_style = diff($text1,$text2)
whould be happy if someone could help
Stefan

Alastair Weller schrieb:
> I've solved the user issue - however I now can't get my head around
> the groups issue.
Do you still need help about the groups?
"CategoryGroup" has this:
All links in this page will be used to find user groups for the
WIKIPAGE group method. User group pages must contain a list of
usernames, and then for consistency after four hyphens a link to this
page.
* [Administrators]
So you have to create the page "Administrators"
and list the names of users there.
Like:
* [MyTestUser]
* [Real Name]
and lock the pages.
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://helsinki.at/ http://spacemovie.mur.at/

On Oct 11, 2007, at 1:11 AM, Reini Urban wrote:
> Just for you now, yes please.
> I remember that lib/upgrade.php had this kind of bug in 1.3.14
>
> function CheckDatabaseUpdate() {
> - global $DBAuthParams;
> + global $DBAuthParams, $DBParams;
>
> Revision 1.60 2007年08月25日 18:43:35 rurban
> add missing DBParams. Detected by Sacha Sch=E4r.
I was starting to feel that I was barking up the wrong tree since it =20
should've found the table I already had, so thanks for that fix! =20
After applying that change I now get a bit further and have the =20
following errors:
---
check for table session ...OK
check for table pref ...OK
check for table member ...OK
Rebuild entire database to upgrade relation links ...
Fatal Error:
lib/WikiDB/backend/PearDB.php:1059 Error: =20
wikidb_backend_peardb_mysql: fatal database error
DB Error: no such field
(INSERT INTO wwn_link (linkfrom, linkto, relation) VALUES (2, 3, 0) =20
[nativecode=3D1054 ** Unknown column 'relation' in 'field list'])
---
Okay, so now my wwn_link table is missing the 'relation' column. Upon =20=
further inspection, the wwn_pref table is missing the 'passwd' & =20
'groupname' columns and the wwn_rating & wwn_accesslog tables are =20
missing (but they appear to be optional, judging by comments in =20
schemas/mysql-initialize.sql).
I've not seen notes in the UPGRADING document regarding changes to =20
the link & pref tables. Should I be able to just add the column and =20
it'll handle it correctly?
Also, does this give any hints as to what version I've got running?
Interestingly, I've got numerous tables without the 'wwn_' prefix =20
(pages, link, pref, etc.) as well, but the data seems to also be in =20
the 'wwn_' prefixed tables, so I think someone must've just left the =20
old tables in there during a previous upgrade.
Thanks in advance for any additional assistance or suggestions you =20
can provide.
Sincerely,
Morgan Aldridge
--
mo...@ma...
http://www.makkintosshu.com/

This is from my config. Comments stripped to save space:
;========================================================================
; Part Three: User Authentication
;========================================================================
ALLOW_ANON_USER = false
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false
ALLOW_USER_PASSWORDS = true
USER_AUTH_ORDER = "Db"
PASSWORD_LENGTH_MINIMUM = 0
USER_AUTH_POLICY = first-only
;Haven't managed to get group auth working otherwise this would be DB.
However group auth config below
GROUP_METHOD = WIKIPAGE
CATEGORY_GROUP_PAGE = CategoryGroup
DBAUTH_AUTH_DSN = "mysql://pwiki_user:pwiki_pass@localhost/pwiki_db"
DBAUTH_AUTH_USER_EXISTS = "SELECT userid FROM pref WHERE userid='$userid'"
DBAUTH_AUTH_CHECK = "SELECT IF(TRIM(passwd)='$password',1,0) AS ok FROM pref
WHERE TRIM(userid)='$userid'"
DBAUTH_AUTH_CHECK = "SELECT IF(TRIM(passwd)=PASSWORD('$password'),1,0) AS ok
FROM pref WHERE TRIM(userid)='$userid'"
DBAUTH_AUTH_UPDATE = "UPDATE pref SET passwd=PASSWORD('$password') WHERE
userid='$userid'"
DBAUTH_PREF_SELECT = "SELECT prefs FROM pref WHERE userid='$userid'"
DBAUTH_PREF_UPDATE = "UPDATE pref SET prefs='$pref_blob' WHERE
userid='$userid'"
DBAUTH_PREF_INSERT = "INSERT INTO pref (userid,prefs) VALUES
('$userid','$pref_blob')"
DBAUTH_IS_MEMBER = "SELECT userid FROM member WHERE userid='$userid' AND
groupname='$groupname'"
DBAUTH_GROUP_MEMBERS = "SELECT DISTINCT userid FROM member WHERE
groupname='$groupname'"
DBAUTH_USER_GROUPS = "SELECT groupname FROM member WHERE userid='$userid'"
I then did an insert through phpMyAdmin to create a new user called
TestUser. When creating the password select PASSWORD from the drop down
menu. If you want to use MD5 or SHA1 you'll have to change your queries
above and.
Hope that helps
Alastair
On 11/10/2007, Marek Lukasik <Mar...@ao...> wrote:
> Hi Alastair,
> How did you solve the user issue?
>
>
> Regards,
> Marek
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> Alastair Weller
> Sent: Thursday, 11 October 2007 4:55 PM
> To: Discussion on PhpWiki features, bugs, development.
> Subject: Re: [Phpwiki-talk] User Authentication
>
> I've solved the user issue - however I now can't get my head around the
> groups issue.
>
> Alastair
>
> On 11/10/2007, Marek Lukasik <Mar...@ao...> wrote:
> > Hi All,
> >
> > Same here, I can't access the WIKI using the admin credentials
> anymore.
> >
> >
> > Regards,
> > Marek
> >
> > -----Original Message-----
> > From: php...@li...
> > [mailto:php...@li...] On Behalf Of
> > Alastair Weller
> > Sent: Wednesday, 10 October 2007 11:55 PM
> > To: php...@li...
> > Subject: [Phpwiki-talk] User Authentication
> >
> > Hi Guys
> >
> > Just setup phpwiki and loving it so far.
> >
> > However one thing I would like to add is user authentication so that
> > only authenticatated users can login and view/edit/created pages and
> > ideally only pages in the groups/categorys there are members of ie if
> > they are in ProjectGroup they only have access to pages under
> > wikiurl/ProjectGroup if they are in ProjectGroup and ClientDetails
> > they have access to wikiurl/ProjectGroup and wikiurl/ClientDetails.
> >
> > I've had a look at the authentication options and tried turning on Db
> > user and group authentication - but it then doesn't let me login as
> > the Admin user. I've also tried to work out how to create users when
> > using the following configuration, to no avail.
> >
> > ALLOW_ANON_USER = false
> > ALLOW_ANON_EDIT = false
> > ALLOW_BOGO_LOGIN = false,
> > ALLOW_USER_PASSWORDS = true.
> >
> > I'm running this on a cpanel server with Apache Apache/1.3.37, PHP
> > 4.4.7 and MYSQL 4.1.22.
> >
> > Many thanks for any help and/or pointers.
> >
> > Alastair
> >
> > --
> > P Before you print think about the ENVIRONMENT
> >
> > ----------------------------------------------------------------------
> > --
> > -
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems? Stop.
> > Now Search log events and configuration files using AJAX and a
> browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Phpwiki-talk mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> >
> > ----------------------------------------------------------------------
> > --- This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems? Stop.
> > Now Search log events and configuration files using AJAX and a
> browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Phpwiki-talk mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> >
>
>
> --
> P Before you print think about the ENVIRONMENT
>
> ------------------------------------------------------------------------
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
-- 
P Before you print think about the ENVIRONMENT

Hi Alastair,
How did you solve the user issue?=20
Regards,
Marek=20
-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
Alastair Weller
Sent: Thursday, 11 October 2007 4:55 PM
To: Discussion on PhpWiki features, bugs, development.
Subject: Re: [Phpwiki-talk] User Authentication
I've solved the user issue - however I now can't get my head around the
groups issue.
Alastair
On 11/10/2007, Marek Lukasik <Mar...@ao...> wrote:
> Hi All,
>
> Same here, I can't access the WIKI using the admin credentials
anymore.
>
>
> Regards,
> Marek
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of=20
> Alastair Weller
> Sent: Wednesday, 10 October 2007 11:55 PM
> To: php...@li...
> Subject: [Phpwiki-talk] User Authentication
>
> Hi Guys
>
> Just setup phpwiki and loving it so far.
>
> However one thing I would like to add is user authentication so that=20
> only authenticatated users can login and view/edit/created pages and=20
> ideally only pages in the groups/categorys there are members of ie if=20
> they are in ProjectGroup they only have access to pages under=20
> wikiurl/ProjectGroup if they are in ProjectGroup and ClientDetails=20
> they have access to wikiurl/ProjectGroup and wikiurl/ClientDetails.
>
> I've had a look at the authentication options and tried turning on Db=20
> user and group authentication - but it then doesn't let me login as=20
> the Admin user. I've also tried to work out how to create users when=20
> using the following configuration, to no avail.
>
> ALLOW_ANON_USER =3D false
> ALLOW_ANON_EDIT =3D false
> ALLOW_BOGO_LOGIN =3D false,
> ALLOW_USER_PASSWORDS =3D true.
>
> I'm running this on a cpanel server with Apache Apache/1.3.37, PHP
> 4.4.7 and MYSQL 4.1.22.
>
> Many thanks for any help and/or pointers.
>
> Alastair
>
> --
> P Before you print think about the ENVIRONMENT
>
> ----------------------------------------------------------------------
> --
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a
browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/=20
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
> ----------------------------------------------------------------------
> --- This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a
browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/=20
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
--
P Before you print think about the ENVIRONMENT
------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Phpwiki-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

I've solved the user issue - however I now can't get my head around
the groups issue.
Alastair
On 11/10/2007, Marek Lukasik <Mar...@ao...> wrote:
> Hi All,
>
> Same here, I can't access the WIKI using the admin credentials anymore.
>
>
> Regards,
> Marek
>
> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...] On Behalf Of
> Alastair Weller
> Sent: Wednesday, 10 October 2007 11:55 PM
> To: php...@li...
> Subject: [Phpwiki-talk] User Authentication
>
> Hi Guys
>
> Just setup phpwiki and loving it so far.
>
> However one thing I would like to add is user authentication so that
> only authenticatated users can login and view/edit/created pages and
> ideally only pages in the groups/categorys there are members of ie if
> they are in ProjectGroup they only have access to pages under
> wikiurl/ProjectGroup if they are in ProjectGroup and ClientDetails they
> have access to wikiurl/ProjectGroup and wikiurl/ClientDetails.
>
> I've had a look at the authentication options and tried turning on Db
> user and group authentication - but it then doesn't let me login as the
> Admin user. I've also tried to work out how to create users when using
> the following configuration, to no avail.
>
> ALLOW_ANON_USER = false
> ALLOW_ANON_EDIT = false
> ALLOW_BOGO_LOGIN = false,
> ALLOW_USER_PASSWORDS = true.
>
> I'm running this on a cpanel server with Apache Apache/1.3.37, PHP
> 4.4.7 and MYSQL 4.1.22.
>
> Many thanks for any help and/or pointers.
>
> Alastair
>
> --
> P Before you print think about the ENVIRONMENT
>
> ------------------------------------------------------------------------
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
-- 
P Before you print think about the ENVIRONMENT

Hi All,
Same here, I can't access the WIKI using the admin credentials anymore.=20
Regards,
Marek=20
-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of
Alastair Weller
Sent: Wednesday, 10 October 2007 11:55 PM
To: php...@li...
Subject: [Phpwiki-talk] User Authentication
Hi Guys
Just setup phpwiki and loving it so far.
However one thing I would like to add is user authentication so that
only authenticatated users can login and view/edit/created pages and
ideally only pages in the groups/categorys there are members of ie if
they are in ProjectGroup they only have access to pages under
wikiurl/ProjectGroup if they are in ProjectGroup and ClientDetails they
have access to wikiurl/ProjectGroup and wikiurl/ClientDetails.
I've had a look at the authentication options and tried turning on Db
user and group authentication - but it then doesn't let me login as the
Admin user. I've also tried to work out how to create users when using
the following configuration, to no avail.
ALLOW_ANON_USER =3D false
ALLOW_ANON_EDIT =3D false
ALLOW_BOGO_LOGIN =3D false,
ALLOW_USER_PASSWORDS =3D true.
I'm running this on a cpanel server with Apache Apache/1.3.37, PHP
4.4.7 and MYSQL 4.1.22.
Many thanks for any help and/or pointers.
Alastair
--
P Before you print think about the ENVIRONMENT
------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Phpwiki-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

Morgan Aldridge schrieb:
> On Oct 9, 2007, at 12:54 PM, Morgan Aldridge wrote:
> 
>> On Oct 9, 2007, at 10:30 AM, Reini Urban wrote:
>>
>>> Try to add the missing tables manually from schemas/mysql-
>>> initialize.sql and
>>> continue then with ?action=upgrade.
>>>
>>> CREATE TABLE session (
>>> 	sess_id 	CHAR(32) NOT NULL DEFAULT '',
>>> 	sess_data 	BLOB NOT NULL,
>>> 	sess_date 	INT UNSIGNED NOT NULL,
>>> 	sess_ip 	CHAR(40) NOT NULL,
>>> 	PRIMARY KEY (sess_id),
>>> 	INDEX (sess_date)
>>> );
>>> and so on.
>>>
>>> The error you get is a php problem, $session_tbl is empty and should
>>> be "session".
>> Interestingly enough, I actually already have a table named
>> 'wwn_session' which MySQL's 'DESCRIBE TABLE' shows matches the format
>> of the above 'CREATE TABLE' command. Looking at the config/config.ini
>> file it appears the I do have 'DATABASE_PREFIX = wwn_' set.
>>
>> I checked config/config-dist.ini and the comments seem to imply that
>> DATABASE_PREFIX is still the correct setting to modify. Is there an
>> issue with the database prefix not being correctly applied in 1.3.14?
> 
> In continuing my investigation, I noticed the following comment on 
> line 465 of lib/upgrade.php:
> 
> 	// 1.3.8 added session.sess_ip
> 
> Now, my 'wwn_session' table does (as it matches the format of the 
> 'CREATE TABLE' SQL query) have a sess_ip column. Does that mean my 
> installation (although unversioned) is probably 1.3.8 or later?
> 
> Also discovered in lib/upgrade.php is that $session_tbl is 
> initialized on line 472 as follows:
> 
> 	$session_tbl = $prefix . $DBParams['db_session_table'];
> 
> But that's the only place it's initialized in the entire file and 
> that's inside the condition that one is running PhpWiki 1030.08 or 
> later.
> 
> In the switch statement starting on line 248, specifically in the 
> 'session' case starting on line 249, $session_tbl doesn't seem to 
> have been initialized before being used on lines 253 & 263 while all 
> the other cases initialize their $<table>_tbl variables (e.g. 
> $pref_tbl, $member_tbl, etc.) in a similar manner as mentioned 
> previously. Here are examples of the $pref_tbl & $member_tbl 
> initialization statements:
> 
> 	$pref_tbl = $prefix.'pref';
> 	
> 	$member_tbl = $prefix.'member';
 extract($this->dbi->_backend->_table_names);
should have initialized $session_tbl.
> This makes sense since the errors I'm getting include "Notice: 
> 'Undefined variable: session_tbl'" as well as a 'CREATE TABLE' SQL 
> query that contains no table name, as follows:
> 
> ---
> 
> lib/WikiDB/backend/PearDB.php:1059 Error: 
> wikidb_backend_peardb_mysql: fatal database error
> 
> DB Error: syntax error
> (
> CREATE TABLE (
> sess_id CHAR(32) NOT NULL DEFAULT '',
> sess_data BLOB NOT NULL,
> sess_date INT UNSIGNED NOT NULL,
> sess_ip CHAR(15) NOT NULL,
> PRIMARY KEY (sess_id),
> INDEX (sess_date)
> ) [nativecode=1064 ** You have an error in your SQL syntax; check the 
> manual that corresponds to your MySQL server version for the right 
> syntax to use near '(
> sess_id CHAR(32) NOT NULL DEFAULT '',
> sess_data BLOB NOT NULL,
> ' at line 1])
> Notice: "Undefined variable: session_tbl"
> 
> ---
> 
> So, should the following be inserted between lines 250 & 251 of lib/ 
> upgrade.php?
> 
> 	$session_tbl = $prefix.'session';
Just for you now, yes please.
I remember that lib/upgrade.php had this kind of bug in 1.3.14
 function CheckDatabaseUpdate() {
- global $DBAuthParams;
+ global $DBAuthParams, $DBParams;
Revision 1.60 2007年08月25日 18:43:35 rurban
 add missing DBParams. Detected by Sacha Schär.
-- 
Reini Urban
http://phpwiki.org/ http://murbreak.at/
http://helsinki.at/ http://spacemovie.mur.at/

Hi Guys
Just setup phpwiki and loving it so far.
However one thing I would like to add is user authentication so that
only authenticatated users can login and view/edit/created pages and
ideally only pages in the groups/categorys there are members of ie if
they are in ProjectGroup they only have access to pages under
wikiurl/ProjectGroup if they are in ProjectGroup and ClientDetails
they have access to wikiurl/ProjectGroup and wikiurl/ClientDetails.
I've had a look at the authentication options and tried turning on Db
user and group authentication - but it then doesn't let me login as
the Admin user. I've also tried to work out how to create users when
using the following configuration, to no avail.
ALLOW_ANON_USER = false
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false,
ALLOW_USER_PASSWORDS = true.
I'm running this on a cpanel server with Apache Apache/1.3.37, PHP
4.4.7 and MYSQL 4.1.22.
Many thanks for any help and/or pointers.
Alastair
-- 
P Before you print think about the ENVIRONMENT

On Oct 9, 2007, at 12:54 PM, Morgan Aldridge wrote:
> On Oct 9, 2007, at 10:30 AM, Reini Urban wrote:
>
>> Try to add the missing tables manually from schemas/mysql-
>> initialize.sql and
>> continue then with ?action=upgrade.
>>
>> CREATE TABLE session (
>> 	sess_id 	CHAR(32) NOT NULL DEFAULT '',
>> 	sess_data 	BLOB NOT NULL,
>> 	sess_date 	INT UNSIGNED NOT NULL,
>> 	sess_ip 	CHAR(40) NOT NULL,
>> 	PRIMARY KEY (sess_id),
>> 	INDEX (sess_date)
>> );
>> and so on.
>>
>> The error you get is a php problem, $session_tbl is empty and should
>> be "session".
>
> Interestingly enough, I actually already have a table named
> 'wwn_session' which MySQL's 'DESCRIBE TABLE' shows matches the format
> of the above 'CREATE TABLE' command. Looking at the config/config.ini
> file it appears the I do have 'DATABASE_PREFIX = wwn_' set.
>
> I checked config/config-dist.ini and the comments seem to imply that
> DATABASE_PREFIX is still the correct setting to modify. Is there an
> issue with the database prefix not being correctly applied in 1.3.14?
In continuing my investigation, I noticed the following comment on 
line 465 of lib/upgrade.php:
	// 1.3.8 added session.sess_ip
Now, my 'wwn_session' table does (as it matches the format of the 
'CREATE TABLE' SQL query) have a sess_ip column. Does that mean my 
installation (although unversioned) is probably 1.3.8 or later?
Also discovered in lib/upgrade.php is that $session_tbl is 
initialized on line 472 as follows:
	$session_tbl = $prefix . $DBParams['db_session_table'];
But that's the only place it's initialized in the entire file and 
that's inside the condition that one is running PhpWiki 1030.08 or 
later.
In the switch statement starting on line 248, specifically in the 
'session' case starting on line 249, $session_tbl doesn't seem to 
have been initialized before being used on lines 253 & 263 while all 
the other cases initialize their $<table>_tbl variables (e.g. 
$pref_tbl, $member_tbl, etc.) in a similar manner as mentioned 
previously. Here are examples of the $pref_tbl & $member_tbl 
initialization statements:
	$pref_tbl = $prefix.'pref';
	
	$member_tbl = $prefix.'member';
This makes sense since the errors I'm getting include "Notice: 
'Undefined variable: session_tbl'" as well as a 'CREATE TABLE' SQL 
query that contains no table name, as follows:
---
lib/WikiDB/backend/PearDB.php:1059 Error: 
wikidb_backend_peardb_mysql: fatal database error
DB Error: syntax error
(
CREATE TABLE (
sess_id CHAR(32) NOT NULL DEFAULT '',
sess_data BLOB NOT NULL,
sess_date INT UNSIGNED NOT NULL,
sess_ip CHAR(15) NOT NULL,
PRIMARY KEY (sess_id),
INDEX (sess_date)
) [nativecode=1064 ** You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right 
syntax to use near '(
sess_id CHAR(32) NOT NULL DEFAULT '',
sess_data BLOB NOT NULL,
' at line 1])
Notice: "Undefined variable: session_tbl"
---
So, should the following be inserted between lines 250 & 251 of lib/ 
upgrade.php?
	$session_tbl = $prefix.'session';
Morgan Aldridge
--
mo...@ma...
http://www.makkintosshu.com/