Posts Tagged ‘repair’

Sick again – Hoping God to solve it all – and no desire to study

Thursday, September 27th, 2007

Yesterday I was out for a coffee with Tony an old frined from the Old metal days, after that I went outwith Lily I drinked 200 gr of Vodka and a Beer. I was pretty desparate actually and I got very drunk I got home 04:10 and got to bed at 4:30. What can I say life is hard. Today Mitko called at dinner time and we drinked a coffee on the fountain. The night we went out in the Central park and drinked a beer per man. I’m starting to think about the meaningless of my life again, since my life seems without a real purpose and seems not going nowhere ( we humans are so weak ). Yesterday I have almost taken the decision to suicide. It almost a miracle after I send lily to her home and was going back home with the idea of my mind to suicide. Lily called and said she can’t unlock the door and everyone inside is sleeping and she didn’t want to disturb them. So we spend more than an hour outside. Today I feel terrible physically again. I really can’t take it anymore I need Jesus to bless me with a healing (Save me Holy Lord, Lord Jesus son of the Blessed God have mercy over me the sinner heal me Lord and Deliver me from all sickness and affliction and pain Heal my Soul, Body and Spirit, make me whole to be able to serve you again :[ Amen) My computer went down twice today I have a problem with the cooling. The cooler should be cleaned but I guess this will happen after our Room’s repair is completed. By the way Both Pc-Freak and Jericho are on the terrace. Because repair works are being done into the room. Day after day I ask my self the question when I will be healed again. I do smoke a lot of cigarettes for which I’m ashamed of myself (But it’s an act of desperation). By the way I don’t have any desire to study anymore I’d like to do things with FreeBSD and learn stuff. If God is merciful to me and heals me probably I’ll continue to live otherwise I guess I’ll end badly. Very often come to the point Nobody out there cares, them I feel the presence of God’s spirit I remember the Bible’s instruction towards doubtful mind and try return back to the Faith of the Eternal, It’s like a sort of schizofrenia (I believe, I don’t believe). I’m sure both cannot be true. Very often I think I deserve more but since God’s rightous probably that’s what I deserve. I tried do good for so many people and to care for as much people I’m very discouraged because as a reward I see it like receiving this infirmity and sickness … Something have to change or I’ll be gone …END—–

How to check and repair broken MySQL ISAM tables

Monday, July 11th, 2011

MySQL repair artistic picture

If you are stuffed with errors in /var/log/mysqld.log similar to:

110711 11:00:48 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './anyboots_moncler_spaccio/zen_seo_cache.frm'
110711 11:00:48 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './anyboots_moncler_spaccio/zen_sessions.frm'

This is a sure sign something terrible has happened with your mysql database tables that lead to corruption.
Having corrupt table in mysql installation can severely lead to data loss as well as significantly reduce the speed and performance of a MySQL server in this awful times mysqlcheck is the best friend of the administrator, here is how you can check and repair broken tables in MySQL server:

mysql-server:~# mysqlcheck --all-databases -u root -p
chillor_hjbgl.vn_users OK
chillor_lul.mybb_adminlog OK
chillor_lul.mybb_adminoptions OK
chillor_lul.mybb_adminsessions OK
chillor_lul.mybb_adminviews OK
chillor_lul.mybb_announcements OK
...

You will notice the corrupt sql tables will be reported as corrupt by the tool and mysqlcheck will try it’s best to recover the corrupt tables.

In most cases this should be enough to recover corrupt tables.

Common commands to Repair Broken or Unbootable Windows XP / Vista / 7 without system Re-install

Monday, October 22nd, 2012

Common commands to repair broken unbootable Windows XP 7 and Vista, the famous genuine great! mfc command :)
If you have severe problems with Windows 7 / Vista / XP whatever and you don’t want to re-install. It is handy to know about the existence of few commands, which can help you fix your basis Windows system without re-install. This commands are not to fix 100% of messed up Windows installs but in most cases I know, they either improved the state of the system or fixed it completely, so here are commands:

1. Change permissions of C:\boot.ini and delete it

