Subject:
Re: Useful 'phpbb' installation guide
From:
jf.pieronne@laposte.net
Date:
Fri, 16 Jul 2004 11:24:06 +0200
Newsgroups:
comp.os.vms


> Porting phpBB to VMS was mit really a problem, I did that a while ago,
> but
> I still have problems with MySQL currupting database tables. This
> happens as soon as I add a new forum in phpBB. I have this problem for
> month now, with MySQL 4.0.16 ,17, 18 and even with the new 4.1.3-beta.
>
> I run VMS 7.3-2 with the lastest patches installed, all disks are
> ODS-5. Any ideas?
>
> Dieter


I have run phpbb successfully using the latest MySQL 4.1.3-beta kit

Check the procedure MYSQL_ROOT:[VMS.MYSQL]run_mysqld.com

The correct run command for MySQL is (may be wrap)

$ mysqld  --default-storage-engine=InnoDB --old-passwords --innodb_flush_log_at_trx_commit=2 --ansi --myisam-recover --log-bin --tmpdir=/mysql_root/mysql_server /tmp --lower_case_table_names=2


The --default-storage-engine=InnoDB mean that each table is create using InnoDB if you don't specify any engine int the create table statement.

InnoDB engine work perfectly, and yes the MyISAM bug is still present...

After stop and restart MySQL, you will have to drop your phpbb database and redo the installation procedure.



Jean-François

ps.
 have build a new version of php_mysql module.

This version was build using MySQL 4.1.3-beta client library.

It can be downloaded from
http://www.pi-net.dyndns.org/anonymous/kits/axp/

I have succesfuly test this module using php_info.php
http://www.pi-net.dyndns.org/php-bin/php_info.php

and phpbb
http://www.pi-net.dyndns.org/phpbb/index.php
after updating config.php
change line "$dbms = 'mysql';" into "$dbms = 'mysql4';"