Posts Tagged ‘future’

Migration of audit messages from snoopy to auditd

Tuesday, April 20th, 2010

his article may be out of date and may be deleted in the future.

This article explains the migration from the previous service "Snoopy" to "Auditd". Only commands that are executed as a user with root rights should be recorded here.

 

Uninstall/disable snoopy
 

Configuration of auditd

Files needed
Auditd start/stop script

/etc/init.d/auditd

Rules for monitoring by auditd

/etc/audit/audit.rules

Auditd plugin for syslog service

/etc/audisp/plugins.d/syslog.conf

Edit the /etc/audit/audit.rules file
Auditd can be specifically configured to capture and exclude messages. The following list is helpful for excluding certain event entries ("msgtype"):

* 1000 – 1099 are for commanding the audit system
* 1100 – 1199 user space trusted application messages
* 1200 – 1299 messages internal to the audit daemon
* 1300 – 1399 audit event messages
* 1400 – 1499 kernel SE Linux use
* 1500 – 1599 AppArmor events
* 1600 – 1699 kernel crypto events
* 1700 – 1799 kernel abnormal records
* 1800 – 1999 future kernel use (maybe integrity labels and related events)
* 2001 – 2099 unused (kernel)
* 2100 – 2199 user space anomaly records
* 2200 – 2299 user space actions taken in response to anomalies
* 2300 – 2399 user space generated LSPP events
* 2400 – 2499 user space crypto events
* 2500 – 2999 future user space (maybe integrity labels and related events)

Adding the rules

In order for auditd to record the desired events, rules must be defined.

List of rules set up
Below is a list and explanation of the rules set up:

-a exclude,always -F msgtype>=2400 -F msgtype<=2499
-a exclude,always -F msgtype=PATH
-a exclude,always -F msgtype=CWD
-a exclude,always -F msgtype=EOE
-a exit,always -F arch=b64 -F auid!=0 -F auid!=4294967295 -S execve
-a exit,always -F arch=b32 -F auid!=0 -F auid!=4294967295 -S execve

The first rule excludes crypto events in user space – these include, for example, messages about a user logging in.
The second through fourth rules remove the information not necessary for monitoring before it is logged.
The fifth and sixth rules capture the commands entered by users moving within an interactive shell. Services etc. executed by the system are therefore not recorded.
It should be noted here that a separate rule must be created for systems that contain both 32- and 64-bit commands and libraries.

Rule syntax

In general, it makes sense to keep the number of existing rules low in order to reduce the load. Therefore, if possible, several rule fields (-F option) should be combined in one rule. Since Auditd obviously has a problem with multiple event entries that are defined in plain text, these have been created in individual rules. The syntax description of the individual rules is given in the next listing:

-a contains the instructions
The action value "exclude" and the list value "always" are specified for rules that should not lead to any log entry
The action values ​​"exit" and "always" have been specified for rules that should lead to a log entry
"exit" stands for a log entry after the command has been executed
-F defines a rules field
Depending on the application, the rules defined here filter by event entry ("msgtype"), architecture ("arch") and login UID ("auid").
-S stands for the syscall. In the rules that should lead to a log entry, the value "execve" is monitored – i.e. when commands are executed.

Redirect to syslog

Within the file /etc/audisp/plugins.d/syslog.conf the value

active = no
on

active = yes
set.

restart auditd with the command

/etc/init.d/auditd restart
the settings are accepted.

Additional information

The following man pages can be consulted for more information:

auditctl
audit.rules
auditd
auditd.conf

THX 1138 a must see SCI FI-movie every Computer geek or IT professional must watch

Wednesday, October 25th, 2017

 

 



thx-1138-a-must-see-sci-fi-movie-of-the-past-thx-film-poster

 

 

THX 1138 is an American science fiction film set in a dystopian future in which the populace is controlled through android police officers and mandatory use of drugs that suppress emotion, including outlawed sexual desire. It was directed by George Lucas in his feature film directorial debut in 1971.

Produced by Francis Ford Coppola and written by Lucas and Walter Murch, it stars Donald Pleasence and Robert Duvall.

THX 1138 was developed from Lucas's student film Electronic Labyrinth: THX 1138 4EB, which he made in 1967 while attending the University of Southern California's film school. The feature film was produced in a joint venture between Warner Bros. and Francis Ford Coppola's production company, American Zoetrope. A novelization by Ben Bova was published in 1971. The film received mixed reviews from critics and failed to find box office success on initial release; however, the film has subsequently received critical acclaim and gained a cult following, particularly in the aftermath of Lucas's success with Star Wars in 1977.

THX1138 Director's cut: The Future Trailer

The movie is one of the most awesome movies on SCi-Fi Topic I've ever seen much better than comercial ones such as Star Wars and perhaps one of the best if not the best movies, George Lucas has done ever.

The THX with its Android police is another inspirational one that perhaps has inspired the naming of the Android Operating System like that.

THX 1138 movie is an example of a kind of communist society in the future which perhaps the global elite has planned for humanity. The only mean of the THX 1138 is to consume and work being programmed (conditioned) by the central authorities with a full control over all aspects of the individual life, its kinda of pretty much what is today western world has been turning into.

I believe we're currently in a transitional stage to this futuristic society in which, the life costs zero.

Well, after all the global programmers of society in our age has a sense of humour to finance a movie like that 🙂

The Dangers of Authority Over-Obedience

Thursday, June 28th, 2012

dangers-of-authority-over-obesity

