Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: John Lewis on June 02, 2001, 07:30:45 PM

Title: phorum setup problems with mysql
Post by: John Lewis on June 02, 2001, 07:30:45 PM

Hey all, I'm trying to install Phorum 3.2.11 on an e-smith server 4.1.2.

I'm new to php and mysql, so please help me out here...

I followed the directions for a basic install of phorum, but when trying to add a new phorum, I get the following:

Warning: MySQL: A link to the server could not be established in /home/e-smith/files/ibays/intelos/html/phorum-3.2.11/db/mysql.php on line 52

Warning: Failed opening 'root_admin/forums/.php' for inclusion (include_path='.:/usr/share/php') in /home/e-smith/files/ibays/intelos/html/phorum-3.2.11/root_admin/index.php on line 665

As far as I can tell, I've entered the correct user and password to mysql, and created a new database (using phpmysql).

What am I doing wrong.  What permissions should I be expecting?  Help... I really want to get this to work.

Here are the permissions in the phorum dir:
drwxr-xr-x    2 root     root         4096 Jun  2 05:44 $PHCONFIG
-rw-rw-r--    1 512      512         14529 Oct 31  2000 advsearch.php
-rw-rw-r--    1 512      512          8828 Jun  2 05:44 common.php
drwxrwxr-x    2 512      512          4096 Jun  2 05:44 db
drwxrwxr-x    2 512      512          4096 Jun  2 05:44 docs
-rw-rw-r--    1 512      512          2216 May 22  2000 down.php
-rw-rw-r--    1 512      512          1242 Nov 25  2000 download.php
drwxrwxr-x    2 512      512          4096 Nov 27  2000 images
drwxrwxr-x    2 512      512          4096 Jun  2 05:44 include
-rw-rw-r--    1 512      512          6017 Nov 22  2000 index.php
drwxrwxr-x    2 512      512          4096 Jun  2 05:44 lang
-rw-rw-r--    1 512      512          9310 Oct 27  2000 list.php
drwxrwxr-x    3 512      512          4096 Jun  2 05:44 plugin
-rw-rw-r--    1 512      512          5946 Nov 25  2000 post.php
-rw-rw-r--    1 512      512         15585 Nov 22  2000 read.php
drwxrwxr-x    4 512      512          4096 Nov 27  2000 root_admin
drwxrwxr-x    2 512      512          4096 Jun  2 05:44 scripts
-rw-rw-r--    1 512      512         12694 Oct 31  2000 search.php
-rw-rw-r--    1 512      512          2087 May 22  2000 violation.php

here are the permissions for the default html tree:
drwxrws---    2 lewis-ho lewis-ho     4096 Jul 16  1999 cgi-bin
drwxrws---    2 lewis-ho lewis-ho     4096 Jun  2 05:41 files
drwxrws---    3 lewis-ho lewis-ho     4096 Jun  2 05:41 html

Is it a permissions thing?

Thanks.

Title: Re: phorum setup problems with mysql
Post by: Mahmood Al-Yousif on June 03, 2001, 03:38:44 AM

Suggest you change the owner of the files:

> chown -R www.www  /home/e-smith/files/ibays/intelos/html/

As all of these files will be run and accessed by Apache directly.

The permissions seem to be okay.

hope this helps

Mahmood

Title: Re: phorum setup problems with mysql
Post by: John Lewis on June 03, 2001, 07:02:11 AM

Duh, after reading Jason Hammond's phpBB howto, I realized the mysql password is different from the root password.

need to look in /root/.my.cnf for the mysql password, and enter in in the admin/database section of phorum...

Changed the password, and it works fine.

-jl