The latest version of Debian GNU/Linux Operating System, Debian 5 with code name Lenny has beed released on February 14, 2009. Debian Lenny has compatibility to many devices started from Palmtops and handheld to super computer. This free operating system able to support twelve of processors arcitectures and some desktop environment.
More updates features have been included into the package, such as the GNUstep desktop 7.3, X.Org 7.3, MySQL 5.0.51a, GNU Compiler Collection 4.3.2 and many other. Easy and numerous installation can be done before using this operating system. We can use DVDs, CDs, USB sticks, floppies or from network.
see the complete new about Debian GNU/Linux 5 or lenny at http://www.debian.org/News/2009/20090214
Incoming search terms for the article:
billing warnet dengan menggunkan wine puppylinux (1),
indobilling 7 3 (1),
indobilling dengan wine di linux (1),
syntax mysql indobilling (1)
There are many people using Linux Operating system for their computer. The advantage that can be picked from Linux usage is not only some money that we can save but also features that included in Linux has almost same ability with the other Operating System in market.
In deciding which Linux we want to choose there are four consideration that we can use:
1.Why we choose Linux for our computer Operating System?
Every Linux distro is free available and we can install them in our PC freely as many as possible. This Operating system also has included with many important applications.
Like OpenOffice.org which has good ability for word editing and counting. Then if you want to edit image you can use Gimp which nice too to be used
Not only this some windows application also can be run in Linux through Wine. Like Linux server Application, it can be Apache Web Server and MySQL for database that also can be used by businessman. In Linux also available a networking software, Samba which also has quality as good as other paid networking software. It also need to known that Linux is not attached by virus as often as the others.
2. Choosing Linux Distro
There are many Linux Distro in market with the differences include in each distro. This difference can be the easy in use and also the feature which are included in each. For example Ubuntu ad Fedora which both of them are easy to be used. If you are new in Linux usage, Puppy Linux with small size can be your choice.
3. How about Support?
We can use some support for solving our problem during using Linux. You might asked to pay, but it is cheap cost. You also can use guidebook that can be found easily in everywhere.
4. Cost Estimation
The other that you need to decide is Cost estimation. It is right that Linux is free and just the support need to be paid, but if you want your worker easy in using Linux you have to open your wallet in order to do the efforts, like training for Linux usage. But if we count it thoroughly Linux usage is saver of money
Incoming search terms for the article:
cara install paket tar gz pet di linux puppy (1),
libccls pet puppylinux (1)
Sample 1:
UPDATE member, grouprate
SET member.mem_type=grouprate.gr_group WHERE member.mem_grouprate=grouprate.name
Sample 2:
UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;
Single-table syntax:
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2] ...
[WHERE where_condition]
[ORDER BY ...]
You can also perform UPDATE operations
covering multiple tables. However, you cannot use ORDER
BY or LIMIT with a multiple-table
UPDATE. The
table_references clause lists the
tables involved in the join. Its syntax is described in
Section 12.2.7.1, “JOIN Syntax”. Here is an example:
Multiple-table syntax:
UPDATE [LOW_PRIORITY] [IGNORE] table_references SET col_name1=expr1 [, col_name2=expr2] … [WHERE where_condition]
For the simple TABLE, instruction UPDATE columns updates tbl_name lines with new values. The clause indicates SET columns to modify and the values they should. The WHERE clause, though, said that the conditions to determine what are the lines to update. With no WHERE clause, all lines will be updated. If the ORDER BY clause is specified, the lines will be updated in order. The LIMIT clause sets a ceiling for the number of lines that can be updated.
Incoming search terms for the article:
mysql update multiple tables (41),
mysql update example (29),
mysql multi table update (20),
update multiple tables mysql (17),
mysql multi table update limit (1),
mysql update multi table (1),
mysql update multi tables (1),
update multiple table in ione set (1)
Untuk mengatasi client billing sering disconnect, bisa upgrade ke versi terbaru billing server.
Namun jika belum bisa dilakukan manual sbb:
Masuk Ms Dos promt Windows, dan ketikkan:
c:\xampp\mysql\bin\mysqladmin.exe -uroot -ppasswordroot flush-host
DImana dalam contoh ini user = root dan password = passordroot
Kalau belum ada file mysqladmin.exe versi 5.0 bisa download di www.indobilling.com/mysql
Incoming search terms for the article:
indobilling client disconnect (40),
kenapa indobilling client disconnect (9),
password disconnect indobilling (8),
download indobilling 6 40 (7),
download indobilling client 6 40 (7),
indobilling error 127 (7),
cara mengatasi indobilling error (6),
cara memperbaiki indobilling (6),
cara mengatasi error mysql pada indobilling (5),
cara masuk indobilling (5),
indobilling error (5),
indobilling 6 4 (5),
indoclient 6 40 (4),
indoclient disconnected (4),
indobilling disconnected (4),
manual indobilling 6 40 (4),
download indobilling 8 4 (4),
cara mengatasi client disconect (4),
cara mengatasi disconnect client (4),
cara memperbaiki indobilling yang gak konek (4)
Billing Client Mode PHP adalah alternatif billing client, yang menggunakan teknologi php
sebagai media komunikasi.
Hal ini dilakukan untuk mengatasi kendala tidak dibukannya port Mysql (3306)
berkaitan dengan semakin ketatnya security di server linux.
Alasan lain adalah, semakin banyaknya DISTRO linux, yang membuat client
indobilling jadi tidak kompatible.
Langkah-langkah:
A. Install PHP di Server
1. Install dulu Webserver (Apache)
2. PHP module
3. PHP Mysql Module
B. Install PHP Billing Server
1. Download billphp.tar.gz di http://www.indobilling.com/downloadv5/linux
2. tar xzvf billphp.tar.gz -C /
maka akan menghasilkan folder /var/www/html/billing
Untuk linux debian biasanya default html di /var/www/
maka pindahlah folder billing ke /var/www degan perintah
mv -rf /var/www/html/billing /var/www/billing
C. Test Billing Dari Client
Misalkan saja alamat billing server 192.168.1.1 coba test dari web browser
http://192.168.1.1/billing
Kalau keluar
It Works!
maka sudah konek, lanjutkan test ke 2
http://192.168.1.1/billing/_opensql.php
Kalau keluar
Query was empty
Berarti database sudah jalan, tinggal install billing php seperti biasa.
D. Install billing php Client
1. download billclientphp5.92.tar.gz di http://www.indobilling.com/downlaodv5/linux
2. tar xzvf billclientphp5.92.tar.gz -C /usr/bin
3. panggil
billclient &
Akan muncul IP dan tombol konek, isikan ip dalam contoh ini 192.168.1.1 (bisa berbeda tergantung server IP)
E. Seting lainnya
Agar bisa shutdown, dan reboot, tambahkan satu baris
debgan mengetikkan perintah:
visudo
%users ALL=(ALL) NOPASSWD: /sbin/poweroff, /sbin/reboot
Kemudian simpan.
Semoga berhasil
Incoming search terms for the article:
billing linux (26),
billing warnet linux (22),
billing warnet php (14),
billing server (13),
billing tidak konek ke server (7),
membuat billing warnet berbasis php (4),
download billinghotspot tar gz (4),
billing server no client (4),
cara setting billing server (3),
billing server tidak konek (3),
billinghotspot tar gz download (2),
billing tidak konek (2),
tutorial membuat billing warnet dengan php (2),
billing warnet tanpaclient (2),
tar xzvf billinghotspot tar gz (2),
billing berbasis php (2),
cara membuat billing warnet dengan php (2),
php billing komputer (2),
cara membuat billing dengan php (2),
membangun billing warnet dengan php (1)
