Showing posts with label Linux. Show all posts
Showing posts with label Linux. Show all posts

Thursday, February 18, 2010

vBulletin - change access superadministrator

Sorry, you dont have permission to access the admnistrative controls on this page.

If you need to access.. bla bla bla...


hmm.. camner nak buat nih... dah login menggunakan username nazril.. sepatutnya full administrator dah diberikan pada username nazril, rupanya masih ada limit permission..

cara senang ialah login guna username admin lah kan.. tp username admin n password tu da lupa lah or orang lain pegang..

asalkan ada full access pada server tu da bleh buat dah..

ok salah satu cara ubah config dalam config.php seperti error message dibawah ini.



Sorry, you are not allowed to edit administrator permissions.

If you think you should have permission to access this page, you will need to edit the $config['SpecialUsers']['superadministrators'] variable in the includes/config.php file.

To allow the administrators to access this page, edit the variable to include the user IDs of those administrators should have access, separating each user ID with a comma, like this:

$config['SpecialUsers']['superadministrators'] = '1,25,57';

To allow only a single administrator to access this page, simply add that user's ID with no commas, like this:

$config['SpecialUsers']['superadministrators'] = '1';



OK..
mula2..
login server dgn su password.. pastu su -
cari ini includes/config.php ok.
tambah user ID seperti line coding diatas ok .
mcmmana nak tau user ID?
masuk database mysql
dbname, username n password ada kat dlm config.php tu.. semak disitu..
note to self:lihat dlm laptop, mydocument vBulletinpermission.txt

mysql -u[username] -p [dbname]

bila dah masuk mysql
show tables; tgk berapa bnyk table yg ada.. carik table yg berkenaan iaitu user

describe user; nak tgk apa field dlam table user tadi.. sbb nak cari field username

select * from user where username ="nazril";

so da bleh tau dah apakah ID untuk user bernama nazril.


ok skarang ni da bleh tutup mysql.

dan bleh la vi includes/config.php tadi.. n masukkan user ID dalam coding diataas tadi..

sekian.

Friday, October 9, 2009

shutdown -h now

login as: www
www@119.xxx.xxx.xxx's password:
Last login: Mon Sep 28 13:39:54 2009 from 60.49.xxx.xxx
[www@maildevel12 ~]$
[www@maildevel12 ~]$ shutdown -h now
-bash: shutdown: command not found "aik tak boleh?"
[www@maildevel12 ~]$ su
Password:
[root@maildevel12 www]# shutdown -h now
bash: shutdown: command not found "lar tak boleh jugak??"
[root@maildevel12 www]# su -
[root@maildevel12 ~]# shutdown -h now

Broadcast message from root (pts/0) (Fri Oct 9 10:52:52 2009):

The system is going down for system halt NOW! "haa baru boleh"
[root@maildevel12 ~]#

Tuesday, August 4, 2009

Create Database

ok.. utk pemahaman sendiri..

situasi : ada 2 server bdd dan bdd01..

bdd: 192.168.1.59
bdd01: 192.168.1.58

skarang ni berada dalam server bdd.. so kena masuk bdd01 dari situ..

ssh -l www 192.168.1.58 (internal)
then
mysql -uroot -p****** (ini password takbleh tunjuk )
so bolehlah:

mysql> create database sepang (contoh)

* show databases; nak tgk ada tak database itu....

pastu kena buat grant, contoh:

zonhisham: mysql> GRANT ALL PRIVILEGES ON sepang.* TO bdd@bdd01 IDENTIFIED BY '******'; (ini password takbleh tunjuk)

zonhisham: pastu kena flush supaya perubahan take effect:

zonhisham: mysql> flush privileges;

zonhisham: thats all

saiya: wokeh..

zonhisham: aksud GRANT command tadi adalah seperti berikut: grant semua privilege ke atas semua table dalam database yg bernama sepang (sepang.*) kepada user yg bernama bdd di server yg bernama bdd01 (bdd@bdd01) dan user bdd tersebut mempunyai password ******(sama cam atas tadi)
zonhisham: so dlm settings.php utk sepang.bdd.org.my (contoh) kena lah edit secukup rasa
zonhisham: thats all. senang kan?
zonhisham:
saiya: ok ok rasanya cam bleh jer nih..
zonhisham: cun

Wednesday, April 29, 2009

Configure IP Address dalam Linux

