Computer and Internet

I want to enable dbase on PHP 5.3. And i found website that have information about it.

Environment :
OS : CentOS 5.7 Final
Web Server : httpd-2.2.3-53
PHP : php53-5.3.3-1.el5_6.1
Programming Language : gcc


Download package from php.net

[root@compare] # wget http://pecl.php.net/get/dbase-5.0.1.tgz

Extract package

[root@compare] # tar -zxvf dbase-5.0.1.tgz

Prepare the build environment for a PHP extension and compile

[root@compare] # cd dbase-5.0.1

[root@compare] # phpize

[root@compare] #./configure

[root@compare] # make

[root@compare] # make install

copy dbase.so to http modules

[root@compare] # cp /root/php/dbase-5.0.1/modules/dbase.so /usr/lib64/httpd/modules/

Message error if dbase.so not compatible or not installed correctly

[Wed Oct 26 20:15:28 2011] [error] [client 192.168.1.254] PHP Fatal error: Call to undefined function dbase_open() in /var/www/html/compare/impdbf.php on line 19

That's all

Source : http://www.myee.web.id/index.php/howto.html
Read More..

There are many software that can be use to transfer file. Many people use File Transfer Protocol to transfer file between computers. If you use Operating System Linux, you can use scp.
scp is used for copying file from local to remote host securely. It uses ssh for data transfer and provides the same authentication and same level of security as ssh.
If you want to copy a file from a remote host to the local host:
scp user@remotehost.com:filename /path/local/directory

If you want to copy a file from the local host to a remote host:
scp /path/local/directory user@remotehost.com:filename

If you want to copy a directory from local host to a remote host
scp -r /path/local/directory user@remotehost.com:/path/remote/directory

If you want to copy a directory from remote host to a local host
scp -r user@remotehost.com:/path/remote/directory /path/local/directory

If you want to copy a file from remote host 1 to remote host 2 (copy file between remote host)
scp user@remotehost1.com:/path/remote/host1/filename
user@remotehost2.com:/path/remote/host2/

If you want to use blowfish cipher to encrypt the data being sent:
scp -c blowfish /path/local/directory user@remotehost.com:filename

If you want to compress the file before send:
scp -c blowfish -C /path/local/directory user@remotehost.com:filename
Read More..

Ports Yahoo! Messenger uses!

Yahoo! Messenger services uses a variety of ports. These are list of ports

Chat & Messenger TCP Port 5050: Client Access only
Insider/Room Lists TCP Port 80: Client Access only
File Transfer TCP Port 80: Server Access.

Your ISP may block this port, as its used for web hosting.
You can change port in Messenger, Preferences, File Transfer.
Voice Chat UDP 5000-5010
TCP 5000-5001: Client Access
If UDP Fails, TCP will be used instead, see below.
WebCam TCP Port 5100: Client Access
Super Webcam TCP Port 5100: Server Access
P2P Instant Messages TCP Port 5101: Server Access
PMs between Buddys may not use the Yahoo! Server, but this is not a requirement. Read More..

User management is an important aspect of managing a MySQL Server. This section covers the most common user management features encountered while managing a server.

Creating a New User Account

To create a new user account, first log in as root. Next, use the following command to create the user.

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'some_password';
flush privileges;

This command would give the new user all privileges on all databases and tables. The user could only log in from the host specified by localhost. For the changes to take effect, you must call the flush privileges; command to make the server reread the user table.

The previous command is not something you would generally do. A more reasonable command line might look like this.

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON db.* TO 'username'@'localhost' IDENTIFIED BY 'password';
flush privileges;

This example explicitly identifies the privileges being granted. This is preferable as privileges are limited to only the user and database where access is required. The privileges are only applied to the database 'db' and not all the databases on the sever.

Change a User's Password

If you need to change a users password and nothing else, use the following set of commands.

mysql -u root -p
use mysql;
update user set password=password('new_password') where user='username';
flush privileges;

The password function encrypts the password in the database. Remember to execute flush privileges; so that your changes take effect.

source:http://www.abbeyworkshop.com/howto/lamp/index.html
Read More..

This tip would be useful for those who are either making backup of their remote mysql database or moving their web hosting to their provider.

Here’s how to export mysql DB to SQL file using command-line utility :
mysqldump –user=username –password=1234 –databases your_database –opt –quote-names –complete-insert > example.sql


or you can use this command :

$ mysql -u username -p dbname > database.sql

If the MySQL programs are not in your path, you will need to manually specify the location of the mysqldump program:

$ /usr/local/mysql/bin/mysqldump -u username -p --opt dbname > database.sql

Download the database.sql and keep it in a safe place (CDR, Zip disk, etc).

If you need to restore your database, you can do so like this:

$ mysql -u username -p databasename < database.sql
Read More..