Many Viruses install via standard Windows boot.ini file and change permissions of the file to make it hard to delete by programs and by
Administrator user. To solve that in Windows Safe Mode (without networking) exec:


C:\> COPY boot.ini boot.bak
C:\> ATTRIB -RSH C:\boot.ini
C:\> DEL boot.ini

-RSH ATTRIB cmd options instruct it to remove Read Only, System and Hidden flags from boot.ini.

2. Re-build boot.ini and other essential Win boot components


C:\> CD WINDOWS
C:\WINDOWS> BOOTCFG /REBUILD

BOOTCFG /Rebuild is a very important for recovering. The command will do complete evaluation with diagnostic tests trying to replace / repair whatever files are preventing OS boot.

3. Fix problems with Unbootable Windows Systems

If the system is completely unbootable you need to use the Windows Install (Setup) CDRecovery Console and in first boot up (blue screen), type R key to enter recovery console. There is option of automated recovery console but for me Automated System Recovery – ASR, never worked.
Once in Recovery Console to repair broken Windows boot up (fix winboot loader):


C:\WINDOWS> BOOTCFG /Rebuild
C:\WINDOWS> CHKDSK /R /F
C:\WINDOWS> FIXBOOT

You should already know from the MS-DOS, DR-DOS times CHKDSK (Check Disk) is thanksfully still on every next Windows release. As CHKDSK does a hard drive check for irregularities and BAD Blocks (depending on the size of HDD) it takes time usually from 30 minutes to 1 hour.
4. System File Checker (SFC) command – restore basis .DLLs and others to Setup CD (install) originals


C:\WINDOWS> SFC /SCANNOW

SFC – has been useful in many, many Windows installs, I fixed it is really precious cmd. It does check the system essential (DLL – Dynamic Loadable Libraries) and matches them against a clean working copy which was copied on the system by Windows Install (CD) SETUP program. If some of the primary win .EXE or .DLL files checksums are not matching, the file is substituted with a clean (working) copy of the Install CD original ones. Some Viruses and Spyware might change those original (clean) binary files placed by Windows during install time. So intelligent Virus progs are very rare so in lets say 90% of broken Windows installs SFC /SCANNOW solves problems with main win files 🙂

If you have doubt that those binaries which SFC matches with are changed, you can always use a Setup Install CD with same Service Pack version as installed on the host. To restore main Windows binaries and libs using the external recovery CD use:


C:\WINDOWS> sfc /offbootdir=c:\ /offwindir=c:\windows /scannow

This tutorial should solve also all kind of start-up errors like:


Windows could not start because the following file is missing or corrupt:
\\WINDOWS\\SYSTEM32\\CONFIG\\SYSTEM


You can attempt to repair this file by starting Windows Setup
using the original Setup CD-ROM.
Select ‘R’ at the first screen to start repair.

Windows NT could not start because the below file is missing or corrupt:
X:\\WINNT\\System32\\Ntoskrnl.exe


Windows NT could not start because the below file is missing or corrupt:
X:\\WINNT\\System32\\HAL.dll


NTLDR is Missing
Press any key to restart


Invalid boot.ini
Press any key to restart

How to Repair Ubuntu Linux which failed due to computer switch off during update :)

Tuesday, August 28th, 2012

My sister tried updating her Ubuntu to a newer version 12.04 (Precise Pangolin) but in the middle of the dist-update process had to go out and hence closed her notebook thinking the update would continue by itself. I’m not fully aware what happened next, maybe the battery charge went down, maybe the computer entered sleep mode in the middle of some important package update or whatever. The result however on next opening OF her Ubuntu powered Acer Aspire 5736Z was Ubuntu unable to boot properly.
The boot up failed in the middle of booting the BootSplash (from some of the /etc/init.d … init scripts)

. The BootSplash status was therefore failing and on the screen the GUI cursor appeared refreshing every few seconds, whether on every refresh the screen become blank, the hard drive was reading on and on, continuously as well. Since the screen was keeping mostly blank I had no way to see exactly why the hard drive was scraping on and on….

