Changes

From SME Server
Jump to navigationJump to search
4,791 bytes removed ,  16:49, 15 November 2023
Line 1: Line 1:  
'''[[Rocket_Chat#smeserver-rocketchat_contrib|Contrib]]''': [mailto:jcrisp@safeandsound.co.uk][[User:ReetP|John Crisp]]
 
'''[[Rocket_Chat#smeserver-rocketchat_contrib|Contrib]]''': [mailto:jcrisp@safeandsound.co.uk][[User:ReetP|John Crisp]]
{{Note box|Please note that there is also a howto on manually installing Rocket.Chat [[Rocket_Chat|'''here''']]
+
{{Note box|Please note that there is also a howto on manually installing Rocket.Chat [[Rocket_Chat|'''here''' This is largely obsolete.]]}}
However, due to dependencies a manual install will not work on SME}}Version up to 0.61.2 will work with this contrib.
     −
Later versions will need my newer smeserver-rocketchat-0.2.x contrib which uses docker.
+
Later versions will need my newer smeserver-rocketchat-0.4.x contrib which uses docker.
    
==smeserver-rocketchat contrib==
 
==smeserver-rocketchat contrib==
 
{{WIP box}}
 
{{WIP box}}
This contrib aims to reduce some of the setup for rocketchat and add some flexibility with settings
     −
