Install KDE 4.8 in openSUSE

KDE 4.8 is out now, and most of the users(KDE fans) might love to give this new version a try(i am one of them). I have upgraded and proudly can say, i’m in love with KDE. This is amazing stuff from KDE, no doubt in that. Faster experience, Cool dolphin, snappier Gwenview and more interesting stuff. As i mentioned/ing in my posts/articles i am openSUSE user, so here i will show you how to upgrade to KDE 4.8 in openSUSE.

1st of all, you will need to add the following repos(YaST -> software repositories), and disable/delete other KDE repos you have enabled.

openSUSE 11.4:

http://download.opensuse.org/repositories/KDE:/Release:/48/openSUSE_11.4/

http://download.opensuse.org/repositories/KDE:/Extra/KDE_Release_48_openSUSE_11.4/

openSUSE 12.1:

http://download.opensuse.org/repositories/KDE:/Release:/48/openSUSE_12.1/

http://download.opensuse.org/repositories/KDE:/Extra/KDE_Release_48_openSUSE_12.1/

Now open terminal, become root by su - and type:

zypper dup

Easy and simple!

One more thing here, if you face dependency issues, i would suggest to follow this thread in openSUSE forums, read it carefully and i am pretty sure you will find all the solutions to your problem there.

Install KDE oxygen font [Linux]

We already have Ubuntu font for some time, and to be honest i really like it. But i do not like its rendering in openSUSE system with KDE, so i haven’t used it that much. I did not see any native font for KDE which can be used by default by the operating system. But now we have KDE font called Oxygen font, it’s still in early stages at the time of writing this post. I am using it for last few days and i can say that it is clean and clear font i ever used.

It can be download from Google fonts repository. Search for Oxygen font.

https://www.google.com/fonts/

In openSUSE KDE, it’s easy to install it via Font Installer from Personal Settings either system wide or per user only.

In action in dolphin

If you want to install it in Ubuntu, here are the easy steps. Open terminal and type(will install it system wide):

gksudo nautilus

Now go to this directory, /usr/share/fonts/truetype and create a folder named ‘oxygen‘ without quotes, and paste fonts here from the downloaded directory. Close this window and now type in terminal:

sudo fc-cache -vf

I haven’t tested it in Ubuntu, try it and share your experience with others.

Flash uses 100% CPU, install it manualy in openSUSE 12.1

Using Firefox and having high CPU usage, some time even 100%?. Not exactly may be 100% but can say more than normal usage range like 30% to 100% range. I was having the same problem. Let me clear this what system i have: openSUSE 12.1 64bit KDE4.7.4 and installed flash player from YaST from non-oss repo. While having this high CPU usage with fan noise(running at high speed) while surfing flash sites or watching videos was a little hard for me to digest. So let’s start what i did which worked for me, i will also mention here that it’s not necessary that it will work for you or others, but give it a try.

1st thing 1st, if you are also using YaST package for flash, just simply uninstall it from software management(YaST > software management) including all the traces it have there(related to flash like flash-player-kde4, pullin-flash-player).

Now download flash player from these sites(download from one site).
1- http://news.softpedia.com/news/Download-Adobe-Flash-Player-11-for-Linux-225431.shtml
2- http://get.adobe.com/flashplayer/

Choose your system(32 or 64), and download the file with .tar.gz extension. RPM based package is also available, but this post is about manual install, so proceed with the tar file and after download extract it(any where you want. can use tar command or just use Ark,fileroller etc). Now open terminal and become root by su - , cd to the extracted directory e.g: cd /Backup/Applications/openSUSE/Flash_Player/.
Now make sure that you have this file inside Flash_Player directory libflashplayer.so.
Now run this command(this command is for 64bit machines and package, just remove 64 from lib64 for 32bit, [or check /usr folder for 32bit]):

cp libflashplayer.so /usr/lib64/browser-plugins/

There are some other files like icons and kde stuff, but not necessary to copy that, if you still want then copy it to its respective directories using cp command(dir structure is already given like usr folder have sub folders).
Open your favorite browser now and see the difference(check addons in FF whether its enabled or not, also consider logout and login in case not working).
In worst case, if still high usage and want to go back to your previous settings, just run this command while in root session in terminal:

rm /usr/lib64/browser-plugins/libflashplayer.so

That will remove the flash player, now go to YaST > software management and install it again from there.
Now my cpu usage for flash sites is less than 10% which means it worked for me and hope it works for you too. (top command can show you the usage)
And that’s almost it.

Upgrade to KDE4.7.4 or later in openSUSE

