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