Skip to main content

Posts

atlassian database configuration file

Where is the Database configuration file? I "often" have to change the database location from "localhost" to another one in the Atlassian products I use and I spend some amount of time figuring out where is the configuration stored.

Here I am.

Bamboo database configuration is in "bamboo-home/bamboo.cfg.xml"
Bitbucket database configuration is in "application-data/shared/bitbucket.properties"
Confluence database configuration is in "confluence/application-data/confluence.cfg.xml"
Jira database configuration is in "jira/application-data/dbconfig.xml"
Recent posts

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$…

Confluence REST add Page

How to add a Confluence Page as a child of an existing page via the REST API Then Confluence API examples are good, but they don't mention how to specify a parent page, under which I want the newly created page must be.
Thanks to https://community.atlassian.com/t5/Confluence-questions/Updating-a-confluence-page-with-Rest-API-problem-with-ancestors/qaq-p/74667 and https://community.atlassian.com/t5/Answers-Developer-Questions/How-to-specify-parent-page-of-new-updated-page-in-Confluence/qaq-p/488096 , this is the solution:
curl -u mihamina:my_password -X POST -H 'Content-Type: application/json' -d '{ "type":"page", "title":"Andrana", "ancestors":[{"id":"61145092"}], "space":{"key":"MVT"}, "body":{"storage":{"value":"This is a new page", "representat…

Vsftpd LXC ERR500

VSFTPD in container list error 500 When running VSFTPD in a container (LXC here, did not try on Docker), default configuration makes directory listing unavailable.
Listing directory content generate an Error 500: $ lftp ftp://192.168.99.58/os/ cd ok, cwd=/os lftp 192.168.99.58:/os> ls ls: Fatal error: 500 OOPS: This is due to the fact VSFTPD use "seccomp" (well, dont ask what it is: I dont know) In order to work arround, I just had to add this line to the VSFTPD configuration: seccomp_sandbox=NO There are many references to this, no need for me to be anotehre reference, I just wrote this article as a reminder for myself:

https://bugs.launchpad.net/serverguide/+bug/1302096https://www.linuxquestions.org/questions/gentoo-87/vsftpd-error-500-vsf_sysutil_bind-priv_sock_get_int-priv_sock_get_cmd-4175436938/https://technologytales.com/2013/09/21/turning-off-seccomp-sandbox-in-vsftpd/

disorder file awk

Randomize a file lines with AWKThe goal here is simple:

I have a file (music playlist, user list,...)I want to disorder it, just like I woul beat the cardsI asked this a long time ago on Usenet (fr.comp.os.unix), and I got this anwser from St├ęphane CHAZELAS.

If the file is not too big:
awk < fichier '{a[n++]=$0} END{for(srand();n--;a[i]=b) {b=a[n];a[n]=a[i=int(rand()*NR)]}; while(++n<NR)print a[n]}'
Otherwise:

awk < fichier 'BEGIN{srand()}{print rand(),$0}'  | sort -k1,1 | cut -d -f2-
I write it down here just for the archives