Forum: help

Monitor Forum | Start New Thread Start New Thread
RE: Install FusionForge to Plesk VPS [ Reply ]
By: Franck Villaume on 2018-03-25 17:43
[forum:1115]
Looks like the db is either not created or incomplete.
In my case, the db was not created. I updated the RPMs and everything works now as expected.

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-25 12:44
[forum:1114]
Perhaps this bug resulted in what I got here:

[root@jenshen2 ~]# forge
SQL: SELECT set_config($1, $2, false)
SQL> ERROR: invalid value for parameter "default_text_search_config": "fusionforge"
SQL: SELECT role_id FROM pfo_role_setting WHERE section_name=$1 AND ref_id=$2 AND perm_val = 1
SQL> ERROR: relation "pfo_role_setting" does not exist
LINE 1: SELECT role_id FROM pfo_role_setting WHERE section_name=$1 A...


RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-25 12:42
[forum:1113]
Once I had connected as DB-root and established tcp connection, I tried to set the forge password.

From an ordinary user, here is what happened:

[graham@jenshen2 data]$ forge_set_password admin ForgePassword
PHP Fatal error: Call to undefined function user_get_object_by_name() in /usr/share/fusionforge/bin/forge_set_password on line 30

But what worked was:
# su - fusionforge forge_set_password admin ForgePassword


RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-25 12:31
[forum:1112]
Here's what I had to do with selinux.

$ sudo setsebool -P httpd_can_network_connect_db 1

I found at first that I could not get to phpPgAdmin so uninstalled FusionForge and got that going. Then found that it would not talk to the DB so fixed that.

So it also needed:

$ sudo firewall-cmd --zone=public --permanent --add-service=http

I'll document these things here for you and others starting from a fresh install of CentOS 7 (specifically 7.4.1708).

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Franck Villaume on 2018-03-25 09:41
[forum:1111]
I found a nice bug in FusionForge RPM installation. I just fixed it. The bug makes the installation to fail. The database is not created correctly. You may have the same issue. The new rpm packages should be publish in few hours.

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Franck Villaume on 2018-03-20 08:54
[forum:1110]
To connect to postgres database, the easiest way is:

$sudo su -
#su - postgres
$psql fusionforge
>

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Franck Villaume on 2018-03-20 08:53
[forum:1109]
selinux may definitively be an issue.

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-20 08:07
[forum:1108]
And this gains access:
$ sudo -u fusionforge -h localhost psql fusionforge
could not change directory to "/home/graham"
psql (9.2.23)
Type "help" for help.

fusionforge=> \d+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+----------------------------------------------+----------+-------------+------------+-------------
public | activity_log | table | fusionforge | 8192 bytes |
.... etc...

So peer connection works OK. No request for password.

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-20 05:39
[forum:1107]
I just tried locally connecting to the postgres DB server with psql and that program can connect OK.

$ psql -U fusionforge -d fusionforge
psql: FATAL: Peer authentication failed for user "fusionforge"

OK, so I guess psql might need MD5 connection to authenticate for this user.

Am I getting close to the answer?

Please give me some commands to try that might shed light on what's wrong.

Thanks...

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-20 04:02
[forum:1106]
Installed a clean Centos 7 on the machine I previously mentioned. All good.
Added a couple of sudo users.
I ran the FusionForge RPM installation which ran through OK.....
- added the EPEL 7 repo to get things like php-tidy.
- added fusionforge-6.1 repo and enabled=1
- imported FusionForge GPG key ($ sudo rpm --import ./B998DC6C.asc)
- $ sudo yum --enablerepo=fusionforge-6.1 install fusionforge

All good so far.

Then, when I run the forge_set_password command I get an error:
$ sudo forge_set_password admin xxxxxxxxx
SQL: SELECT set_config($1, $2, false)
SQL> ERROR: invalid value for parameter "default_text_search_config": "fusionforge"
Can't find this user...

I am a bit rusty on running postgresql. Is this because postgres is not setup properly?
$ sudo ps aux |grep postgres
postgres 2475 0.0 0.2 237008 9508 ? S 11:05 0:00 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432
postgres 2476 0.0 0.0 192560 1500 ? Ss 11:05 0:00 postgres: logger process
postgres 2480 0.0 0.2 237236 7856 ? Ss 11:05 0:00 postgres: checkpointer process
postgres 2481 0.0 0.0 237008 2004 ? Ss 11:05 0:00 postgres: writer process
postgres 2482 0.0 0.0 237008 1992 ? Ss 11:05 0:00 postgres: wal writer process
postgres 2483 0.0 0.0 237984 3100 ? Ss 11:05 0:00 postgres: autovacuum launcher process
postgres 2484 0.0 0.0 197028 1860 ? Ss 11:05 0:00 postgres: stats collector process

Seems to be running.

So I tried to access the server from my browser. Got blank screen with favicon. Here are the apache error_log entries.