==Current version==
+
===Version===
 +
{{ #smeversion: smeserver-rocketchat }}
   −
3rd March 2018
  −
  −
Rocket RPM in my repo is 0.61.2
  −
  −
0.61.2 is likely to be the last version that can be installed direct to CentOS 6/ Koozali SME v9.x due to node module dependency requirements
  −
  −
I have tried to build 0.62.0 so far without success see this bug https://github.com/RocketChat/Rocket.Chat/issues/9943
  −
  −
https://reetspetit.com/smeserver/6/repoview/rocketchat.html
  −
  −
Latest source is here:
  −
  −
https://github.com/RocketChat/Rocket.Chat/tags
  −
  −
{{Note box|Latest version is 0.61.2
  −
This requires node 8.x and a prebuilt module which the RPM should install}}I am currently looking at running Rocket 0.62 on docker in CentOS 6 which I do have working using the existing local Mongo DB
  −
  −
I will post a link to a new wiki page when I have it tested further and know what I am doing with Docker
      
==Required repos==
 
==Required repos==
Line 35: Line 16:     
* [[epel]]
 
* [[epel]]
* [[Centos-sclo-rh]]
+
* [[mongoDB]]
 +
* [[Docker]]
 
* [[User:ReetP|reetp]]  
 
* [[User:ReetP|reetp]]  
* [[Fws]]
     −
/sbin/e-smith/db yum_repositories set epel repository \
+
===Installation===
Name 'Epel - EL6' \
  −
BaseURL 'http://download.fedoraproject.org/pub/epel/6/$basearch' \
  −
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch' \
  −
EnableGroups no \
  −
GPGCheck yes \
  −
GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \
  −
Exclude perl-Razor-Agent \
  −
Visible no \
  −
status disabled
     −
/sbin/e-smith/db yum_repositories set reetp repository \
+
There is now a smeserver-rocketchat contrib to install Rocket.Chat with docker.
BaseURL http://www.reetspetit.com/smeserver/\$releasever \
  −
EnableGroups no \
  −
GPGCheck no \
  −
Name "ReetP Repo" \
  −
GPGKey http://www.reetspetit.com/RPM-GPG-KEY \
  −
Visible yes status disabled
     −
/sbin/e-smith/db yum_repositories set centos-sclo-rh \
+
Install Mongo DB natively as per the wiki page https://wiki.koozali.org/MongoDB
repository Name 'Centos-RH Software collections' \
  −
BaseURL 'http://mirror.centos.org/centos/$releasever/sclo/$basearch/rh/' \
  −
EnableGroups no Visible yes status disabled
     −
/sbin/e-smith/db yum_repositories set nodejs8 \
+
Currently it is suggested to use Mongo 4.4
repository Name 'Node JS 8' \
  −
BaseURL https://rpm.nodesource.com/pub_8.x/el/6/x86_64 \
  −
EnableGroups no GPGCheck no Visible yes status disabled
     −
signal-event yum-modify
+
Mongo 5+ requires additional instructions in the CPU that older CPUs may not have. See teh wiki page for more.
   −
yum --enablerepo=nodejs8 install nodejs nodejs-devel
+
Do not go further than initiating the replicaset. Users are not required.
   −
==RocketChat 0.40+==
+
Next install smeserver-docker following the wiki page https://wiki.koozali.org/Docker
   −
From Rocketchat 0.40 onwards you require a higher version of node than the one in the SCL repos.
     −
Rocket.Chat v 60.0+ requires:
  −
node: v8.9.3
  −
npm: v5.6.0
     −
This can be installed from the node repo. The following is how to check and set up node versions manually - the rpm should sort this out for you.
+
Settings
   −
===Setup node versions:===
+
config set rocketchat service TCPPort 3000 mailPort 25 mailURL localhost access private status enabled SSLProxy yes Version 5.4.9 rootURL chat.domain.com
   −
Some of this is magic (to me!) and I still don't get the local and global stuff. Be careful with paths. See NPM Usage below for more.
  −
  −
The node rpm install node to /usr/bin but the npm 'n' module will install to /usr/local/bin
  −
  −
Check the version of node in /usr/bin
  −
  −
[root@test ~]# node -v
  −
v8.9.3
  −
  −
Install n version manager:
  −
npm install -g n
  −
Install specific node version (which will go in /usr/local/bin)<syntaxhighlight>
  −
n 8.9.3
  −
</syntaxhighlight>Install the LTS version<syntaxhighlight>
  −
n lts
  −
</syntaxhighlight>List available versions<syntaxhighlight>
  −
n ls
  −
</syntaxhighlight>Install latest version of npm:
  −
npm install -g npm
  −
  −
Install specific npm version:
  −
npm install -g npm@5.6.0
  −
Show the npm version<syntaxhighlight>
  −
[root@test ~]# npm --version
  −
5.6.0
  −
</syntaxhighlight>
  −
  −
=== Install required rpms ===
  −
<syntaxhighlight>
  −
yum --enablerepo=centos-sclo-rh,epel install scl-utils rh-python34-python rh-mongodb26-mongodb rh-mongodb26-mongodb-server \
  −
GraphicsMagick
  −
</syntaxhighlight>
  −
  −
You should be able to install the smeserver-rocketchat RPM now
  −
  −
yum --enablerepo=reetp install smeserver-rocketchat
  −
  −
Don't post-upgrade yet.
  −
  −
config set rocketchat service TCPPort 3000 mailPort 25 mailURL localhost access public status enabled
  −
config set rh-mongodb26-mongod service TCPPort 27017 mongoURL localhost access private status enabled
      
  signal-event post-upgrade;signal-event reboot
 
  signal-event post-upgrade;signal-event reboot
   −
Now we should be able to install rocketchat itself - it is better to specify a version here in case a newer version breaks anything:
  −
yum --enablerepo=reetp install rocketchat-0.59.6
  −
  −
Check the progress:
  −
tailf /var/log/rocketchat.log
      
  System ➔ startup
 
  System ➔ startup
Line 158: Line 68:  
  mongo
 
  mongo
 
  use rocketchat
 
  use rocketchat
  db.rocketchat_settings.update({"_id" <nowiki>: "SMTP_Host"}, {$set: {"value":"mail.yourdomain.com"}})
+
  db.rocketchat_settings.update({"_id" : "SMTP_Host"}, {$set: {"value":"mail.yourdomain.com"}})
      db.rocketchat_settings.update({"_id"</nowiki> <nowiki>: "From_Email"}, {$set: {"value":"admin@yourdomain.com"}})
+
db.rocketchat_settings.update({"_id": "From_Email"}, {$set: {"value":"admin@yourdomain.com"}})
       exit</nowiki>
+
       exit<
   −
Restart Rocket.Chat to be sure:
     −
service rocketchat restart
+
===Reverse proxy===
 
  −
You should now be able to register a new account and get a confirmation email. Check /var/log/qpsmtpd/current for any errors.
  −
 
  −
If you have not set the From address you are likely to get:
  −
 
  −
Mail with no From header not accepted here
  −
 
  −
===Errors===
  −
 
  −
If you have issues make sure you stop the rocket chat service
  −
 
  −
service rocketchat stop
  −
 
  −
Check /var/log/rocketchat.log
  −
 
  −
Try running main.js manually:<syntaxhighlight>
  −
export PORT=3000
  −
export MAIL_URL=smtp://localhost:25
  −
export MONGO_URL=mongodb://localhost:27017/rocketchat
  −
export ROOT_URL=http://my.smeserver.net/opt/Rocket.Chat
  −
node main.js
  −
</syntaxhighlight>
  −
 
  −
===SSL with Proxypass===
  −
{{Note box|This is still experimental and there may be issues with SSL only for the Primary iBay and Letsencrypt. You will need a minimum version of smeserver-rocketchat-0.1-5 }}
  −
 
  −
It is recommended to add Letsencrypt support as detailed below (see here for my contrib https://wiki.contribs.org/Letsencrypt)
  −
 
  −
We need some extra settings to enable SSL with ProxyPass.
  −
 
  −
Add the FWS repo:
  −
 
  −
db yum_repositories set fws repository \
  −
BaseURL http://repo.firewall-services.com/centos/\$releasever \
  −
EnableGroups no GPGCheck yes \
  −
Name "Firewall Services" \
  −
GPGKey http://repo.firewall-services.com/RPM-GPG-KEY \
  −
Visible yes status disabled
  −
 
  −
Update the repos:
  −
signal-event yum-modify
  −
 
  −
Install proxy pass rpm:
  −
yum --enablerepo=fws install mod_proxy_wstunnel
  −
 
  −
Regenerate httpd.conf
  −
signal-event remoteaccess-update
      
Now we need to setup our subdomain for the reverse proxy
 
Now we need to setup our subdomain for the reverse proxy
Line 228: Line 90:     
  config setprop rocketchat rootURL chat.mycompany.domain SSLProxy yes
 
  config setprop rocketchat rootURL chat.mycompany.domain SSLProxy yes
  signal-event remoteaccess-update
+
  signal-event smeserver-rocketchat-update
service rocketchat restart
  −
 
  −
If you can now successfully get to Rocketchat on your subdomain https://chat.mycompany.local you can disable default access on port 3000:
     −
config setprop rocketchat access private
+
Now start the docker container (always run compose from the docker directory)
signal-event remoteaccess-update
     −
You may find you need to clear your browser cache before it works correctly on https://chat.mycompany.local rather than http://chat.mycompany.local:3000
+
cd /home/e-smith/files/docker/configs
 
+
docker-compose up -d rocketchat
IF you have Letsencrypt support you can now set your main domain to SSL only:
+
docker logs -f rocketchat
    
  db accounts setprop Primary SSL enabled
 
  db accounts setprop Primary SSL enabled
 
  signal-event ibay-modify Primary
 
  signal-event ibay-modify Primary
   −
===Upgrades===
  −
  −
To upgrade rocketchat:
  −
  −
yum --enablerepo=reetp install rocketchat
  −
  −
To upgrade the rocketchat configurator:
  −
  −
yum --enablerepo=reetp install smeserver-rocketchat
  −
  −
===Bugs===
  −
  −
Look for bugs :-) As the contrib is not in CVS please report them in the forum and I will try and keep an eye out.
  −
  −
==Manual config of templates==
  −
expand-template /etc/rc.d/init.d/rocketchat
  −
expand-template /etc/profile.d/scls-rh-mongodb26.sh
  −
expand-template /etc/profile.d/scls-rh-python34.sh
  −
expand-template /etc/profile.d/scls-rh-java-common.sh
  −
expand-template /etc/opt/rh/rh-mongodb26/mongod.conf
     −
/etc/rc.d/init.d/rocketchat start
+
==Bugs==
/etc/rc.d/init.d/rh-mongodb26-mongos start
     −
==Mongod fails to start after reboot==
+
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-rocketchat component or use
 +
{{BugzillaFileBug|product=SME%20Contribs|component=smeserver-rocketchat |title=this link}}.
   −
Sometimes it appears that mongo fails to start after a reboot.
     −
I believe that this may be caused due to rocketchat being run by the forever service which means that rocketchat tries to keep running as the server shuts down despite mongod being stopped. This leaves lock files and prevents mongod from restarting properly. I think I probably need to look at the shutdown/start order of scripts.
+
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |disablecache=1 |component=smeserver-rocketchat |noresultsmessage="No open bugs found."}}
   −
