Mandriva Spring 2009.1 : Simple Web Server

bikin webserver dengan cara mudah di mandriva spring 2009.1 dan simple :)
bagi yang belum punya cd instalasi mandriva spring 2009.1 isa download di :

http://kambing.ui.edu/iso/mandriva/2009.1/mandriva-linux-free-2009.1-dual.iso

soale aq juga pake itu. kenapa kok pake iso file diatas ? simple aja. aq butuh
yang simple-simple, coz untuk aplikasi server langsung cocok, apalagi aplikasi
dekstop nya. cool abizz....
trus kenapa juga pake yang dual arch ? simple, mo pake cpu yang udah pensiun or
mo pake cpu yang support 64bit langsung isa. enak kan ?? :D

ok langsung aja yow... untuk tahapan instalasi aq lewatin aja, coz instalasi mandriva
linux simple banget.

o iya, file iso mandriva diatas akan menginstall desktop lxde yang ringan sebagai
default desktop nya. jangan kuatir dengan lxde, lxde akan lebih mudah dibanding kan
icewm :D

waduh... ni sebenere mo ng-review mandriva apa cara bikin webserver nya ya ? :p

pertama-tama, buka konsole, masuk menggunakan root dengan perintah 'su'.
setelah itu tambahkan repository untuk mandriva, disini aq pake yang server di indonesia
jalankan perintah ini :

urpmi.addmedia arsip_main_rilis http://telkom.arsip.or.id/mandrivalinux/official/2009.1/i586/media/main/release/

urpmi.addmedia arsip_main_backports http://telkom.arsip.or.id/mandrivalinux/official/2009.1/i586/media/main/backports/

urpmi.addmedia arsip_main_updates http://telkom.arsip.or.id/mandrivalinux/official/2009.1/i586/media/main/updates/

diatas untuk menambahkan repository main nya, sekarang untuk repo contrib nya

urpmi.addmedia arsip_contrib_rilis http://telkom.arsip.or.id/mandrivalinux/official/2009.1/i586/media/contrib/release/

urpmi.addmedia arsip_contrib_backports http://telkom.arsip.or.id/mandrivalinux/official/2009.1/i586/media/contrib/backports/

urpmi.addmedia arsip_contrib_updates http://telkom.arsip.or.id/mandrivalinux/official/2009.1/i586/media/contrib/updates/

ok, penambahan repositori instalasi untuk mandriva spring 2009.1 kita udah selesai. sekarang lanjut ke proses berikutnya. install webserver + database (apache+php+mysql+phpmyadmin).
jalankan perintah ini :

urpmi task-lamp

dengan perintah diatas, semua kebutuhan untuk lamp (linux,apache,mysql,php) langsung terpenuhi.
setelah proses diatas selesai, hal yang perlu di perhatikan adalah password untuk mysql / database
server nya. untuk menjalankan mysql server terlebih dulu silahkan ganti or buat password root untuk mysql server nya, dengan perintah seperti ini :

/usr/bin/mysqladmin -u root password 'root'

perintah diatas akan mengeset mysql server kita dengan username root dan password root.

ok sudah selesai semuanya. sekarang tinggal test drive :D

jalankan webserver, dengan perintah :

/etc/init.d/httpd start

atau

service httpd start

kemudian jalakan database server nya, disini mysqld dengan perintah

/etc/init.d/mysqld start

atau

service mysqld start

tes dengan buka browser (firefox) dan akses ke alamat http://localhost.

done...


nb : untuk semua dokumen / berkas web di simpan di /var/www/html

TP-Link TL-WN322G On Mandriva Spring

Install and Configure USB WiFi TP-Link TL-WN322G in
Mandriva 2008.1 Spring Free Edition

Prepared:
-Mandriva 2008.1 Spring Free Edition
-USB WiFi TP-LINK TL-WN322G

Step by Step :
-PLUG USB to USB port
-Check with dmesg command, like this



-Run MCC / Mandriva Control Center. Input Password root

-From MCC, choose Hardware > Browse and configure hardware
-Auto hardware is running, then driver installation begin automatically
-Result of hardware detection



-Configure USB Wifi, from MCC choose Network & Internet > Set up a new network interface ... > Choose connection >

Mandriva Spring with Moto Rokr E2

Using Motorola Rokr E2 as Modem to connect Internet with Mandriva Spring 2008.1
Motorola Rokr E2
-Goto Main Menu
-Settings
-Connections
-USB Settings
-Choose Modem

On Mandriva Spring 2008.1 with wvdial
Install wvdial first

[root@box bayu]# urpmi wvdial
To satisfy dependencies, the following packages are going to be installed:
Package Version Release Arch
(medium "main_speedy")
libwvstreams4.4 4.4 3mdv2008.1 i586
libxplc0 0.3.13 3mdv2008.1 i586
wvdial 1.60 1mdv2008.1 i586
1.9MB of additional disk space will be used.
729KB of packages will be retrieved.
Proceed with the installation of the 3 packages? (Y/n)

