Loading...
 
Architecture / Installation

Architecture / Installation


Error installing tiki - "Tiki cannot find a database connection"

posts: 2

Hi,

I am trying to install tiki on Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) but am getting an error saying "Tiki cannot find a database connection" when i run the tiki-install.php through
my browser.
I have configured php for mysql support during the installation so that shud not be an issue as mentioned in some replies for some posts read by me.

The steps that i followed are as follows

1. Installed MYSQL version 4.1.5 from the mysql-standard-4.1.5-gamma-pc-linux-i686.tar.gz file
as per the install guide in documentation.

Foll. are the steps that i followed:
groupadd mysql
useradd -g mysql mysql
gunzip < mysql-VERSION.tar.gz | tar -xvf -
cd mysql-4.1.5
./configure --prefix=/usr/local/mysql
make
make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
chgrp -R mysql .
bin/mysqld_safe --user=mysql &



2. installed apache
a. downloaded httpd.2.0.52.bz2 from http://httpd.apache.org/download.cgi
b. unzipped and changed the directory

c. ./configure prefix=/usr/local/apache enable-so enable-cgi enable-info enable-rewrite enable-speling --enable-usertrack \
enable-deflate enable-ssl --enable-mime-magic
d. make
e. make install


3. installed php support for apache - php-4.3.9.tar.bz2
a. ./configure \
--with-apxs2=/usr/local/apache/bin/apxs \
--with-mysql \
--prefix=/usr/local/apache/php \
--with-config-file-path=/usr/local/apache/php \
--enable-force-cgi-redirect \
--disable-cgi \
--with-zlib \
--with-gettext \
--with-gdbm
b. make c. make install
d. cp -p .libs/libphp4.so /usr/local/apache/modules
e. cp -p php.ini-recommended /usr/local/apache/php/php.ini
f. Added php directives to httpd.conf as provided at http://dan.drydog.com/apache2php.html

4. Tried running sample php's to check the installation and also performed sanity checks to verify apache installation at http://dan.drydog.com/apache2php.html

5. tiki installation(tikiwiki-1.7.6.tar.bz2) - For this i followed the steps at http://tikiwiki.org/InstallTikiDoc.
a) Unzipped and untarred tiki to Document root of apache set to /var/www/html/tiki. changed to the above directory.
b) chmod 755 setup.sh
c) ./setup.sh nobody
d) mysql configuration
1) mysqladmin create tikidb
2) mysql -u root mysql grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER on tikidb.* to tiki@localhost identified by 'tiki"

3) Tested configuration by connecting to the server
/usr/local/mysql/bin/mysql -p -u tiki -D tikidb
After this i run the url http://hostname/tiki/tiki-install.php i get an error saying "Tiki cannot find a database connection".
I also tried running the url http://localhost/tiki/tiki-install.php from the local machine using lynx browser on my telnet window but get the same error
Please guide





posts: 1092
Just a little idea: Can you check that the file db/local.php in tiki has the good parameters

posts: 2

yes id to it reads as below



and am able to connect to the db using mysql client as below

/usr/local/mysql/bin/mysql -p -u tiki -h localhost -D tikidb
but still get the cannot find a database connection error on running the tiki-install.php.

if i run the index.php in tiki i get error saying "DB Error: no such database" tho' the database exists


posts: 2881 United Kingdom

TikiWiki is not compatible with MySQL 4.1 the latest that is supported by ADODB which we use is 4.0

Damian