My first guess was to try to boot the Ubuntu in single user mode (without GUI environment) and then complete the interrupted packages apt-get dist-upgrade.

In the old days of RedHat and probably nowdays in Fedora, I remember entering single user mode was easy just press I button few times on OS boot in non-interactive mode. The I (boot single-mode) shortcut however is not compatible with Deb based distros (as I found out by trying it out unsuccesfully).

Actually during booting process, this notebook did not even prompted the GRUB menu with even simple choice to choose an old kernel or something, hence I took a quick look on the net how can I make the GRUB menu appear on Ubuntu!.
As I read the reason why GRUB menu did not appear on the laptop boot was due to very short GRUB (select) boot timeout delay set.

Therefore to make the GRUB prompt (select) prompt appear in Ubuntu it is necessery to:

1. Hold continously the SHIFT key at boot

Ubuntu Linux version 12.04 GRUB boot textscreen picture

Once the textmode GRUB selection screen appears, as I read in instructions in blogs one has to:
HIT e key, over default boot-up kernel, e.g.:

Ubuntu, with Linux 3.2.0-23-generic

Now to boot Ubuntu in single user mode as I red it is necessery to modify near line:

linux /boot/vmlinuz-3.2.0-24-generic root=UUID=bc6f8146-1523-46a6-8b\6a-64b819ccf2b7 ro quiet splash

to something like:

linux /boot/vmlinuz-3.2.0-24-generic root=UUID=bc6f8146-1523-46a6-8b\6a-64b819ccf2b7 ro single quiet splash
initrd /boot/initrd.img-3.2.0-24-generic

Then finally to load up with the changed GRUB options, I have pressed Ctrl+X
Unfortunately this didn’t work on this totally bugged Ubuntu. After continuously looking for way to boot in sigle user or textmode (without X server), I found another blog recommending to change: quiet splash words with text in grub kernel load-up options ..

In my case none of the ways worked out so I finally decided to do it the “old-fashioned” classical way to recover Ubuntu, e.g. – by using Ubuntu Install CD, booting in “Try Ubuntu” mode and using the good old chroot cmd.

Fixing the failed updates Ubuntu, came up to booting with Ubuntu Install CD with option: Try Ubuntu without any change of your computer, further on once the CD boot up, I entered console and inside console used commands similar to one of my previous posts – How to mount /proc, /dev and chroot in Linux

Ubuntu fix was up-to to issuing :

# mkdir /mnt/recover
# chroot /dev/sda1 /mnt/recover
root@ubuntu:~# mount /proc
root@ubuntu:~# mount /proc/pts
root@ubuntu:~# mount -a
root@ubuntu:~# mount /dev
root@ubuntu:~# dpkg-reconfigure -a
root@ubuntu:~# apt-get update
....
root@ubuntu:~# apt-get --yes upgrade
....
root@ubuntu:~# apt-get --yes dist-upgrade
....

Onwards during the apt-get upgrade and apt-get dist-upgrade few questions poped up asking me if I would like to replace some files with their new versions on each questions I substituted the files with the new maintainer version. Then finally after PC restart my sis Ubuntu boot up now fine with the latest Ubuntu version 12.04.

How to fix a broken QMAIL queue with queue-repair and qmhandle

Friday, May 27th, 2011

How qmail works, qmail queue picture :)

The aim of this small post is to give just a brief idea of how I fix my qmail server after breaking it or in case it is broken after mail bomb attacks, etc.

Most common cases when I break my qmail queue myself, are after I’m implementing some new patches and reinstall parts of the qmail server with a patched version of default qmail binaries.
On other occasions, I simply used the qmailctl to start or stop the server as a part of some routine tasks necessery for the administration of the qmail server.

Everybody who has already experience with qmail should have experienced, that qmail is very fragile and could break even with a simple changes, though if it works once it’s rock solid piece of mail servant.

Below I explain few ways I used through my days as a qmail sys admin to deal with broken or messed queues.

