discourse & cloudflare – show real users IP address

Discourse has a recent (5month old?) template to handle with this.

Captura de ecrã 2016-07-24, às 14.51.40

Lets add   – “templates/cloudflare.template.yml” to our templates scheme…

nano containers/app.yml

Save it and rebuild the app! 🙂

./launcher rebuild app

Captura de ecrã 2016-07-24, às 15.01.51

Et voilá!, my  ISP (portuguese) IP! 🙂

Captura de ecrã 2016-07-24, às 15.09.51

More readings

Discourse – email and Job exception: Net::ReadTimeout

 

Email

For a Discourse instance to function properly Email must be set up. Use the SMTP_URL env var to set your SMTP address, see sample templates for an example. The Docker image does not contain postfix, exim or another MTA, it was omitted because it is very tricky to set up correctly.

Source: https://github.com/discourse/discourse_docker

Yah! Discourse doesn’t came with any MTA (mail transfer agent).
I had to install Postfix so that Discourse could send out emails.

My emails weren’t getting delivered…
I was getting the following error on discourse logs(/var/discourse/shared/standalone/log/rails/production.log)….

Job exception: Net::ReadTimeout

After a few tweaks… I got it working…
This is my app.yml excerpt….

## TODO: List of comma delimited emails that will be made admin and developer
 ## on initial signup example [email protected],[email protected]'
 DISCOURSE_DEVELOPER_EMAILS: [email protected]'

## TODO: The SMTP mail server used to validate new accounts and send notifications
 DISCOURSE_SMTP_ADDRESS: mail.domain.com
 DISCOURSE_SMTP_PORT: 25
 DISCOURSE_SMTP_USER_NAME: [email protected]
 DISCOURSE_SMTP_PASSWORD: XXXXXXX
 DISCOURSE_SMTP_ENABLE_START_TLS: false
Readings

 

SELECT list is not in GROUP BY clause and contains nonaggregated column

 

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ” which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

 

Lets edit my.cnf

sudo nano /etc/mysql/my.cnf

and add the following lines to it, save and exit nano….

[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Lets restart mysql

sudo service mysql restart

It should work! 😉

 

bad ownership or modes for chroot directory component

 

Jul 14 11:41:18 sd-47XXX systemd-logind[643]: New session 26596 of user wojcatie.
Jul 14 11:41:18 sd-47XXX systemd: pam_unix(systemd-user:session): session opened for user wojcatie by (uid=0)
Jul 14 11:41:18 sd-47XXX sshd[8455]: fatal: bad ownership or modes for chroot directory component "/home/httpd/html/domain.com/"
Jul 14 11:41:18 sd-47XXX sshd[8430]: pam_unix(sshd:session): session closed for user wojcatie
Jul 14 11:41:18 sd-47XXX systemd-logind[643]: Removed session 26596.

/home/httpd/html/domain.com/ has to be owned by root:root and chmod with 755.

sudo chown root:root /home/httpd/html/domain.com/
sudo chmod 755/home/httpd/html/domain.com/