Loading...
 
Architecture / Installation

Architecture / Installation


Tiki 5 Install loop

posts: 12

Info:

MySQL 5.1
IIS 6 on 2003 Server
PHP 5.3.1
Tiki 5 installer

Note - I have successfully installed 3.x many times on this same scenario. No issues.

Problem I am seeing has been reported, but with no fix offered.

- new database install (of MySQL 5.1)
- new database created for tiki
- fresh install of Tiki 5.0

Go through (pre)install process:

1. create database in anticipation of Tiki, create a db user, give this user full rights to the datbase
2. unpack tiki 5 to the appropriate folder

- php is installed before hand, not going back that far for this issue, unless someone indicates it is necessary.

Go through install process:
1. Welcome/select language - no issue
2. System requirements - no issue
3. Reset Database connection - no issue (?!)

Now the fun (HA!) loop starts where I get kicked back to the welcome screen. I do not know what is going on, although this is 100% repeatable (not even one success with tiki 5).

Again - I go and create a database and give a specific user full rights to the database. I use this information for username and password. I cannot get to the Install although it is 'clickable', it simply demands the username and password again - which returns me to 'welcome'...

I have also reversed the database creation process and went into the new mysql install and create the user, then under the user create the database - same result.

Anyone - help?

Is the answer 'go back to 3.x'?

I'd like to see 5.x - if it is remotely possible. Other than seeing others having the same issue, I've seen no documentation or anything else saying how to fix the issue. I am very definitely using a username and password with rights to the database, which is the only 'gotchya' that I could see.

Thanks in advance,

Bueymo

posts: 12

Hi Rick,

Thank you for your reply. I've looked in the /db/local.php and have always found database name, username and password to be correct. I did find a bit of an mismatch that I've listed below.

For the 'session data is correct (in your php.ini)' I'm not quite sure what you mean - is there an example you could point to me? The session.save path is what I'd expect it to be, and this is the only thing I could think of that may match.

I tested a bit more yesterday, and with the exact same scenario, can install 3.6 with no issue. 4.3 I have the same issue as 5. It appears to me that there is a direct connection between the security check that was introduced and the loop - but beyond this I'm stuck. Below is the db/local.php and the difference I found.

The database info in the TikiInstallPath/db/local.php is what I'd expect with one exception - db version of MySql

$db_tiki='mysqli'
$dbverson_tiki= '4.0'

          • NOTE THAT THE VERSION of MySQL INSTALLED IS 5.1********


$host_tiki='localhost' (it is on same machine as tiki)
$user_tiki='username' - correct, and has been each time I've checked
$pass_tiki='password' - correct password, and has been eachtime i've checked
$dbs_tiki='tiki43'

Hope the additional information can help you or others help sort this loop out.

Thanks,

Bueymo


posts: 12

Ok, kept smacking my head against the wall long enough that I decided to try a different approach.

Read about the manual install (hmmm)...

Step 1.
Discovery that navicat lite will not allow for database imports (DRAT!)

Step 2.
phpMyAdmin3.3.3 - set up as new default website (easy enough in IIS - just redirect home directory to the extracted phpMyAdmin3.3.3 and was extremely pleased to find that it just worked - no issues at ALL with it.
Selected database I had set up for the Tiki.
2a. I then did an import of /db/tiki.sql (it worked!! - also nicely shown this by phpMyAdmin).
2b. I then did the optional Insert secdb (import again).

Step 3.
Reset Tiki5 extracted directory as the home/default website.
SUCCESS - at least as far as this goes. My next challenge will be to see about the username and password to logon - it's been a long time since I did the setup for 3.x.

Hope this helps people. I know how incredibly frustrating that loop can be!

Bueymo

posts: 12

MySQL 5.1
IIS 6 on 2003 Server
PHP 5.3.1
Tiki 5 installer

1. create database in phpMyAdmin
- use the phpmyadmin as default website

2. extract tiki5 to appropriate location
- modify default website so that it is now pointing to extracted tiki5 folder

3. set permissions required (within iis, rt click and 'permissions' (internet guest account))

4. create local.php in \TikiExtracted\db

File example:
?php (NOTE: put < before the ?PHP if you use this as a template)
$db_tiki='mysql';
$dbversion_tiki='5.0';
$host_tiki='localhost';
$user_tiki='UserNameWithPermissiontoDatabase';
$pass_tiki='password';
$dbs_tiki='NameOfDatabase';
$client_charset='utf8';

5. Launch phpMyAdmin to import database
- select database created to be the tiki db
- verify permissions are set
- click 'Import' tab, browse for tiki.sql (in the tikiunpacked/db folder)
- accept defaults seem fine, click 'go'
- message 'improt has been successfully finished, 1066 queries executed'
- Browse... look for tiki-secdb_5.0_mysql.sql in the same location
- open/go
- message import successfully finished
- close phpMyAdmin

6. Make Tiki the default website again.
- may need to do iisreset
- do not use the tiki-install.php, but rather index.php for the file (documents tab)


Default username - admin
default password - admin

7. login
- go to 'getting started using Admin Panel'

Message 'Your database requires an update to match the current TikiWiki version. Please proceed to the installer. Using Tiki with an incorrect database version usually provoke errors. If you have shell (SSH) access, you can also use the following, on the command line, from the root of your Tiki installation: php installer/shell.php'

- click on blue 'the installer' that is in the above (please proceed to THE INSTALLER)
- enter in database username and password that was established in step 4.
- step thru the installer process

DATABASE PAGE
- have option of using existing or setting up new
- click 'use existing'
2 options - reinstall the database
- upgrade

upgrade gave lot of messages that i had no clue about - started over

trying reinstall the database

SUCCESS!!!

****************************

We recommend enabling the .htaccess file for your Tiki. This will enable you to use SEFURLs (search engine friendly URLs) and help improve site security.
To enable this file, simply rename the _htaccess file (located in the main directory of your Tiki installation) to .htaccess.

************************

click continue
- General settings - enter general settings
Browser title -

emails -
https login - disabled

- enter and lock installer (done)

Note - if doing over I'd start with a separate website for the phpmyadmin rather than flipping back and forth. I was just running thru to get things working (or trying to).

Good luck.

My next project - tiki5 with AD authentication. Had it working just fine for 3. Hoping there is some good windows world doc for it :-)

Cheers!

Bueymo


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