How much and to what level should, we obey authority. And is it really that authorities in force things always the best for the masses? Well history has shown and shows again and again that being obedient to Authority is a good think only if the authority did not pass a certain borders. In second world war both Nazis and Stalinist Russian "pogroms" passed this borders. So how this came to be? How Stalin and Hitler become the totalitarian dictators they did?

By completely dis-obeying the authorities at their times. Hitler was in Jail, Stalin was membering a communist guerillas who blow up trains and did subversive activities to Tsarist Russia. Hence obviously this two evil man was against the their times authorities. The way they raise up to power was also with breaking then ruling authorities. As a result of their dis-like for the system before Nazi Germany and Communist Russia both of the dictators lived in isolation be it among communist with anarchistic anti-government ideas in Stalin's case or living inprisoned in Hitler. The later results of being exposed to this isolation become evident, when by all means they came to power. Both of them were people with enormous egos (egoists). The only think that moved both of them was their own megalomanias and desires to be controlling imitating how God controls the universe.

But the WW II killed jews and the pogroms Stalin did in Russia was not only Stalin and Hitler's fault. It was a result of one false propaganda and openly anti-christian spread ideas all around the world. This atrocities were a fruit of the huge isolation that happened in many people lifes and their detachment from faith in God, also it was a cause of a huge masses of people who obeyed the new-created communist and Nazi authorities without questioning.
True Christians at the time in both Russia and Germany tried to oppose the new ungodly totalitarian order mainly (through press), the attempt was futile.

The reason was that many people in Germany become so heavy dependent on the local authorities. That the masses did not have the guts to go to the streets and oppose the new anti-human laws edicted. In Russia, probably at least half of the people living their lived in villages and used to obey the Tsar's authority as the monarchy was a prooved working system and for many generations people lived in monarchy and knew only monarchy; also many people in Russia were lacking high level education neither were prepared to fight something as the raising communism sponsored by Westerm Europe. So Western Europe gave money to Lenin and the communists in Russia to destroy the country monarchy from within, whether Hitler took a loan from America. Just think for a while and see how ridiculous all this is … What makes the whole thing even more ridiculous was that the money for financing both Hitler and Stalin activities (including the atrocities against poor jew people)) was financed with bank money given as loans by other Jews …

All this money were loaned because of dirty profit. There were many people in the chain who could have said no and protest against loaning the money but not wanting to disobey the system they were silently helping the whole war to bloom.

Now just 67 years after thanksfully by God's grace this war has over, the world headed the same direction as before the WW II. The severe economic crisis, the isolation of large masses of individual from family, the decay of family values, the lack of community and the over-use of technology and non-direct communication. All this makes us isolated. The increased isolation makes us unable to operate normally in many cases and hence highly dependent on the social system (just see how many people in Europe are living thanks to social pension).
The social system dependence and inability to live and think out of the established governmental system puts us in a situation, where we cannot live out of the system and to always adapt to the system. For many things, we can't say NO anymore. The over-increased surveillance and people tracking that was accepted as normal not only through Europe and America continent but the whole world is a good example on how publicity of severe freedom threat is kept in secret. People who talk about their dislike for surveillance and the possible short future abuse are even nowadays considered as abnormal paranoids. Suddenly it is more and more happening that normal society concerned people are being concerned as crazy and probably the future fate of people who in anyways question the more and more totalitarian like system that is being build right before our eyes will be similar to the WW II jews extermination …

Hannah Arendt "The Dangers of Obedience"

Intel and IBM future tech world vision about the world, do we really want this?

Saturday, June 30th, 2012

the-hellish-future-as-envisioned-by-leading-it-companies-IBM-and-intel-and-the-slavery-of-Internet-of-Things

I'm quite a visionary person as such I'm always interested to prognosis on what the world might look like few years from now. Below are two videos showing IBM and Intel's vision on what might future bring us. I don't know about you but I'm strong in my conviction that I DON'T WANT TO LIVE IN SUCH WORLD. I'm pretty sure that many other people share my opinion that such a world is not fun and is far from what really we're supposed to live. The sad thing is the corporations are already powerful enough to impose their vision and make the vision reality.

It is my understanding that the main problem we have to solve is not how we can embed better or newer technology to change our life (for good?) but rather how we can get out of the trap of living in a fake world like the one displayed in the video. Obviously the vision of this two giant companies is not far from what we're forewarned in the holy bible in Revelation. In revelation we read that there will be a unified system, where everything and everyone on this earth will be market and whoever does not have the mark "of the beast" he will not be able to buy or sell within the system. This prophecy closely matches the vision of future marketing offered as a possible outcome by IBM. I don't think IBM have red in Revelation to get their idea on their infernal system shown within their vision of supermarket video

The logical conclusion might dirive therefore is there is a higher force who leads IBM (and possible most if not all of corporations) on creating the fake tech-nocrat culture society which is building right in front our eyes.
The destruction of real communities and the worsening conditions within the Orthodox Church are another symptom that the End Times as prophecised centuries before are closer than we think.

It is my firm believe that people who does understand about this problem should start uniting and say no to technology innovation that leads us in this technological trap ,,,,,

I'm sure even people who does not have a believe in Jesus Christ and are not Christian from other religions are also seeing that the direction this world has taken up is dark.
We should be very dumb and blind not to see that technology is boxing us and leading us to a modern day techno slavery …..

Intel | Future Technology | Vision

IBM's vision on how future market might look like

What is predictive programming and how it is used to manipulate our ideas about the future

Sunday, May 20th, 2012

