Dreamhost add mysql database to different server

Apache Solr MySQL Sample Data Config

http://digitalpbk.com/apachesolr/apache-solr-mysql-sample-data-config Apache Solr MySQL Sample Data Config ApacheSolr is an indexing server from apache. It is written in Java and can be used to make search pages on your website. Most Websites use a MySQL database to store its data and standard MySQL search using SQL or FULLTEXT Searching by MySQL. But with ApacheSolr we can not only search but also improve the search results. Solr recognizes plurals and similar words like read, reading or A-DATA, adata etc. Therefore Solr returns more efficient search results ...

Resolve Net::MySQL Hang problem if the database result has only 1 row or is empty

http://digitalpbk.com/perl/solve-netmysql-hang-problem-if-database-result-has-only-1-row-or-empty Resolve Net::MySQL Hang problem if the database result has only 1 row or is empty Net::MySQL is a simple MySQL perl Client to connect to MySQL servers. But Net::MySQL hangs if your result set is having just one row. Sample Net::MySQL code #!/usr/bin/perl use Net::MySQL; $mysql = Net::MySQL->new( hostname => 'localhost', database => 'db', user => 'user', password => 'password', ); $gid = 1; $mysql->query('SELECT * FROM table ...

SQL Injection: Tutorial Part 1

http://digitalpbk.blogspot.com/2009/06/hacking-sql-injection-tutorial.html . Warning: The following methods may be illegal, given for illustration purpose only. Most dynamic websites use a database server such as SQL Server from Microsoft, MySQL, etc. To demonstrate what SQL injection is, let us see a piece of code that is used as a login script. Most ASP websites use a code like this:user = Request.Form("user")pass = Request.Form("pass")SQL = "SELECT * FROM users WHERE username='" & user & _ "' AND password='" ...

How to change root admin user password in Drupal ?

http://digitalpbk.com/drupal/how-change-drupal-root-user-password How to change root admin user password in Drupal ? In order to reset the root or superadmin password on a drupal system, login into the database by looking at the settings.php. You can use phpMyAdmin or any other MySQL utilities like SQLYog, or MySQL command line. Run the following query to reset the password. UPDATE users SET pass = MD5('password') WHERE uid = 1 The user id of administrator is always 1. Password field in drupal is stored as MD5 of the actual string password. So ...

Timezone: PHP, Shell and Crontab

http://digitalpbk.blogspot.com/2009/05/crontab-server-timezone-php-date.html Timezone: PHP, Shell and Crontab Programming in different timezones can be a headache if not taken care off initially. Codes written to work in one time zone can go wrong when ported to a server that runs on another Timezone. There a few things to take care off when you change from server to server.PHPBy default PHP uses the Timezone that is set in the server or php.ini configuration files. Inorder to make a robust php code that can work in any server environment, it is always a good practice ...

Making subdomains on localhost

http://digitalpbk.blogspot.com/2007/01/making-subdomains-on-localhost.html 127.0.0.1 sub2.localhost127.0.0.1 images.localhost127.0.0.1 www.mysiteonmycomp.comNext we have to assign each of these different URL's to different folders.This is done on the apache conf file. (httpd.conf file situated in apache\conf\ directory)Scroll all the way down the httpd.conf file until you reach about Virtual Hosts.AddNameVirtualHost *:80 #(This line was commented before) ServerName subdomain name.localhost OR yoursite.com DocumentRoot Path to the server root, See examples. Directory ...

An Introduction to PHP

http://digitalpbk.blogspot.com/2007/04/introduction-to-php-part1.html An Introduction to PHP PHP ?PHP stands for Hypertext Preprocessor. Well what is it ? In the world wide web we are familiar with the HTML page. The HTML page is static and does not change. What if we want a page that has some parts common and other parts different according to the browser or user that is visiting the site? Say for an example, a user's profile page. It is wasteful and time consuming to make each user a separate HTML page. Here is where Server side scripting comes in. Thus we ...

Hosting a Site at your Home using Dataone

http://digitalpbk.blogspot.com/2008/07/dataone-hosting-site-my-computer-home.html apache2On the router..Once having done that next step is to open a PORT in the router and forward the port to our PORT 80 on your computer. Port 80 is the default HTTP port. You can open up any port in the router, say 2345.I did it using telnet and the way to open up a port differs from router to router.Most modem hosts a site and runs a server internally at port 80, so you can try http://192.168.1.1or the IP address of the router.It will ask for a username and password.The default username ...

Removing index.php From URL in CodeIgniter

http://digitalpbk.com/code-ignitor/removing-indexphp-url this will be your index.php file, unless you've renamed it to | something else. If you are using mod_rewrite to remove the page set this | variable so that it is blank. | */ $config['index_page'] = ""; .htaccess Does not work If your htaccess does not work on localhost. Goto your server configuration. In case of Apache 2, the conf would be in Installation Directory/conf/httpd.conf. Look for the section Directory of your Document Root of your server # # Possible values ...

Select random rows from a table in MySQL

http://digitalpbk.com/mysql/select-random-rows-table Select random rows from a table in MySQL In order to select a random row from MySQL, we can order the rows by a random number and then pick the first row. SELECT * FROM node ORDER BY rand() limit 1; The above query randomly selects a row from the table node. MySQL Software ...