[Tue Mar 20 13:46:56.807935 2018] [:error] [pid 13823] [client 192.168.20.100:60678] PHP Warning: pg_pconnect(): Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server running on host "127.0.0.1" and accepting\n\tTCP/IP connections on port 5432? in /usr/share/fusionforge/common/include/database-pgsql.php on line 80
[Tue Mar 20 13:46:56.808071 2018] [:error] [pid 13823] [client 192.168.20.100:60678] PHP Warning: pg_last_error() expects parameter 1 to be resource, boolean given in /usr/share/fusionforge/common/include/database-pgsql.php on line 660
[Tue Mar 20 13:46:56.808135 2018] [:error] [pid 13823] [client 192.168.20.100:60678] PHP Fatal error: Uncaught exception 'DBException' with message 'FusionForge Could Not Connect to Database: ' in /usr/share/fusionforge/common/include/database-pgsql.php:82\nStack trace:\n#0 /usr/share/fusionforge/common/include/database-pgsql.php(127): db_connect()\n#1 /usr/share/fusionforge/common/include/database-pgsql.php(264): db_connect_if_needed()\n#2 /usr/share/fusionforge/common/include/PluginManager.class.php(55): db_query_params('SELECT plugin_i...', Array)\n#3 /usr/share/fusionforge/common/include/PluginManager.class.php(180): PluginManager->getPlugins()\n#4 /usr/share/fusionforge/common/include/PluginManager.class.php(379): PluginManager->LoadPlugins()\n#5 /usr/share/fusionforge/common/include/pre.php(258): setup_plugin_manager()\n#6 /usr/share/fusionforge/www/index.php(29): require_once('/usr/share/fusi...')\n#7 {main}\n thrown in /usr/share/fusionforge/common/include/database-pgsql.php on line 82

Is this an selinux or firewall issue do you think?



RE: Install FusionForge to Plesk VPS [ Reply ]
By: Franck Villaume on 2018-03-12 08:08
[forum:1105]
Hi Graham,

My advice would be:
- install CentOS 7
- install FusionForge (FusionForge should take care of any dependencies)
- install & adjust DNS

Never tried with webmin.

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-12 01:40
[forum:1104]
Thank you so much for your advice Franck. Much appreciated.

By the sounds of it, I should install a clean CentOS 7, get the DNS and apache running, then install FusionForge. Make a backup of the server.

Once that is running, then I can try adding Samba to see if it impacts FusoinForge or Samba.

Do you think or know if the server can be administered with a Webmin control panel? Have you heard of any problems running Webmin along side FusionForge?

Thanks, Graham

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Franck Villaume on 2018-03-11 09:28
[forum:1103]
Hi,

DNS is fine.

You need to look closer to samba since FusionForge does a tight integration with users & groups. FusionForge can provide SSH access to the server (activated by default).

Configuration is fine as well. Some forges I'm running have inferior characteristics.

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-10 23:00
[forum:1102]
Thanks for your advice Franck, much appreciated. So dedicated server it should be.

I have an aging computer that I can use to build a dedicated forge server. It's currently being used as a samba and DNS server on our internat LAN. Its running CentOS 5 but I can fairly easily upgrade it to CentOS 7 while replacing the 150GB drive (holding /boot, /, and swap) with a 2TB and clean install of CentOS 7.

I'd like to keep DNS and Samba functionality on this machine. That should be OK, yes?

This machine is:-
- Dual-Core Pentium (E6300) @ 2.8GHz
- 4GB (1333) RAM
- Gb Ethernet

There will only be 1 or 2 developers attached to this server, with perhaps 1 or 2 clients interacting during the devlopment cycle.

We plan to use Git for the SCM

Do you think this machine will suffice?

Thanks, graham

RE: Install FusionForge to Plesk VPS [ Reply ]
By: Franck Villaume on 2018-03-08 07:24
[forum:1101]
Hi,

I dont know specific about Plesk. Your VPS should be as any other virtual server.

Keep in mind that FusionForge will require the following domain entries:
- <forge_domain_fqdn>
- scm.<forge_domain_fqdn>

and optionally:
- users.<forge_domain_fqdn>
- lists.<forge_domain_fqdn>
-<project>.<forge_domain_fqdn>

Usually FusionForge requires a dedicated virtual server. It may be not a good idea to mix FusionForge installation with other applications.

RPM installation on CentOS should be fine. It is automatically tested by our CI.

Install FusionForge to Plesk VPS [ Reply ]
By: Graham Miller on 2018-03-08 05:32
[forum:1100]
Hi all,

I am considering installing FusionForge to my Centos7 VPS controlled by Plesk Onyx.

It has multiple subscriptions, some with more than one domain. All of these are controlled by myself. I have root SSH access to the VPS.

Will the RPM install be OK on this VPS?

And how do I run it on a particular domain in the VPS?

Thanks.