what-is-predictive-programming

What is Predictive Programming?

Predictive programming is a subtle form of psychological conditioning provided by the media to acquaint the public with planned societal changes to be implemented. If and when these changes are put through, the public will already be familiarized with them and will accept them as 'natural progressions'; thus lessening any possible public resistance and commotion. Predictive programming therefore may be considered as a veiled form of preemptive mass manipulation or mind control.

Here are few youtube videos pretty well showing some major all main stream youth culture know movies like the Matrix, Fight Club and Star Trek that has a rich predictive programming embedded:


 

Predictive Programming of Mind Control by Media


 

Hollywood's Agenda 1 – Predictive Programing and Hidden in Plain Sight

The propaganda in the movies is clear:

New World Order, dictatorship, an upcoming human saviour Messiah and everything we know prophecies in the Holy Bible by the elders and the saints and the saint Living Orthodox Christian books.

Predictive programming is not only in the hollywood produced high budget movies, its also widely used in the TV news and games like X Factor and many many more …
There is plenty of interesting info on the subject, but be careful as it is very addictive. At the end nomatter what kind of secret agenda lays in all this mass medias to imply us ideas on possible future events or possible future gadgets economic systems or whatever it is still up to God to allow any of the agendas to come to reality.

One major methodology used in almost all brainwashing pre-conditoning, predictive programming is the so called Hegelian Dialectics claiming the foruma ( A + B = C)

Thesis + Antithesis = Synthesis

The Hegelian Dialectic visual Diagram Thesis and Anthisis equals Synthesis

The scenarios in most movie or news is like that.

