phpwiki-talk

Re: [Phpwiki-talk] upload log file not writable

[Sabri L. <sab...@st...>]

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.

[Phpwiki-talk] Fwd: User Authentication

[Alastair W. <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

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

Re: [Phpwiki-talk] import a CHM or a set of folders to Wiki ?

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

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/

[Phpwiki-talk] upload log file not writable

[Harold H. <ha...@ha...>]

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!

[Phpwiki-talk] import a CHM or a set of folders to Wiki ?

[mcb_34 <mar...@ub...>]

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.

Re: [Phpwiki-talk] compare text with diff

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

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

Re: [Phpwiki-talk] User Authentication

[Alastair W. <lis...@al...>]

 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

[Phpwiki-talk] compare text with diff

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

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

Re: [Phpwiki-talk] User Authentication

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

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/

Re: [Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

[Morgan A. <mak...@ma...>]

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/

Re: [Phpwiki-talk] User Authentication

[Alastair W. <lis...@al...>]

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

Re: [Phpwiki-talk] User Authentication

[Marek L. <Mar...@ao...>]

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

Re: [Phpwiki-talk] User Authentication

[Alastair W. <lis...@al...>]

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

Re: [Phpwiki-talk] User Authentication

[Marek L. <Mar...@ao...>]

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

Re: [Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

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

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/

[Phpwiki-talk] User Authentication

[Alastair W. <ma...@aw...>]

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

Re: [Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

[Morgan A. <mak...@ma...>]

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/

[Phpwiki-talk] Newbie in German

[Lothar, G. <Lot...@ED...>]

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.5/1058 - Release Date: 08.10.2007 =
16:54

Re: [Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

[Morgan A. <mak...@ma...>]

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?

Morgan Aldridge
--
mo...@ma...
http://www.makkintosshu.com/

Re: [Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

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

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".


2007/10/9, Morgan Aldridge <mak...@ma...>:
> I've inherited a PhpWiki installation running on Mac OS X 10.4.10
> (Tiger) Server with its default installation of PHP 4.4.7 & MySQL
> 4.1.22.
>
> Unfortunately, the previous owner either checked it from a version
> control repository or stripped out all documentation regarding the
> version number, so I don't know exactly which version it's running.
> Judging by features and dates I'm guessing it's definitely a 1.3.x
> release, probably 1.3.9 or later.

no, it is more likely 1.3.7 or earlier.

> However, I dropped the config file & pages directory into 1.3.14 and
> I get the following error when trying to run ?action=upgrade:
>
> ---
>
> check for necessary database updates - SQL
> db version: we want 1030.14
> db version: we have 0
> Backend type: mysql
>
> check for table session ...MISSING ...
> Fatal Error:
> 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"
>
> Notice: "Undefined variable: session_tbl"
>
> ---
>
> Is this likely a 1.3.9 or 1.3.7 installation and I need to redo the
> config.ini and manually modify the MySQL database?
>
> Any suggestions as to how to get this upgraded to 1.3.14 would be
> greatly appreciated.
>
> Sincerely,
>
> Morgan Aldridge
> --
> mo...@ma...
> http://www.makkintosshu.com/
>
>
> -------------------------------------------------------------------------
> 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://spacemovie.mur.at/   http://helsinki.at/

[Phpwiki-talk] MySQL Errors upgrading to PhpWiki 1.3.14

[Morgan A. <mak...@ma...>]

I've inherited a PhpWiki installation running on Mac OS X 10.4.10  
(Tiger) Server with its default installation of PHP 4.4.7 & MySQL  
4.1.22.

Unfortunately, the previous owner either checked it from a version  
control repository or stripped out all documentation regarding the  
version number, so I don't know exactly which version it's running.  
Judging by features and dates I'm guessing it's definitely a 1.3.x  
release, probably 1.3.9 or later.

However, I dropped the config file & pages directory into 1.3.14 and  
I get the following error when trying to run ?action=upgrade:

---

check for necessary database updates - SQL
db version: we want 1030.14
db version: we have 0
Backend type: mysql

check for table session ...MISSING ...
Fatal Error:
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"

Notice: "Undefined variable: session_tbl"

---

Is this likely a 1.3.9 or 1.3.7 installation and I need to redo the  
config.ini and manually modify the MySQL database?

Any suggestions as to how to get this upgraded to 1.3.14 would be  
greatly appreciated.

Sincerely,

Morgan Aldridge
--
mo...@ma...
http://www.makkintosshu.com/

Re: [Phpwiki-talk] About escaping words and urls

[Sabri L. <sab...@st...>]

Sabri LABBENE wrote:
>Hi all,
>I need to make strings I escape with '~' character to be 
>displayed with a specific css class.
>I'm searching for the piece of code that decides whether to 
>link or not (escaped strings). Can't find out from where it is done !
>Can any body point me on something ?
>
>This needed in wysiwyg edition mode to know if some words were 
>escaped in order to prefix them with Phpwiki escape char when 
>converting back to wikitext syntax (performing a preview or 
>save action).
>

Any hints ?

Thanks,
-- Sabri.

Re: [Phpwiki-talk] FYI: WikiSym 2007

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

Walter Rafelsberger schrieb:
> WikiSym 2007 International Symposium on Wikis
> http://www.wikisym.org/ws2007/index.html

PhpWiki will be there also:

Tuesday, October 23rd - Collaborative Technologies (10:30 - 12:00)
D. Frankowski et al. Recommenders Everywhere: The WikiLens 
Community-Maintained.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/

[Phpwiki-talk] FYI: WikiSym 2007

[Walter R. <wa...@ra...>]

WikiSym 2007 International Symposium on Wikis
http://www.wikisym.org/ws2007/index.html

lgw

-- 
Researcher
---------------------------------------------------
MODUL University Vienna
Department of New Media Technology
Am Kahlenberg 1
1190 Vienna, Austria
(p) +43 1 320555 520
(f) +43 1 320555 903
(e) wal...@mo...

Re: [Phpwiki-talk] Numbers in wikiwords

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

I also have a new plugin with action page which regenerates the markup cache:

page:_Retransform
<? plugin _Retransform ?>

call it like MyPage?action=_Retransform
change config.ini
MyPage?action=_Retransform

2007/10/1, Sabri LABBENE <sab...@gm...>:
> On 10/1/07, Campo Weijerman <rf...@nl...> wrote:
> > On Mon, Oct 01, 2007 at 03:05:41PM +0200, Sabri LABBENE wrote:
> > > OK, I see.
> > > BTW, did you faced some slowness in document rendering, or any other
> side
> > > effects after changing the regexp aside from having to escape other
> words?
> >
> > I didn't notice anything like that.  Just change it and see what
> > happens--if you don't like it, change it again, or change it back.
>
>
> At the moment, every thing is ok in my wiki. I just wanted to know more
> about your case and if have you have noticed something particular after
> changin the wiki regexp.
>
> > There is one gotcha: when playing with it, I used to open any page in
> > edit mode, then hit Preview to see which words would be rendered as
> > WikiWords.  With 1.3.14 and the MonoBook theme, this now seems to be
> > delayed until the page is finally saved.  Similarly, the effect of
> changing the the regexp will not become obvious immediately.  There may be
> an admin option somewhere that lets you re-generate all pages, I think it's
> called the markup cache.
>
>
> Right. Purging the cached html versions of the pages from admin section will
> regenerate every page from its markup.
>
> Thanks for sharing you experiments.
>
> BR
> -- Sabri.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
>


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