openSUSE 12.1 is shipped with KDE 4.7.2, but some people like me might be interested to update to latest stable release. So that’s quite easy, we just need to add stable upstream repos. Here i will show you that how to update to latest version.

1-1st of all, if you have other KDE repos, please disable/delete them. Then add the following repos for your distro. Open YaST and add them using the software repositories module

12.1

http://download.opensuse.org/repositories/KDE:/Release:/47/openSUSE_12.1/

http://download.opensuse.org/repositories/KDE:/Extra/KDE_Release_47_openSUSE_12.1/

11.4

http://download.opensuse.org/repositories/KDE:/Release:/47/openSUSE_11.4/

http://download.opensuse.org/repositories/KDE:/Extra/KDE_Release_47_openSUSE_11.4/

2- Now open terminal, and type zypper dup it will change the vendors too, and update the system to the latest packages from every repo.

It will ask for yes or no, type y or yes. That’s it.

Hope after all updates you will have KDE 4.7.4 with stable packages and stable system.

Note: Having these repos, you will always get latest stable point release of KDE SC 4.7.

How to insert csv file data into MySQL database

MySQL have this load data function, where we can insert data to a table from external files like csv, txt etc.
The process is quite simple, 1st lets login to mysql via terminal/console.

mysql -u root -p

Enter your MySQL password. Change root to any username(MySQL users) you would wish to login to MySQL.

mysql>

Now lets run the command.

mysql> LOAD DATA LOCAL INFILE ‘/var/www/site/site_users.csv’
INTO TABLE site_users FIELDS
TERMINATED BY ‘;’
ENCLOSED BY ‘”‘
LINES TERMINATED BY ‘\n’
IGNORE 1 LINES;

You will see this if command ran successfully:

Query OK, 370 rows affected (0.00 sec)
Records: 370  Deleted: 0  Skipped: 0  Warnings: 0

In the 1st line, we load a file from local dir and that is the reason we used ‘LOCAL’.
2nd line will insert the data into site_users table.
In the 3rd line we tell the command to break the fields by ; . You can check your csv file in txt format that whether its ; or comma(,).
4th line means that data is enclosed with the double quotes.
And lines are terminated by \n.
Last line will ignore the 1st line, which usually represents the data headers.

One thing i would like to mention here, make sure that the table fields and csv columns sequence matches.
Like name, address, phone are in the table, csv will also be name, address, phone. Which means data will be inserted into the right field.
And yeh column name can be changed, that does not matter like in table first_name and in csv name. What i mean to say here is that the sequence of fields need to match that right data goes to the right field.

That’s it.

Install KDE4.6 in openSUSE!

After having factory repos for KDE4.6, now we have stable repos for KDE4.6, so we can stay with the stable packages. The process of installing or upgrading is very simple, if you are using factory repos(disable/delete it), switching to stable is also easy. Nothing going to be lost in the process. It will just download and install the packages while changing to stable repos.

Lets start with the installation:

1- Add the following repos(choose your distro repos [11.2 or 11.3 or 11.4]). We will be doing this the easy way, i mean by YaST. Open YaST and click on software repositories, click on the Add button.

openSUSE 11.2 repos :

http://download.opensuse.org/repositories/KDE:/Release:/46/openSUSE_11.2/

http://download.opensuse.org/repositories/KDE:/Extra/KDE_Release_46_openSUSE_11.2/

openSUSE 11.3 repos :

http://download.opensuse.org/repositories/KDE:/Release:/46/openSUSE_11.3/

http://download.opensuse.org/repositories/KDE:/Extra/KDE_Release_46_openSUSE_11.3/

openSUSE 11.4 repos :

http://download.opensuse.org/repositories/KDE:/Release:/46/openSUSE_11.4/

http://download.opensuse.org/repositories/KDE:/Extra/KDE_Release_46_openSUSE_11.4/

If you are done successfully with adding above repos, close the software repositories module.

2- At this point we will follow two ways to install/upgrade. Either by terminal OR by software management. Please choose either step 2a or 2b to upgrade, which suits you best.

2a- Open YaST and go to software management. Choose Repositories from the drop down menu if it is not there as a tab. Select the newly added repo. You will see ‘switch system packages‘ above the packages pane. Click on it and do this for the 2nd repo(extra repo). Done, click on the Accept button and there you go.

2b- Terminal way, run this command if you want to upgrade it through terminal(1st become root by su - ) :

zypper up

If you want to update the whole system with vendor change, run this command:

zypper dup

dup: distribution upgrade.

Please run one command at a time.

After installation, logout OR restart your machine.

Caution: Watch out for the dependency issues if any, hope will be not.

Have fun!