Install postgresql on Debian Squeeze / How to install PostGreSQL on Obsolete Debian installation


June 10th, 2016

how-to-install-postgresql-on-obsolete-old-debian-squeeze-tutorial

If you're in position like me to be running an old version of Debian (Squeeze) and you need to install PostgreSQL you will notice that the Debian 6.0 standard repositories are no longer active and apt-get update && apt-get upgrade are returning errors, thus because this Debian release is already too old and even the LTS repositories are inactive it is impossible to install postgresql with the usual.

To get around the situation first thing I did was to try to add followin Debian  repositories. to /etc/apt/sources.list
 

deb http://ftp.debian.net/debian-backports squeeze-backports-sloppy main
deb http://archive.debian.org/debian-archive/debian/ squeeze main contrib non-free
deb http://archive.debian.org/debian-archive/debian/ squeeze-lts main contrib non-free

After adding it I continued getting missing package errors while trying:
 

# apt-get update && apt-get install postgresql postgresql-client
….
…..

 

E: Some index files failed to download. They have been ignored, or old ones used instead.


Thus I googled a bit and I found the following PostgreSQL instructions working Debian 7.0 Wheeze and decided to try it 1 in 1 just changing the repository package wheezy word with squeeze
in original tutorial postgre's deb repositories are:

 

deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main


I've only changed that one with:

 

deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main

 

I guess though this worked for Debian Squeeze installing current versions such as Debian 8.0 Jessis and newer wouldn't be a prolem if you just change the debian version keyword witht he distribution for which you need the postgresql package


Here is all the consequential steps I took to make the PostgreSQL 9.5 running on my old and unsupported Debian 6.0 Squeeze

Create /etc/apt/sources.list.d/pgdg.list. The distributions are called codename-pgdg. In the example, replace wheezy with the actual distribution you are using:

# vim /etc/apt/sources.list.d/pgdg.list

 

deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main

debian:~# apt-get –yes install wget ca-certificates debian:~# wget –quiet -O – https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add – debian:~# apt-get update debian:~# apt-get upgrade debian:~# apt-get –yes install postgresql-9.5 pgadmin3

Next step is to connect to PostGreSQL and create database user and a database # su – postgres $ psql

Create a new database user and a database:

postgres=# CREATE USER mypguser WITH PASSWORD 'mypguserpass'; postgres=# CREATE DATABASE mypgdatabase OWNER mypguser;

 

or

# createuser mypguser #from regular shell # createdb -O mypguser mypgdatabase

Quit from the database

postgres=# q

Connect as user mypguser to new database

# su – mypguser $ psql mypgdatabase

or

# psql -d mypgdatabase -U mypguser

If you get errors like:

psql: FATAL: Ident authentication failed for user "mypguser"

edit pg_hba.conf in /etc/postgresql/9.5.Y/main/pg_hba.conf

 

local all all trust # replace ident or peer with trust

reload postgresql

/etc/init.d/postgresql reload …

 


To make sure that PostGreSQL is running on the system check the following processes are present on the server:

 

 

 

root@pcfreak:/var/www/images# ps axu|grep -i post postgres 9893 0.0 0.0 318696 16172 ? S 15:20 0:00 /usr/lib/postgresql/9.5/bin/postgres -D /var/lib/postgresql/9.5/main -c config_file=/etc/postgresql/9.5/main/postgresql.conf postgres 9895 0.0 0.0 318696 1768 ? Ss 15:20 0:00 postgres: checkpointer process postgres 9896 0.0 0.0 318696 2700 ? Ss 15:20 0:00 postgres: writer process postgres 9897 0.0 0.0 318696 1708 ? Ss 15:20 0:00 postgres: wal writer process postgres 9898 0.0 0.0 319132 2564 ? Ss 15:20 0:00 postgres: autovacuum launcher process postgres 9899 0.0 0.0 173680 1652 ? Ss 15:20 0:00 postgres: stats collector process root 14117 0.0 0.0 112404 924 pts/1 S+ 16:09 0:00 grep -i post

 

 


Well that's all folks now you will have the postgresql running on its default port 5433:

 

debian:/etc/postgresql/9.5/main# grep -i port postgresql.conf
port = 5433 # (change requires restart)
# supported by the operating system:
# supported by the operating system:
# ERROR REPORTING AND LOGGING # %r = remote host and port

 

 


Well that's it folks thanks The Lord Jesus Christ grace by the prayers of John The Baptist and Saint Sergij Radonezhki it works 🙂

 

 

Share this on

Adobe PDF Reader Mac OS X disable (Automatic) Update annoying prompt popping up every now and then


June 8th, 2016

Adobe-Reader-icon

Generally recent'y I've been more and more convinced the less you update the better. I've recently installed Adobe Reader on the Mac Book Air of Svetlana, cause I still have some illusions some PDFs are visible more clearly with Adobe. And soon I was unpleasently suprised that once installed Adobe automatically added auto-update service to the Mac and an auto-update policy that is popping up all the time with offers to update.

This could get crazy every normal person that prefer to not update software so often. There are not much people I know of that like to be puzzled on every next release about the new functionality he don't need anyways but I guess adobe's company aggressiveness escalated nowadays.

Thanksfully as I've googled quickly I found the fix on the common site for Mac problems Mac OS X Daily here

FlashUpdateNotification_annoying-prompt-how-to-disable

To get rid of the m'f'in Automatic Adobe Reader update

 

 Launch Terminal (located in /Applications/Utilities/)
* At the command prompt, paste this command exactly

defaults write com.adobe.AdobeUpdater.Admin Disable.Update -bool yes

* Hit return to execute the command 

You will get no output but anyways this nice command will have created for you inside your home directory (/Library/Preferences/) the file Preferences/com.adobe.AdobeUpdater.Admin.plist

You check the file's existence with command:

 

svetlana@localhost:~$ ls -al ~/Library/Preferences/com.adobe.AdobeUpdater.Admin.plist
-rw——-  1 svetlana  staff  62 Jun  6 19:52 /Users/svetlana/Library/Preferences/com.adobe.AdobeUpdater.Admin.plist

 

The conent of the file is simple it sets a boolean valiable of Disable.Update to True 

 