cd / etc/sysconfig/network-scripts
lepastu taip
vi ifcfg-eth0
akan kuar VI untuk tukar ip address.. lepas tukar ip.. close VI... dan taip
/sbin/service network restart

Thursday, April 23, 2009

Delete File Logs.


Azril Nazli Alias: ok ssh masuk
Azril Nazli Alias: as root
Azril Nazli Alias: cd /var/www/
Azril Nazli Alias: opss
Azril Nazli Alias: apa yer alamat
saiya: alamat ape
Azril Nazli Alias: cd /var/www/p**m**a.com/statistics
Azril Nazli Alias: path
Azril Nazli Alias: boleh masuk
Azril Nazli Alias: cd /var/www/
saiya: spai situ jer
Azril Nazli Alias: ok ls

Azril Nazli Alias: ok cd vhosts
Azril Nazli Alias: cd p**m**a.com
Azril Nazli Alias: atau cd vhosts aja
Azril Nazli Alias: pastu taip
saiya: da masuk
Azril Nazli Alias: taip nih
Azril Nazli Alias: du -sh *
Azril Nazli Alias: bagitau aku folder apa paling besar
saiya: paling besar statistics 471M
Azril Nazli Alias: ok
Azril Nazli Alias: cd statistics
Azril Nazli Alias: ls
saiya: anon_ftpstat ftpsta ftpstat logs webstat webstat-ssl

Azril Nazli Alias: cd logs
saiya: ls
saiya: access_log access_log.processed error_ssl_log
access_log.1 access_ssl_log xferlog_regular
access_log.2 access_ssl_log.processed xferlog_regular.processed
access_log.process error_log

Azril Nazli Alias: rm *.processed
Azril Nazli Alias: rm access_log.1
Azril Nazli Alias: rm access_log.2
saiya: rm: remove regular empty file `access_log.processed'?

Azril Nazli Alias: Y
saiya: maknanya nak remove semua file dot prosesed la ni
Azril Nazli Alias: yup
saiya: ok da suda
Azril Nazli Alias: ok skrg
saiya: tgk balik ek
Azril Nazli Alias: echo " " > access_log
Azril Nazli Alias: echo " " > error_log
saiya: ok dah
Azril Nazli Alias: taip df
saiya: Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
2064208 1164004 795348 60% /
/dev/sda1 101086 12596 83271 14% /boot
none 517300 0 517300 0% /dev/shm
/dev/mapper/VolGroup00-LogVol02
13288568 12146776 466772 97% /var

Azril Nazli Alias: 97%
Azril Nazli Alias: ok skrg cd /var/www/vhosts/p**s.biz/statistics
Azril Nazli Alias: cd logs
Azril Nazli Alias: du -sh *
saiya: 26M access_log
0 access_log.1
0 access_log.2
0 access_log.process
0 access_log.processed
180M error_log
0 xferlog_regular
4.0K xferlog_regular.processed

Azril Nazli Alias: echo "" > error_log
Azril Nazli Alias: kemudian gi /var/www
Azril Nazli Alias: cd /var/www
Azril Nazli Alias: kemudian taip du -sh *
saiya: 1.8M cgi-bin
8.0K dansguardian
200K error
2.1M html
944K icons
3.5M usage

saiya: 1.8M cgi-bin
8.0K dansguardian
200K error
2.1M html
944K icons
3.5M usage
2.8G vhosts
8.0K xlog

Azril Nazli Alias: cd vhosts
Azril Nazli Alias: du -sh *
saiya: disini ada lah dlm vhosts
38M ****.com.my
1.4M ****.com
29M ****.com.my

carik yang mana filesize besar

Azril Nazli Alias: ok pi masuk p***d
Azril Nazli Alias: mankuk nyer p***d
saiya: ok cd p***d.biz
Azril Nazli Alias: cd statistics
Azril Nazli Alias: clearkan log dia
Azril Nazli Alias: du -sh *
Azril Nazli Alias: cd logs
Azril Nazli Alias: cd p***d.biz
saiya: 708M logs

saiya: so clear mcm tadi la kan
Azril Nazli Alias: ha-ah
saiya: access_log.1 ngan access_log.2 takde
Azril Nazli Alias: tapi ko nyer target kena kecikkan /var nyer free space

Azril Nazli Alias: https://www.fido.net/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=1
saiya: echo " " > access_log ni utk ape
Azril Nazli Alias: kosongkan isi kandung file
Azril Nazli Alias: lepas semua tuh ko gi cd /
Azril Nazli Alias: ehh silap
Azril Nazli Alias: taip df
saiya: 0 access_log
233M access_log.processed
324K error_log
0 xferlog_regular

saiya: error log ni pun nak rm jugak ker
Azril Nazli Alias: echo "" >
Azril Nazli Alias: semua sekali ko buat echo "" > filename
saiya: ooo yg rm tu utuk procesed
saiya: echo "" > error_log
saiya: dalam p**d tadi ade ni
saiya: 224K access_log
80M access_log.processed.1.gz
30M error_log
0 xferlog_regular

Azril Nazli Alias: .gz ko delete
Azril Nazli Alias: error log ko kosongkan
saiya: ok
Azril Nazli Alias: taip df
Azril Nazli Alias: apa value skrg
saiya: Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
2064208 1164884 794468 60% /
/dev/sda1 101086 12596 83271 14% /boot
none 517300 0 517300 0% /dev/shm
/dev/mapper/VolGroup00-LogVol02
13288568 10767296 1846252 86% /var

Azril Nazli Alias: 14% aja available
Azril Nazli Alias: du -sh * /var/www/vhosts
saiya: [root@p***t logs]# du -sh * /var/www/vhosts
224K access_log
4.0K error_log
0 xferlog_regular
1.7G /var/www/vhosts

Azril Nazli Alias: ok
Azril Nazli Alias: dah ok kot
Azril Nazli Alias: tapi bend anih kena buat every 2 weeks
saiya: wooo
saiya: ok ok

Connection Database Problem - Cara Repair

Symptom:

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.



Show Recent Messages (F3)

saiya: kat p*t*n m*n*a ade error Error: The requested address '/' was not found on this server. ni ker?
Azril Nazli Alias: database down
Azril Nazli Alias: kena restart mysqld
Azril Nazli Alias: /sbin/service mysqld restart
saiya: ok ok aku wat kan tp ajar aku
Azril Nazli Alias: ssh masuk ke ph1
saiya: aku da masuk da ph1
Azril Nazli Alias: taip whoami
Azril Nazli Alias: bagitau aku apa status
saiya: www
Azril Nazli Alias: ko kena login as root
Azril Nazli Alias: taip su
Azril Nazli Alias: letak password root
saiya: ok da suda
Azril Nazli Alias: taip /sbin/service mysqld restart
Azril Nazli Alias: dia tulis apa kat screen ?
saiya: stopping mysql [ok]
Azril Nazli Alias: ok
Azril Nazli Alias: starting cemana
saiya: starting failed
Azril Nazli Alias: ko taip nih
Azril Nazli Alias: reboot
Azril Nazli Alias: reboot terus server
saiya: ok da reboot
Azril Nazli Alias: dah ready
saiya: ok da ready
Azril Nazli Alias: ok masuk sebagai root
saiya: ok da root dah
Azril Nazli Alias: skrg turn off database
Azril Nazli Alias: /sbin/service mysqld stop
saiya: ok
saiya: stopping mysql... [OK]
Azril Nazli Alias: try run
Azril Nazli Alias: /sbin/service mysqld start
saiya: failed
saiya: Timeout error occurred trying to start MySQL Daemon.
Azril Nazli Alias: ada
Azril Nazli Alias: cd /var/lib/mysql
saiya: boleh
Azril Nazli Alias: boleh ?
Azril Nazli Alias: ls
Azril Nazli Alias: apa folder yg ada
saiya: A**
g***
m****
p****m

a***n
p*t*nm*n*a_2009
p*t*nc**s_db

dan banyak lagi perkara dlm ni..

Azril Nazli Alias: cd p*t*nm*n*a_2009
saiya: ok boleh

Azril Nazli Alias: try myisamchk -r *.MYI
Azril Nazli Alias: kalau diam..maksudnya dah repair
saiya: file index ape tah
saiya: fixing index
Azril Nazli Alias: ohh dia tgh repair
saiya: recovering
saiya: ok dah
Azril Nazli Alias: cun
Azril Nazli Alias: cd ../p*t*nc**s_db (ok ni maksudnya patah balik folder belakang dan masuk folderbaru) contoh dia akan jd cam ni ler sama jugak
cd /var/lib/mysql/p*t*nm*n*a_2009 (folder asal)
cd /var/lib/mysql/p*t*nc**s_db (nak masuk folder ni)

saiya: ok
Azril Nazli Alias: myisamchk *.MYI
saiya: oo wat lagi skali ek
saiya: nak ade -r tak
Azril Nazli Alias: command nih akan repair semua fail ending dgn .MYI
Azril Nazli Alias: ada
Azril Nazli Alias: -r maksudnya auto repair
saiya: myisamchk -r *.MYI
Azril Nazli Alias: lepas r ada jarak
saiya: recovering
Azril Nazli Alias: ok cun
saiya: fixing index 1
Azril Nazli Alias: sure seronok tengok kan
Azril Nazli Alias: dia tgh repair
saiya: ha'ah
saiya: nampak nombor bergerak2
saiya: - recovering (with sort) MyISAM-table 'smf_messages.MYI'
Data records: 244037
- Fixing index 1
Found block that points outside data file at 79740844
Found block that points outside data file at 79740852
Found block that points outside data file at 79740864
- Fixing index 2
- Fixing index 3
- Fixing index 4
244000

Azril Nazli Alias: nanti bila ko free..aku ajar ko create databae, backup database
saiya: mcm2 dia repair
saiya: ok cun.. sbb skarang ni pun aku tgh install vmware...
saiya: aku nak install centos dlm tu
Azril Nazli Alias: ok
Azril Nazli Alias: centos...fedoracore laa senang
Azril Nazli Alias: ko nak belajar cakephp pun aku leh ajar
saiya: ok da siap repair
Azril Nazli Alias: ok skrg start db
Azril Nazli Alias: /sbin/service mysqld start
Azril Nazli Alias: command tu untuk start database mysql daemon
saiya: command tu taip kat mana2 pun bleh ek
saiya: Starting MySQL: [ OK ]

Azril Nazli Alias: yup boleh
saiya: tapi kat http://ad.p*t*m*a.com/ masih sama
Azril Nazli Alias: ok
Azril Nazli Alias: killall mysqld
Azril Nazli Alias: taip tu
Azril Nazli Alias: pastu taip mysqld start balik
saiya: ok
saiya: msqld: no process killed

Azril Nazli Alias: ok skrg taip nih
Azril Nazli Alias: mysql -u -p p*t*n*a_2009
saiya: sama ar ERROR 1040 (00000): Too many connections

Azril Nazli Alias: ok
Azril Nazli Alias: skrg try reboot
Azril Nazli Alias: tunggu 10 minit
Azril Nazli Alias: sebab kita dah repair database
Azril Nazli Alias: kita reboot server
saiya: ok
Azril Nazli Alias: server tuh dah tahap kokah
Azril Nazli Alias: kokak
Azril Nazli Alias: zaman 1990an nyer server kot
saiya: erm agaknyr la
Azril Nazli Alias: ker awal 2000
Azril Nazli Alias is using a different version of Yahoo! Messenger. Certain features may be unavailable.

saiya: aha.. dah nampak dah
Azril Nazli Alias: ok done
Azril Nazli Alias: simpan dalam nota
Azril Nazli Alias: sebab aku rasa server nih dah nyawa nyawa ikan
saiya: apemenda yang berlaku tadi
Azril Nazli Alias: skrg aku nak ko backup database aku
Azril Nazli Alias: tapi bukan skrg laa
Azril Nazli Alias: petang karang ker
saiya: ok ptg karang wat
Azril Nazli Alias: oppss satu db lagi x repair
Azril Nazli Alias: cd /var/lib/mysql/peroduacars_db
Azril Nazli Alias: mysam check yg tadi siap r
saiya: oo ok jap
Azril Nazli Alias: database pmc still error...
Azril Nazli Alias: Can't open file: 'smf_sessions.MYI' (errno: 145)
saiya: ok skarang ni tgh repair peroduacars_db
Azril Nazli Alias: ok
saiya: ok da siap repair
Azril Nazli Alias: cd masuk protonmania_2009
Azril Nazli Alias: rapir balik
saiya: ok da siap repair
Azril Nazli Alias: ok
Azril Nazli Alias: too many connections error balik
Azril Nazli Alias: ubat dia
Azril Nazli Alias: reboot
Azril Nazli Alias: pastu kalau error lagi....
Azril Nazli Alias: esok laa pk balik
Azril Nazli Alias:
saiya: ok tgh reboot
saiya: harap ok la kot
Azril Nazli Alias: ker nak ganti hdd baru