Skip to main content

Posts

Showing posts from 2019

move postgresql datadir

How to move PostgreSQL datadirThe contextI run RHEL 7 and CentOS 7 .
The sysadmin team has setup a virtual machine for me and they put a big "/data" partition.
The default PostgreSQL installation usually use "/var/lib/pgsql" for PostgreSQL location.
I want to change it to "/data/pgsql"

How toStop PostgreSQL
systemctl stop postgresql
Move  "/var/lib/pgsql" and retain ownership & permissions
rsync -av /var/lib/pgsql /data/
Note: don't remove "/var/lib/pgsql" yet!

Configure "/data/pgsql/data/postgresql.conf" with the new location:
- #data_directory = 'ConfigDir'           + data_directory = '/data/pgsql/data'
Configure systemd service file "/usr/lib/systemd/system/postgresql.service"
- Environment=PGDATA=/var/lib/pgsql/data + Environment=PGDATA=/data/pgsql/data
Start PostgreSQLand check it all:
# systemctl start postgresql # systemctl status postgresql # ps aux | grep pgsql # su - postgres $ psql p…

wget maven ntlm proxy

How to make wget, curl and Maven download behind an NTLM Proxy
Working on CentOS, behind an NTLM proxy:
yum can deal without problem with a NTLM Proxywget, curl and Maven cannotThe solution is to use "cntlm".
"cntlm" is a NTLM client for proxies requiring NTLM authentication.

How it works
Install "cntlm"Configure "cntlm" by giving it your credentialsby giving it the NTLM Proxy Start "cntlm" deamon (it listens to "127.0.0.1:3128")Configure wget, curl and Maven to use "cntlm" instead of using directly the NTLM ProxyNote: You will have then a kind of 2 stages Proxy: cntlm + the NTLM proxy

Configure CNTLMAfter installing cntlm, the configuration file is in "cntlm.conf".

You must have your domain (in the Windows meaning), proxy login and  proxy password.
Mine are respectively: rktmb.org, mihamina, 1234abcd (yes, just for the example)

You must have you NTLM Proxy Hostnama or IP and port
Mine are respectively: prx.r…

Jira server Firefox mobile

Make Jira server to deliver the mobile version when using Firefox Mobile. My use case I mostly receive Jira notifications by Email, read on my telephone.
When I want to comment the notification from my telephone, I usually choose Firefox Mobile.
Problem Unfortunately (dunno if it has to do with fortune), Firefox Mobile is not a supported web browser, so that Atlassian has made the choice to deliver the desktop version if the client is the client browses with an unsupported browser.
Solution I have an Apache reverse proxy in front of my Jira instance: I can force a Redirection to the mobile URL if I match the Firefox Mobile User-Agent.

... RewriteCond "%{HTTP_USER_AGENT}" "^Mozilla\/[1-9]\.0 \(Android [1-9]\.0\.0; Mobile; rv:[1-9][1-9]\.0\) Gecko\/[1-9][1-9]\.0 Firefox\/[1-9][1-9]\.0$" RewriteRule "^/browse/(.+)$" "https://jira.rktmb.org/plugins/servlet/mobile#issue/$1" [R,L,NE] RewriteRule "^/browse/(.+)#add-comment$…