cat ~/Library/Preferences/com.adobe.AdobeUpdater.Admin.plist
bplist00?^Disable.Update

 

This will guarantee you that rebooting your Mac (which I guess was some 6 months ago or just a simple user logging out will not prompt you with the sh*tty annoying Adobe Update Manager

Share this on

Trip to Dragalevski manastir (Dragalevci) and Bay Krystio Hut in National Park Vitosha Sofia Bulgaria


May 28th, 2016
Vitosha-Dragalevtzi-Holy-Monastery

The spring and summer season in capital of Bulgaria Sofia gives unique possibilities for rest of the ordinary busy IT person like me because Sofia is situated in the ridge of Vitosha Mountain. Actually mountain tourism is really a great way to reduce pressure and clean up our heads of the overbusy daily office life consisting of non stop solving complex management, programming and other system administration tasks.

Dragalevci-Pyteka

Besides being a great place for lovers of Nature Sofia and nearby places gives a lot of entertainment mountain huts (the popular Hijas, delta planers, ski lifting, horse riding,  crystal clear air and mountain springs and perhaps the best a unique virgin nature situated just a 20 minutes with bus from the center of 1.5 million people.  One common route in Sofia for residents and also for tourist who come for a visit to Sofia is actually Dragalevci (a Sofia village like Suburb) and the route leading to the ancient and famous monastery of Dragalevci which is in honour of The Holy  Theotkos (Virgin Mary) Vitoshka.

Dragalevski-Manastir-entrance-icon-Holy-Virgin-Mary

From there there is ecological mountain footpath leading to a place called Bai Krystio who was a famous mountain tourist who helped a lot during 20 century for developing of mountain tourism in Bulgaria and Dragalevci and build a Hija (a mountain hut) which today is currently named in his honour.
Dragalevski-Manastitosha-Sofia-stenopis

For the lazy ones after 14:00 you can also go their with a car there is an asphaltous way leading to the Mountain Hut, even though it is much preferrable to go their walking the steep wild road going through the wood surrounded by beautiful springing waters. A walk in Dragalevci to the Hut could be successfully made for less than 2 hours with a small 5 minutes breaks the pathway leading to it is long and as a lot of tourists go their regularly there is no chance for you to lost yourself.  From Dragalevci there are a lift-station  chairs called "Goli Vryh" translationg as "Naked peak". Right the Dragalevci station their is a "plazza" which leads to the very famous near Sofia rest place called "Hija Aleko  / Hut Aleko".

Landscape-view-of-Hija-Aleko-Vitosha-Sofia-national-park

Walking through the wood once reaching the asphals, there is a sign showing the way  to Aleko hut (which is named after the famous Bulgarian author and publicist Aleko Konstantinov). Our trip started from Paradise Mall and to reach their we catched a bus number 93 the bus ticket is just like an ordinary city ticket and costs only 1 leva, the bus we travelled with was a bit archaic some old medel Mercedes but in my opinion there is also a charm in these too.
 

Going to Dragalevski monastery has 2 ways either the asphalt one or the wood footpath so we me (Billiana, Ilia and Svetlana) choose the footpath from which you see and hear the relaxing voice of Dragalevska river which is parallel the walk path. Dragalevski-manastery-monk-cells-Vitosha-mountain-Sofia
      Dragalevtzi view to the nuns cells and cemetery
 
Dragalevski Nun Monastery is a very peaceful and beatiful place  behind the beautiful church is the cemetery where about 7 nuns are peacefully laying waiting for the resurrection of the Dead that is to come in the Judgment day when the Lord Jesus Christ commands all the dead to Resurrect for judgement.

Dragalevski-manastir-Vitosha-Sofia-Bulgaria-alter-and-cemetery

 

 

Dragalevci Eastern Orthodox Church Holy Alters (actually belonging to 2 Churches the old and the new one)
Dragalevski-Monastery-Bells-Vitosha-Mountain

Dragalevtzi Monastery Bells Going through a stone stairs you reach a spring water (Holy Spring / Aiazmo) and a monastery wood pavillion where you can sit to have a picnic or have a peaceful rest looking through the beautiful garden downway.
Dragalevski-manastir-holy-spring

Holy Spring in Dragalevtci Monastery Virgin Mary (Vitoshka) Dragalevski-manastery-monk-cells-Vitosha-mountain-Sofia
Nuns livings cells

If you continue uplifting the mountain footpath after about 30 – 40 minutes you reach the mountain-lifts in the region of Bai Krystio and you see a lot of people lifting down the mountain, a great way to travel back if you're too tired from the walk.

Dragalevski-lift Sofia Vitosha mountain tourism

In the Bai Krystio hut you'll find a kind of mixture of a mountain restaurant and caffeteria where you can have a great lunch / dinner of meatballs with french fries / kachamak / bob a cabbage salat with carrots, shopska salata with beer or hot tea. We had the chance to have a quick interaction with the selling old granny and the helper kitchen lady which was too kind calling everyone my child and having the mothers like behaviour. The hygene and the overall atmosphere of the  Hija was okay though don't expect a 5 stars restaurant. Also it is notable that everyone we saw on the wood path leading to the Hija was greeting us so the atmosphere was much warmer than the cold and lonely cities we live in nowdays. If you continue from Bai krystio you can reach the marked pathway leading to Goli Vryh and from their you will reach to Aleko Hut, Cherni Vryh (Black Peak) or Momina Skala (The Maiden Rock).

Kraj_Momina_skala-view-to-mountain

We enjoyed a lot and I'm thankful to God for the great day we had today, if you happen to live in Sofia and looking for enjoyment for the weekend or you are on a holiday i recommend you go Dragelvtzi you'll not regret it.

Share this on

Trip to Balckhik Sea Resort City, Saint George Church Liturgy and The Palace Sea Garden of the Romanian Queen


May 11th, 2016

Balchik_Sea-Resort-Bulgaria_Aerial_photo-from-Black-Sea


Last Sunday 08.05.2016, we travelled with my beloved friend Elica on Opel Astra car (The so called Police Opel as this opel is well known in Bulgaria because it is the most used car by Police forces in Bulgaria. The distance  from Dobrich to Balchik Sea Town is very near (by car its only 31.5 km).
Nearby Balchik situated in 20-30 km, there are plenty of other uniquely beatiful Sea resorts, just to name a few Albena, Kranevo, Golden Sands, Kavarna.

From Balchik Seacoast it is visible Albena's remote shore, which is one of favourite tourist destination for Russian and one of the most famous tourist resort in Bulgaria are visible. What makes Balchik a great place to visit is also its unique and rich history, the city was inhibited more than 2500+ years ago, according to Herodotus in 585 – 550 year B.C.

Balchik-sea-resort-boats-near-coast

Balchik's history is very dramaticit was of the important sea cities to control by Thracians (during Thracian Empire) later by  Romans, conseqnently by Greeks in Byzantine times and since the creation of Bulgaria in year 681 by Bulgarians (during first and second Bulgarian Kingdom) and under Turkish Slavery 1396-1878 by Turks (during Ottoman Turkish Empire), then after the liberation again by Bulgarians, during the Balkan wars controlled by Romanians as part of Romania and finally since September 7 1940 after the restoration of Southern Dobrudzha region to Bulgaria again part of Re-United Bulgaria.

Once reaching Balchik, we attended Sunday Holy Liturgy in the Saint George majestic Church which on a first looks by its size gives the observer the impression of a small Eastern Cathedral Cathedral. On this date it was the Sunday of the Doubting Thomas the last day of the so called Bright week (the first week after Eastern Orthodox Pascha).

The service was amazingly beautiful with ac choire of only few ladies headed for my surprise by a non-Bulgarian (Belarusian) chorister lady Svetlana. The serving priest Father Stratia is a really tall and ascetic looking priest by the way he served the service and he prayed it was evident he possess a deep faith in God and perhaps a true heart relationship with Christ. The Church is full of icons and has a very unique iconostatis which by the words of the priest is the most unique Church iconostasis made by a Russian person and is the most unique and beatiful Church craftwork in the whole Dobrich region.

saint_George-Church-Eastern-Orthodox-Church-Seacity-Balchik

Saint George Eastern Orthodox Church Entrance – Balchik Sea City Resort, Bulgaria


The Russian influence in the Church is also evident by the many icons of well known Russian saints such as Saint John of Kronstadt, Saint Seraphim Seravski, Saint Xenia from Peterburg, Saint Matriona from Moscow, Saint King Vladimir etc. etc. Also it is very remembering experience in this Church the high number of different icons of saint George, many of which are well known and miracle making from Mount Athos (Fanailova) icon etc.

Saint_George_church-alter-in-Balchik-SeaCity-resort

Saint George Eastern Orthodox Church Alter – Balchik, Bulgaria

After the end of the Church service we had a walk through a piece of old stone strairs which are common for Balchik.

Balchik-old-city-stone-strairs

At the end of the service he blessed and wished a lot of "brightness and love" for the coming week and we went down from Balchik city center through a beautiful old stone stairs leading down to the Seacoast and Balchik's beach.

Balchik_cheap-caffeteria-sideview-to-black-sea-shore

We spend some time on the coffee waiting for Mitko and Samuil to drop by because we had agreed the previous day to travel by Mitko's Citroen C3 Pluriel (tutle sized car) from Balchik to Sofia.

Nearby the sea coast as in most of resorts there is a line with caffeterias and restaurands with a nice view facing the sea and a remote tiny mountain hights.
Balchik and the region is one of the most beautiful and green locations all around Dobrudja region with a beatiful plants, trees, herbs, woods. There are also few springs mineral drinable water in and nearby Balchik and the town is also famous for the healing mud center and many thermal springs of Tuzlata.

The temperature of the health water is 33 degrees centigrade; it is without color, low mineralized, and has excellent gustatory properties. The curative mud which comes from two firth lakes is dark brown, coarse-grained and has perfect physic-chemical properties. Near to the lakes there is a balneological center. Using the healing properties of the mug, good results have been reported on the treatment of gynecological, nervous diseases, diseases of the locomotory system and so on.

Balchik Tuzlata healing mud for recovering from and healing all kind of neurological, psycho-emotional and other diseases.

Balchik-Tuzlata-healing-mud-for-recovering-from-and-healing-of-all-kind-of-neurological-and-other-diseases

Perhaps the most famous and worthy thing to see in Balchik is Baclhik Palace (Dvoretz Balchik) which was constructed during 1926 – 1937  for the rest needs of the Romanian Queen during romanian control of the region in communist years of Bulgaria (1945 – 1989) and onwards it was reorganized to become one of the major and biggest Botanical garden in Bulgaria and is famous as Balchiks Botanical Garden exposing the largest collection of large cactuses in Bulgaria arranged in 1000 m2, the second biggest collection of Cactuses following after the one in Monaco.

Balchik-Botanical-garden-cactuses-second-largest-europe-collection-of-cactuses-in-Bulgaria

Few Cactuses shot – Balchik Botanical Garden Second Largest Botanical Garden in Europe

Balchik-Botanical-Garden-in-late-spring-Bulgaria-one-of-biggest-botanical-gardens-in-Europe

View to a Roman Catholic Chapel in Balchik Garden
 

The current Balchik Botanical garden has area of 65,000 m² and accommodates 2000 plant species belonging to 85 families and 200 genera a similar garden but smaller garden was build in Vrana's Bulgarian King Palace nearby Sofia

Balchik-sea-Botanical-Garden-and-a-queen-palace-one-of-most-beatiful-botanical-gardens-in-europe-and-world

The garden is absolutely unique to see mixing together architectural characteristics for Balkans and oriental motifs such as from Islam the garden was build by Italian architects Augustino and Americo and the overall arrangement of the Palace was made by a Swiss frorist.

Balchik-unique-one-world-best-botanical-gardens-Bulgaria

The main Palace building's extravagant minaret coexists with a Christian chapel, perfectly illustrating the queen's Bahá'í beliefs.

Balchik-heaven-like-botanical-garden-one-of-best-in-Europe

A virtual tour of Balchik Palace check is on the official site of Palace here


Dvorec-Balchik-Botanical-Garden-Islamic-Minare

Though Balchik is only about 10000 to 12000 of citizens it is the second largest town in Dobrich region, rich for historical reason in diverse culture and architecture.

Below is a small chunk of the many interesting old historical things the lover of beauty can enjoy.

Balchik_old_townhouse_1871_-_door_detail

Though it is a little in size it has obsiouly rich citizen spirituality as the city has 5 Churches 4 of which in active service.

Saint_Nicholas_liberation-movement-Church-Balchik

Saint Nicolas Church built in Liberation of Bulgaria period

Sveta_Petka_Tarnovska-Church-in-Balchik


Another unique beatiful Eastern Orthodox Church to visit if you happen to be in Balchik is Saint Petka Tarnovska Church

Balchik is situated on a steep hills thus, the roads are а bit uneven like in mountains, one can see in city center also some builtiful 'bulgarian renesanse' buildings left from 19th century architecture in the famous for that time Austrian / Italian Architecture.

Bulgaria-Balchik-old_building-from-19th-century

As Balchik is small in size it is perfect for people who want to have rest in a cozy town and still have all conveniences of a beach resort. The overall feeling of being in Balchik is like in a small Italian sea town with the only difference that the prices of food and drinks in Balchik are quite affordable if compared to Western Europe resorts. A four people meal with some small drinks nearby see would be cheap like 40-50 euro.

Share this on

Travelling on Diesel Electric train through ex – USSR (Soviet Union Belarus) from Jirovichi to Ros via Slonim


April 23rd, 2016

After spending 6 blessed  days in Jirovichi Sveto Uspenski Manastir (Zhirovichky Monastery) and having the possibility to pray and venerate the multitde of holy relics kept in Jirovichki (holy cloister), eat with the seminary students in Jirovichi spiritual seminary and receive a blessing of Archibishop Gurij and many of the Jirovichi serving father, hieromonks and talk to seminary students, visit the monastery library, viist students classrooms, computer lab  and get impression an impressions on general serminary monastir life, next on today I had the chance to travel for a one more time on an eletric multiple unit (famous in Russia / Belarus / Ukraine) as "elektrichka".

Sviato-Uspenskij-Jirovichki-manastir-bus-station

My  travel started in Jirovichi bus station which is situated nearby the Jirovichi Monastery walls.

Jirovichi is really unique monastery for a pilgrimage as it is the largest Eastern Orthodox Christian monastery and seminary (orthodox spiritual academy school) in Belarus. In Jirovichi is also the most holy considered icon in Belarus which happens to be also the smallest icon of the Non-hand made image of Virgin Mary (Theotokos).

Jirovichi-Dormition-of-Mother-Mary-Eastern_Orthodox-monastery

The miracle making icon of Holy Theotokos is self ingraved on a stone and was given as a sign from heaven to the inhabitants of Belarusia lands at that time because, perhaps many of the Belarusian "savage" like living people (dveriani) were falsely honouring cult hand made stones and trees and by the glorious miracle of God, the pagan inhabitants turned to faith in the True Lord and Savior Jesus Christ being astoned to see such an unique image of the mother of the Lord The Stone icon of the Virgin Mary appeared for a first time in Jirovichi in about year 1460.

The stone Virgin Mary icon was found by shepherds on top of a burning pear tree while wandering in the wood searching for their last sheeps.
Jirovichij (Bojii Mater)
as popular among Belarusians is said to have conducted a multitude of miracles through the years even to this very day.

Jirovichi-holy-icon-of-Mother-Mary-Jirovichka-bojia-mater

The found Stone self-ingraved icon of Jirovichi monastery, the smallest (miracle making) icon of Virgin Mary on earth

Today in Jirovichi monastery the place where the burning pear was is on the entrance of the monastery main Church which is in honour of the Dormition of Virgin Mary.

Jirovichi-bojij-mater-Mother-of-God-Jirovichi-holiest-place-of-Belarus

Jirovichi Bojii Mater

The monastery has 2 corpuses one for seminary students and one for monks. Inside the monastery there are about 20 monks and 10 priests regularly serving various services and holy liturgy daily. The seminary has a beautiful garden and a holy spring (well) right infront of the main Church entrance.

Jirovichka-Bojij-Mater-Virgin-Mary-miracle-making-icon-Jirovichi-monastery-Belarus

Jirovichi Mother of the Son of God Holy Icon

I've catched a bus from the holiest place of Belarus situated in village of Jirovichi (hosts about 1000+- citizens) to Slonim (Vokzal) = Train Station in Russian language. The bus from Jirovichi to Slonim is about 20-30 km and ticket was 8000 BYR (which is very cheap to about 0.40 USD).

Then from Slonim's Train station I've bought a Train ticket to Ros as I needed to go to Krasnoselsk and there was no direct transportation to it. Ros is a nearby poselok to Krasnoselsk (another poselok) nearby the town of Valkowysk , (Volkovoisk), Волковыск is inhabited by about 44000 people as of time of writting. In Russian (poselok is a little bigger than village but not really to be called town usually consists to up to few thousands of people up to 10 000 ppl.

Slonim-city-center-tank

Slonim City Center Tank

Travelling through ex empire of Soviet Union ( USSR ) which was an union in many things to reside the today's European Union is an unique experience as one sees the endeavor of soviet people to build different things that kept running the so called communist regime. 

The train ticket is really cost low (costed me 14.900 BYR Belarussian Rubles = about 0.80 dollar cents!). The train ticket looked just like an ordinary cash reeipt printed on a cheap paper, however uniquely on the train ticket is written besides the departure and arrival towns also, number of kilometers from town A to town B that you pay for, in my case from Slonim to Rosy this was 088 km. The train itself is a real excitement for anyone who is in love with history and old trains.

Slonim-city-Belarus-train-station

Slonim Belarus, Bus Station with a Kiosk

While waiting the train I dropped by the Caffeteria nearby the Train Station (Vokzal) and get a coffee for 6000 BYR (about 0.25 USD) and 2  kinda of local Belarusian snacks (bulochka) which costed about 3000 BYR each (0.12 USD)! Amazingly I had my coffee and a quick meal for less than a dollar, amazingly cheap isn't it? 🙂

Diesel-Elektrichka-inter-town-village-train-Belarus-DR1A-135
 

The Russian type trains are different from European as the rails distance is higher than in rest of Europe. Actually there was practical reason behind the rails standard differene as the Russian rails standard was invented to be different from European in order to stop Hitler's Nazi Germany to easily transport goods / tanks etc. from and to the Stalin's U.S.S.R.

Because of the different rail distance the inside of the train coupe is also wider separated in two column seats on each of it could sit up to 3 people:

Elektrichka-common-train-between-villages-and-cities-in-Belarus-Russia-and-ex-USSR

The train toilet is also unique to see as it belonged to the perhaps 30-40 years old train:

Even though the toilet doesn't look shiny still it was clean and there was a toilet paper, what intrigued me most was the hole on the ground in front of the toilet seat, the meaning of it was to be a kinda of a natural air-condition 🙂
The toilet flush is really amazing to see too, usually in europe and everywhere I've been including in Arab Emirates (Dubai), the water flush is being triggered on top of toilet paper with hand, well in ex-USSR this is different to to flush the water you have to press a button with your leg. The sink water is also interesting to see usually in Europe sink water is being triggered by pushing on top or by turning a stopcock, here in Russia you have to press down to make water flow. Talking about oddities another oddity for non-Belarusians in Belarus is the home bath locks, usually in europe we're used to have some kind of lock mechanism, locking with a key is most common, here in Belarus in home the lock doors mechanism is simply a button to be pressed up or down. 

In the train there was policeman, the policeman here in Belarus are firm man walking threating all around the train, so no place for bad or misbehaving citizens here in Belarus 🙂

I've safely reached village of Ros in 16:35 (with a delay of about 5 minutes) which is pretty normal for a non-western train, so overall train timing was cool. The train had some signatures with some instructions what is allowed and disallowed in the train, smoking was strictly prohibited and there was huge sum fine / "shtraf". Even though that I've seen a young person to smoke a cigarette (while closing the doors) in between coupes compartment obviously not much caring about the cops standing just a few wagons next 🙂

Before reaching Rosy we've passed on few villages, the villages here in Belarus are very beatiful there is difference in how Belarusians built a lot of their old wooden houses if compared to lets say Bulgaria or Balkans where we build brick solid houses a lot of village houses in Belarus are wooden, here is few pictures to give you an idea on how a typical Belarusian village looks like:

Belarus-ex-USSR-village

Belarus-derevnija-picture-ex-USSR-village

Even though the harsh Soviet atheistic communism regime which tried to force unbelieve in God and kill all kind of religiousness in people after the fall of the (USSR) United Soviet Socialistic Republic Belarusians who used to be historically a very religious people are gradually returning to faith.
An interesting fact worthy to mention is Belarus used to be proclaimed the first officially Atheistic country in the world which "freed itself" from the slavery of faith as the anti-christ communists used to be loving saing. 

Well obviously they were wrong nowadays, in many of villages which doesn't have their own Church in Belarus it is typical practice to bringup the Holy Cross of Christ as in below picture, each year the nearby city / town / Poselok Eastern Orthodox priest comes to pray to God for the blessing of the village and abundance of fruits this typically happens on Eastern or Nativity. In Belarus the Eastern Orthodox population is about 78% with some 15% person of Catholics, so often villages with mixed (Orthodox and Catholic) citizens has both separate crosses like in the picture where Orthodox and Catholics christians go to pray seperately.

Belarus-ex-USSR-village-Cross

Share this on

Flight from Sofia Minsk via Moscow Sheremetevo airport a few impressions from Russia and Belarus


April 17th, 2016

Sofia-Sheremetevo-Minsk-my-impressions-on-Russian-and-Belarusian-airport-what-it-is-like-in-Eurasian-Union

Thanks God, today we had a safe flight  for one more time with my wife Svetlana from Sofia  airport Vrazhdebna ( Terminal 2 )  to Minsk Belarus National Airport.
We travel 2 times to Belarus from Bulgaria (European Union) and though in Summer time tickets are more cheap and more regular and more convenient direct flights are available from Bulgaria to Minsk (Varna -> Minsk and Burgas -> Minsk) because of tourism the only way to travel quickly by plane to Minsk from Bulgaria is either via Moscow or via Istanbul as in the late days the political situation in Turkey is so ignited and the problem with these refugees and crazy bomb hihhadists is escalating we decided to not fly through Istanbul Ataturk airport even though the bit lower ticket prices.

The trip started from Sofia airport, there we had to go through the regular Metal Detector scan and removal of all metal things and going through the scan "gateway" doors. It seems after the last terrorist acts in Brussels Belgium and the risk for many other Islamic ones the security in airports was raised even further.

The distrust to the regular flight traveller like me has reached a crazy levels, these times besies the regular Metal detector, we were asked to give our hands and with a small device called "Trivka", were checked whether our skin has recently been exposed to explosive materials and stuff like this …

For both flights Sofia -> Moscow Sheremetevo and Sheremevo -> Minsk we flied with Aeroflot. This is not the first time we fly with Aeroflot and I think it will definitely not to be the last time. The airplanes we flight with were a new airplanes (SU) Sukhoi airplane and I enjoyed the flight.

My impression was the Russian pilots are "driving" / flying the plane very much like they drive an ordinary military airplane and that's quite fun as the airplane lift off and landing is done very rapidly exactly like being done with a military aircraft. Of course that could be my own gut feeling but it feels that way just to compare the aviators of other Westerner airplanes such as Boeng 737 / 777 does speed up before lift off much more easily so the flight out doesn't boost up so much adrenaline 🙂

The food in Sofia -> Moscow plane was quite decent too we were served the so common and valued in Russia, Belarus and Eurasian Union (EAC) juice called RICH before the meail toghether with some option for a beef meal or a chicken meal. The meal itself was worm and served in a board inside holding 2 cardboard boxes one containing the beef together with some spaghetti with steamed vegetables and the other one containing a tiny soared corny with a few pieces of beef (or pork) meet with two pieces of some healthy "black" rye bread pieces one of which was with some healthy sesame seeds accompanied by a small package of butter and some other souce. For a dessert  a delicious waffle like made of drought mashed fruits.

To be honest my first impression seeing that strange meal combination was not very positive, not to say that I honestly wanted to puke but after tasting it I would say I really liked it. Aeroflot offers also a vegetarianian menu but this has to be pre-ordered in advance and as I didn't ordered it earlier but for next time if it is a fasting period before Easter or Christmas I would definitely pre-order a vegeraranian meal.

What I truly liked about Aeroflot's Sukhoi SuperJet 100-95 with which we flight is the the simplistic design, no extras inside the plane no annoying monitors that show you all the time the altitude and reporting over which country you're flying and generally no useless and often unwanted information.
However we were reported by the pilot a couple of times some information such as that we're flying over Brest and Minsk, but of course the English of the pilot was hard to understand. Well the radio from the pilot on the airplane is definitely something that didn't impressed me as in any other western airplane the radio connection from pilot is much more clearly heard but I guess this can be solved quickly.
The toilets in the airplane was also normal ones as in any other Western built Boeng, here is time to say it was always intesting for me the wiping of the toilet once the wipe off button is pressed a small hole is opened letting some air directly from outside to pull off what is inside the toilet and that quickly cleans it up 🙂

Entering the airplane was done through an attachable cordon (air tunnel) and not like with my earlier flights in which we were driven to the airplane by an ordinary bus.  

moscow-sheremetevo-terminal-2

Sheremetevo is really huge airport and what impressed me is the fact Sheremetevo's airport letters were written in pure cyrillic, something surely unique to see for any person coming from the west.

First impression from Moscow Sheremetevo if compared to Shiphol airport in Holland or Heatrow port in London is Sheremetevo is much more calm and quiet, the airport looks feels relaxing and cozy even though its outlook is a bit old fashioned. The marketing and advertisement ads all around the place and complexity of Sheremetevo is much less if compared to any other huge International airport and some things are made in a typical Russian manner, even the number of products being sold in the airport are much less than in any western airport, though there is plenty of caffeterias and restaurants to have lunch / dinner.

Moscow-Shermeetevo-free-duty-shops-and-terminal-D-red-cooridor-signatures

The simplicity on Sheremetevo airport is really a great thing as even the monitors showing up information for the flights are displaying the information in a very understanable and simply way even though possessing generally an old fashioned DOS like outlook if compared to the modern European Union / United States airports.
While waiting on Terminal D for the onboarding to flight Moscow -> Minsk, I had an amazing view of the airports airplanes, moving all around.
This is the first time I saw so many airplanes gathered on one place even though I've flight via Sheremetevo previous times this is the first time I'm starting to understand how big is really Sheremetevo.

One unfortunate fact about the flught was that our luggage was not transferred directly to Minsk Belarus but sent from Sofia to Sheremetevo and then we had to wait for some time to pick it up right after we've been checked by the border control kiosk.
There by the border police Russian lady I had to answer her few questions and she filled me a small list called "Migration card" blank for the Transfer visa.
Oh yes, I almost forgot in order to fly through Russian to another country inside the Eurasian Union such as Belarus, you need to have a Russian Transfer Visa which is being applied for from Russian embassy in Bulgaria.
The Russian Transit flight  VISA costs 60 EUR (if it is to be made from 4 to 10 days) and for a 3 days creation of VISA it costs 95 EURO.

Sheremetevo_airport_Saint_Nicolas_Eastern_Orthodox-Chapel

One very great thing about Sheremetevo which I liked so much as I'm an Eastern Orthodox Christian is the existence of the Eastern Orthodox Chapel in honour of Saint Nicolas the Myrh-Bearer who is in our Christian faith considered to be a protector of all travelers. Thus if like me you happen to be a Christian and you're flying via Moscow it is very nice to drop by for a few minutes in St. Nicolas chapel to light up a candle and pray to the saint with a beseach for a safe flight.

 

Sheremetevo-airport-Saint_Nicolas_Chapel-iconostas-icons-of-the-Savior-Jesus-Christ-and-Virgin_Mary
Here in Minsk the airport is also very cozy and warm (especially the old terminal), so one have a relaxing feeling once in Minsk.
Minsk airport is also very well organized and well maintained so to be honest it looks to me personally more beautiful than Sheremetevo.

Minsk-National-airport-logo

To transfer to the 2nd airplane that flight from Moscow Sheremetevo to Minsk we needed to make transfer from Terminal F (where we arrived) to Terminal D which is the terminal that runs the local Eurasian Union flights from Russia to Belarus (note that Russian, Belarus doesn't have a flight border so anyone flying from Russia to Belarus could fly freely and once you reach Belarus, you're not being checked at all from any border control and that's pretty cozy because we didn't have to be checked for a second time once we reached Minsk.

minsk-inside-airport-shops-and-infrastructure

My impression from Minsk National airport is that it is a nice mixture of communistic remains architecture and modern architecture.
There are plenty of private  busses (marshrutki) that goes every 15 minutes from Minsk airport which is 43 km from city center as well as an ordinary state bus that gues to the train station and city center.
The train station in Minsk is also on a very much Western level and for some things it is even better as it has a cheap shop, where you can buy food at same prices as in any other supermarket chain in Belarus. 
We travelled to train station and there what striked me is the touch screen interface allowing you to see various info about Minsk infrastructure the trains timing and even there was a video call to Train Station Staff to find out more about anything you can't find out yourself.

 

Share this on

Remove pre-installed HP, Dell, Asus, Acer, Toshiba not needed default vendor software on a new bought PC notebook quickly with Decrap My Computer


April 14th, 2016

remove-default-unneded-software-from-manufacturer-hp-asus-acer-dell-toshiba
While browsing today and looking for software to clean up all the spy software from my corporate HP laptop, I've come across an interesting tool called Decrap which aims at removing Bloatware from a Windows PC / notebook

So what is Bloatware ?

The term Bloatware (also called jokingly crapware) is term is the one that was coined to describe, the default pre-installed software that comes to you together with Windows pre-installed OS by the hardware manufacturer.
I'm sure anyone who bought brand new branded PC or laptop over the last 10 years have already suffered the unwanted and unnecessery
bunch of software that comes pre-installed freeware programs aiming to help you in your daily work but in reality just slowing down your PC
and showing annoying popups or at best keeping useless in Windows system apptray.

Let me give you an example:

Cleanup (Remove) common ASUS, HP, Dell default  installed unneded (Bloatware) software

Many users may want to uninstall ASUS Crapware software such as ASUS Tutor, ASUS LifeFrame3, ASUS WebStorage and ASUSVibe.

Like Asus, HP computers often come preloaded with useless software from factory, example for this is HP Customer Service enhancements, HP Update, HP Total Care Setup and ProtectSmart.

If you buy Dell PC notebook soon you'll discover that there are several preloaded software (often unnecessery software) such as Dell Stage, Dell Digital Delivery and Dell DataSafe.

Toshiba computers and notebooks contain pre-loeaded "crapware" software from Toshiba.
Just to mention a few of those: Toshiba Disc Creator, Toshiba ReelTime, Service Station, Bulletin Board and Toshiba Assist.

Often there are fingerprint reader programs, Wi-Fi connection managers, Bluetooth managers, Audio Management sofware and other third party vendor software which tend to be not working as good as others softwares from third vendor, so Decrap is to help you to identify and remove these too in a easy GUI manner.

Non-experienced Computer users often leave the bloatware to hang around for even years and only if some relative that is an IT involved person / sysadmin / Even once you're aware that the Bloatware is on the system the ordinary user is hard to remove it as he is scared not to break the system.
Besides that fften this bloatware just soft comes so much integrated into Windows that removing it costs hours of tries and research online on
all the Bloatware components and even then could mislead you so you break the PC. programmer etc. comes home of such users finds out about the happily existing of the useless software on the notebook.


So here is Decrap My Computer coming at place aiming to help to remove the unnecessery Hardware vendor software in few easy (Click, Click, Click Next ..) steps.

decrap-my-computer-clean-up-bloatware-crapware-on-windows-laptop-main-gui

Then decrap does silently all the complex operations and suggestions to make the HP, Dell, Asus, Toshiba manufacturer prebundled software to be stopped and uninstalled.
Decrap My Computer is a freeware, lightweight and easy to use and lets you safely remove crapware and bloatware, or any software, from any Windows PC.

Even for Old computers, Decrap comes handy for the unexperienced avarage user who used his laptop with this useless  default vendors programs silently killing the performance respectively user experience for years.

Using Decrap is quite intuitive PC is scanned for Bloatware and then after a backup Windows Restore Point is offered you're offered to review and Uninstall the unwanted softwares. There is also an automatic mode but those one still could be a bit dangerous, so use the automatic mode only on multiple machines with the same model  / brand notebooks that comes prebundled with same sofware after testing and confirming the automatic mode on 1 initial machine will not break up some needed functionality.

decrap-your-pc-clean-up-windows-from-hp-dell-toshiba-asus-bloatware-unuseful-programs

Here is few screenshots of the tool in action:
decrap-choose-what-default-laptop-manufacturer-software-you-want-to-clean-from-new-bought-pc

decrap-choose-what-default-laptop-manufacturer-software-you-want-to-clean-from-new-bought-pc-1

decrap-choose-what-default-laptop-manufacturer-software-you-want-to-clean-from-new-bought

Share this on

Windows unable to delete file, file locked unlocking with Unlocker tiny tool


April 13th, 2016

Windows-Unlocker-program-show-what-program-or-software-is-locking-your-file-why-file-cant-be-deleted-file-locked

If you want to delete some file on a Windows server or Desktop but you get the a dialog with an error saying:

"This action can't be completed because the folder or a file in it is open in another program"

windows-unable-to-delete-file-file-locked-get-what-is-locking-it-and-unlock-the-file-with-Unlocker-tiny-desktop-graphic-tool-0

Then you need to find out which Program is preventing the file from deletion / locking the file, I've earlier blogged on how to check which process locks file with tasklist or wmic Windows commands

However some users might prefer to not bother with command line check what is locking a file and then killing the Process manually with taskmanager (taskmgr.exe) but do both file unlocking from one single gui interface, that's especially for lazy novice users, gamers and most of Desktop Windows users.

If you're one of those lazy users you will appriace

Unlocker – a useful utility for unlocking files, it will help you figure out which file is using a file what program is using the file you're prevented to delete.
Unlocker is the tool for you if you get any of below error messages, when you try to delete a file:

 

  • Cannot delete folder: It is being used by another person or program
  • Cannot delete file: Access is denied
  • There has been a sharing violation.
  • The source or destination file may be in use.
  • The file is in use by another program or user.
  • Make sure the disk is not full or write-protected and that the file is not currently in use.
     

windows-unable-to-delete-file-file-locked-get-what-is-locking-it-and-unlock-the-file-with-Unlocker-tiny-desktop-graphic-tool-1

If you stumble unto an locked file once you download and install Unlocker tool and launch the tool ( in case it disappers in future a mirror of Unlocker tool here ).
Once installed if you click properties over the file which is refused to be deleted you will get a new menu such as in below screenshot:

NB! Beware while installing Unlocker you might be offered to install a bunch of malware (make sure you deselect it). Also Unlocker's site is made in a way so the Download button could easily be confused with some Google Adsense

unlocker-windows-menu-added-to-properties-options-screenshot

Click on the file that is being locked and choose the Unlocker button, for example if you have a bunch of Videos installed and the video is being locked by VLC clicking on the file you will be shown VLC like in below screenshot

 

Unlocker-screenshot-locked-file-because-movie-opened-in-VLC

As you see you're shown the Process PID that is being used by the file the full path to the locking program and you have the option to quickly kill the process or unlock the file. Note that at some cases unlocking a file used by some critical program lets say Microsoft Word / Excel or OneNote could cause you a data loss, so before unlocking a file make sure you know what you're doing.

For more advanced users that still prefer GUI to find out what is Locking a file you can also check out Microsoft Process Explorer (advabced task manager) like tool.
If you haven't tried Process Explorer be sure to take a look at it as its a great tool for Win SysAdmins:

Process Explorer is very handy if you want to explore which .DLL (Windows Libraries) are used by a Process / Program

Windows-process-explorer-an-advanced-task-manager-for-windows-and-handy-tool-to-see-what-external-libraries-and-files-a-program-is-using.png

Windows-process-explorer-an-advanced-task-manager-for-windows-and-handy-tool-to-see-what-external-libraries-and-files-a-program-is-using-1

 

Share this on

How to force logrorate process logs / Make logrotate changes take effect immediately


April 10th, 2016

how-to-force-logrorate-to-process-logs-make-logrorate-changes-take-effect-immediately-log-rotate-300x299

Dealing with logrorate as admins we need to change or add new log-rorate configurations (on most Linux distributions configs are living uder
/etc/logrotate.d/
 

logrotate uses crontab to work. It's scheduled work, not as daemon, so usually no need to reload its configuration.
When the crontab executes logrotate, it will use your new config file automatically.

Most of the logrotate setups I've seen on various distros runs out of the /etc/cron.daily

$ ls -l /etc/cron.daily/logrotate
-rwxr-xr-x 1 root root 180 May 18  2014 /etc/cron.daily/logrotate

Here is content of cron job scheduled script:

$ cat /etc/cron.daily/logrorate

#!/bin/sh /usr/sbin/logrotate /etc/logrotate.conf EXITVALUE=$? if [ $EXITVALUE != 0 ]; then /usr/bin/logger -t logrotate "ALERT exited abnormally with [$EXITVALUE]" fi exit 0

Configurations change to lograte configs takes effect on next crontab run,
but what If you need to test your config you can also execute logrotate
on your own with below ommand:

 

logrotate -vf /etc/logrotate.conf 

If you encounter some issues with just modified or newly added logrorate script to check out the status of last logrorate executing bunch of log-rotate scripts run on Debian  / Ubuntu etc. deb based Linux:

cat /var/lib/logrotate/status

Or on RHEL, Fedora, CentOS Linux


cat /var/lib/logrotate.status

logrotate state -- version 2

 

"/var/log/syslog" 2016-4-9
"/var/log/dpkg.log" 2016-4-1
"/var/log/unattended-upgrades/unattended-upgrades.log" 2012-9-20
"/var/log/unattended-upgrades/unattended-upgrades-shutdown.log" 2013-5-17
"/var/log/apache2/mailadmin.pc-freak.net-access.log" 2012-9-19
"/var/log/snort/portscan.log" 2012-9-12
"/var/log/apt/term.log" 2016-4-1
"/var/log/squid/access.log" 2015-3-21
"/var/log/mysql/mysql-slow.log" 2016-4-9
"/var/log/debug" 2016-4-3
"/var/log/mysql.log" 2016-4-9
"/var/log/squid/store.log" 2015-3-21
"/var/log/apache2/mailadmin.pc-freak.net-error.log" 2012-9-19
"/var/log/daemon.log" 2016-4-3
"/var/log/munin/munin-update.log" 2016-4-9
"/var/log/unattended-upgrades/unattended-upgrades*.log" 2013-5-16
"/var/log/razor-agent.log" 2015-2-19
"/var/log/btmp" 2016-4-1
"/var/log/squid/*.log" 2014-11-24
"/var/log/munin/munin-graph.log" 2016-4-9
"/var/log/mysql/mysql.log" 2012-9-12
"/var/log/munin/munin-html.log" 2016-4-9
"/var/log/clamav/freshclam.log" 2016-4-3
"/var/log/munin/munin-node.log" 2016-1-23
"/var/log/mail.info" 2016-4-3
"/var/log/apache2/other_vhosts_access.log" 2016-4-3
"/var/log/exim4/rejectlog" 2012-9-12
"/var/log/squid/cache.log" 2015-3-21
"/var/log/messages" 2016-4-3
"/var/log/stunnel4/stunnel.log" 2012-9-19
"/var/log/apache2/php_error.log" 2012-10-21
"/var/log/ConsoleKit/history" 2016-4-1
"/var/log/rsnapshot.log" 2013-4-15
"/var/log/iptraf/*.log" 2012-9-12
"/var/log/snort/alert" 2012-10-17
"/var/log/privoxy/logfile" 2016-4-3
"/var/log/auth.log" 2016-4-3
"/var/log/postgresql/postgresql-8.4-main.log" 2012-10-21
"/var/log/apt/history.log" 2016-4-1
"/var/log/pm-powersave.log" 2012-11-1
"/var/log/proftpd/proftpd.log" 2016-4-3
"/var/log/proftpd/xferlog" 2016-4-1
"/var/log/zabbix-agent/zabbix_agentd.log" 2016-3-25
"/var/log/alternatives.log" 2016-4-7
"/var/log/mail.log" 2016-4-3
"/var/log/kern.log" 2016-4-3
"/var/log/privoxy/errorfile" 2013-5-28
"/var/log/aptitude" 2015-5-6
"/var/log/apache2/access.log" 2016-4-3
"/var/log/wtmp" 2016-4-1
"/var/log/pm-suspend.log" 2012-9-20
"/var/log/snort/portscan2.log" 2012-9-12
"/var/log/mail.warn" 2016-4-3
"/var/log/bacula/log" 2013-5-1
"/var/log/lpr.log" 2012-12-12
"/var/log/mail.err" 2016-4-3
"/var/log/tor/log" 2016-4-9
"/var/log/fail2ban.log" 2016-4-3
"/var/log/exim4/paniclog" 2012-9-12
"/var/log/tinyproxy/tinyproxy.log" 2015-3-25
"/var/log/munin/munin-limits.log" 2016-4-9
"/var/log/proftpd/controls.log" 2012-9-19
"/var/log/proftpd/xferreport" 2012-9-19
"/var/spool/qscan/qmail-queue.log" 2013-5-15
"/var/log/user.log" 2016-4-3
"/var/log/apache2/error.log" 2016-4-3
"/var/log/exim4/mainlog" 2012-10-16
"/var/log/privoxy/jarfile" 2013-5-28
"/var/log/cron.log" 2016-4-3
"/var/log/clamav/clamav.log" 2016-4-3

 

The timestamp date next to each of the rotated service log is when the respective log was last rorated

It is also a handy thing to rorate only a certain service log, lets say clamav-server, mysql-server, apache2 and nginx
 


logrorate /etc/logrorate.d/clamav-server
logrorate /etc/logrorate.d/mysql-server
logrotate /etc/logrotate.d/nginx

Share this on