First they show you something making a Thesis (Let's say – The Dolly ship first cloned animal), then they show develop an Anti-Thesis (Big money are paid for people to criticize on the dangers of mass animal cloning), then after a while there is synthesis = (The mass animal cloning is dangerous but necessery and therefore OKAY so we will clone.). The same scenario is repeated again and again myriad of times. For the unknowing observer, all the 'trial' looks perfectly legid…

Communism was one good example of a Regime that people thought will continue forever and every country sooner or later could become communist. The facts years after is clear Communism is pure Utopia and even though the regime was so strong it failed 🙂 So we should not worry too much and 'we should not our hearts be  troubled' by this unwalful stuff being around, but we should be aware of it and next time we're told this in school or university and claimed as being okay we should oppose it as TRUE CHRISTIANS. At the end God is in control as we read in the Holy Bible, so nomatter happens if we trust God and pray for his mercies, he will never forsake us.

 

The Church feast of St. Tsar (King) Boris Mihail (Michael) I – Baptizer of Bulgaria – 2nd of May a Triumph for Bulgarian Autocephalous Church and Church Slavonic

Monday, May 2nd, 2011

saint Tsar Boris the baptizer of all Bulgaria

Today on Second of May every year in the Bulgarian Orthodox Church calendar we commemorate the memory of Saint King Boris (Michael) who is a baptizer of Bulgarian nation and among the greatest saint of Bulgaria, perhaps second in saintship after St. John of Rila.

St. King Boris was the ruler of the First bulgarian Empire (852-889) the actual title as we know it from the chronicles is not king but archont which literally means ruler, but as the main chronicles who came to us are Byzantine we have to take in consideration that Byzantine Chronicles aimed to discredit the Bulgarian rulers because of feeling inferior every non-Byzantines who in Byzantine terms were considered barbarians.

He had a notable correspondence with Pope Nicolas II head of the Western Church before the Great Schism.
Saint Boris I is famous with with 115 Questions (which are fully preserved). He  beseech the pope to sent an apostoles of faith who will teach the new nation to faith in the same time he lead a correspondence with the Byzantine emperor and the Eastern Church.

The pope sent 2 missionaries cardinal Formiosa of Portuens and Bishop Paul of Papulon. King Boris requested for Cardinal Formiosa to become a future archibishop of Bulgaria, but the pope Nicolas II being afraid of loosing ground of a choice of future Bulgarian archibishop rejected king Boris request it is interesting fact that the same cardinal Formiosa become the next Pope of the Roman Western Church in period (891 – 896).

Taking in consideration the papal's desire to dominate over him and the more freedoms given by the Byzantine Church along with the fact that Saint Cyril and Methodius's pupils came to him with a ready Church Slavonic Glagolic version of the Holy Bible and a new Church language (and considering the fact that the seven pupils of St. Cyril and Methodius were being chased away from Great Moravia (Saint Clement of Ohrid (Kliment Ohridski) and Naum Ohrdiski with Sava, Angelarius and Gorazd) and seeing the fallacy of the filioque addition to the Creed of Faith finally King Boris received baptism by the hands of Patriarch Photius.

He received holy baptismal in year 864, receiving the Christian name Michael (Mihail) receiving his Christian name from his godfather, Emperor Michael III.

According to Church tradition the reason to Baptize in Christian faith was his amazement of an icon of the Judgement Day he saw in one of his visits to Constantinople.

The Church tradition also says saint Boris I's sister have lived for a long time in Constantinople, where she received baptism and once returning to the Bulgaria she bring the light of faith here too.

Besides that some of his family has already earlier converted to Christianity and some earlier Bulgarian Khans such as Trivelius (Tervel) who is considered to saved Europe from Muslim Invasion earlier were already Christians.

King_Boris I bapttish of Byzantine Emperor Michael III

During his holy reign he has established mass Christianization of Bulgaria, where the traditional ancient pagan traditions and belief in fake gods like Tangra were abolished completely.

St. Tsar Boris has secured the Bulgarian Church an autocephalousy, he also received the saints Cyril and Methodius, when they were banished from Great Moravia.

Our saint king has secured a refuge for st. Cyril and Methodius and provided them with assistance to develop the Slavonic alphabet and literature.

After he abdicated in 889, his eldest son and successor tried to restore the old pagan religion but was deposed by Boris I. During the Council of Preslav which followed that event, the Byzantine clergy was replaced with Bulgarian and the Greek language was replaced with Old Bulgarian as an official language of the Church and the state.

Bulgaria_under_rule_of_Boris_I-st-the-baptizer-king-of-Bulgaria

In 889 Boris abdicated the throne and became a monk. His son and successor Vladimir attempted a pagan reaction (to return the Bulgarians to the old belief in Tanra), which brought Boris out of his monastic life in 893 out of zeal for Christ and a fatherhood for the future of Bulgarian nation.

Vladimir was defeated and blinded by a miracle of God as Boris had less soldiers than his pagan son but in the name of the Lord Jesus Christ he showed victorious.

Once defeating his unbelieving son, Boris gathered the Council of Preslav in which the Old Greek language in Church was replaced with Church Slavonic and most imporantly on the council King Boris on the Church assembly placed his third son, Simeon I of Bulgaria on the throne, threatening him with the same fate if he too apostatized.

Simeon I was reluctant to become a secular ruler as according to some of the written sources he was preparing to become a great spiritual leader a monk and perhaps a next archibishop or even patriarch in the newly established autocephalous Bulgarian Church but following the monk rule of humility he decided and accepted the throne but throughout his life he kept his great zeal for monasticism and enlightenment. His ruling become a golden age for the Church Slavonic he financed seriously and worked hardly to prepare educated monks and to translate a major works of the Holy Fathers such as Shestodnev (The Six Days of Creation), Simeonov Sbornik (Simeon's Collection) and many of the key works of saint Athanasius the Great, Saint Basyl the Great, Saint John of Damascus etc.

According to some historians it was King Simeon who later give birth to the second by size Monastic Community in Byzantine Emperire the Stone Monasteries of (Meteora).

Boris returned to his monastery, emerging once again in c. 895 to help Simeon fight the Magyars, who had invaded Bulgaria in alliance with the Byzantines. After the passing of this crisis, Boris resumed monastic life and led a holy life until he pass out in year 907.

Here is the daily troparion assigned by the Bulgarian Orthodox Church sang at the churches today (the text is translation from Bulgarian):

St. Boris-Michael, prince of Bulgaria, Troparion

Full of the fear of God, and enlightened by holy baptism, thou becamest a habitation of the Holy Spirit,
O right-believing King Boris; and having established the Orthodox Faith in the land of Bulgaria,
and set aside the scepter of kingship,
thou madest thine abode in the wil derness,
didst flourish in ascetic struggles, and found grace before the Lord.
And now, standing before the throne of the Most High, pray thou, that He grant unto us who entreat thee salva tion for our souls.

Fix MySQL ibdata file size – ibdata1 file growing too large, preventing ibdata1 from eating all your server disk space

Thursday, April 2nd, 2015

fix-solve-mysql-ibdata-file-size-ibdata1-file-growing-too-large-and-preventing-ibdata1-from-eating-all-your-disk-space-innodb-vs-myisam

If you're a webhosting company hosting dozens of various websites that use MySQL with InnoDB  engine as a backend you've probably already experienced the annoying problem of MySQL's ibdata1 growing too large / eating all server's disk space and triggering disk space low alerts. The ibdata1 file, taking up hundreds of gigabytes is likely to be encountered on virtually all Linux distributions which run default MySQL server <= MySQL 5.6 (with default distro shipped my.cnf). The excremental ibdata1 raise appears usually due to a application software bug on how it queries the database. In theory there are no limitation for ibdata1 except maximum file size limitation set for the filesystem (and there is no limitation option set in my.cnf) meaning it is quite possible that under certain conditions ibdata1 grow over time can happily fill up your server LVM (Storage) drive partitions.

Unfortunately there is no way to shrink the ibdata1 file and only known work around (I found) is to set innodb_file_per_table option in my.cnf to force the MySQL server create separate *.ibd files under datadir (my.cnf variable) for each freshly created InnoDB table.
 

1. Checking size of ibdata1 file

On Debian / Ubuntu and other deb based Linux servers datadir is /var/lib/mysql/ibdata1

server:~# du -hsc /var/lib/mysql/ibdata1
45G     /var/lib/mysql/ibdata1
45G     total


2. Checking info about Databases and Innodb storage Engine

server:~# mysql -u root -p
password:

mysql> SHOW DATABASES;
+——————–+
| Database           |
+——————–+
| information_schema |
| bible              |
| blog               |
| blog-sezoni        |
| blogmonastery      |
| daniel             |
| ezmlm              |
| flash-games        |


Next step is to get some understanding about how many existing InnoDB tables are present within Database server:

 

mysql> SELECT COUNT(1) EngineCount,engine FROM information_schema.tables WHERE table_schema NOT IN ('information_schema','performance_schema','mysql') GROUP BY engine;
+————-+——–+
| EngineCount | engine |
+————-+——–+
|         131 | InnoDB |
|           5 | MEMORY |
|         584 | MyISAM |
+————-+——–+
3 rows in set (0.02 sec)

To get some more statistics related to InnoDb variables set on the SQL server:
 

mysqladmin -u root -p'Your-Server-Password' var | grep innodb


Here is also how to find which tables use InnoDb Engine

mysql> SELECT table_schema, table_name
    -> FROM INFORMATION_SCHEMA.TABLES
    -> WHERE engine = 'innodb';

+————–+————————–+
| table_schema | table_name               |
+————–+————————–+
| blog         | wp_blc_filters           |
| blog         | wp_blc_instances         |
| blog         | wp_blc_links             |
| blog         | wp_blc_synch             |
| blog         | wp_likes                 |
| blog         | wp_wpx_logs              |
| blog-sezoni  | wp_likes                 |
| icanga_web   | cronk                    |
| icanga_web   | cronk_category           |
| icanga_web   | cronk_category_cronk     |
| icanga_web   | cronk_principal_category |
| icanga_web   | cronk_principal_cronk    |


3. Check and Stop any Web / Mail / DNS service using MySQL

server:~# ps -efl |grep -E 'apache|nginx|dovecot|bind|radius|postfix'

Below cmd should return empty output, (e.g. Apache / Nginx / Postfix / Radius / Dovecot / DNS etc. services are properly stopped on server).

4. Create Backup dump all MySQL tables with mysqldump

Next step is to create full backup dump of all current MySQL databases (with mysqladmin):

server:~# mysqldump –opt –allow-keywords –add-drop-table –all-databases –events -u root -p > dump.sql
server:~# du -hsc /root/dump.sql
940M    dump.sql
940M    total

 

If you have free space on an external backup server or remotely mounted attached (NFS or SAN Storage) it is a good idea to make a full binary copy of MySQL data (just in case something wents wrong with above binary dump), copy respective directory depending on the Linux distro and install location of SQL binary files set (in my.cnf).
To check where are MySQL binary stored database data (check in my.cnf):

server:~# grep -i datadir /etc/mysql/my.cnf
datadir         = /var/lib/mysql

If server is CentOS / RHEL Fedora RPM based substitute in above grep cmd line /etc/mysql/my.cnf with /etc/my.cnf

if you're on Debian / Ubuntu:

server:~# /etc/init.d/mysql stop
server:~# cp -rpfv /var/lib/mysql /root/mysql-data-backup

Once above copy completes, DROP all all databases except, mysql, information_schema (which store MySQL existing user / passwords and Access Grants and Host Permissions)

5. Drop All databases except mysql and information_schema

server:~# mysql -u root -p
password:

 

mysql> SHOW DATABASES;

DROP DATABASE blog;
DROP DATABASE sessions;
DROP DATABASE wordpress;
DROP DATABASE micropcfreak;
DROP DATABASE statusnet;

          etc. etc.

ACHTUNG !!! DON'T execute!DROP database mysql; DROP database information_schema; !!! – cause this might damage your User permissions to databases

6. Stop MySQL server and add innodb_file_per_table and few more settings to prevent ibdata1 to grow infinitely in future

server:~# /etc/init.d/mysql stop

server:~# vim /etc/mysql/my.cnf
[mysqld]
innodb_file_per_table
innodb_flush_method=O_DIRECT
innodb_log_file_size=1G
innodb_buffer_pool_size=4G

Delete files taking up too much space – ibdata1 ib_logfile0 and ib_logfile1

server:~# cd /var/lib/mysql/
server:~#  rm -f ibdata1 ib_logfile0 ib_logfile1
server:~# /etc/init.d/mysql start
server:~# /etc/init.d/mysql stop
server:~# /etc/init.d/mysql start
server:~# ps ax |grep -i mysql

 

You should get no running MySQL instance (processes), so above ps command should return blank.
 

7. Re-Import previously dumped SQL databases with mysql cli client

server:~# cd /root/
server:~# mysql -u root -p < dump.sql

Hopefully import should went fine, and if no errors experienced new data should be in.

Altearnatively if your database is too big and you want to import it in less time to mitigate SQL downtime, instead import the database with:

server:~# mysql -u root -p
password:
mysql>  SET FOREIGN_KEY_CHECKS=0;
mysql> SOURCE /root/dump.sql;
mysql> SET FOREIGN_KEY_CHECKS=1;

 

If something goes wrong with the import for some reason, you can always copy over sql binary files from /root/mysql-data-backup/ to /var/lib/mysql/
 

8. Connect to mysql and check whether databases are listable and re-check ibdata file size

Once imported login with mysql cli and check whther databases are there with:

server:~# mysql -u root -p
SHOW DATABASES;

Next lets see what is currently the size of ibdata1, ib_logfile0 and ib_logfile1
 

server:~# du -hsc /var/lib/mysql/{ibdata1,ib_logfile0,ib_logfile1}
19M     /var/lib/mysql/ibdata1
1,1G    /var/lib/mysql/ib_logfile0
1,1G    /var/lib/mysql/ib_logfile1
2,1G    total

Now ibdata1 will grow, but only contain table metadata. Each InnoDB table will exist outside of ibdata1.
To better understand what I mean, lets say you have InnoDB table named blogdb.mytable.
If you go into /var/lib/mysql/blogdb, you will see two files
representing the table:

  •     mytable.frm (Storage Engine Header)
  •     mytable.ibd (Home of Table Data and Table Indexes for blogdb.mytable)

Now construction will be like that for each of MySQL stored databases instead of everything to go to ibdata1.
MySQL 5.6+ admins could relax as innodb_file_per_table is enabled by default in newer SQL releases.


Now to make sure your websites are working take few of the hosted websites URLs that use any of the imported databases and just browse.
In my case ibdata1 was 45GB after clearing it up I managed to save 43 GB of disk space!!!

Enjoy the disk saving! 🙂

How to easy add Joomla 1.5 donate Paypal capabilities with Joomla PAYPAL DONATION MODULE

Wednesday, June 15th, 2011

PayPal donation Module Joomla Screenshot

Many joomla CMS installations are for Non-profit organizations or Non Government organizations. These are organizations which are not officially making profit and therefore this instituations are interested into donations to support their activities.

In this occasions adding Joomla paypal capabilities is very essential. There are plenty of modules which enables Joomla to support paypal monetary payments, however many of them are either paid or requires registration and thus it’s quite time consuming to set up a decent PayPal supporting module for Joomla.
After a bit of investigation thanks God, I’ve come across a module that is free of charge, easily downloadable (wihtout registration) and is also relatively easy to configure, these module is called PAYPAL DONATION MODULE
I’ve mirored the module to my server, just in case if the module disappears in the future.

Here are a very brief explanation on how the module can be downloaded installed and configured:

First Download (mod_ojdonation_pp) Paypal Donation Module here

Install it as joomla module via:

Extensions -> Install/Uninstall
menu

Afterwards, go to:

Extensions -> Module Manager

In the list of modules you will notice the Donate module which will be disabled. Use the Enable button to enable it.

Next by clicking on the Donate Module Name, one can configure the module, where the most essential configuration values that needs to be filled in are:

1. Title: – The title of the donation form:
2. Donation Title: – Title of donation picture to show in the webpage
3. Donation Amount: – Default donation amount user will donate with paypal by clicking on Donate button
4. Currency – Default currency the donators will use to donate to configured paypal account
5. Paypal ID: – The email address of paypal account your donators will donate to (This was a bit hard to understand since Paypal ID is not a number ID but the email address configured as an username in PayPal).
6. Donation Description: – Description text to appear before the Donate button
7. Donation Footer: – Text to appear after the Donate button

There are two ways one could add the donation module to show the donation form, on the joomla website:
a. One is to enable the donation button on every joomla webpage (I don’t like this kind of behaviour).

To use this kind of donate button display approach, you will have to select from the Donation module, conf options:
– Show on FrontPage: and Show Title:

Also make sure the Enabled: option is set to Yes

b. Second approach is to set the PayPal Donation form only to appear on a single menu, to do so:

While in Paypal Donation Module configuration in Menu Assignment section, select:

Select Menu Item(s) from the List
instead of the default All value set for Menus.

The last setting to be choosen is the paypal donation form page location (where exactly on the selected pages the form will appear).

The form location is set from the Position: dropdown menu, the option which I found to be the best one for me was the bottom option. However just play with the Position setting and choose the one that will be best for you.

Then scroll on in the Menu Selection: and choose only the menus where you want a paypal donation form to appear.

Finally to save all the recent made settings, click on Apply and refreshing in a new page should show you paypal’s money donation form in joomla

If all is configured fine with Joomla’s – Paypal Donation Module you should get on your webpage:

PayPal donation Module in Joomla Screenshot
 

Saint George’s day in an Elder – Spiritual father Georgi (91 years old Priest) in Jeglarci’s Village Bulgaria

Friday, May 9th, 2014

https://www.pc-freak.net/images/otec-father-Georgi-Jeglarci-village-spiritual-elder-in-Bulgaria

This year on 6th of May – saint George's day Church feast and army celebration in Bulgaria I had the blessing to be in a small village with 868 citizens – Jiglarci (Jeglarci).
Jeglarci is situated about 40 km from Dobrich. Father Georgi from Jiglarci is a well known priest in Dobrich region. He is spiritual father of many priests, monks and nuns here in Bulgaria. This is the 3rd time I'm visiting Jiglarci one time I was on Great and Holy Friday – the day on which the Lord Jesus Christ was crucified and one time I was a few months ago with some brothers and sisters from Holy Trinity Church in Dobrich. This time I had the blessing to go fr. Georgi with my wife Svetlana with Russian family from moscow Mihail and Mariana, and Denica (a sister from Church in Dobrich).

Jiglarci-Cyrkva-Church-building-where-father-Georgi-from-Jiglarci-serves

The Church saint George in Jeglarci village

Each time I visit father Georgi I have the blessing to see and hear a living proof of God's existence. Father's Georgi from Jeglarci is famous all around Bulgaria for being one of the spiritual elders of Bulgaria. He is now 91 years old but even though his age  continues his service for God (serves Holy Liturgy every day during great Lent!), continue to preach and accept dozens of people almost daily looking for spiritual advice, spiritual help, confession, or questions on how to deal with life hardship situations.
Father Georgi is known in the world under the secular name Georgi Stoyanov Peev his life is full of miracles, interesting events and wondrous facts. In communism times of atheism and Orthodox Christian faith persecutions, father Georgi was one of the many priests who underwent tortures and persecutions for his faith in Christ. Because of his firm faith of zealous priest, the Lord endowed the fr. with great spiritual gifts. In short I will mention some facts about fr. Georgi From Jeglarci life as the father is an example of a living saint, very much like another Bulgarian Church Elder (Dijado) Dobri from Baylovo.

Father Georgi has been nurtured with Christian virtues since his childhood – his aunt (sister of his father) was a nun. By his own words, "Since a child, the joy of my life was in faith". Since his youth years his faith was strong and because of that God has helped him in numerous times. Fr. Georgi had 6 children 3 sons and 3 daughters. All of his sons choose the way of priesthood and are now priests in the Bulgarian Orthodox Church. His nephew fr. Stoyan is also a priest in Holy Trinity Orthodox Church in Dobrich. The father become priest while being 43 years old, by studying in seminary after feeing the call of God and need for firm believers and mass disbelieve in atheistic communist times. In seminary father Georgi studied together with his son. To be able to support himself and his family financially, he worked all kind of hard labour  (sand mining near his village). His all life was labor and prayer in all his free time during studing he learned the church services, readhing the living of saints and holy bible.

Thanks to the house whom he turned into a small chapel almost 20 people become priests later in Bulgarian Orthodox Church. In his priesthood fr. Georgi was among the minority which opposed the ungodly communistic regime, he rejected to comply with communist desires to close the Church in Jeglarci and as a responce to their closure opened as a Church his own house. He was questioned and asked for reports being increminated from local Communist authorities, threatened with death and called in police stations many times because of his refusal to stop his service in Church and preaching the Gospel.

Here is a story of fr. Georgi's youth:

"Our Lord as a Good Father, not only listens our prayers but also reads in the hearts. In 1953 my brother Atanas was a soldier. We received a letter, that soldiers will be dismissed in January next year, this was a very long time. It was st. Dimiter's feast and I wanted my brother to be home for Christmas. At night I prayed the Lord, simple and by all my heart: "Lord for you nothing is hard or impossible. I beg you – in one way or another make it possible, that my brother Atanas to come home earlier.

I had a strong faith in God. My faith in God was so strong that I was feeling like being able to fly. In 3 days later only, when I saw my brother Atanas on the front door, my legs started shaking and I sat down, started crying and in my thoughts started giving thanks to the Lord, "Lord, Lord I'm a big sinner and what you've done for me the sinner …
In a short while, my brother told me how in a human way everything ordered in a way that he was able to come home, 3 days after my prayer. When I received the letter on St. Dimiter's day I've prayed, the prayer was heard and God moved. The human mind is a spiritual substance connected with God. God orders things and we in a human way receive them. On the next day after st. Dimiter's feast the coy was gathered and the commander said, "Atanas Stoyanov Peichev, make 5 steps forward and start Marching!". Together with another man commander sent them in hospital, where a doctor had to inspect their health. The two soldiers took their luggate, foreseeing that they might be kept in hospital. The health check prooved they're healthy. There were 4 months until service completion but in hospital the doctor told them – "Come on go home. Your service is over". – Do you see how in a human way the things ordered. Disbelievers would say it was a coincidence but believers knows the Lord hears our prayers, when they're prayed by our whole being and with pure heart."

fr-Georgi-Jeglarci-elder-of-Dobrich-Bulgaria-3

Saint George Church in Jeglarci – Altar and Dveri

Another of his stories is connected with fasting:

"The fasting of the body is a big power. It does clean up the body and draws us near God. The fasting gives a big power. I was hindered in many ways, disbelieving authorities in the village has done me many attempts to do me evil but the Lord has saved me. Didn't allowed them nothing bad to happen to me. He grant me powers, spirit to speak the truth and to not resign from righteousness. But I leave fasting …

Fasting and Prayer are lights leading to God. I was warned 3 times by our Lord about fasting significance. When we were living in North Dobrudja, following thing happened to me: " I was 15 years old. Near our village Karamankyoij a river rich of fish was flowing. One day my bigger brother cought a lot of fish from the white one. My father and all of us was tempted, we wanted eating and it was during the Great Lent. My father said, "Okay prepare the fish and let us eat, God will forgive us?" Notice he said that in faith! apostol Paul writes, 'who eat eats for the Lord and who doesn't eat- also doesn't eat for the Lord'". We have done so as well, we were big family 7-8 children,  grandma, grandpa, my father, mother. Some eat others doesn't. I was in the group of those who ate. We ate and we went to bed. A sudden pain in stomach came … hard to explain. Nothing helps, a thought came to my mind: "Lord forgive me, I will no longer eat fish during fasting". The pain immediately disappeared I immediately got well.

But unfortunately I was weak. On the other day my brother prepared fish again and invited me.

– Genyo, come lets eat.
– I suffered yesterday – I don't want.
– Don't worry your pains was from something else not from the fish, come eat I beg you.

I was tempted and ate. We played until night time and all was well with me. In night, I fall asleep, but suddenly the pain come again, 3 times more painful. I thought I am dying, I was all sweating. My mother and grandma tried to heal me but nothing helped. Then I turned with a prayer to the Lord: "Please Lord forgive me this time also." And out of a sudden I hear a noise like from many waters coming like from heaven. Something went through me and took away the pain. There was a flash in front of my eyes. Do you see how merciful is the Lord!"

Among the many spiritual gifts of fr. Georgi is the gift of "foreseeing" (thoughts and deeds, and future). Many people who visited him later narrated the father told them things which helped them improve their spiritual life. During my first visit of the father I had the possibility to raise few questions on my spiritual life, his answers was a proove for myself that the fr. has truly the gift of sagacity.
Father Georgi had many dreams during his life and many of his dreams were prophetic about future events to come. By his own words often God spoke to him in "dreams and visions". A very notable gift he has is the gift of humility and pure Godly love. He speaks in his stories about everyone including of many who tried to do him evil with profound love and forgiveness.

fr-Georgi-Jeglarci-elder-of-Dobrich-Bulgaria-2

By prayers of father Georgi many miracles has happened, he openly speaks of this miracles, believing that through this the weak in faith are strengthened. The father says "Even if the whole earth is convincing me to deny what I saw and experienced with my spiritual eyes I will not forsake.

His humility is sincere, he says about himself: "I am just negligible mot and the miracle is not in human deed but in God's. God uses a lot simple people and through them creates miracle to edify "the smart", those which is of God is being remembered like it happened today.  Wondrous are God's deeds!"

fr-Georgi-Jeglarci-elder-of-Dobrich-Bulgaria-1
 

"The Spiritual deed is very hard. I have worked many kind of works, when you get tired you take a rest, and for the spirit there is no rest.
What to say, how to behave, how to determine the spiritual in you, to be vigilant for your food and for body pureness for pureness of your thoughts and your heart … And of course the Prayer! This is a hard labour. The devil is trying to hit us exactly there, because in all those is the direct relationship with God. Your thought is careless, you remember "important" things, you get tired to be concentrated … And it is most harder to collect your mind and feelings and enter the heart with pure infinite faith that the Lord is with you and he hears you and then pray from all your heart and soul … So is this all easy?! And there is no end and there is no station. But once you live like this there is delight and you can't live no longer in another way …"

 

 

How to remove and disable BlueTooth support on Debian GNU / Linux servers

Thursday, October 18th, 2012

How to remove / disable bluetooth support on Debian GNU / Linux servers
If you running Debian Squeeze Linux (as server Apache, MySQL, Qmail etc.) on brand new purchased hardware with bluetooth support; you will notice default Linux kernel will detect and load modules for Bluetooth

This would not be a problem only if Bluetooth does not pose possible errors or (even at cases even maybe system hangs ups?). The actual reason in my case to want to disable bluetooth on a productive Linux server operating like host was I found out in dmesg produced output, some errors related to Bluetooth, here they are:


root@deb:~# dmesg|grep -i 'call trace' -A 8
[323406.744439] Call Trace:
[323406.744440] [] ? lapic_next_event+0x18/0x1d
[323406.744450] [] ? __report_bad_irq+0x30/0x7d
[323406.744453] [] ? note_interrupt+0x105/0x16e
[323406.744455] [] ? handle_fasteoi_irq+0x93/0xb5
[323406.744458] [] ? handle_irq+0x17/0x1d
[323406.744460] [] ? do_IRQ+0x57/0xb6
[323406.744463] [] ? ret_from_intr+0x0/0x11
[323406.744464]

I saw this error and similar ones occuring, every now and then obviously displaying something wents wrongs with IRQs related to BlueTooth Communication with Kernel (as it keeps processing requests loaded in system memory) …

Well anyways having the bluetooth kernel module loaded on memory just takes up few chunks of useless assigned memory.
I don't have intention to use bluetoothever in future on these host so I decided to completely remove bluetooth support on those Debian.

1. Remove blueetoh support on Debian GNU / Linux

First to check info about the loaded kernel module bluetooth.ko and its assigned module load alias run:


root@deb:~# /sbin/modinfo bluetooth
filename: /lib/modules/2.6.32-5-amd64/kernel/net/bluetooth/bluetooth.ko
alias: net-pf-31
license: GPL
version: 2.15
description: Bluetooth Core ver 2.15
author: Marcel Holtmann
srcversion: 9FD5BF98FC88505DC637909
depends: rfkill
vermagic: 2.6.32-5-amd64 SMP mod_unload modversions

Secondly disable memory preloaded bluetooth.ko on the current host with cmds:


root@deb:~# rmmod -f bnep
root@deb:~# rmmod -f l2cap
root@deb:~# rmmod -f sco
root@deb:~# rmmod -f bluetooth

Default way to control if Bluetooth (on host support is ON or OFF) is through /etc/default/bluetooth. Inside /etc/default/bluetooth is a control variable:


BLUETOOTH_ENABLED=1

To shut it off change its value to 0:


BLUETOOTH_ENABLED=0

Then to permanently prevent bluetooth.ko from being ever in future loaded its also good idea to blacklist modules – bnep, btusb, bluetooth:


root@deb:~# echo 'blacklist bnep' >> /etc/modprobe.d/bluetooth.conf
root@deb:~# echo 'blacklist btusb' >> /etc/modprobe.d/bluetooth.conf
root@deb:~# echo 'blacklist bluetooth' >> /etc/modprobe.d/bluetooth.conf

Onwards re-build, current kernel initramfs:


root@deb:~# update-initramfs -u -k `uname -r` -v
......
......

Next update boot init scripts with update-rc.d to make sure bluetooth (service / daemon) is not started:


root@deb:~# update-rc.d bluetooth remove
......

That's all bluetooth will not load up anymore on next boot and at present time will not take up useless mem space.

2. Re-enable disabled blueetooth on Debian Linux
 
I've been asked in one of comments, what to do If you need to re-enable bluetooth on your Debian Linux at some time in future, so here are the steps to turn back blueetooth on again


/etc/modprobe.d/bluetooth.conf

Change variable:

BLUETOOTH_ENABLED=0

to 

BLUETOOTH_ENABLED=1

Open  /etc/modprobe.d/bluetooth.conf and remove any blacklisted modules, e.g:

'blacklist bnep'
'blacklist btusb'
&39;blacklist bluetooth'

Rebuild again kernel ramfs

root@deb:~# update-initramfs -u -k `uname -r` -v
 
Enjoy 🙂