Koozali.org: home of the SME Server

Install RackTables on SME 9

Offline Bud

  • *
  • 487
  • +0/-0
Install RackTables on SME 9
« on: July 13, 2019, 05:17:00 PM »
please guys can you help

i can and have installed RackTables on SME 8 as per - https://forums.contribs.org/index.php/topic,49036.msg244623.html#msg244623

however, when i do the installation n an SME 9.2 64bit Server i cannot login.

when i try to login it says

This system requires authentication. You should use a username and a password.

it keeps asking me for the correct username and password and i have done the installation 5 times all with the same results.

please can you possibly indicate where i can view the logs as ai cannot seem to find them to see what the issue is

any help greatly appreciated  :D

Offline janet

  • ****
  • 4,812
  • +0/-0
Re: Install RackTables on SME 9
« Reply #1 on: July 14, 2019, 03:01:31 PM »
Bud

The server manager has a panel where you can read log files to see what is going on, otherwise at cli look in
/var/log/.....

Does admin user work ? The manual seems to imply it should.

This might help, seems you may have to edit a config file.
https://wiki.racktables.org/index.php/RackTablesAdminGuide#User_authentication

User authentication
Authentication is a way to tell that the remote user is who he or she purports to be. This can be done in three ways, with or without knowing the user's password, and is controlled through an option on the configuration page and via editing parameters in the "secret.php" file in the "inc" folder of your installation. Authentication does not automatically equate to access. All users other than the default "admin" user must be explicitly granted access, either individually, or via group permissions (see the "Permission configuration" section below), as specified under "Configuration: Permissions". If you do not grant access, the user will not be permitted to view any pages. !RackTables traditional account locking works regardless of authentication sources, so one can always disable accounts one by one, if necessary.

« Last Edit: July 14, 2019, 03:04:59 PM by janet »
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Install RackTables on SME 9
« Reply #2 on: July 14, 2019, 04:41:00 PM »
On a virgin SME9.2 system racktables only works for me if it is at the root of the web space.

That is - I installed racktables in an ibay named racktables and saw the same behavior you saw - the admin username and password would not work when attrmpting to login at http://my-sme-server/racktables/index.php.

I moved the alread-installed racktables html folder into the Primary ibay, and it let me login fine.

I can't tell where it was failing - I found nothing in any sme log file indicating any errors whatsoever.

You should be able to get an ibay-based installation working if you create a domain on your SME and point its content to the racktables ibay (I moved the html folder because this is a temp server and that was easier).

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Install RackTables on SME 9
« Reply #3 on: July 14, 2019, 04:45:51 PM »
You should be able to get an ibay-based installation working if you create a domain on your SME and point its content to the racktables ibay (I moved the html folder because this is a temp server and that was easier).

I was wrong here - I tried this, and I get the same login failures.

So - The only way I can login to RackTables is to host it in the Primary i-bay. (so far)

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Install RackTables on SME 9
« Reply #4 on: July 14, 2019, 05:07:12 PM »
It also works for me if I move the installed html into a sub-folder of /home/e-smith/files/ibays/Primary/html, then access it using the server primary url with the folder name appended.

That is, I did this:
- create ibay racktables
- install racktables into ibay (using php73)
- get failure logging in at http://my-sme-server/racktables
- mv /home/e-smith/files/ibays/racktables/html/ /home/e-smith/files/ibays/Primary/html/rt
- get success logging in to http://my-sme-server/rt


Offline mmccarn

  • *
  • 2,626
  • +10/-0

Offline Bud

  • *
  • 487
  • +0/-0
Re: Install RackTables on SME 9
« Reply #6 on: July 15, 2019, 10:14:06 AM »
mmccarn thank you for your help, much appreciated

i have done exactly what you recommended using PHP71 as per you install notes:
https://github.com/mmccarn/smeserver/blob/master/Install%20RackTables%20on%20SME9.2.md

- i get failure logging in at http://my-sme-server/racktables

when i do
- mv /home/e-smith/files/ibays/racktables/html/ /home/e-smith/files/ibays/Primary/html/rt
- i get an HTTP ERROR 500

any ideas?




Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Install RackTables on SME 9
« Reply #7 on: July 15, 2019, 01:20:57 PM »
I forgot to mention in the notes that I also changed the php-scl setting for "PHP-mod version" - "Choose another PHP-mod version for the http server, instead of an Ibay." - at the bottom of the "PHP-SCL Versions" page in server-manager.

Try setting that to PHP71 and see if it starts working.

Another possible factor would be the settings on the Primary ibay -
Code: [Select]
# db accounts show Primary
Primary=ibay
    CgiBin=enabled
    Group=shared
    Modifiable=no
    Name=Primary i-bay
    PasswordSet=no
    Passwordable=no
    PublicAccess=global
    Removable=no
    UserAccess=wr-admin-rd-group

Offline Bud

  • *
  • 487
  • +0/-0
Re: Install RackTables on SME 9
« Reply #8 on: July 15, 2019, 01:50:14 PM »
mmccarn thank you very much

it's working!!!

doh and i could not figure that out  :D

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Install RackTables on SME 9
« Reply #9 on: July 15, 2019, 01:54:00 PM »
Congrats.

Pretty useful looking tool.

Offline Bud

  • *
  • 487
  • +0/-0
Re: Install RackTables on SME 9
« Reply #10 on: July 17, 2019, 05:59:38 PM »
mmccarn thank you very much for your support

i need to attach files to Racktables however the system will not allow me to upload any files

the error i get is: " File upload failed, error: 6 "

is there a folder that i need to create with rights or?

i have tried doing the following:

Edit the File " /etc/httpd/conf/.httpd.conf "
Enter Paths for Primary iBay PHPBaseDir: " /home/e-smith/files/ibays/Primary/html/:/tmp/ "
# signal-event console-save

still does not allow me to upload a file

the file size is 1mb

thank you again  :)
« Last Edit: July 18, 2019, 12:42:02 PM by Bud »

Offline mmccarn

  • *
  • 2,626
  • +10/-0
Re: Install RackTables on SME 9
« Reply #11 on: July 18, 2019, 01:30:07 PM »
open_basedir is controlled by a db variable.  If you edit httpd.conf directly, then issue any event that updates the file, your edit is reverted.

Try this (from PHP):
Code: [Select]
db accounts setprop Primary PHPBaseDir /home/e-smith/files/ibays/Primary/html/:/tmp/
signal-event remoteaccess-update

There are also some php settings controlled by PHP Software Collections - check these for PHP v7.1 using config show php71 (from PHP_Software_Collections#Usage):
Code: [Select]
# config show php71
php71=configuration
    AllowUrlFopen=Off
    MaxExecutionTime=30
    MaxFileUpload=20
    MaxInputTime=60
    MemoryLimit=128M
    PhpModule=disabled
    PostMaxSize=20M
    UploadMaxFilesize=10M

Offline Bud

  • *
  • 487
  • +0/-0
Re: Install RackTables on SME 9
« Reply #12 on: July 19, 2019, 10:18:03 AM »
mmccarn thank you

bingo! that sorted out the problem

much appreciated  :)