Loading...
 
Architecture / Installation

Architecture / Installation


Tiki cannot find a database connection

posts: 12 South Africa

Hi,

I've installed Tiki and created the DB using the tiki.sql script. MySql 4.0.9 is running. The OS is Win XP Pro using IIS. When I go to the tiki-install.php script, I get

Tiki cannot find a database connection
Please enter your database connection info

I've edited local.php and tiki-db.php to reflect the user name, password, host and DB name. I can access MySQL using other tools such as PHPMyAdmin amd MySQL Control Centre.

Any ideas.

Thanksconfused

posts: 2881 United Kingdom

Hiya

Try deleting your local.php file and reverting the tiki-db.php back

tiki-install will create these for you. If it gets a successfull connection

if it still cant, then you might want to double check the mysql username/password and that your tiki database is created too.

posts: 4 Australia

Hi,

I'm in a similar situation.

I've uploaded Tiki onto a Linux host, but don't have shell access, so CHMOD the directories manually according to setup.sh. This means tiki-install.php no longer says there is no write access to directories - I've reached the Tiki Installer page okay.

I'm specifying the same Host, User, Password and Database name as in phpadmin, but receive error:

Tiki cannot find a database connection
Please enter your database connection info

I've changed the Hostname to an IP address with no luck.

I've loaded tiki.sql into phpadmin to create the tables, but the Tiki Installer will not proceed.

Is there a work around, or something I am missing?

Running MySQL 3.23.58-Max

Thanks confused


posts: 4 Australia

Hi,

I'm in a similar situation.

I've uploaded Tiki onto a Linux host, but don't have shell access, so CHMOD the directories manually according to setup.sh. This means tiki-install.php no longer says there is no write access to directories - I've reached the Tiki Installer page okay.

I'm specifying the same Host, User, Password and Database name as in phpadmin, but receive error:

Tiki cannot find a database connection
Please enter your database connection info

I've changed the Hostname to an IP address with no luck.

I've loaded tiki.sql into phpadmin to create the tables, but the Tiki Installer will not proceed.

Is there a work around, or something I am missing?

Running MySQL 3.23.58-Max

Thanks confused


posts: 1001 Canada

Hi Volterra,
I'll try a few things hoping this solves your problem :

  1. Your MySQL must have some privileges on the Tiki database.
  2. Your DB settings must not contain thos characters : " " ", " ' ", "/" and possibly "$".


If it still doesn't work, running tiki.sql is half the installer's job, and you can manually create a tiki/db/local.php which is the other half. The content of this file should be documented in tiki/db/tiki-db.php. If you don't want to create local.php, and enter the settings in tiki-db.php instead, remember to delete "tiki-install.php" or change the extension for security.

posts: 4 Australia

Hi Chealer9, Damian

1. MySQL looks to have privileges to the database, as correction:phpMyAdmin 2.2.4 connects and works with it fine.

2. database name does not contain any invalid characters.

tiki/db/local.php created okay.
tiki/tiki-install.php deleted.

From tiki/tiki-admin.php:

Warning: fopen(modules/cache//mod-assistant.tpl.en.cache): failed
to open stream: Permission denied in .../www/tiki/tiki-modules.php
on line 134
...etc...

I have chmod 775
tiki/modules/cache

Issue remains.
Is it the double-backslash before mod-assistant.tpl.en.cache ?

Assistance appreciated.

posts: 2881 United Kingdom

> Volterra:
> Hi Chealer9, Damian
>
> 1. MySQL looks to have privileges to the database, as correction:phpMyAdmin 2.2.4 connects and works with it fine.
>
> 2. database name does not contain any invalid characters.
>
> tiki/db/local.php created okay.
> tiki/tiki-install.php deleted.
>
> From tiki/tiki-admin.php:
>
> Warning: fopen(modules/cache//mod-assistant.tpl.en.cache): failed
> to open stream: Permission denied in .../www/tiki/tiki-modules.php
> on line 134
> ...etc...
>
> I have chmod 775
> tiki/modules/cache
>
> Issue remains.
> Is it the double-backslash before mod-assistant.tpl.en.cache ?
>
> Assistance appreciated.

This error message is because apache cannot write to that folder. I'll have a look at the attached txt file now and see what I can see


posts: 2881 United Kingdom

Also dont forget to check that your PHP — MySQL module is working correctly.

manutius wont have this problem as his phpmyadmin seems to be running fine, but volty might have this prob.

Damian


posts: 4 Australia

Hi Chealer9, Damian

1. MySQL looks to have privileges to the database, as correction:phpMyAdmin 2.2.4 connects and works with it fine.

2. database name does not contain any invalid characters.

tiki/db/local.php created okay.
tiki/tiki-install.php deleted.

From tiki/tiki-admin.php:

Warning: fopen(modules/cache//mod-assistant.tpl.en.cache): failed
to open stream: Permission denied in .../www/tiki/tiki-modules.php
on line 134
...etc...

I have chmod 775
tiki/modules/cache

Issue remains.
Is it the double-backslash before mod-assistant.tpl.en.cache ?

Assistance appreciated.

posts: 2881 United Kingdom

> Volterra:
> Hi Chealer9, Damian
>
> 1. MySQL looks to have privileges to the database, as correction:phpMyAdmin 2.2.4 connects and works with it fine.
>
> 2. database name does not contain any invalid characters.
>
> tiki/db/local.php created okay.
> tiki/tiki-install.php deleted.
>
> From tiki/tiki-admin.php:
>
> Warning: fopen(modules/cache//mod-assistant.tpl.en.cache): failed
> to open stream: Permission denied in .../www/tiki/tiki-modules.php
> on line 134
> ...etc...
>
> I have chmod 775
> tiki/modules/cache
>
> Issue remains.
> Is it the double-backslash before mod-assistant.tpl.en.cache ?
>
> Assistance appreciated.

This error message is because apache cannot write to that folder. I'll have a look at the attached txt file now and see what I can see


posts: 2881 United Kingdom

Ok unless your apache is running as the user "users" even templates_c isnt writeable to it.

you may have to chmod to 777

Whats the user that apache is running?
If its anything other than the user "users" you'll need to either:

chown the directories to that user or chmod to 777 those needed directories

Damian


posts: 2

Hi Manutius,

I get the same error, I am using IIS aswell and MySQL 3.x is running fine as I can see. If you get a fix can you post me a reply

Cheers

The Muzz


posts: 1001 Canada

Note for The Muzz :
This problem is very frequent and it's unlikely that you solve it the same way as Manutius. If you do, the answer is already somewhere anyway (most likely on InstallTroubleshootingDoc). Actually I'm pretty sure that manutius already solved his problem, you can message him personally to make sure.

posts: 4 Australia

Chealer9, Damian,

I could not of run the setup.sh file properly as I did not have rights in a shared Linux hosting environment.

My hosting company have resolved this well for me, and TikiWiki appears to be running fine.

Cheers biggrin


posts: 4 Australia

Chealer9, Damian,

I could not of run the setup.sh file properly as I did not have rights in a shared Linux hosting environment.

My hosting company have resolved this well for me, and TikiWiki appears to be running fine.

Cheers biggrin


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting