Installing mysql di fedora 14

#curhat :D
hari nie gw baru install Fedora d labtop Acer tua gw,
tadi nya gw mo install backtrack 4rc eeh cd na rusak gtu, bete :(
akhirnya gw ngubek" barak gw(kamar :p), eh nemu fedora 14, dari pada ga ada yacg daah gw install
daah beres install pertama dapet masalah adalah dia turunan red hat yg ga suport mp3..
ngubek" s embah akhirnya nemu jga cara buat yetel mp3nya :D

karna gw kangen ma java(biarpun ga ada bakat sama sekali ;p) gw download eclipse ma mysql

trus gw coba kan
#yum install mysql-server
daah beres install dan download
gw coba kan command
#mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysq/mysql.sock' (2)

arrrrggggg
gogling lagi....

coba sana sini
yg sukses yg nie nie :D :

[souce tutorial: http://www.if-not-true-then-false.com] cek aja gan ada centos dan kawan"nya :D

---------------
ni step" na :D :

- jadi root supaya bisa install :)
# su -

- Remi Dependency on Fedora 14, 13, 12, 11, 10, 9, 8
# rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
# rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm

-fedora 14
# rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm


-check list paket yg tersedia
# yum --enablerepo=remi list mysql mysql-server

-install atau update mysql
# yum --enablerepo=remi install mysql mysql-server

-start servises mysql
# /etc/init.d/mysqld start

-mulai isntall mysql
/usr/bin/mysql_secure_installation

isi dengan kebutuhan anda :). selamat berfedora :)

: no version information available (required by /usr/bin/python)

ubuntu command terminal gw tiba begini setelah gw oprek nginstall Zend Server CE :D

/usr/bin/python: /usr/local/zend/lib/libcrypto.so.0.9.8: no version information available (required by /usr/bin/python)
/usr/bin/python: /usr/local/zend/lib/libssl.so.0.9.8: no version information available (required by /usr/bin/python)

setelah googling nie solusinya

# sudo mv /usr/local/zend/lib/libssl.so.0.9.8 /usr/local/zend/lib/libssl.so.0.9.8.hold
# sudo mv /usr/local/zend/lib/libcrypto.so.0.9.8 /usr/local/zend/lib/libcrypto.so.0.9.8.hold

yg di atas maksudnya supaya tak terbaca system na :D

# oracle@freakyhost-Rev-1-0:~$ sudo /usr/local/zend/bin/zendctl.sh start
Starting Zend Server 5.0.4 ..

httpd: Could not reliably determine the server's fully qualified domain name, using ::1 for ServerName
/usr/local/zend/bin/apachectl start [OK]
spawn-fcgi: child spawned successfully: PID: 4915
Starting Zend Server GUI [Lighttpd] [OK]
[ 15.01.2011 17:21:37 SYSTEM] watchdog for lighttpd is running.
[ 15.01.2011 17:21:37 SYSTEM] lighttpd is running.

note : efeksamping pada Zend Server CE blum d ketahui :D

selamat berubuntu :))

error 13, Permission denied for file ./dirchk/*.cpe

Error opening checkpoint for EXTRACT EU01
(error 13, Permission denied for file /ogg01/oragg/dirchk/EU01.cpe)

ubah file permision d dirchk/ dengan chown/chmod

exsample : chown [UserOsOgg]:[GroupOgg] dirchk/*.cpe

Install Oracle 10g Di Ubuntu

1. Install package berikut ini
* sudo apt-get install build-essential libaio1 rpm lesstif2-dev alien

2. Bikin user ama group untuk oracle installation :
* sudo groupadd oinstall
* sudo groupadd dba
* sudo groupadd nobody
* sudo useradd -g oinstall -G dba,nobody -m oracle -s /bin/bash

3. berikan Password untuk user oracle bebas masukan apa saja
* sudo passwd oracle

4. buat directory dan owner untuk directory nya
* sudo mkdir -p /u01/app/oracle
* sudo chown -R oracle:oinstall /u01/app/oracle
* sudo chmod -R 775 /u01/app/oracle

5. Ubah configuration paramater kernel /etc/sysctl.conf
* sudo gedit /etc/sysctl.conf

masukan kedalam nya settingan ini :

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

6. Reboot system untuk mastikan settingan suadah banar.
* /sbin/sysctl -p

7. Ubah file /etc/security/limits.conf

* sudo gedit /etc/security/limits.conf

masukan settingan ini :

soft nproc 2047
hard nproc 16384
soft nofile 1024
hard nofile 65536

8. Membuat symbolic links untuk membuat oracle menyangka bahwa distro yg support

* sudo ln -s /usr/bin/awk /bin/awk
* sudo ln -s /usr/bin/rpm /bin/rpm
* sudo ln -s /lib/libgcc_s.so.1 /lib/libgcc_s.so
* sudo ln -s /usr/bin/basename /bin/basename
* sudo touch /etc/redhat-release
* sudo chmod 666 /etc/redhat-release
* sudo echo redhat-4 > /etc/redhat-release

9. Logout dan login as Oracle

10.Login sebagai user Oracle,

* vi /home/oracle/.bashrc

masukan setingan ini :
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin

11. jalan kan script nya

./runInstaller -ignoreSysPreReqs