A simple cure is as follows:
  −
  −
/etc/rc.d/init.d/rh-mongodb26-mongod stop
  −
  −
Remove the following files if they exist:
  −
  −
rm /var/opt/rh/rh-mongodb26/lib/mongodb/mongod.lock
  −
rm /var/opt/rh/rh-mongodb26/run/mongodb/mongod.pid
  −
  −
Restart the mongod service:
  −
  −
/etc/rc.d/init.d/rh-mongodb26-mongod start
  −
  −
Restart the rocketchat service:
  −
  −
service rocketchat restart
  −
  −
The following is simpler and appears to work:
  −
  −
service rocketchat stop
  −
/etc/rc.d/init.d/rh-mongodb26-mongod restart
  −
service rocketchat start
      
==Mongo DB examples==
 
==Mongo DB examples==
Line 314: Line 129:  
  db.rocketchat_settings.find({"_id" : "SMTP_Host"})
 
  db.rocketchat_settings.find({"_id" : "SMTP_Host"})
 
  db.rocketchat_settings.find({"_id" : "From_Email"})
 
  db.rocketchat_settings.find({"_id" : "From_Email"})
 +
 +
db.getCollection("rocketchat_settings").find({"name":"Joe Blogs"})
 +
 +
db.getCollection("rocketchat_settings").find({"_id":{$regex:"^LDAP"}})
    
  db.rocketchat_settings.findOne({_id : "From_Email"}, {_id:0, value: 1})
 
  db.rocketchat_settings.findOne({_id : "From_Email"}, {_id:0, value: 1})
 
  db.rocketchat_settings.findOne({_id : "SMTP_Host"}, {_id:0, value: 1})
 
  db.rocketchat_settings.findOne({_id : "SMTP_Host"}, {_id:0, value: 1})
   −
  <nowiki>db.rocketchat_settings.update({"_id":"From_Email"}, {$set: {"value":"admin@yourdomain.com"}})
