Installation Problems - Step 3

[samuliakin]

Hi I'm trying to install vs 1.3.0 but am running into problems in step 3. Steps 1 and 2 worked fine, I created the database, modified the appropriate file, but once it goes to step 3 the page is blank. Any ideas what can be wrong?

Here's my hotaru_settings.php file:

<?php
/* Configuration file for Hotaru CMS�@*/

// Paths
define('BASEURL', "http://enfluxx.com/"); // e.g. http://example.com/ (needs trailing cache)

// Database details
define("DB_USER", 'samulia_hotaru'); // Add your own database details
define("DB_PASSWORD", 'xxxxxxx');
define("DB_NAME", 'samulia_hotaru');
define("DB_HOST", 'localhost'); // You probably won't need to change this

// You probably don't need to change these
define("DB_PREFIX", 'hotaru_'); // Database prefix, e.g. "hotaru_"
define("DB_LANG", 'en'); // Database language, e.g. "en"
define("DB_ENGINE", 'MyISAM'); // Database Engine, e.g. "MyISAM"
define('DB_CHARSET', 'utf8'); // Database Character Set (UTF8 is Recommended), e.g. "utf8"
define("DB_COLLATE", 'utf8_unicode_ci'); // Database Collation (UTF8 is Recommended), e.g. "utf8_unicode_ci"

?>

Thanks!

[shibuya246]

Hi I'm trying to install vs 1.3.0 but am running into problems in step 3. Steps 1 and 2 worked fine, I created the database, modified the appropriate file, but once it goes to step 3 the page is blank. Any ideas what can be wrong?

Thanks!

Page 3 of install is where Hotaru takes your database data and tries to create its first link to all of the Hotaru variables and objects. Since it is failing here, there may be something wrong with the initialization process.

It looks like the tables were created successfully so the database connection should be ok. This means it could be something in PHP which is not firing right.

Can you tell me what version of PHP you are running and what hosting service you use?

thanks
Alan

[samuliakin]

Hi thanks for the help,

The php version is: PHP Version 5.2.10 and the hosting is with fluidhosting (www.fluidhosting.com).

Thanks Alan!

[shibuya246]

Hi thanks for the help,

The php version is: PHP Version 5.2.10 and the hosting is with fluidhosting (www.fluidhosting.com).

Thanks Alan!

This might takes us a bit of back and forward working with files or if you want I can try logging in to your server by ftp and find out the problem. If you want me to try the ftp route then private message me with login details.

If not, try uploading this file to your install directory. I have put some comments in the top of the page to try and see where the code is having a problem. I don't expect this step to tell us much, but it will probably confirm that the install script is not the problem and instead the initialization script is causing issues. From there we can dig a bit further.

[twine]

Although I'm a total newbie I had several problems installing as well. Most of the issues were little things that were the fault of the hosting not hotaru. If you are installing in a directory that is not the root of enfluxx.com then you may not need the hotaru folder as the parent and just upload the files within. For example I had an issue there where there were multiple sites off of one primary domain (ie. http://www.primarydomain.com/seconda...rectory/hotaru) So even tho my site had a unique URL it was sitting in a folder under the primary domain. To fix the problem I removed the hotaru directory and put the all the files into the secondarydomain folder. So for me it read http://www.primarydomain.com/seconda...ll/install.php

Very confusing but hope it helps.

I can say that one you get it installed, it's an amazing CMS. I just upgraded to 1.3 and it gets better everytime. I just wish I had a better knowledge of PHP so I could customize more.

[shibuya246]

I can say that one you get it installed, it's an amazing CMS. I just upgraded to 1.3 and it gets better everytime. I just wish I had a better knowledge of PHP so I could customize more.

Really nice to hear you say that. Nick and I have put quite a deal of time into Hotaru and are pleased with the progress so far. We hope that people can learn PHP and SQL while using Hotaru and also help to add to the growing number of plugins and themes. It is always good to see people growing with us

[shibuya246]

Hi thanks for the help,

The php version is: PHP Version 5.2.10 and the hosting is with fluidhosting (www.fluidhosting.com).

Thanks Alan!

ok, thanks for the PM and the FTP login details. I first checked your CACHE folder and saw the permissions were still on 755. I changed these to 777 and then Hotaru was able to create the necessary cache files.

This allowed us to advance to the next step of install. The next problem seems to be with the database connection. It looks like the database user has permission to read the database, but not permission to write to it. If you are using CPanel, you need to go to mySQL databases section and make sure the created user that is attached to the database has ALL permissions. If you change this I think everything will work fine.

Here is the screen on my cpanel



I have made a change to the install script to check for problems with CACHE folder permissions. Hopefully this will help others as well.
I am trying to find a way to also run a test for permission to write to db at install. This should also help others out.

Let me know if you are able to check those permissions on database. I am sure you will find that will solve everything.

Thanks
Alan

[samuliakin]

I checked the permissions, seems to have full access... any other ideas?

[shibuya246]

I checked the permissions, seems to have full access... any other ideas?

ok, there are some other permissions that get set for mysql as well, such as permissions for user groups and also whether localhost only can write to db.

I put in some error checking and now get this back

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

This normally means, either SQL is not running, your server is looking for the SQL program in the wrong place, or the database connections may be wrong. You might want to pass this error back to your host. You can also try logging in to SQL with the username/password from the command line if you have SSH access. That would be a good test.

Alan

[shibuya246]

To finish the thread here, the answer came down to 2 things

1. the CACHE folder needed to have permissions changed from 755 to 777. (making sure recursive folders got the 777 as well)
2. for some reason this host did not allow LOCALHOST as the setting for DB_HOST but needed a real url.

Hope this helps others if they encounter the same problems.