Category Archives: Linux

slackpkg

Published by:

Not just ubuntu who has an easy install program using apt-get command. Slackware has one too.
First edit /etc/slackpkg/mirrors
Uncomment one of the closest server from you under the slackware version you use. Mine is Indonesia but the server is not active. So I m using Australian.
Do
#slackpkg update
for updating the repository.
Next time we need to install something do this (in root)
#slackpkg install program
Well done.

mysql command

Published by:

using mysql from console
$mysql -u myuser -pmypassword

show database
mysql>show databases;

connect to database
mysql>use mydatabase;

show tables inside the database
mysql>show tables;

show what inside the table
mysql>select*from tablenamesatu

search the data inside the table
mysql>select*from tablenamesatu where columndata=’data’;
mysql>select*from tablenamesatu where columndata mycolumns like ‘data%’;

insert data
mysql>insert into tablenamesatu (column1,column2,..) values(‘data’,’data’,’…’);

delete data
mysql>delete from tablenamesatu where username=’data’;

update/change data
mysql>update tablenamesatu set columndata=’data’ where columndata1=’data’;

show header of column of table
mysql>show columns from tablenamesatu;

can’t start xampp 1.7.4 properly in mysql

Published by:

Sometime strange thing happen to me with my machine. I use slackware for many years. And I have two machine with the same slackware version. With one maching I can install xampp fine. But in another one, can not. The error messege when running xampp with /opt/lampp/lampp start is Mysql can’t running.
It is because there’s another mysqld service running on my slackware 13.1. Heres is the result when I stop /etc/rc.d/rc.mysqld
(do it in root)
#ps x | grep mysql
# 3731 pts/1 S 0:00 /bin/sh /usr/bin/mysqld_safe –datadir=/var/lib/mysql –pid-file=/var/run/mysql/mysql.pid –skip-networking

So I stop the mysqld
#/etc/rc.d/rc.mysqld stop

Restart the lampp
#/opt/lampp/lampp restart
The mysql should be working now.

joe editor

Published by:

I though joe is somebody name but this is linux editor. Slackware has it.
As easy as nano and mcedit. Here are the list of joe’s command
source is here and here

Help Screen turn off with ^KH more help with ESC . (^[.)

CURSOR GO TO BLOCK DELETE MISC EXIT
^B left ^F right ^U prev. screen ^KB begin ^D char. ^KJ reformat ^KX save
^P up ^N down ^V next screen ^KK end ^Y line ^T options ^C abort
^Z previous word ^A beg. of line ^KM move ^W >word ^R refresh ^KZ shell
^X next word ^E end of line ^KC copy ^O wordline SPELL ^KE edit
^KF find text ^KV end of file ^KY delete ^_ undo ^[N word ^KR insert
^L find next ^KL to line No. ^K/ filter ^^ redo ^[L file ^KD save

IW tonguetwister Row 1 Col 1 9:48 Ctrl-K H for help

New File

easyhotspot with coovachilli in virtualbox

Published by:

Finally I made it to install easyhotspot with ubuntu iso inside the virtualbox. Actually it’s already running but when I made a change a little in the dns setting, chillispot is not running.
So I upgraded to coovachilli and today I made it to make it work. Together with easyhotspot web management that I didn’t find any reference about how to make a relation between them.
Wait for the complete review.

activating ssh in ubuntu 9.10 karmic

Published by:

As usual ubuntu always need some extra setting when we need one. For example I need to install ssh server in it. Ubuntu doesn’t have one. So we need to find the program first.

#sudo apt-get install openssh-client
#sudo apt-get install openssh-server
#sudo nano /etc/ssh/ssh_config

Uncheck Port 22 or we can change the port to the empty one.

Restart the ssh

#sudo /etc/init.d/ssh restart

That’s it.

install aura-cms

Published by:


Extract into your public_html
Create the database from phpmyadmin, import structure from auracms.sql into your sql through phpmyadmin
Then open new tab in your browser
type : http://localhost/
Search for login form, usually at your left. The default user is admin with password auracms
To change the username from admin, we need to do some trick. I’ll find out about that later

gsm and cdma dial up numbers

Published by:

source : http://charless.wordpress.com/

Someday we’re going to need this setting in our wvdial.conf or any wireless linux setting.
1. Telkomsel Flash – Halo/Simpati/As (Waktu)
Dial Up Number : *99***1#
User Name :
Password :
Access Point : FLASH
Extra Setting : at+cgdcont=1,”IP”,”flash”

2. Telkomsel GPRS – Halo/Simpati/As (Data)
Dial Up Number : *99***1#
User Name : wap
Password : wap123
Access Point : TELKOMSEL
Extra Setting : at+cgdcont=1,”IP”,”internet”

3. Indosat – Matrix – (Data)
Dial Up Number : *99***1#
User Name :
Password :
Access Point : www.satelindogprs.com
Extra Setting : at+cgdcont=1,”IP”,” www.satelindogprs.com”

4. Indosat – Mentari – (Data)
Dial Up Number : *99***1#
User Name : indosat
Password : indosat
Access Point : www.satelindogprs.com
Extra Setting : at+cgdcont=1,”IP”,” www.satelindogprs.com”

5. Indosat – IM3 – (Data)
Dial Up Number : *99***1#
User Name : gprs
Password : im3
Access Point : www.indosat-m3.net
Extra Setting : at+cgdcont=1,”IP”,” www.indosat-m3.net”

6. Indosat – IM3 – (Waktu)
Dial Up Number : *99***1#
User Name : indosat@durasi
Password : indosat@durasi
Access Point : www.indosat-m3.net
Extra Setting : at+cgdcont=1,”IP”,” www.indosat-m3.net”

7. XL – Xplor/Bebas/Jempol (Data)
Dial Up Number : *99***1#
User Name : xlgprs
Password : proxl
Access Point : www.xlgprs.net
Extra Setting : at+cgdcont=1,”IP”,” www.xlgprs.net”

8. Telkom Flexi – Classy/Trendy (Data)
Dial Up Number : #777
User Name : telkomnet@flexi
Password : telkom
Access Point :
Extra Setting : at+crm=1

9. Telkom Flexi – Classy/Trendy (Waktu)
Dial Up Number : 080989999
User Name : telkomnet@instan
Password : telkom
Access Point :
Extra Setting : at+crm=0

10. Mobile 8 – Fren
Dial Up Number : #777
User Name : m8
Password : m8
Access Point :
Extra Setting :

11. Starone
Dial Up Number : #777
User Name : starone
Password : indosat
Access Point :
Extra Setting :

12. Esia (Waktu)Dial Up Number : #777
User Name : esia
Password : esia
Access Point :
Extra Setting :

13. three
Dial Up Number : *99#
User Name : 3data
Password : 3data
Access Point :3data
Connection name: three
Registration dial : *234#

open office 3.3 – deleting recovery file without re-install openoffice

Published by:

Sometime there’s a recovery option that really bugging us and never stop asking when opening open office. The fact is the recovery file is already damaged and cant be restored. But we can’t just cancel the recovery because somehow open office reject it. So we need to delete the recovery file record.
This is how :
delete all files in .openoffice/3/user/backup
start open office again
That’s it.