Skip to main content

Posts

Include dbase on PHP 5.3 Centos 5.7

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

SCP How To

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/...

Yahoo Messenger Port

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.

Create User in MYSQL

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...

Backup Mysql Database

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

Optimize Wordpress

Optimize your website is important steps after you made it. If you build your website using wordpress, i found three steps to optimize it. First Step – Optimize 1) Upgrade to latest WordPress release 2) Delete all the unused or unwanted plugins (this is the first reason why you need 10-12 seconds to load your homepage). 3) Clean up your css code using a css compressor like styleneat, cleancss or csstidyonline. 4) Reduce the PHP and database queries. For example, on your header, use absolute URLs (http://www.yourdomain.com/wp-content/themes/example/style.css instead of ). Second Step – Install some plugins After that you can install 6 ‘magic’ plugins: 5) WP Super-Cache (to cache all the dynamic requests as static html files). 6) WP Tuner (to analyze your database and to find slow queries or plugins). 7) WP Smush.it (to reduce image file sizes using Smush.it) 8) WP-DBManager (again, to optimize and repair the database) 9) Disable Revisions and Autosave (every time you change a post you c...

How To Install VB6 on Windows 7

After surfing around the net, I've found very little information regarding installation of VB6 on Windows 7. Most of the information out there is for Vista, and most of it is queries for assistance. You may be wondering why someone would want to utilize VB6 on a shiny new operating system like Windows 7. Or even Vista for that matter. There are about a bazillion legacy applications out there that have to be supported, and people like me who speak VB6 need to have the tools installed on our workstations in order to implement and test updates and such for these legacy applications. It also helps out when I need to squirt out a quick tool for use in my daily work. So without further delay, here is the process that I have used on my Windows 7 machines to install Visual Basic 6. 1. Turn off UAC. 2. Insert Visual Studio 6 CD. 3. Exit from the Autorun setup. 4. Browse to the root folder of the VS6 CD. 5. Right-click SETUP.EXE, select Run As Administrator. 6. On this and ...