1. Fixing a broken qmail queue using automatic tools There are few handy tools which in most cases are able to solve issues with the queue, one very popular one isqueue-repair – check http://pyropus.ca/software/queue-repair/.
Installation of qmail-repair is dead easy, but it needs to be installed from source as no official debian package is available:

linux:/usr/local/src# wget http://pyropus.ca/software/queue-repair/queue-repair-0.9.0.tar.gz
linux:/usr/local/src# tar -xzvvf queue-repair-0.9.0.tar.gzdrwxr-xr-x charlesc/qcc 0 2003-10-22 16:54 queue-repair-0.9.0/
-rw-r--r-- charlesc/qcc 268 2003-10-22 16:54 queue-repair-0.9.0/TODO
-rw-r--r-- charlesc/qcc 1700 2003-10-22 16:54 queue-repair-0.9.0/CHANGELOG
-rw-r--r-- charlesc/qcc 18007 2003-10-22 16:54 queue-repair-0.9.0/COPYING
-rw-r--r-- charlesc/qcc 1098 2003-10-22 16:54 queue-repair-0.9.0/BLURB
-rwxr-xr-x charlesc/qcc 26286 2003-10-22 16:54 queue-repair-0.9.0/queue_repair.py

To check if there are issues fixable within the qmail queue it’s as easy as:

linux:/usr/local/src# cd queue-repair-0.9.0
linux:/usr/local/src/queue-repair-0.9.0# ./queue-repair -t
...
checking files...
checking queue/mess files...
checking split locations...

The tool will walk through the mail sub-directories containing mail queued files in /var/qmail/queue and will list any issues found.
It’s recommended that the qmail server is stopped before any queue modify operations are issued on the server:

linux:/usr/local/src# qmailctl stop
...

Further on in order to solve any found issues with the queue, there is the “-r”/repair option:

linux:/usr/local/src/queue-repair-0.9.0# ./queue-repair -r
...

Another tool which comes handy whether a repair of a messed qmail queue is needed is qmhandlehttp://sourceforge.net/projects/qmhandle/

The use of qmhandle is also pretty easy, all one has to do is to follow the usual classical steps of a download the source & compile:

linux:/usr/local/src# wget https://www.pc-freak.net/files/qmhandle-1.3.2.tar.gz
linux:/usr/local/src# tar -zxvvf qmhandle-1.3.2
...
linux:/usr/local/src# cd qmhandle-1.3.2

Once again it’s necessery that the qmail server is stopped via its init script before qmHandle tool is used, e.g.:

linux:~# qmailctl stop
...

There is a difference between qmail queue repair tool and qmail handle , while qmail queue-repair tool is used to fix improper permissions of queued files with the qmail queue, qmhandle ‘s application is to completely delete the stored mail contents of a broken queue.

Deleting all the qmail queue content is in some cases the only option to fix the queue.
Often such a drastic measure is required after a heavy mail server overload, let’s say a result of spammers or caused by virus infected mail users which send a massive amounts of spam mails.

Thus at many cases when queue-repair was unable to solve a queue mess, I use qmhandble and sacrifice all the queued emails by completely wiping them out like so:

linux:/usr/local/src/qmhandle-1.3.2# ./qmhandle -D
...

Above command would eradicate all queued emails. Hopefully after the qmail server gets launched again with qmailctl start all the mail server operations should be back to normal.

Note that the use of qmhandle’s queue delete capabilities is pretty dangerous, if you forgot to stop the qmail server before issuing the above command!

Note that in order to use both qmHandle and queue-repair tools you will need to install python interpreter as both of the tools are written in python.

To check what is currently in the queue in Qmail, there are also native tools available, as you should probably know if you have dealt with qmail, e.g.:

debian:~# qmail-qstat
debian:~# qmail-qstat
messages in queue: 2
messages in queue but not yet preprocessed: 0

Often when there are problems with Qmail and more specificly with qmail server queue the qmail-qstat command does show messages in queue, however when an attempt to check what kind of messages are in the queue with qmail-qread no messages are shown, for instance below you see an example of that, even though qmail-qstat claims 2 messages are in the queue, qmail-qread is unable to list the messages:

debian:~# qmail-qread
debian:~#

If all is fine with qmail queue above’s qmail-qread command should have returned something similar to:

debian:~# qmail-qread
26 May 2011 07:46:47 GMT #659982 3517 <hipo@www.pc-freak.net>
remote somemail@gmail.nl
26 May 2011 07:46:47 GMT #659983 3517 <hipo@www.pc-freak.net>

2. Fixing qmail queue manually This is very dangerous initiative, so before you try anything, make sure that you know what you’re doing, the possibility that you make the situation worst if you attempt to tamper manually the qmail queue is quite high 🙂

However if you’re still convinced to try fixing it manually, take a look at /var/qmail/queue it’s very likely that there are permission issues with some of the queued files, in order to fix the situation it’s necessery that the following directories:

/var/qmail/queue/mess/
/var/qmail/queue/remote/
/var/qmail/queue/bounce
/var/qmail/queue/info

gets explored with midnight commander / mc or some kind of convenient file explorer.

If there are queued files owned by users different from qmailq and user group qmail , for instance if owned by the root user, a simple chown qmailq:qmail to the wrong permissions file, should be able to resolve the issues.

Apart from all I explain above, there are many other ways suggested online on howto clean a qmail queue, one very popular one is using James’s qfixq shell script.

This script as of this very date is not working on Debian based systems, the script is dedicated initially to run on Fedora and Redhat based Linuces

Moreover myy experience with qfixq was never successful.

One very important note which is often a cause of many problems, is always make sure you stop and start the qmail server with an interval of at least of 10 seconds.

I’ve managed many servers which after an immediate (undelayed) qmailctl stop and qmailctl start was unable to run the whole engine of the qmail server (and either email sending or email receiving was not properly working) afterwards.

In that cases many weird behaviours are common, consider this seriously if you deal with the qmail-queue, it might happen that even if you have fixed your qmail queue, after a restart the qmail might breaks up.
I’ve experienced this kind of oddities numerous times, thus when I do changes to qmail I always make sure I restart the server a couple of times (at least 5 times 😉 ) always with a good delay between the HUPs.

And as always with qmail prayer is always needed, this server is complex, you never know what will happen next 🙂

Our beloved brother in Christ Ipodqkon Georgi (Atonski / from Mount Athos) has passed away

Sunday, May 22nd, 2011

Ipodqkon Georgi Atonski from Dobrich

Below I post the only picture I have of this beloved brother in Christ ipodqkon Georgi You see our brother on the right side of the Metropolitan of Varna and Great Preslav Kiril.
Georgi served as an ipodqkon in the Church Holy Trinity here in Dobrich and was well known and loved by the Church community there.
He also was a really good loving and decent man completely devoted to our Orthodox faith, standing firm in the faith.
He worked for many months in Holy mount Athos as a repair workers cook, where he cooked for about 70 people.

Before he worked in Holy Mount Athos, he used to be a restaurant chef in Sandanski.
Since about 6 or 7 months time he become sick, his assumption for the sickness was that it might be of a bad sploit old food which was consumed by accident by him and the rest of the workers.
He shared with me that all of the workers felt sick after eating it but all of them except him has vomited the food afterwards.

He gets poisoned and urgently transfered back in a hospital in Bulgaria. Consequently he went under a lot of examinations which failed to proof the exact type of sickness he was suffering from.
He was prescribed to eat only fasting food (some bread, apples, oil and a few of other light meals). He was prescribed a lot of medications he tried but none of them really helped him and he on a numerous times has shared with me he is not feeling weel, though I was not really believing his health situation is so severe.

The exact state he was experiencing was infirmity, headaches, skin rushes, he could hardly stay on his foots for more than few hours, as lastly he shared with me.
He also got rashes from most of the food he consumed. His life was a real tragedy as I remember I saw him just 3 weeks ago and he was about to go to Sofia for some examinations.
Even though his hardships in life, he was not loosing faith and believed all that was happening was according to God’s will and did accepted his sickness with humility.
During the about 7 months he spend in sickness he was many times being hospitalized in Hospitals in Dobrich, Varna and Sofia.