http://opensource.telkomspeedy.com/repo/mandriva/official/2008.1/i586/media/main/release/libxplc0-0.3.13-3mdv2008.1.i586.rpm
http://opensource.telkomspeedy.com/repo/mandriva/official/2008.1/i586/media/main/release/wvdial-1.60-1mdv2008.1.i586.rpm
http://opensource.telkomspeedy.com/repo/mandriva/official/2008.1/i586/media/main/release/libwvstreams4.4-4.4-3mdv2008.1.i586.rpm
installing libxplc0-0.3.13-3mdv2008.1.i586.rpm wvdial-1.60-1mdv2008.1.i586.rpm libwvstreams4.4-4.4-3mdv2008.1.i586.rpm from /var/cache/urpmi/rpms
Preparing... ##########################################################################################
1/3: libxplc0 ##########################################################################################
2/3: libwvstreams4.4 ##########################################################################################
3/3: wvdial ##########################################################################################
[root@box bayu]#

then run

[root@box bayu]# wvdialconf
Editing `/etc/wvdial.conf'.

Scanning your serial ports for a modem.

Modem Port Scan<*1>: S0 S1 S2 S3
WvModem<*1>: Cannot get information for serial port.
ttyACM0<*1>: ATQ0 V1 E1 -- OK
ttyACM0<*1>: ATQ0 V1 E1 Z -- OK
ttyACM0<*1>: ATQ0 V1 E1 S0=0 -- OK
ttyACM0<*1>: ATQ0 V1 E1 S0=0 &C1 -- OK
ttyACM0<*1>: ATQ0 V1 E1 S0=0 &C1 &D2 -- OK
ttyACM0<*1>: ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0 -- OK
ttyACM0<*1>: Modem Identifier: ATI -- ERROR
ttyACM0<*1>: Speed 4800: AT -- OK
ttyACM0<*1>: Speed 9600: AT -- OK
ttyACM0<*1>: Speed 19200: AT -- OK
ttyACM0<*1>: Speed 38400: AT -- OK
ttyACM0<*1>: Speed 57600: AT -- OK
ttyACM0<*1>: Speed 115200: AT -- OK
ttyACM0<*1>: Speed 230400: AT -- OK
ttyACM0<*1>: Speed 460800: AT -- OK
ttyACM0<*1>: Max speed is 460800; that should be safe.
ttyACM0<*1>: ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0 -- OK

Found an USB modem on /dev/ttyACM0.
/etc/wvdial.conf: Can't open '/etc/wvdial.conf' for reading: No such file or directory
/etc/wvdial.conf: ...starting with blank configuration.
Modem configuration written to /etc/wvdial.conf.
ttyACM0: Speed 460800; init "ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0"
[root@box bayu]#

Edit config file /etc/wvdial, this for my provider

#telkomsel
[Dialer telkomsel]
Modem = /dev/ttyACM0
Baud = 460800
Init1 = ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
Init3 = at+cgdcont=1,”ip”,”telkomsel”
Modem Type = USB Modem
ISDN = 0
Phone = *99***1#
Username = “wap”
Password = “wap123″

#three
[Dialer three]
Modem = /dev/ttyACM0
Baud = 460800
Init1 =ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
Init3 = at+cgdcont=1,”ip”,”3gprs”
Modem Type = USB Modem
ISDN = 0
Phone = *99***1#
Username = “3gprs”
Password = “3gprs”

#indosat
[Dialer indosat]
Modem = /dev/ttyACM0
Baud = 460800
Init1 =ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
Init3 = at+cgdcont=1,”ip”,”www.indosat-m3.net”
Modem Type = USB Modem
ISDN = 0
Phone = *99***1#
Username = “gprs”
Password = “im3”

# xl
[Dialer xl]
Modem = /dev/ttyACM0
Baud = 460800
Init1 = ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
Init3 = at+cgdcont=1,”ip”,”www.xlgprs.net”
Modem Type = USB Modem
ISDN = 0
Phone = *99***1#
Username = “xlgprs”
Password = “proxl”

Setting for GPRS Access Point.
telkomsel->telkomsel
three->3gprs
indosat->www.indosat-m3.net
xl->www.xlgprs.net

OK, let's do it

$ wvdial

Eg :
$ wvdial telkomsel
$ wvdial three
$ wvdial indosat
$ wvdial xl

end

Mandriva : Install LAMP / XAMP

Simple way to install Webserver with PHP, MySQL, and PERL in Mandriva Spring

Connect to repo from http://easyurpmi.zarb.org, then
Install LAMP (Linux Apache MySQL PHP) with command

urpmi lamp
The following packages contain lamp:
task-lamp
task-lamp-perl
task-lamp-php
task-lamp-python

or

urpmi task-lamp (for complete LAMP in mandriva spring)

Tweaking KDE

After establishing these foundations, users can tweak KDE to perform well on older hardware. Several options are listed at the KDE wiki.

1. Update to a recent version of KDE. The updating game gets old real fast, but generally, with KDE a recent version means improved performance.
2. Disable wallpaper. Select a pleasing and comfortable desktop screen color. (Configure Desktop.)
3. Disable background gradients. (Configure Desktop.)
4. Disable shadowed fonts. (Configure Desktop, Advanced Options.)
5. Disable desktop icon tool tips. (Configure Desktop, Behavior.)
6. Minimize the number of device icons on the desktop. (Configure Desktop, Behavior.)
7. Virtual desktops. Limit this to two desktops, possibly only one. Consider that most people are not multi-taskers. Typically most people concurrently run only two to three desktop programs. Having a bunch of programs running in standby, which is how virtual desktops basically work, means a lot of extra overhead that most typical users do not need. Although useful, many people get by comfortably with only one desktop. (Configure Desktop, Multiple Desktops.)
8. Use a plain blank screen saver. (Configure Desktop, Screen Saver.)
9. Disable the mouse cursor launch feedback. (Appearance and Themes, Launch Behavior.)
10. Disable themes. Yes, themes add a degree of personalization, but with older hardware, at the sacrifice of speed and response.
11. Consider using the KDE Classic widget set and KDE 2 window decorations. Yes, this ends up looking like MS Windows 95, but this desktop is easy on system resources. (Appearance and Themes, Style; Appearance and Themes, Window Decorations.)
12. Disable displaying window content when moving or resizing windows. (Desktop, Windows Behavior.)
13. Disable shading animation and hovering. (Desktop, Window Behavior.)
14. Disable transparent and translucent menus and panels. These bells and whistles are CPU and memory intensive. (Desktop, Window Behavior.)
15. Disable GUI effects, such as cascading menus and drop shadows.
16. Mouse cursor. A simple non-themed mouse pointer is sufficient for most people.
17. System sounds. Reduce the number of system sounds being used and use sound files that are small in size and load quickly.
18. Enable Konqueror preloading. Konqueror will load faster and Konqueror is too useful as a file manager not to have this option enabled. (Control Center→KDE Components→KDE Performance)
19. Disable as many KDE specific services as practical. (Control Center→KDE Components→Service Manager)

Hopefully these suggestions will noticeably improve your KDE performance with your older box.

Mandriva Spring 2008.1 : How install LAMP

LAMP = Linux Apache Mysql Phpmyadmin (link).
Connect to repository Mandriva from easyurpmi.

Installation:

-run command

urpmi apache mysql phpmyadmin

done...

Mandriva Spring 2008.1 : Mysql Installation

urpmi mysql phpmyadmin

installing mysql-common-5.0.51a-7mdv2008.1.i586.rpm mysql-client-5.0.51a-7mdv2008.1.i586.rpm apache-mod_php-5.2.5-5mdv2008.1.i586.rpm phpmyadmin-2.11.5-1mdv2008.1.noarch.rpm mysql-5.0.51a-7mdv2008.1.i586.rpm from /var/cache/urpmi/rpms
Preparing... ##########################################################################################
33/37: mysql-client ##########################################################################################
34/37: mysql-common ##########################################################################################
35/37: apache-mod_php ##########################################################################################
36/37: phpmyadmin ##########################################################################################
37/37: mysql ##########################################################################################
----------------------------------------------------------------------


More information on package mysql-5.0.51a-7mdv2008.1.i586

The initscript used to start mysql has been reverted to use the one shipped
by MySQL AB. This means the following changes:

* The MYSQLD_OPTIONS="--skip-networking" option in the /etc/sysconfig/mysqld
file has been removed, this is now set in the /etc/my.cnf file.

* The MySQL Instance Manager is used by default, set use_mysqld_safe="1" in
the /etc/sysconfig/mysqld file to use the old mysqld_safe script.

* The generation of the initial system mysql database is now done when mysql
is started from the initscript and only if the /var/lib/mysql/mysql
directory is empty (mysql_install_db). Previousely this was quite hidden and
silently done at (rpm) install time.

The extra MySQL-NDB server package has been merged into the MySQL-Max package
and ndb related pieces has been split into different sub packages as done by
MySQL AB. The MySQL libraries and the MySQL-common sub package uses the
MySQL-Max build so that no functionality required by for example the NDB
parts are lost.

The MySQL-common package now ships with a default /etc/my.cnf file that is
based on the my-medium.cnf file that comes with the source code. The
/etc/my.cnf file is constructed at build time of this package.

To connect to the Instance Manager you need to pass the correct command line
options like in the following examples:

* mysql -u root --password=my_password --port=2273 --protocol=TCP
* mysql -u root --password=my_password --socket=/var/lib/mysql/mysqlmanager.sock

Please note you also need to add a user in the /etc/mysqlmanager.passwd file and
make sure the file is owned by the user under which the Instance Manager service
is running under.

[root@box bayu]# /etc/init.d/mysqld start
Initializing MySQL database:
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h box password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd / ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQL: [ OK ]
[root@box bayu]#