Problems installing emoncms on Domainfactory

christianpfeil · 11 September 2018 19:31

Hi,

I want to install emoncms on domainfactory hosting.

I uploaded all files from github (stable version), changed and uploaded settings.php. MySQL login and database information is correct. mySQL and PHP version are up to date.

When I call index.php from my webspace, there is an error message:

Can anyone help me please? Is there an installation PHP?
How are the database tables setup? Do they need to be manually set up?

Best regards,

Christian

danbates · 12 September 2018 14:36

Out of interest what are you trying to achieve?
There’s already a version of emoncms set up on the web, called emoncms.org. Is there a reason you’re not using that?

borpin · 13 September 2018 07:02

There are a number of things that need to be done from the command line / SSH. Have you looked at the Linux install guide?

christianpfeil · 13 September 2018 13:02

Hi Brian,

I read the install guide for Shared Linux Hosting.

github.com

emoncms/emoncms/blob/master/docs/SharedLinuxHostingInstall.md

# Shared Linux Hosting

Your shared hosting provider should already have a LAMP server installed. You may need to ask your hosting provider to enable mod_rewrite. It's unlikely that redis will be available (redis is used to improve performance through caching), but emoncms can be run without it.

To install emoncms on a shared server

1) Check with your hosting provider that mod_rewrite is enabled

2) Download the emoncms zip file from:

**You may want to install one of the other branches of emoncms here, perhaps to try out a new feature set not yet available in the master branch. See the branch list and descriptions on the [start page](https://github.com/emoncms/emoncms)**

[https://github.com/emoncms/emoncms/archive/stable.zip](https://github.com/emoncms/emoncms/archive/stable.zip)

Unzip to your shared server's public_html folder, rename the folder to emoncms.
i.e. You should end up with all the files in the directory public_html/emoncms/

3) Create a mysql database for your emoncms installation, note down its name, username and password.

4) In your shared hosting /home/username folder create a folder called emoncmsdata to hold your emoncms feed data.

This file has been truncated. show original

There are no instructions on how to create the mySQL tables. I followed the innstructions mentioned in the guide, but I receive the error mentioned above when calling index.php

@Daniel: emoncms.org changed to payed version. As I am already paying for my hosting, I want to host emoncms on my domainfactory hosting.

Best regards,

Christian

pb66 · 13 September 2018 13:23

The sql tables are generated automatically when the first user is registered.

why are you “calling index.php” ? Just navigate to the domain/emoncms root eg

http://myserver.com/emoncms

that will present the log-in dialog box, you can click “register” and add your details (username, email and password x2) and on “create user” you will be logged in (and the tables created).

christianpfeil · 13 September 2018 13:39

Hi Paul,

thank you for your support!

If I call the root folder domain/emoncms I exactly get the error I mentioned in my first post.

Very strange. When I enter the error message or parts of it in Google, I do not receive posts / information etc. on this.

I just get some general information on this e.g. php - Fatal error: Call to a member function fetch_row() on boolean - Stack Overflow

It seems as if emoncms tries to determine the number of users etc. ( User->get_number_of_users()) but fails with the mySQL query. But the mySQL are not there.

Best regards,

Christian

christianpfeil · 13 September 2018 13:47

Hi,

just checked /emoncms/Modules/user/user_model.php:804
There is a query, selecting users from a mySQL table.

But how can emoncms select from a table if it is not yet created?
Are you sure emoncms is installing the tables on its on after first logon?

Best regards,

Christian

pb66 · 13 September 2018 14:15

The blank database is created during the install steps and then the tables are created on first use. I do not know the exact instance the tables are created as successfully creating the first user is my first use. It certainly isn’t “after first login” as that wouldn’t be possible.

Looking at the code you link, it does look like that is expecting there to be a “users” table by the time it reaches that point, but ordinarily there are no tables before 'http://server.com/emoncms" is called (there is no install step to create them), at which point the user login screen appears for the first user to be created. So if you are not getting the log-in screen, then somewhere in index.php or enroute to L804 of the user_model.php there must be a check/call to create the tables that isn’t happening for some reason. I do not know where that is without delving into the code.

Is the “emoncms” mysql user correctly set up with the right permissions?

christianpfeil · 13 September 2018 14:18

Hi Paul,

good point!

In index.php line 71 I see this:

It is setting up mySQL tables and it is loading the mySQL schema / table structure from each module in Modules directory (Files named _schema.php). Not after first login, but when calling index.php.

I also think that it fails at this point. Maybe of mySQL users right permissions.
I will check /debug this.

Thank you for your help!

Regards,
Christian

danbates · 13 September 2018 15:24

We can add this problem to the list of MySQL related issues perhaps.

emonCMS setup is failing to create parts of the database, it’s possible to create them manually.

(MySQL database setup for user registration. · Issue #1016 · emoncms/emoncms · GitHub)

The issue linked here I encountered on a fresh install, it doesn’t seem to be creating the same errors as what you’re seeing, but they could be related, worth a shot.

borpin · 13 September 2018 15:35

Might the update db script work?

https://github.com/openenergymonitor/emonpi/blob/master/emoncmsdbupdate.php

pb66 · 16 September 2018 17:49

See this PR from @anna_carboncoop (thanks Anna), I do not know when this might get pulled in, but it seems an easy enough edit to make manually and worth a try as it fits your symptoms.