In each of the hospitals he spend a couple of weeks on injections and live sustaining medical systems.
During this periods, when he was in his home here in Dobrich somewhere in Balik, he often chatted with me over Skype, giving me good spiritual advices.
He also often called my landline phone to consult on various stuff concerning his problems with his notebook. As in the last days he could only lay and use the computer.
The computer he had was one of the few possessions he had, in his last days he did not have money at all as all of his savings were spend for examinations and drugs…

I remember still one time when I walked with him towards the bus-station and I was in a terrible desperation, being faithless.
He instructed me I should pray and told me not to despair and stop smoking as I was nervously smoking…
He lived a life similar in many ways to the life of the saints. He had a strong love for monasticism and had the desire to either become a monk or priest.
He told me many miraculous things he has seen and heard when he was in holy Mount Athos.

Last time I saw my beloved brother Georgi near the Church saint George (sveti Georgi) and for my grief I behaved partly as an asshole, and I repent I was not behaving better.

In this last time I saw him he shared for his great gratitude for God that he was allowed to visit the holy Lands (Jerusalem) The Holy Sepulchure church in Jerusalem.
Even in this last days, obviously living in infirmity he had his strong dedication to the Church and come to the Church services for Resurrection / (Easter) and was mostly being present on holy liturgies in Sundays.

The last time I saw him in the Church he did the Gospel and red some psalms. He was always serious and looked for the spiritual in everything, very rare kind of person to meet today.
Georgi blessed me with a couple of small icons (two copies of icons of Saint Georgi [Fanailska and Araviiska] miraculous icons from mount Athos as well as an icon picture of the Altar of Holy Sepulchure Jerusalem church), and I pray in front of them when I pray to God.

These are two of the icons brother Georgi give me as a gift and blessing from Holy Mount athos:

Saint Georgi Zographus miraculous making icon

Saint Georgi Zographus Miracle making icon

Saint Georgi Fanuilska Zographus Bulgarian Monastery miracle making icon

My beloved brother in Christ Georgi (God Forgive him / Bog da prosti) has also blessed me with a wonderful digital movie about the Bulgarian monastery in Holy Mount Athos Zographus. The movie about Zographus is explaining thoroughfully the history of the holy cloister and showing the originals of the Holy miraculous icons and monks who spoke about today’s spirituality and what is it to be a monk on holy mount athos (one of the most holy places on earth today).

I know also that Georgi was a wonderful a really talanted cook (even a chief) as he was responsible to take an eye for 6 cooks during his work as chief in Sandanski.
In the just recently passed away Resurrection day, he has cooked an Easter cakes and banica as well as some other meals using a holy mount athos recipee.

After the Resurrection early Holy liturgy was over we ate together with the brothers and sisters from Georgi’s delicious meals praising God and rejoicing for our Lord has Resurrected from the dead…
I will really miss my namesake (adash) as I used to call him often. I just hope one day I would see him again if by God’s grace I’m allowed to enter Heaven.
Just about 1 year ago his mother passed away, then some few years before his father has passed away and now not more than a year after his parents he is gone as well.
When I look over this tragedy it’s really hard to understand it but using the Holy Scriptures, one can easily understand why it happened that way as,

His early departure from this life is according to the words in the Holy Bible in Isaiah 57:1:


The righteous perish, and no one ponders it in his heart; devout men are taken away, and no one understands that the righteous are taken away to be spared from evil.

I hope ipodqkon Georgi will find grace in front of God to pray for me the sinner and the rest of us who’re still living in ours sins on this sinful earth.

As the memory of the righteous lasts forever he will be forever remembered as I believe he was in the number of the rightous …

Please Orthodox Brothers and sisters pray for ipodqkon’s Georgi’s soul that our merciful God forgives him his trespasses and grants him an ever lasting joy with all the saints in the heavenly church, in paradise!

God forgive you our and my beloved brother Georgi! Let your memory last forever. Amen!