Re: Useful 'phpbb' installation guide

jf.pieronne_at_laposte.net
Date: 07/16/04 

Date: Fri, 16 Jul 2004 11:24:06 +0200

> 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';"

Relevant Pages

  • Re: Slightly OT; Opinions on Forum type software
    ... dunno how/why they run phpbb with access but they said they did. ... Actually I have another Linux host that has MySQL for free, but I really wanted to try Windows server this time around. ... | the database to get your forums online. ... As for Snitz vs. phpbb, ...
    (microsoft.public.frontpage.client)
  • Re: MySQL 4.x questions...
    ... > I installed MySQL server 4.1.0_1 to support the PostNuke CMS and the phpBB ... Both users groups tell me that there's a mysql ... connecting using the unix socket will ...
    (freebsd-questions)
  • [UNIX] PHPBB BBcode Process Vulnerability (DoS)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... WSS has found a vulnerability in <http://www.phpbb.com/> phpBB, ... Will cause the following data to be saved to the database: ... whitecell$ mysql -uuser -ppasswd ...
    (Securiteam)
  • Re: Database Startup
    ... > My overall goal is to set up phpBB on a box that is running fedora/apache. ... > The documentation states I need to have PostgreSQL or MySQL. ... Both PostgreSQL and MySQL come with Fedora ...
    (Fedora)
  • Intermittent error with MySQL and phpBB
    ... I am having intermittent access problems with MySQL and phpBB... ... I have pretty much confirmed that PHP is using the correct password/hostname ...
    (comp.unix.bsd.freebsd.misc)