+
  db.rocketchat_settings.update({"_id":"From_Email"}, {$set: {"value":"admin@yourdomain.com"}})
  db.rocketchat_settings.update({"_id":"SMTP_Host"}, {$set: {"value":"mail.yourdomain.com"}})</nowiki>
+
  db.rocketchat_settings.update({"_id":"SMTP_Host"}, {$set: {"value":"mail.yourdomain.com"}})
      Line 345: Line 164:     
Replace specific user ID's password in the database:
 
Replace specific user ID's password in the database:
  <nowiki>db.users.update( {'_id': 'useridhere'}, {$set: {'services.password.bcrypt': 'bcryptedpasswordhere'}}, {multi:true} )</nowiki>
+
  db.users.update( {'_id': 'useridhere'}, {$set: {'services.password.bcrypt': 'bcryptedpasswordhere'}}, {multi:true} )
    
My only issue with above (only time I needed it for recovery purposes), was that I didn't know which tool to use to generate a bcrypted password. So in the hurry I copied the hash from one account I already knew (my own). If someone knows a good command for creating one directly in bash, I assume it would do.
 
My only issue with above (only time I needed it for recovery purposes), was that I didn't know which tool to use to generate a bcrypted password. So in the hurry I copied the hash from one account I already knew (my own). If someone knows a good command for creating one directly in bash, I assume it would do.
Line 361: Line 180:  
  db.users.find({'username':'SomeUserName'}).forEach( function(u) { print(u.services.password.bcrypt + " ; " + u.username); } )  
 
  db.users.find({'username':'SomeUserName'}).forEach( function(u) { print(u.services.password.bcrypt + " ; " + u.username); } )  
    +
