backup mysql tables and restore

it's easy to backup all you mysql tables: just go to /var/lib/mysql (on SuSE linux distro) and copy all folders, that's it.
If you record this forlders on a cd or dvd as backup and you lost all privilege settings, this is what you have to do after you copy back your backup on mysql folder:

chmod -R 766 *
chmod -R 700 mysql/

and all will work fine again!

go backup guys! ;)

Apache2 settings

after installing all needed rpms about apache2 and php4, just open /etc/apache2/httpd.conf and add following two lines on bottom to make UserDir and Alias work:
Include /etc/apache2/mod_userdir.conf
Include /etc/apache2/conf.d/*
UserDir permit you to use /home//public_html directory as server directories and make users publish their own files.
Alias permit to use any directory on you server for publish contents.
For more infos, consult apache documentation or contact me!

bye
antonio

strange SU wrong password

Haven't told you that I've installed the brand-new SuSE 9.2 on my laptop and It works great only if I use KDE. In fact I tried Gnome 2.6 and was so unhappy to see that it doesn't work good... Gnome it's hard to configure if u are a maniac of personalization. Let me know if your experience wit gnome have been better than mine!

But, let's talk about the title's argument. It was so strange but, after a long "play" with yast and user configuration, I wasn't able to "su" or "sudo" from console. Still dont know what happened but that executables lost the suid privileges. What I've done, to make all things work again, was:

chown 4755 /bin/su /usr/bin/sudo

bye

/dev/loki

this is the blog of the mantainer of GURU-rpm, a killer SuSE rpm mantainer!

check it out!

/dev/loki

Force user logout!

have you ever wanted to know how to force logout of a user on a remote machine that is logged in locally ( or remotely too :P )?

here the tip:

kill -15 $(ps -U NameOfUserToLogout -o "pid=")

what does it mean this command??
well why dont you type in your command line these other two commands:

man kill
man ps

you will learn more, guaranteed :D

WineTips

If you want configure wine easy, I suggest you this site

WineTips

I'm planning to mirror it! Stay tuned!

change file permissions

Again a simple command to simplefy our life on linux/unix machines :D

As you know I am a webmaster and usually I need to upload files on webservers that manage permissions in different ways from me on my machine and I have to chmod a large amount fo files. Using following command I can make this work in seconds :D

find . -type d -name public_html -exec chmod 0755 {} \;

It searches (using find recursively (ie it checks folders and sub folders/directories and sub directories) for a directory (-type d) called (-name) public_html and when it does it runs the command (-exec) chmod 0755 (which sets the permissions so that the owner can read, write and execute/open the folder and all other users can read and execute/open the folder).

Feel free to experiment and change this command on your machine

bye

change names of folders

Today I got a funny problem: I create a new link on Desktop of my Home folder.
My Surprise was that his name was "TRASH FOLDER".
So I thought "WHAT's UP?? Who gave this name to my home folder??". The first Thing I've done ( as ex-Winzozz User ) was right-click on folder to access properties and change the name there, but .... the name didn't change.
Well I demistyfied that, to change the name of folders, there is an hidden file inside every folder-link on desktop called ".directory". Here you can change some property, included the name "TRASH FOLDER".

:d see you

multiple conversion to lowercase

This is a modified version of my script to change extensions, for lowercase (or uppercase inverting in script) multiple files in a directory recursively.

for i in $(find . -type f);
do mv $i $(echo $i | tr "[:upper:]" "[:lower:]");
done

hope to be useful as usual.

good work!

MYSQL wont startup

Today, mysql wont startup and dont know why (or maybe!)
First of all I looked at "/var/lib/mysql/<\your host name\>.err" log and this was the error:

Fatal error: Can't open privilege tables: Can't find file: 'host.MYI' (errno: 2)

The problem is the file was there (/var/lib/mysql/mysql).
The solution is delete /var/lib/mysql/mysql wit command rm -fR,
type rcmysql start and the folder will be recreated.
You'll lost all users but mysql will be up and running! Now you have to reset the root password: mysqladmin -u root password

hope to have been useful again!

P.S.
I forgot... the error was my fault ... I played too much with phpmyadmin.
Machines do always what we want they do!

Multiple rename with find command!

I've done this shell script for multiple rename files not in same folder
(for doin that, simply use rename command) using the combination between mv and find in this way:

for i in $(find / -name *.ext1);
do mv $i $(echo $i | cut -f1 -d.).ext2;
done

in the specific, this change an extension of a file (ext1) in one another (ext2).
feel free to modify it to match your needs.

bye

bluetooth and SuSE 9.1

It costed to me a lot of work, but finally I got IT!
My bluetooth phone work and I can browse it.

First of all, connect your bluetooth.usb.key directly on usb port without using hubs or will not work (dont know why but I'll solve it in future).

UPDATE the deafault kdebluetooth installed with your suse wit this one kdebluetooth
because it lacks a lot of necessary files you need for make it work.

After that, start kbluetoothd and you'll have an icon in system proces pannel click on it and it will show u the services disposable on your phone. that's all (well ... there are a lot of things to learn so read here: kde-bluetooth.sourceforge.net)!

Tips Installing software on SuSE 9.1

To install RPM files with Yast from command line, type this : yast -i <\packagetoinstall\>.rpm

If you downloaded source code from a program (tar.gz files) you can quickly make an RPM file from it.
To do this, first of all install the package "checkinstall", then unpack your source package and cd to the directory where you unpacked the tar.gz file.
Run the following commands:

./configure
make
checkinstall #instead of make install

When finished, you'll find your RPM in /usr/src/packages/RPMS/i686

Now you can install it where you want with yast - i <\packagetoinstall\>.rpm or with rpm -i <\packagetoinstall\>.rpm. This allows your to easily uninstall it afterwards.

bye

Asus L3500 Power Management on SuSE 9.1

Today, I discovered that power management on my asus doesn't function properly and that I can configure extra buttons and leds on my laptop trought powersave (default acpi manager for suse).
Now I'll show you how-to do it!

SUSPEND AND STANDBY

edit '/etc/powersave.conf'. Right at the end there are two lines:
POWERSAVED_DISABLE_USER_SUSPEND=yes POWERSAVED_DISABLE_USER_STANDBY=yes
modify it to 'no'

ASUS_ACPI

acpi4asus (kernel module for asus special keys and leds) is included in the kernel (from 2.6). Just load the module 'asus_acpi' since startup, editing the file '/etc/sysconfig/powersave/common'.

Search for the definition of 'POWERSAVE_ACPI_MODULES' and add 'asus_acpi'.
Same goes for 'POWERSAVE_ACPI_MODULES_NOT_TO_UNLOAD'.

Set POWERSAVE_CPUFREQD_MODULE="p4-clockmod" (doesnt work well: cpu boot at 300Mhz instead of 2.400Mhz even I've set powersave as well! tryin to find help and further informations)

searching for other tips... stay tuned!

sources:
http://www.wach-o-witz.de/asus_l3500d_install.html

mozilla and firefox run better

Take Note: These tips are for SUSE 9.1 with the 2.6 kernel:

Mozilla and FireFox both seem to run a little slow on Suse 9.1 cause "ipv6". What is "ipv6"...sheee...I haven't a clue...but there is a fix...and after I applied it...both Mozilla 1.7 rc1 and FireFox opened and went to the different websites fast. Before the fix...both browsers would often just sit and spin their little icons...and never reach the sites before they timed out.

• Fix One: Go to >> /etc/modprobe.conf, right below this line:
  alias net-pf-10 ipv6
  add the following line:
  install ipv6 /bin/true
  Found this fix on Yahoo SCOX Message Board and credit for fix goes to w4rmc47, who posts on yahoo finance scox message board.

source : thelinuxapprentice

Canon i250

I found drivers for this cheap printer on this site :

http://203.111.45.57/bj/i250linux/ (CANON NEW ZELAND)

and downloaded the following:

• bjfiltercups-2.3-0.i386.rpm
• bjfilteri250-2.3-0.i386.rpm
• guidei250-2.3-0.tar.gz

install rpm with YaST as usual and unpack the last package cause this is the guide!
then, always in YaST, go to "hardware"(on left), "printer"(on right) and add your printer!

It WORKS WOW!!!!!

Apache, PHP, MySQL

this is the most difficult part...
I'll write the article when I'll finish all.

Gaim

First of all, if you installed the SuSE personal like me, you should change the source installation!

Do this :

1. open YaST
2. from left pannel choose "software" and from right choose "change installation source"
3. click "add" button and choose ftp or http and fill the form using a SuSE mirror
   
4. then disable the cd source and enable the source just added (dont enable more than one source or YaST will freeze when you will add packet choosin "install/uninstall packets")
   

Now we can install Gaim with his dependancies.
For installing using an rpm go to guru.linuxbe.org, download gaim and install it wit YaST!

EASY SuSE!! I love it.

Thunderbird

it was easy as installing firefox... I restored alse the folder wit my settings and email taken from windows wit just deletin

/-user-/home/.thunderbird/profiles

and

adding the profiles folder I had from windows ! easy and fantastic...

SuSE again UP and Running

I'm still curious about what happened to my SuSE and still angry about that!
Now I'm a little bit scared cause I think that if this happen when I'll have data on disk, I'll be lost! But let think over.... =D

I reinstalled also mozilla but, this time, I choosed the version without the installer and it worked on the first start... I HIGHLY reccomend it.
These are the operation I've done to install firefox via terminal:

download from site ( obvious! =D)
mkdir /opt/mozilla
mv /home/-user-/Desktop/firefox*.tar.gz /opt/mozilla/
ungzip firefox*.tar.gz
tar -xvf firefox*.tar
ln -s /opt/mozilla/firefox/firefox /home/-user-/Desktop/firefox

then you can apply the icon in kde!
thats all!

bye antonio