U.A.E. & Oman touring

Back in 2008/9 I was travelling a bit around UAE and Oman. Wrote 2 articles about that only in Czech but you might find GPS data file from Oman trip to Salalah usefull. U.A.E. trip Oman trip GPS…

Oracle SQL query – sort by Czech language

This was the best result so far that reflected czech characters and IMHO correct sorting. select * from test6 order by NLSSORT( (NAME),’NLS_SORT=Xczech‘)   46 46 d 47 47 D 134 134 dra 136 136 Dra 139 139 dráb 138…

Oracle setting – language specific search

Our R&D did struggle with Oracle setting for Czech specific search. Following might be the solution. ALTER SESSION SET NLS_COMP=ANSI;ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;– this should be XCZECH we discussed previously First 3 screenshots are from setting up the DB where…

Modify FW rules

The iptables firewall will need to be modified to allow connections to the Apache web server that will be installed. Edit your /etc/sysconfig/iptables file with your favorite text editor. Modify the file as outlined below by adding the black line…

Search for word in files

find . -type f -exec file ‚{}‘ ; Runs `file‘ on every file in or below the current directory. Notice that the braces are enclosed in single quote marks to protect them from interpretation as shell script punctuation. The semicolon…

Check and mount the disc

Check what directory is most fulldu -b | sort -n -r | more List of available discsfdisk -l Show mounted discs/directoriesmount Configuration of mounted pointsmore /etc/fstab List available vxdiscsvxdg listvxdisk list Volume Group displayvgdisplay Physivcal volume displaypvdisplay Mount disc to…

Cacti installation Fedora6

I’ve used following documentation Few commands is incorrect like mysql -u <username> -p <dbname> Configuration is at /usr/share/cacti/include or /var/www/html/cacti/ Some parts from following link helped as well Cacti-Installation-on-Fedora-101.pdf

Apache troubleshooting

Apache Error Log File All apache errors / diagnostic information other errors found during serving requests are logged to this file. Location of error log is set using ErrorLog directive. If there is any problem, you should first take a look at…