Set a user config item:
 +
 +
db.users.update( {'username': 'SomeUserName'}, {$set: {'settings.preferences.showMessageInMainThread': 'true'}} )
 +
 +
Find a single user:
 +
 +
db.getCollection('users').find( {'username':'SomeUserName'} )
 +
 +
Get limited information:
 +
 +
db.getCollection('users').find({}, {"username":1, "settings.preferences.showMessageInMainThread":1})
 +
 +
Reset 2FA nonsense:
 +
 +
db.users.update({'username': 'SomeUserName'}, {$unset: {'services.totp': 1}});
 +
db.users.update({'username': 'SomeUserName'}, {$unset: {'services.email2fa': 1}});
    
===Database Backup===
 
===Database Backup===
Line 373: Line 208:     
  mongorestore --restoreDbUsersAndRoles -d rocketchat -dir  /root/rocketchatmongo/rocketchat --quiet
 
  mongorestore --restoreDbUsersAndRoles -d rocketchat -dir  /root/rocketchatmongo/rocketchat --quiet
 +
 +
===Database Fix tables===
 +
 +
To remove user data file links a variation on this link
 +
https://github.com/RocketChat/feature-requests/issues/718
 +
 +
mongo
 +
use rocketchat
 +
db.rocketchat_user_data_files.remove( { } )
 +
db.runCommand({ compact: 'rocketchat_user_data_files', force: true });
 +
quit;
    
==Node usage==
 
==Node usage==
 +
 +
* This should go to a new Node page for reference
    
Use n, an extremely simple Node version manager that can be installed via npm (See http://stackoverflow.com/questions/7718313/how-to-change-to-an-older-version-of-node-js)
 
Use n, an extremely simple Node version manager that can be installed via npm (See http://stackoverflow.com/questions/7718313/how-to-change-to-an-older-version-of-node-js)
Line 426: Line 274:  
     status=enabled
 
     status=enabled
   −
rh-mongodb26-mongod=service
+
 
    TCPPort=27017
  −
    access=private
  −
    mongoURL=localhost
  −
    status=enabled
      
==Koozali SME v10==
 
==Koozali SME v10==
Line 445: Line 289:  
Docker Compose  (because it makes it easier to template)
 
Docker Compose  (because it makes it easier to template)
 
https://github.com/docker/compose/releases
 
https://github.com/docker/compose/releases
 +
 +
Docker environment settings to disable 2FA
 +
 +
  - OVERWRITE_SETTING_Accounts_TwoFactorAuthentication_Enforce_Password_Fallback=false
 +
  - OVERWRITE_SETTING_Accounts_TwoFactorAuthentication_Enabled=false
    
Mongo (I prefer to run a full instance rather than a docker one)
 
Mongo (I prefer to run a full instance rather than a docker one)
 
https://wiki.contribs.org/MongoDB
 
https://wiki.contribs.org/MongoDB
   −
Make sure you add replicaset support in Mongo
+
Make sure you add replicaset support in Mongo and set it up:
https://docs.rocket.chat/installation/manual-installation/centos
+
 
 +
mongo --eval "printjson(rs.initiate())"
 +
 
    
I'll add more later, and try and make a full contrib in due course
 
I'll add more later, and try and make a full contrib in due course
 +
 +
FAQ
 +
 +
https://handbook.rocket.chat/company/tools/rocket.chat
 +
 +
==Bugs==
 +
 +
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-rocketchat component or use
 +
{{BugzillaFileBug|product=SME%20Contribs|component=smeserver-rocketchat |title=this link}}.
 +
 +
 +
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |disablecache=1 |component=smeserver-rocketchat |noresultsmessage="No open bugs found."}}

Navigation menu