phpwiki-talk

[Phpwiki-talk] Problem with phpwiki

[Nick H. <nh...@lu...>]

Greetings,

	I downloaded and installed phpwiki 1.3.4 and when I go to the main page
I get this error:


lib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_mysql:
fatal database error

      * DB Error: unknown error
      * (LOCK TABLES page WRITE,version WRITE,link WRITE,recent
        WRITE,nonempty WRITE [nativecode=3D1044 ** Access denied for user:
        'phpwiki@localhost' to database 'phpwiki'])

lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME


lib/config.php:381: Notice[1024]: The admin password cannot be empty.
Please update your /index.php

I dont understand what is wrong??  I set up a user 'phpwiki' to access
that mysql db like it said in the install docs.  I set my persm in
index.php using this: $DBParams =3D array( 'dbtype' =3D> 'SQL' 'dsn' =3D>
'mysql://phpwiki:<password>@localhost/phpwiki

Yet I still get the error like the DB perms arent set up correctly.  Any
idea on how I might be able to fix this??

Thanks

Nick Hudson

Re: [Phpwiki-talk] Problem with phpwiki

[Philip J. H. <ph...@ho...>]

Are you running mysql version 4.x?  The install instructions have
changed slightly because there are changes in how mysql security works
with locks.  Check the phpwiki main site and search for mysql - someone
has posted the corrected instructions there.  Basically you need to run
some mysql grant commands to permit the phpwiki users to set locks.

P.

On 07/05/03, Nick Hudson wrote:
> Greetings,
> 
> 	I downloaded and installed phpwiki 1.3.4 and when I go to the main page
> I get this error:
> 
> 
> lib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_mysql:
> fatal database error
> 
>       * DB Error: unknown error
>       * (LOCK TABLES page WRITE,version WRITE,link WRITE,recent
>         WRITE,nonempty WRITE [nativecode=1044 ** Access denied for user:
>         'phpwiki@localhost' to database 'phpwiki'])
> 
> lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME
> 
> 
> lib/config.php:381: Notice[1024]: The admin password cannot be empty.
> Please update your /index.php
> 
> I dont understand what is wrong??  I set up a user 'phpwiki' to access
> that mysql db like it said in the install docs.  I set my persm in
> index.php using this: $DBParams = array( 'dbtype' => 'SQL' 'dsn' =>
> 'mysql://phpwiki:<password>@localhost/phpwiki
> 
> Yet I still get the error like the DB perms arent set up correctly.  Any
> idea on how I might be able to fix this??
> 
> Thanks
> 
> Nick Hudson



-- 
Philip J. Hollenback
ph...@po...
http://www.hollenback.net

Re: [Phpwiki-talk] Problem with phpwiki

[Nick H. <nh...@lu...>]

Yeah im running mysql 4.x, I will look there thank for the help.

Nick Hudson


On Sat, 2003-07-05 at 15:23, Philip J. Hollenback wrote:
> Are you running mysql version 4.x?  The install instructions have
> changed slightly because there are changes in how mysql security works
> with locks.  Check the phpwiki main site and search for mysql - someone
> has posted the corrected instructions there.  Basically you need to run
> some mysql grant commands to permit the phpwiki users to set locks.
>=20
> P.
>=20
> On 07/05/03, Nick Hudson wrote:
> > Greetings,
> >=20
> > 	I downloaded and installed phpwiki 1.3.4 and when I go to the main pag=
e
> > I get this error:
> >=20
> >=20
> > lib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_mysql:
> > fatal database error
> >=20
> >       * DB Error: unknown error
> >       * (LOCK TABLES page WRITE,version WRITE,link WRITE,recent
> >         WRITE,nonempty WRITE [nativecode=3D1044 ** Access denied for us=
er:
> >         'phpwiki@localhost' to database 'phpwiki'])
> >=20
> > lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME
> >=20
> >=20
> > lib/config.php:381: Notice[1024]: The admin password cannot be empty.
> > Please update your /index.php
> >=20
> > I dont understand what is wrong??  I set up a user 'phpwiki' to access
> > that mysql db like it said in the install docs.  I set my persm in
> > index.php using this: $DBParams =3D array( 'dbtype' =3D> 'SQL' 'dsn' =
=3D>
> > 'mysql://phpwiki:<password>@localhost/phpwiki
> >=20
> > Yet I still get the error like the DB perms arent set up correctly.  An=
y
> > idea on how I might be able to fix this??
> >=20
> > Thanks
> >=20
> > Nick Hudson
>=20
>=20

Re: [Phpwiki-talk] Problem with phpwiki

[Nick H. <nh...@lu...>]

Ok well that worked I guess, I got the main startup page for the wiki
where it can the commands from the pgsrc directory and it said it was
completed.  Now I have another problem.  I did what the install file
said to do which was create a pages directory and have it put the dbm
file there.  I moved the wiki_pagedb.gdbm file from /tmp to
phpwiki/pages.  I did a chown nobody:root pages and a chmod 755 pages.=20
Now when I try to start the home page I get all the crap on my page, it
looks to be encoded.  If you wish to look here it is
http://www.deepfog.net/phpwiki . =20

Thanks
Nick Hudson



On Sat, 2003-07-05 at 15:37, Nick Hudson wrote:
> Yeah im running mysql 4.x, I will look there thank for the help.
>=20
> Nick Hudson
>=20
>=20
> On Sat, 2003-07-05 at 15:23, Philip J. Hollenback wrote:
> > Are you running mysql version 4.x?  The install instructions have
> > changed slightly because there are changes in how mysql security works
> > with locks.  Check the phpwiki main site and search for mysql - someone
> > has posted the corrected instructions there.  Basically you need to run
> > some mysql grant commands to permit the phpwiki users to set locks.
> >=20
> > P.
> >=20
> > On 07/05/03, Nick Hudson wrote:
> > > Greetings,
> > >=20
> > > 	I downloaded and installed phpwiki 1.3.4 and when I go to the main p=
age
> > > I get this error:
> > >=20
> > >=20
> > > lib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_mysql:
> > > fatal database error
> > >=20
> > >       * DB Error: unknown error
> > >       * (LOCK TABLES page WRITE,version WRITE,link WRITE,recent
> > >         WRITE,nonempty WRITE [nativecode=3D1044 ** Access denied for =
user:
> > >         'phpwiki@localhost' to database 'phpwiki'])
> > >=20
> > > lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME
> > >=20
> > >=20
> > > lib/config.php:381: Notice[1024]: The admin password cannot be empty.
> > > Please update your /index.php
> > >=20
> > > I dont understand what is wrong??  I set up a user 'phpwiki' to acces=
s
> > > that mysql db like it said in the install docs.  I set my persm in
> > > index.php using this: $DBParams =3D array( 'dbtype' =3D> 'SQL' 'dsn' =
=3D>
> > > 'mysql://phpwiki:<password>@localhost/phpwiki
> > >=20
> > > Yet I still get the error like the DB perms arent set up correctly.  =
Any
> > > idea on how I might be able to fix this??
> > >=20
> > > Thanks
> > >=20
> > > Nick Hudson
> >=20
> >=20

RE: [Phpwiki-talk] Problem with phpwiki

[Frank S. <fra...@rn...>]

I'm a bit confused here - if you're using mysql, why are you moving gdbms
around?

Which install instructions did you follow? ./INSTALL or ./doc/INSTALL.mysql?

The ./INSTALL file describes the procedure for installing a gdbm backend,
the default database (if I recall correctly). Seeing as a gdbm is a binary
file, that would explain why you're getting crap on your page.

Which backend do you want to use?

frank

> >>> "nh...@lu..." 07/05/03 22:35 >>>
>
> Ok well that worked I guess, I got the main startup page for the wiki
> where it can the commands from the pgsrc directory and it said it was
> completed.  Now I have another problem.  I did what the install file
> said to do which was create a pages directory and have it put the dbm
> file there.  I moved the wiki_pagedb.gdbm file from /tmp to
> phpwiki/pages.  I did a chown nobody:root pages and a chmod
> 755 pages.
> Now when I try to start the home page I get all the crap on
> my page, it
> looks to be encoded.  If you wish to look here it is
> http://www.deepfog.net/phpwiki .

RE: [Phpwiki-talk] Problem with phpwiki

[Nick H. <nh...@lu...>]

Ok well in that case.  With this install I just used the
doc/INSTALL.mysql file to install phpwiki.  Here are the steps I did.

1: mysqladmin -uuser -ppassword create phpwiki
2: mysql -uuser -ppassword phpwiki
3: GRANT select, insert, update, delete, lock tables
   ON phpwiki.*
   TO phpwiki@localhost
   IDENTIFIED BY 'password';
   ( I am using mysql 4.0.13 )
4: mysql -uuser -ppassword phpwiki <schemas/mysql.sql
5: Edit $DBParams in index.php to reflect your settings.

	a) $DBParams['dbtype'] should be set to 'SQL'.
	b) $DBParams['dsn'] should be set to something like
           'mysql://username:password@host/phpwiki'.
            in the file it was more like this:
            'dsn' =3D> 'mysql://username:password@host/phpwiki'

With doing that and following just the install directions in doc/INSTALL.my=
sql
I get the following error on my webpage, as you can see for yourself at
http://www.deepfog.net/phpwiki


lib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_mysql:
fatal database error

      * DB Error: unknown error
      * (LOCK TABLES page WRITE,version WRITE,link WRITE,recent
        WRITE,nonempty WRITE [nativecode=3D1044 ** Access denied for user:
        'phpwiki@localhost' to database 'phpwiki'])

lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME


lib/config.php:381: Notice[1024]: The admin password cannot be empty.
Please update your /index.php



This is my following the directions in doc/INSTALL.mysql and also the
directions to install on mysql 4.0.x in the FAQ on the webpage.  Both
looked exactly the same except for the fact that I had to set the lock
tables perm.  Also what is weird is that when I set up the perms for the
database I also created a user for the database, phpwiki, well looks
like for some reason the user phpwiki cannot access the database even
though I set up the perms for that user like its telling me to.  As far
as I know I am doing what it says, please let me know if I am doing
anything wrong here.

Thanks

Nick




On Mon, 2003-07-07 at 03:51, Frank Shearar wrote:
> I'm a bit confused here - if you're using mysql, why are you moving gdbms
> around?
>=20
> Which install instructions did you follow? ./INSTALL or ./doc/INSTALL.mys=
ql?
>=20
> The ./INSTALL file describes the procedure for installing a gdbm backend,
> the default database (if I recall correctly). Seeing as a gdbm is a binar=
y
> file, that would explain why you're getting crap on your page.
>=20
> Which backend do you want to use?
>=20
> frank
>=20
> > >>> "nh...@lu..." 07/05/03 22:35 >>>
> >
> > Ok well that worked I guess, I got the main startup page for the wiki
> > where it can the commands from the pgsrc directory and it said it was
> > completed.  Now I have another problem.  I did what the install file
> > said to do which was create a pages directory and have it put the dbm
> > file there.  I moved the wiki_pagedb.gdbm file from /tmp to
> > phpwiki/pages.  I did a chown nobody:root pages and a chmod
> > 755 pages.
> > Now when I try to start the home page I get all the crap on
> > my page, it
> > looks to be encoded.  If you wish to look here it is
> > http://www.deepfog.net/phpwiki .
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

RE: [Phpwiki-talk] Problem with phpwiki

[Frank S. <fra...@rn...>]

(Apologies, Nick, for accidentally replying off-list)

I wasn't quite sure what you were getting at in your point 5, so I hope this
answers your problem:

I changed index.php, commenting out the setting of $DBParams. Instead I have
a small php script that sets up just those values I want changed. I run a
WikiFarm, and this is just the simplest thing to do, in my situation.
Anyway, in that small setup script I have

mysql> select host, user from user where user='wiki';
+-----------+------+
| host      | user |
+-----------+------+
| %         | wiki |
| 127.0.0.1 | wiki |
+-----------+------+

and

$DBParams = array(
   'dbtype'      => 'SQL',
   'dsn'         => 'mysql://wiki@localhost/wiki',
   'timeout'     => 20,
);

I've just checked on my wiki at home (running on FreeBSD), and there I have

mysql> select host, user from user where user='wiki';
+-----------+------+
| host      | user |
+-----------+------+
| %         | wiki |
| localhost | wiki |
+-----------+------+

and

$DBParams = array(
   'dbtype'      => 'SQL',
   'dsn'         => 'mysql://wiki:password@localhost/' . WIKI_NAME,
   'timeout'     => 20,
);

where WIKI_NAME is the database name ('frank' in this case).

In most cases, you'd just set the $DBParams in index.php, of course.

frank

> >>> "nh...@lu..." 07/07/03 12:38 >>>
>
> Ok well in that case.  With this install I just used the
> doc/INSTALL.mysql file to install phpwiki.  Here are the steps I did.
>
> 1: mysqladmin -uuser -ppassword create phpwiki
> 2: mysql -uuser -ppassword phpwiki
> 3: GRANT select, insert, update, delete, lock tables
>    ON phpwiki.*
>    TO phpwiki@localhost
>    IDENTIFIED BY 'password';
>    ( I am using mysql 4.0.13 )
> 4: mysql -uuser -ppassword phpwiki <schemas/mysql.sql
> 5: Edit $DBParams in index.php to reflect your settings.
>
> 	a) $DBParams['dbtype'] should be set to 'SQL'.
> 	b) $DBParams['dsn'] should be set to something like
>            'mysql://username:password@host/phpwiki'.
>             in the file it was more like this:
>             'dsn' => 'mysql://username:password@host/phpwiki'
>
> With doing that and following just the install directions in
> doc/INSTALL.mysql
> I get the following error on my webpage, as you can see for
> yourself at
> http://www.deepfog.net/phpwiki
>
>
> lib/WikiDB/backend/PearDB.php:681: Fatal[256]: wikidb_backend_mysql:
> fatal database error
>
>       * DB Error: unknown error
>       * (LOCK TABLES page WRITE,version WRITE,link WRITE,recent
>         WRITE,nonempty WRITE [nativecode=1044 ** Access
> denied for user:
>         'phpwiki@localhost' to database 'phpwiki'])
>
> lib/config.php:276: Notice[8]: Undefined variable: SCRIPT_NAME
>
>
> lib/config.php:381: Notice[1024]: The admin password cannot be empty.
> Please update your /index.php
>
>
>
> This is my following the directions in doc/INSTALL.mysql and also the
> directions to install on mysql 4.0.x in the FAQ on the webpage.  Both
> looked exactly the same except for the fact that I had to set the lock
> tables perm.  Also what is weird is that when I set up the
> perms for the
> database I also created a user for the database, phpwiki, well looks
> like for some reason the user phpwiki cannot access the database even
> though I set up the perms for that user like its telling me
> to.  As far
> as I know I am doing what it says, please let me know if I am doing
> anything wrong here.
>
> Thanks
>
> Nick
>
>
>
>
> On Mon, 2003-07-07 at 03:51, Frank Shearar wrote:
> > I'm a bit confused here - if you're using mysql, why are
> you moving gdbms
> > around?
> >
> > Which install instructions did you follow? ./INSTALL or
> ./doc/INSTALL.mysql?
> >
> > The ./INSTALL file describes the procedure for installing a
> gdbm backend,
> > the default database (if I recall correctly). Seeing as a
> gdbm is a binary
> > file, that would explain why you're getting crap on your page.
> >
> > Which backend do you want to use?
> >
> > frank
> >
> > > >>> "nh...@lu..." 07/05/03 22:35 >>>
> > >
> > > Ok well that worked I guess, I got the main startup page
> for the wiki
> > > where it can the commands from the pgsrc directory and it
> said it was
> > > completed.  Now I have another problem.  I did what the
> install file
> > > said to do which was create a pages directory and have it
> put the dbm
> > > file there.  I moved the wiki_pagedb.gdbm file from /tmp to
> > > phpwiki/pages.  I did a chown nobody:root pages and a chmod
> > > 755 pages.
> > > Now when I try to start the home page I get all the crap on
> > > my page, it
> > > looks to be encoded.  If you wish to look here it is
> > > http://www.deepfog.net/phpwiki .