Asep Andria

Cassandra: Recover SSTable Due To Version Mismatch

2011-11-07T09:15:00.002+07:00

Cassandra 0.7 version shipped with a bug that caused incorrect row-level bloom filters to be generated when compacting sstables generated with earlier versions. This would manifest in IOExceptions during column name-based queries. Cassandra provides "nodetool scrub" to rebuild sstables with correct bloom filters, with no data lost. (If your cluster was never on 0.7.0 or earlier, you don't have to worry about this.) Note that nodetool scrub will snapshot your data files before rebuilding, just in case.

When adding a node to the cluster, the boostrapping process get's stuck when it receives a file which is apparently from an older version. This is the Exception:

java.lang.RuntimeException: Cannot recover SSTable /var/lib/cassandra/data/MYKEYSPACE/UserUpdateStatusWallTimeline-tmp-f-1 due to version mismatch. (current version is g).
at org.apache.cassandra.io.sstable.SSTableWriter.createBuilder(SSTableWriter.java:240)
at org.apache.cassandra.db.compaction.CompactionManager.submitSSTableBuild(CompactionManager.java:1090)
at org.apache.cassandra.streaming.StreamInSession.finished(StreamInSession.java:110)
at org.apache.cassandra.streaming.IncomingStreamReader.readFile(IncomingStreamReader.java:104)
at org.apache.cassandra.streaming.IncomingStreamReader.read(IncomingStreamReader.java:61)
at org.apache.cassandra.net.IncomingTcpConnection.stream(IncomingTcpConnection.java:177)
at org.apache.cassandra.net.IncomingTcpConnection.run(IncomingTcpConnection.java:114)

This is a bash script that will simplify scrubbing your Cassandra data.

#!/bin/sh
# Cassandra: Recover SSTable Due To Version Mismatch
# (by) Asep Andria
# http://www.linkedin.com/in/asepandria

NODETOOL="/usr/local/cassandra/bin/nodetool"
CASSANDRA_HOST="192.168.0.1"
EXEC="$NODETOOL -h$CASSANDRA_HOST scrub "
CASSANDRA_DATA="/data/cassandra/data/MYKEYSPACE"
$EXEC | ls "$CASSANDRA_DATA"/*-f-* | sed 's#^.*/##' | cut -f1 -d'-' | uniq -i -d

How To Recursively Delete .svn Folders

2009-12-15T10:00:00.001+07:00

Today, using versioning system on a software development is a must. This is to avoid the replacement of a file that can occur while the development process.

When using versioning system such as Subversion, the system will automatically create a .svn folder on each folder we have. The bad things come whenever we have to send a project folder to other people. It's not convenient if we send them a project folder with .svn folder in it. Yes, we need to clean the .svn folder.

On a Linux environment, go to your project folder and type the syntax below :

rm -rf `find . -type d -name .svn`

On a Windows environment, please create one batch file for example cleansvn.bat and put the code below to that batch file :

FOR /F "tokens=*" %%G IN ('DIR /B /AD /S *.svn*') DO RMDIR /S /Q "%%G"

Execute your batch file on a Windows command line and give your project folder as a parameter (in this example: d:\master\htdocs\vivanews.com is a project folder which we want to clean from .svn)

D:\>cleansvn.bat d:\master\htdocs\vivanews.com

And voila ... your project folder is clean from .svn files. Hope this help.

Editing HOSTS File on Windows 7

2009-12-02T08:49:00.002+07:00

HOSTS file is a file that contains the mappings of IP addresses to host names. It's used by Microsoft TCP/IP for Windows or TCP/IP for Linux.

If you're a developer or programmer or even an administrator, i'm sure you will often edit this file. You can found this HOSTS file on C:\Windows\System32\drivers\etc\hosts (for Windows XP, Windows 2003 Server, Windows Vista, Windows 7) or on /etc/hosts (for Linux family).

In previous Windows version (Windows XP or 2003 Server), you can change the content of this HOSTS file and simply save your changes without problem. But, if you try to edit this HOSTS file on Windows 7 you will face an error something like this "This is a read-only document".

The solution is simple. If you are using Notepad or EditPlus or another editor application to edit this HOSTS file, make sure that you run the Notepad or EditPlus as an Administrator.

The question now is how to make sure that my editor application is run as administrator?

Ok. This is a sample if you're using Notepad as an editor.

Go to Start -> All Programs -> Accessories. You will see the Notepad icons there. Right-click on Notepad and choose "Run as administrator". Then open the HOSTS file using that Notepad.

And now you can edit your HOSTS file without problem.

How To Permanently Delete Your Facebook Account

2009-05-07T10:41:00.002+07:00

This is the article i've found from Facebook when going to delete my Facebook account.

Ever tried to leave Facebook and found out they only allow you to "deactivate" your account? All your personal data, including photos, interests, friends etc will still be saved indefinitely! You don’t have to be a conspiracist to find this quite fishy (or simply annoying)!

Look further down for instructions on how to get your account permanently deleted.

Maybe you see no reason to leave Facebook yet?
In any case, information about how to close an account should be easily available to all members. Join this group to keep the information handy the day you appreciate your privacy more than invitations to vampire applications and updating long lost “friends” of your life.

- - - - - - - - - - - - - - HOW TO ACHIEVE PERMANENT DELETION - - - - - - - - - - - - - -

Go to this page:
http://www.facebook.com/help/contact.php?show_form=delete_account

Click "Submit" and follow the instructions.

Your account will be deactivated for two weeks, and if you don't log in during that period, your account is permanently deleted.

This method is official and should be complete, i.e. no need to delete individual photos, comments, messages or items from your profile or anywhere else on Facebook!

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Please note that I'm not a part of the Facebook team, and consequently cannot fix anything that's broken. If you are experiencing problems with the link above (or anything else concerning your account) your best bet is to contact facebook directly using this form: http://www.facebook.com/help/contact_generic.php

If someone has stolen your identity or if you are subject to any other form of "account abuse", try this form: http://www.facebook.com/help/contact.php?show_form=fake_profile

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
(Outdated instructions were put in
"Archive: Obsolete ways of account deletion" in the discussion board.)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Strange Behaviour on D-Link DSL-302T ADSL Modem

2008-05-02T07:56:00.002+07:00

In my home (actually my parent in law home) i have two computers connected on LAN using switch. I have an ADSL modem (D-Link DSL-302T) and want to make my two computers connected on the internet. So, i plug a modem RJ 45 to the switch and also each computers.

I configure the IP address like this :

192.168.1.1 (ADSL Modem)
192.168.1.2 (Computer 1)
192.168.1.3 (Computer 2)

and pointing the gateway on each computer to the ADSL modem IP (192.168.1.1)

Logically, this setting have to work. But, in fact i can't browsing to the internet on each computers. I saw the log on the modem that my modem already connected and got WAN IP address.

So, what's wrong here? Ok, i try to solve this problem by changing the TCP/IP address to obtain an IP address automatically.

Check the connection using ping command and restore the TCP/IP address to the default IP address which is 192.168.1.2 and 192.168.1.3.

And, magically now all computers connected to the internet.

How To Change Boot Sequence on Windows XP

2008-05-02T07:41:00.002+07:00

I have to face a situation that needed to have two operating systems installed on my single computer. In my case, i already have installed Windows XP Pro Service Pack 2 English version for a long time ago. And now, the condition force me to have Windows XP Korean version installed.

The new operating system installed successfully. When booting the computer, there are two option of which operating system will be used. The default operating system is a newer operating system installed. But, i need my English version of Windows XP as a default entry for operating system. How to do this?

You can do this by right click My Computer and choose Properties as the image below:

Then go to Advanced tab and on the Startup and Recovery section click Settings button

In here you will face the section called System startup and the list of available Default operating system.

Choose your preferred operating system and then click OK. The previous XP and newer XP operating system will have a same name. This thing can make us confuse. To edit the operating system boot name, click on the Edit button and you will be prompted with the notepad contain the boot information like this

Just change the operating system name with the name preferred, for example like the image below

Save your changes and try to reboot your computer and see the result.

JavaScript Suicide

2008-04-25T16:02:00.001+07:00

Getting busy with a day by day working hours makes me for a long time not involved on writing this blog anymore. I do apologize for this.

In some situation, we might want to run a script (asp, php, c#, jsp, cfm) using browser and then after execute the script the browser closed automatically.

You can simply do this using the JavaScript code below. Put this code at the beginning of your script :

<script>
function doSuicide()
{
opener = self;
top.window.close();
}
</script>

And then put this code at the end of your script :

<script>doSuicide();</script>

How this JavaScript code works?

First, the browser will load all the script till the end of the script. After the browser parsing the code and found the JavaScript function that call doSuicide() function then this will make the browser forced to closed by himself.

This JavaScript code known works on Internet Explorer and Firefox 2+

The field is too small to accept the amount of data you attempted to add

2007-12-10T08:59:00.000+07:00

Like the other developers, the error code print out would make easier to find out the way where we must to debug and fix the problem.

Like the error code below

System.Data.OleDb.OleDbException: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Register.ExecuteCommand(String MyCmd) in d:\Project\fake\UserManagement\Register.aspx.cs:line 60

The error code above represent that our Table Field Size didn't have sufficient Field Size to handle the data longer than the available Field Size.

On Ms. Access database the default length for Text Data Type is 50. The maximum length of a Text Data Type is 255. So, please provide the sufficient Field Size for the data you want to be saved on an Access database.

If the data is longer than 255 it might you need consider to use a Memo field, then you can get a whole lot more characters, but this may be overkill.

Operation must use an updateable query

2007-12-10T08:37:00.000+07:00

It might be sometime you will got this error when working with ASP.NET and Ms. Access database.

System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Register.ExecuteCommand(String MyCmd) in d:\Project\fake\UserManagement\Register.aspx.cs:line 60

The error would be different depending on your ASP.NET code. But the main error will looks similar.
This is very well known problem and may occur under the following circumstances

An ASP.NET worker process (Aspnet_wp.exe) runs under the default ASPNET account.
You do not enable impersonation on that application.
You try to connect to or write to an Access database.

To solve the problem you need to give the permission to ASPNET account. The exact permissions are Modify. Although on Windows Server 2003, it is probably the NETWORK SERVICE account.

Right click on the folder containing the Access database, then choose Properties | Security.
Click "Add".
Click "Advanced" and make sure the "From this location..." entry matches the current box.
Click "Find Now" and you will be presented with a list of user accounts.
Double click the NETWORK SERVICE entry, then click OK.
Select the "Modify" option, then click "Apply".

The image shown below illustrated the process.

Hope this helps.

Reference :
(1) http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

Don't Give Space When Calling MySQL Function

2007-11-27T11:15:00.000+07:00

Dear people ... this might be a simple problem but you can take a whole day to trace where the problem exist if you didn't care about this. I face this problem and get confuse when working with MySQL.

I have the following code and execute well using phpMyAdmin but it's failed (no result set given) when i try to execute directly from my php script.

$strSql = "
SELECT user_password, user_name
FROM user_t
WHERE 1
AND user_id = '" . $_POST['txt_id'] . "'
AND user_password = SHA1 ('" . $_POST['txt_pwd'] . "')" ;

if ( $objRS = mysql_query ($strSql, $objConn) )
{
// Do something here ...
}

As you can see in the bold style of the code above we can see that there is a space between MySQL SHA1 function and the parameter for that function.

After i remove that space then the problem is solved. So, my code now looks like below :

$strSql = "
SELECT user_password, user_name
FROM user_t
WHERE 1
AND user_id = '" . $_POST['txt_id'] . "'
AND user_password = SHA1('" . $_POST['txt_pwd'] . "')" ;

if ( $objRS = mysql_query ($strSql, $objConn) )
{
// Do something here ...
}

So, keep your MySQL function closed with ( without space after function name. Hope this helps.

MySQL Stored Procedure : can't return a result set in the given context

2007-11-21T17:28:00.000+07:00

This problem came when i'm deploying the program and databases to the production server while it's running smooth on my local computer. This is terrible and i have a suspicious if there's something wrong with the MyODBC Connector in the production server. I need to know what version of MyODBC Connector installed on my local computer and on my production server so i can compare it. But how do i know the version of this MyODBC Connector?

Below is my step to find out the version of MyODBC Connector :

Go to Control Panel -> Administrative Tools and choose Data Sources (ODBC).

Click the Add button and scroll to the end of the data source list and you will find out the version of your MyODBC Connector like shown in the image below.

The version of MyODBC Connector on my computer is 3.51.12.00 while the version on production server is 3.51.11.00. The MyODBC Connector version on production server come with the installation of Plesk 8.1.

This why i got the error PROCEDURE db_name.procedure_name can't return a result set in the given context when running MySQL stored procedures on the production server. And after i upgraded the MyODBC Connector to the latest version then the problem is solved.

In the general case, the server did not know if a procedure will return just one result set, or more. So, it has to assume the "worst" case, that several results sets might be returned.

Make sure we are using the latest ODBC version. And don't forget to restarting the server to takes an effect.

The support for the CLIENT_MULTI_RESULTS flag was added in 3.51.12.

How To Check If Processor Type Is 32-bit Or 64-bit

2007-11-21T16:56:00.000+07:00

Sometime when we need to download or install a software, we need to know for what and which processor type that software. In some case we can use the same software for 32 and 64-bit version. But in most cases we need to install a different software for a specific processor type.

For a Windows user you can check the processor type using the following way :

Right click My Computer and choose Properties.
Click the Advanced tab.
Click Environment Variables.
In the System variables find a variable with the name PROCESSOR_ARCHITECTURE. If your PC has a 32-bit processor, this variable will have a value of x86. If it has a 64-bit processor this variable will have a value of x64.

This way is not a real world test for checking the processor type because those variables can be changed by anyone but at least you can use this way.

To check the processor type for another machine or another operating system you can use this link http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=31892 as a reference.

MySQL Stored Procedure Is Gone !

2007-11-21T11:55:00.000+07:00

Hello people ... i face this problem when working with MySQL Server 5.0.45

I've creating a new database on this MySQL Server and create many routines (stored procedure and function). And when i renaming the database name then all my routines related to the database i renamed is gone. All is gone.

I try to find out manually on the MySQL information schema because all the routines of all database is stored there but i find nothing except the other routines for other database. This is terrible and do not let you face the same problem.

So, be careful to backup your MySQL routines (stored procedure and function) before renaming the database name. Hope this helps !

GUI Editor for MySQL 5

2007-09-12T08:57:00.000+07:00

Most of PHP/MySQL programmers will use phpMyAdmin as an administration tools when managing MySQL database. I'm one of them but i get a difficulties when working with MySQL 5 routines (stored procedure and stored function). So, i'm looking an alternate GUI for managing MySQL database.

If you have a difficulties when create/edit/drop stored procedure when working with MySQL 5 then you can try to use GUI Tools from MySQL. You can try to use MySQL GUI Tools from http://dev.mysql.com/downloads/gui-tools/5.0.html

The MySQL GUI Tools Bundle for 5.0 includes the following products :

MySQL Administrator 1.2
MySQL Query Browser 1.2
MySQL Migration Toolkit 1.1

This tools is easier to use. Below is the screen shot of MySQL Administrator when working with stored procedure

How to Get Result Set from MySQL 5 Stored Procedure using Classic ASP

2007-09-12T08:39:00.000+07:00

For developer or programmer that worked on classic ASP, if you want to communicate with MySQL 5 then you need to install MySQL Connector/ODBC from MySQL official site. The MySQL Connector/ODBC is the name for the family of MySQL ODBC drivers (previously called MyODBC drivers) that provide access to a MySQL database using the industry standard Open Database Connectivity (ODBC) API.

You need to specify the correct DRIVER on your database connection string. The source code below is an example of how classic ASP work with MySQL 5 stored procedure.

For a note :

Default PORT for MySQL is 3306. I'm here using 3307 because i'm installed 2 versions of MySQL on my computer that MySQL 4.0.26 on port 3306 and MySQL 5.0.45 on port 3307.

<%@ Language=VBScript%>

<%
Option Explicit

Dim strConn, objConn
Dim strDBHost, strDBPort, strDBUser, strDBPassword, strDBName, blnConnStatus
Dim strSql, objRS
Dim strCustNumber, strInvNumber, strSPCode
Dim strMessage, sServer, sPort, sUser, sPassword

strDBHost = "localhost"
strDBPort = "3307"
strDBUser = "my_db_user"
strDBPassword = "my_db_password"
strDBName = "jmnsms"

strConn = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & strDBHost & ";PORT=" & strDBPort & ";UID=" & strDBUser & ";PWD=" & strDBPassword & ";DATABASE=" & strDBName
blnConnStatus = False

Call OpenDBConn()

Response.Write "<h3>" & strMessage & "</h3>"

If blnConnStatus = False Then

Response.End()

End If

strSql = "CALL jmnsms.MB_SelectInvoice();"

Set objRS = Server.CreateObject("ADODB.Recordset")

objRS.Open strSql, objConn

If objRS.EOF Then

Response.Write "Data Not Found!"

Else

Do While NOT objRS.EOF

strCustNumber = objRS.Fields("cust_number")
strInvNumber = objRS.Fields("inv_number")
strSPCode = objRS.Fields("sp_code")

Response.Write strCustNumber & " -- " & strInvNumber & " -- " & strSPCode & "<br />"

objRS.MoveNext

Loop

End If

objRS.Close
Set objRS = Nothing

Call CloseDBConn()

'
' Procedure to Open Database Connection
'
Sub OpenDBConn()

Err.Clear()
On Error Resume Next

Set objConn = Server.CreateObject("ADODB.Connection")

If Len(Err.Description) <> 0 Then

strMessage = " " & Err.Description & " MySQL connection can't be established!"

Else

objConn.ConnectionTimeout = 120
objConn.Open strConn

If Len(Err.Description) <> 0 Then

strMessage = " " & Err.Description & " MySQL connection can't be established!"

Else

strMessage = " MySQL connection succesfull established!"
blnConnStatus = True

End If

End If

End Sub

'
' Procedure to Close Database Connection
'
Sub CloseDBConn()

objConn.Close
Set objConn = Nothing

End Sub

%>

The stored procedure called MB_SelectInvoice() is look like here

CREATE DEFINER=`root`@`localhost` PROCEDURE `MB_SelectInvoice`()
BEGIN
SELECT * FROM jmnsms.t_invoice;
END

What an IMSI and PLMN is ?

2007-08-07T14:39:00.000+07:00

IMSI

The IMSI (International Mobile Subscriber Identity) is a unique 15-digit code used to identify an individual user on a GSM network.

The IMSI consists of three components:

Mobile Country Code (MCC)
Mobile Network Code (MNC)
Mobile Subscriber Identity Number (MSIN)

The IMSI is stored in the Subscriber Identity Module (SIM).

PLMN

Short for Public Land Mobile Network, a generic term for a mobile wireless network that is centrally operated and administrated by an organization and uses land-based radio frequency transmitters or base stations as network hubs. PLMNs can stand alone and interconnect with one another or connect to a fixed system such as the PSTN.

Cellular phones and mobile Internet access are two common uses of a PLMN.

The log file for database is full. Back up the transaction log for the database to free up some log space.

2007-08-03T17:28:00.000+07:00

Don't panic. This error inform that the log file for your SQL Server database is full. If you're playing with Classic ASP then the error message would be appear like this below:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'YOURDATABASENAME' is full. Back up the transaction log for the database to free up some log space.

To solve this problem simply open Query Analyzer and then run the command below:

BACKUP LOG yourdatabasename WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (yourdatabasename_log,0)
GO

Then, make sure that you have a backup schedule in place to prevent the log file growth from getting out of hand. Backup the database, and then shrink the transaction log to free up log space.

You can setup a new maintenance plan. Go into Enterprise Manager -> Management, right click on Maintenance plan and choose New Maintenance plan.

How to Check MDAC Version

2007-06-07T11:09:00.000+07:00

There are two different ways to check which version of Microsoft Data Access Components (MDAC) is installed on your system
(1) Use the Component Checker tool.
(2) Check the version information that is stored in the registry.

Install and Use the Component Checker Tool

The most reliable way to determine which version of MDAC is installed is to compare the version number of each MDAC DLL file to a list of the DLL files that are shipped with each MDAC version. The Component Checker can help you to do this. It checks the files on the computer, compares them to a list from each version of MDAC, and reports the closest match.

To install Component Checker, follow these steps:
1. Browse to the following Microsoft Web site: http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en
2. Click the link to download Component Checker. When you are prompted by the browser, save Cc.exe (a self-extracting executable file) to the desktop.
3. On the desktop, double-click Cc.exe; this extracts the Component Checker files and installs to the default location, C:\Comcheck.

To use Component Checker to check the MDAC version, follow these steps:
1. From the Start menu, click Run.
2. In the Open text box, type c:\comcheck\comcheck.exe and then click OK.
3. In the Component Checker - Choose Analysis Type dialog box, select Perform Analysis of your machine and automatically determine the release version, and then click OK.
4. The program attempts to identify the MDAC version on your computer by scanning all of the core MDAC files and registry settings. This process normally takes several minutes. When finished, you should receive the following message:

The MDAC version that is closest to the version on your computer is 'XXXX'.

5. Click OK.
6. A summary of the Component Checker scan appears. Note that the Dir, FileDescription, and FileSize errors can be safely ignored.

Check the Version Information Stored in the Registry

Because now Microsoft using a system to check whether you are using Windows Genuine Version or not like the image above, then if you're unable to get the Component Checker tool you can check the MDAC version in the registry. The version information is found in the following key: HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer

To check the registry, follow these steps:
1. On the Start menu, click Run.
2. In the Open text box, type regedit and then click OK; this starts Registry Editor.
3. In the Navigation pane, drill-down to the following path: HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess
4. In the Details pane, look in the Name column for FullInstallVer and Version. Each of these keys will have corresponding version information in the Data column.
5. When finished, click Exit on the Registry menu to close Registry Editor.

An example is shown in the image below

Reference :
(1) http://support.microsoft.com/default.aspx?kbid=301202&product=mdac

Microsoft VBScript runtime error '800a000d' Type mismatch: 'objRegExp.Replace'

2007-05-17T11:19:00.000+07:00

As you can see, the article title describes the error of VBScript runtime. Yes, that's right. This is the runtime error when i'm using classic ASP RegEx function. So, why we get this error ?

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'objRegExp.Replace'

Don't worry, not all error is caused by our mistake on programming code. Sometimes the mistake are come from the NULL value from the database. So, you need to make sure that the value returned from the database is NOT NULL.

Below is the sample of classic ASP RegEx code :

Function stripHTML(strHTML)

'Strips the HTML tags from strHTML
Dim objRegExp, strOutput

'Ensure that strHTML contains something
If Len(strHTML) = 0 Then
stripHTML = strHTML
Exit Function
End If

Set objRegExp = New Regexp

objRegExp.IgnoreCase = True
objRegExp.Global = True
objRegExp.Pattern = "<(.|\n)+?>"

'Replace all HTML tag matches with the empty string
strOutput = objRegExp.Replace(strHTML, " ")

'Replace all <> with < and >
strOutput = Replace(strOutput, "<", "<")
strOutput = Replace(strOutput, ">", ">")

stripHTML = strOutput 'Return the value of strOutput

Set objRegExp = Nothing

End Function

Patching gnokii 0.6.14 for iTegno 3000 GSM Modem

2007-04-13T16:24:00.000+07:00

Hi all. At this time i will share my experience on patching gnokii 0.6.14. Why we need to do a patch for gnokii 0.6.14 ?
Well, somebody are using iTegno 3000 GSM Modem or a device that known as a WAVECOM MODEM. And without using this patch then probably your smsd daemon won't work as expected. So, you still need this patch to make your AT Command working as you expected.

Simply editing file atgen.c (this file located at gnokii-0.6.14\common\phones\atgen.c)

Go to line 563 of your atgen.c file and you will find a code like this image below

Replace that code with the text like this image below

Go to line 1442 of your atgen.c file and you will find a code like this image below

Replace that code with the text like this image below

And all are already done. Please re-install your gnokii installation from the beginning with this new patch. Hope this article helps. Please read my another blog article about gnokii and iTegno 3000 GSM Modem on this site. It might help you too.

Credit Card Verification

2007-04-07T13:48:00.000+07:00

There are two verification system for the credit card. That is AVS and CVM.

1. AVS

AVS stands for Address Verification System. AVS is only available for the U.S. and partially available in four European countries. In the US, AVS checks if the cardholder's address and zip code matches the information at the card-issuing bank. AVS only uses the zip code and numeric portion of the billing street address. There are many reasons why AVS may fail (recent address change, AVS computers down, etc.). If the address verification fails on any level, the merchant may decline the transaction. If the AVS fails for any reason, the merchant should contact the customer for additional information (for example, the name of the issuing bank, the bank's toll-free telephone number, etc.).

The code will tell you whether or not the address given in the order actually matches that of the cardholder. On some system, the AVS code is comprised of three numbers. The first corresponds to the numbers in the street address. The second corresponds to the zip code. And the third is an overall verification of both. For example, an AVS code of YYY means: "yes" the address matches, "yes" the zip code matches and "yes," both the address and zip code match the cardholder's. But an AVS response code of NYZ means "no" the address does not match, "yes" the zip code matches and only the "zip" code matches.

Don't be fooled by YYY response codes. Some crooks have access to the cardholder's address information. Be observant and know what red flags to look for. Pay close attention to: the product ordered and order size; the e-mail address given; the ship-to address and shipping method requested among other things. Be suspicious of sizeable purchases that are being shipped to a different address, especially if express shipping is requested. Pay attention to whether or not the e-mail address given is valid. If the e-mail address is a person's name, check to see if it matches the cardholder's name. These, among other things, are all red flags to look for.

Below is the common AVS response code letters and their meanings :
Letter_ Meaning
Y_____ Exact Match
N_____ Not A Match
A_____ Address Match Only
Z_____ Zip Code Match Only
S_____ Service Not Supported (often for non-US credit cards, get proof from cardholder via fax if possible)
U_____ Address Information Not Available (call cardholder's issuing bank)
X_____ When with "YY" means exact match. Otherwise, "XXU" means address Information Not Available (call cardholder's issuing bank)
R_____ Retry - System Unavailable Or Timed Out
W_____ Zip Code OK
E_____ Error Response For Merchant Service Category Code

2. CVM

CVM stands for Card Verification Methods (VISA = CVV2, MasterCard = CVC2, and American Express = CID use a security code of 3 or 4 extra digits imprinted on the card, but not embedded or encrypted in the magnetic stripe. This verification code does not appear on credit card receipts. Since most fraudulent transactions result from stolen card numbers rather than the actual theft of the card, a customer that supplies this number is much more likely to be in possession of the credit card. VISA claims that the use of AVS with CVV2 validation for card-not-present transactions can reduce chargebacks by as much as 26%.

How To Find The Service Pack Version Installed On SQL Server

2007-04-03T15:08:00.000+07:00

To determine the service pack that's installed on your SQL Server, open Query Analyzer. Connect to your server. Execute the following command:

SELECT @@VERSION
GO

The output of this command will be something like the one pasted below. The first line of the output displays the version number of the server. The last 3 digits (build number) of the version number are used to determine the service pack installed on your SQL Server. In this case 194.

Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Below are the SQL Server version list :

SP Version : 6.00.121
Product___ : SQL Server 6.0

SP Version : 6.00.124
Product___ : SQL Server 6.0

SP Version : 6.00.139
Product___ : SQL Server 6.0

SP Version : 6.00.151
Product___ : SQL Server 6.0

SP Version : 6.50.201
Product___ : SQL Server 6.5 (Hydra)

SP Version : 6.50.213
Product___ : SQL Server 6.5 (Hydra)

SP Version : 6.50.240
Product___ : SQL Server 6.5 (Hydra)

SP Version : 6.50.258
Product___ : SQL Server 6.5 (Hydra)

SP Version : 6.50.281
Product___ : SQL Server 6.5 (Hydra)

SP Version : 6.50.415
Product___ : SQL Server 6.5 (Hydra)

SP Version : 6.50.416
Product___ : SQL Server 6.5 (Hydra)

SP Version : 7.00.623
Product___ : SQL Server 7.0 (Sphinx)

SP Version : 7.00.699
Product___ : SQL Server 7.0 (Sphinx)

SP Version : 7.00.842
Product___ : SQL Server 7.0 (Sphinx)

SP Version : 7.00.961
Product___ : SQL Server 7.0 (Sphinx)

SP Version : 7.00.1063
Product___ : SQL Server 7.0 (Sphinx)

SP Version : 8.00.194
Product___ : SQL Server 2000 (Shiloh)

SP Version : 8.00.384
Product___ : SQL Server 2000 (Shiloh)

SP Version : 8.00.534
Product___ : SQL Server 2000 (Shiloh)

SP Version : 8.00.760
Product___ : SQL Server 2000 (Shiloh)

SP Version : 8.00.2039
Product___ : SQL Server 2000 (Shiloh)

SP Version : 9.00.1399.06
Product___ : SQL Server 2005 (Yukon)

Apart from SELECT @@VERSION, there are other commands too, that show you the build number. Try, sp_server_info and master..xp_msver. In SQL Server 2000, there is a new system function called SERVERPROPERTY, that returns service pack information. Here is an example:

SELECT SERVERPROPERTY('ProductLevel')
GO

Changing SQL Server Passwords

2007-04-03T14:56:00.000+07:00

Most security experts recommendations include changing passwords frequently to enhance security. It is easy to change the password on a SQL Server Username via Query Analyzer. Changing the password with Query Analyzer makes it easy to coordinate changing the password on the database server at the same time as it is changed in the connection string. This approach provides the flexibility to change the password at the most appropriate time for the application.

To change the SQL Server Username password, just connect to the database with Query Analyzer using the SQL Server Username that is being updated and the current password. Then run "sp_password" to change the password.

Here is a simple example that changes the current password from "current_password" to "new_password" :

sp_password 'current_password', 'new_password'

If your first SQL Server installation use a blank password then you need this way to change the SQL Server password :

sp_password NULL, 'new_password'

Be sure to use a strong password, "new_password" is just an example. For a quick test to confirm that the new password is working, close Query Analyzer and then re-connect with the new password. That is all there is to it, except for changing your connections string. It is obvious, but still critical to remember to change the password in your connection string if this SQL Username is used in your code. Once the password has been changed and tested with Query Analyzer, update the connection string with the new password and test that everything still works correctly, and you're done.

Using Server.HTMLEncode on Classic ASP

2007-03-22T19:42:00.000+07:00

If you have an ASP pages that display strings stored in the database fields, you should always process the strings with the Server.HTMLEncode method, otherwise the string won't be displayed correctly in the user's browser if it contains characters that have a special meaning to HTML, such as the quote ("), the less-than (<) and greater-than (>) symbols, the ampersand symbol (&), and any character whose ANSI code is larger than 127.

It is easy to hardcode these things into our ASP script, but if these characters exist in your database, you need to dynamically encode them. To do so, apply the HTMLEncode method to your recordset data before it is sent to the response object:

Response.Write Server.HTMLEncode(rs.Fields("my_field"))

Other examples is:

<%
Dim sLink

sLink = "<a href="'http://www.printerspost.com.au'">Printers Post Australia</a>"

Response.Write "Not HTMLEncoded string: " & sLink & "<br/><br/>"
Response.Write "HTMLEncoded string:" & Server.HTMLEncode(sLink)

%>

DKU-5 vs CA-42 Data Cable

2007-03-19T11:43:00.000+07:00

Hello all, now i want to explain the differences between Nokia DKU-5 and CA-42 data cable. Sometime we are confusing to choose a data cable for our Nokia Phone. There are DKU-5 and CA-42 data cable. I hope this article helping you who are decided to buy a Nokia data cable.

DKU-5

DKU-5 has a chip in it to emulate a serial port through the USB connector. This is for phones without native USB connectivity. DKU-5 is used for models without external memory (6100, 3100, 3120, 3200, 3220, 6610, 7210, 7250, 68xx, 6200, 6220).

CA-42

CA-42 is a replacement cable for DKU-5 cable. Some phones are compatible with both of them, some with just CA-42.

The main differences are three :

The CA-42 cable consumes less power than the DKU-5 when it is idle.
The CA-42 cable is not detected by the PC unless the phone is connected to the other end.
The CA-42 cable can be also used in Operating Systems other than Windows 98/2K/XP, such as Windows CE, Linux and Mac.

Session.LCID (LOCALE ID)

2007-03-15T11:23:00.000+07:00

When we are developing a website using ASP script, sometime we had to format dates, numbers, currency, etc. by ourself. And relying on the version of Windows that was installed on the server, it is not good idea in case you moved sites from say The United States to a United Kingdom provider. With IIS4 and IIS5 (Windows NT4 and Windows 2000 respectively) you only need to set the LOCALE ID (Session.LCID) and everything is done for you. The Session.LCID is a read/write property, meaning you can assign a value to it as well as read its current value.

Session.LCID has session scope, which means you can just add one line of code to your global.asa file and ASP does the rest for you. Just remember that if you assign a new value to the Session.LCID it will override global.asa and will remain until a new value is set or the session is ended.

Below you can see locale id's for the US and the UK as well as how dates are formatted using these locales.

Session.LCID = 1033 'This is the English(United States) format.

Short Date : 3/15/2007
Long Date : Thursday, March 15, 2007
Time : 12:11:02 AM
Currency : $9.95

Session.LCID = 2057 'This is the English(British) format

Short Date : 15/03/2007
Long Date : 15 March 2007
Time : 00:11:02
Currency : Ј10.00

When working with databases, you will want to also set the format of the date field to correspond with the LCID that is being used in the script. You can do this by going into the design view and setting the format to dd/mm/yyyy or the format you are using.

Below is a table of the LCIDs, and the corresponding language that you have available:

LOCALE ID :

LCID____Language
-----------------------------
1078____Afrikaans
1052____Albanian
5121____Arabic(Algeria)
15361___Arabic(Bahrain)
3073____Arabic(Egypt)
2049____Arabic(Iraq)
11265___Arabic(Jordan)
13313___Arabic(Kuwait)
12289___Arabic(Lebanon)
4097____Arabic(Libya)
6145____Arabic(Morocco)
8193____Arabic(Oman)
16385___Arabic(Qatar)
1025____Arabic(Saudi Arabia)
10241___Arabic(Syria)
7169____Arabic(Tunisia)
14337___Arabic(U.A.E.)
9217____Arabic(Yemen)
1069____Basque
1059____Belarusian
1026____Bulgarian
1027____Catalan
3076____Chinese(Hong Kong)
2052____Chinese(PRC)
4100____Chinese(Singapore)
1028____Chinese(Taiwan)
1050____Croatian
1029____Czech
1030____Danish
2067____Dutch(Belgian)
1043____Dutch(Standard)
9_______English
3081____English(Australian)
10249___English(Belize)
2057____English(British)
4105____English(Canadian)
9225____English(Caribbean)
6153____English(Ireland)
8201____English(Jamaica)
5129____English(New Zealand)
7177____English(South Africa)
11273___English(Trinidad)
1033____English(United States)
1061____Estonian
1080____Faeroese
1065____Farsi
1035____Finnish
2060____French(Belgian)
3084____French(Canadian)
5132____French(Luxembourg)
1036____French(Standard)
4108____French(Swiss)
2108____Gaelic(Irish)
1084____Gaelic(Scots)
3079____German(Austrian)
5127____German(Liechtenstein)
4103____German(Luxembourg)
1031____German(Standard)
2055____German(Swiss)
1032____Greek
1037____Hebrew
1081____Hindi
1038____Hungarian
1039____Icelandic
1057____Indonesian
1040____Italian(Standard)
2064____Italian(Swiss)
1041____Japanese
1042____Korean
2066____Korean(Johab)
1062____Latvian
1063____Lithuanian
1071____Macedonian
1086____Malaysian
1082____Maltese
1044____Norwegian(Bokmal)
2068____Norwegian(Nynorsk)
1045____Polish
1046____Portuguese(Brazilian)
2070____Portuguese(Standard)
1047____Rhaeto-Romanic
1048____Romanian
2072____Romanian(Moldavia)
1049____Russian
2073____Russian(Moldavia)
1083____Sami(Lappish)
3098____Serbian(Cyrillic)
2074____Serbian(Latin)
1051____Slovak
1060____Slovenian
1070____Sorbian
11274___Spanish(Argentina)
16394___Spanish(Bolivia)
13322___Spanish(Chile)
9226____Spanish(Colombia)
5130____Spanish(Costa Rica)
7178____Spanish(Dominican Republic)
12298___Spanish(Ecuador)
17418___Spanish(El Salvador)
4106____Spanish(Guatemala)
18442___Spanish(Honduras)
2058____Spanish(Mexican)
19466___Spanish(Nicaragua)
6154____Spanish(Panama)
15370___Spanish(Paraguay)
10250___Spanish(Peru)
20490___Spanish(Puerto Rico)
3082____Spanish,Spain-Modern Sort
1034____Spanish(Spain - Traditional Sort)
14346___Spanish(Uruguay)
8202____Spanish(Venezuela)
1072____Sutu
1053____Swedish
2077____Swedish(Finland)
1054____Thai
1073____Tsonga
1074____Tswana
1055____Turkish
1058____Ukrainian
1056____Urdu
1075____Venda
1066____Vietnamese
1076____Xhosa
1085____Yiddish
1077____Zulu
2048____default

Gnokii : Upgrade From Nokia 5110 To iTegno 3000

2006-12-26T21:52:00.000+07:00

(1) Backup your current ~/.gnokiirc file for Nokia 5110 to the safe place.

(2) Put in SIM Card to the iTegno modem and closed it well.

(3) Put in RS232 iTegno port to the PC and put in the modem Adapter to the electrical power.

(4) Modem will be lightening. Wait for a second and in a second the modem would be flicker and then as simultaneous the modem indikator light would be flickering.

(5) Login as root and extract gnokii-0.6.14.tar.bz2 files to the folder /usr/local/src with this command :

tar xjvf /media/cdrom/gnokii/gnokii-0.6.14.tar.bz2 –C /usr/local/src

(6) Go to the new extracted gnokii source directory gnokii with this command :

cd /usr/local/src/gnokii-0.6.14

(7) Do this step one by one to install new gnokii and have a look if this process successfull or not :

./configure --prefix=/usr/local
make
make install
make install-docs

(8) After step (7) done, copy .gnokiirc file to the root home folder.

cp /media/cdrom/gnokii/.gnokiirc ~/.

For the content of .gnokiirc file, please have a look on my previous article configuring iTegno 3000 with gnokii

(9) You need to make sure that your gnokii version is a new version. Check with this command :

gnokii --version

(10) Now checking the modem to make sure the modem is recognized by gnokii.

gnokii --identify

(11) If the information below shown to you then your modem has been recognized by gnokii.

IMEI : 351621000201970
Manufacturer : WAVECOM MODEM
Model : MULTIBAND 900E 1800
Revision : 543_09gg.Q2406A 1364028 020305 19:10
Serial device: closing device

(12) The next step is installing minicom. Minicom is an important tools to check whether your modem is in the right functional.

dpkg –i /media/cdrom/minicom/minicom_2.1-9_i386.deb

(13) If there's another package then install it simultaneously with that minicom package.

(14) The next step are operating the minicom. First, we need to setup minicom with the right serial baudrate and parity. Type in the linux console like this image below :

(15) Then you will be prompted with a menu like this image below. Choose Serial port setup.

(16) Put in the configuration / setting like this image below. And after all the configuration complete, press or key to exit from that menu.

(17) Choose Exit menu to exit from minicom setting menu.

(18) You will be prompted to the screen where you are able to typing the AT command.

(19) Type AT
Type AT+COPS?

AT+COPS? use this command to get your provider.

Type AT+CNMI?

You need to make sure the value +CNMI: 2,0,0,2,1

If the value is different then you have to set the value with this command :
AT+CNMI=2,0,0,2,1

Save CNMI setting in your modem with this command :
AT&W

Check again whether +CNMI setting already 2,0,0,2,1
AT+CNMI?

(20) After finishing and +CNMI setting is right, press Ctrl-A then Z. Then you will be redirecting to the screen like this below.

(21) Choose Quit with no reset then you will be prompted to the screen :

(22) Choose Yes and you'll taken to linux terminal. Then you need to check if gnokii can sending sms or tidak. Type this command :

echo "sending sms from gnokii " | gnokii --sendsms +6285659969486 -r

(23) If in your SIM Card inbox already a sms, then check with this command below. This command very important to check whether gnokii can read the data from your SIM Card or not. If in this step not working then you must repeat gnokii installation from the beginning. To make sure if in your inbox already a sms or not, please send one sms to your SIM Card in your modem.

gnokii --getsms SM 1

If the final result is :

Received message type 12
GetSMS SM 1 failed! (Command failed.)
Serial device: closing device

Then, there is something wrong with your gnokii source.

(24) If there is no problem then we go to the next step to install smsd. Go to the smsd source directory.

cd /usr/local/src/gnokii-0.6.14/smsd
make
make install

(25) If there is no error then your smsd installation successfully complete. Go ahead to running up the smsd service manually to see the output on your linux console. Then try the application (for example : playsms).

(26) Finish.

Curriculum Vitae

2006-12-22T09:16:00.011+07:00

Personal Information

Name : Asep Andria I.W., ST.
Gender : Male
Email : dataandria [at] yahoo [dot] com
Yahoo! ID : dataandria
Language : English

Work Experience

11 June 2008 - Now : PT. Surya Citra Media Tbk. - A Holding Company of SCTV, Jakarta, Indonesia as a Senior Internet Programmer
21 March 2007 - 26 May 2008 : Printers Post Pty Ltd, Sydney, Australia as a Computers Programmer
November 2006 - 20 March 2007 : Printers Post Pty Ltd, Sydney, Australia as a Computers Programmer (Part Time Employee)
4 April 2005 - 20 March 2007 : Akur Pratama, PT. (a.k.a Yogya Group), Bandung, West Java, Indonesia as a Developer
10 December 2001 - 25 March 2005 : Konsep Dot Net, PT., Bandung, West Java, Indonesia as a Programmer
Year 2001 : www.inidia.com, Bandung, West Java, Indonesia as a Programmer
Year 1999 - 2000 : Dagonet Cyber Café, Bandung, West Java, Indonesia as a Network Administrator
Year 1999 - 2000 : STMIK PMBI Computer Laboratory, Bandung, West Java, Indonesia as a Technical Assistant
Year 1999 : Networking Studio, Bandung, West Java, Indonesia as a Network Administrator
Year 1998 - 1999 : STMIK PMBI Computer Laboratory, Bandung, West Java, Indonesia as a Technical Assistant

Expertise & Technical

1. Programming Language
- PHP
- Classic ASP
- ASP.Net (VB.Net, C#.Net)
- Java/JSP/Servlet
- Python
- HTML, DHTML, CSS & Java Script
- Borland Delphi
- Visual Basic
- Oracle Form Developer

2. Database
- MySQL
- Oracle
- MS SQL Server
- MS Access
- PostgreSQL
- SQLite

3. Reporting Tools
- Oracle Form Report
- Crystal Reports

4. Web/Application Server
- Apache HTTPD
- IIS
- Apache Tomcat

5. Operating System
- Linux
- Microsoft Windows

6. Foreign Language
- English

IT Projects Experience

ERP (Enterprise Resource Planning)

Year : 2002 – 2004
Project Name : Kurnia Mineral – ERP
Client Name : PB. Kurnia (now PT. Kurnia Artha Pratiwi), Padalarang - Indonesia
Description : Build a web based Intranet Application including Sales, Procurement, Inventory, Finance, and Accounting
Technology : Slackware Linux 8.0, PHP, JpGraph, MySQL, Java Script, DHTML
Url : -

ASSET MANAGEMENT

Year : 2005 – 2006
Project Name : PRASS (PPBJ, PO, Receiving, Assets)
Client Name : Akur Pratama, PT. a.k.a Yogya Group, Bandung - Indonesia
Description : Asset Management including User Request Form and Purchase Order
Technology : Fedora Linux Core 2, PHP, Oracle 10g, Java Script
Url : -

FINANCE

Year : 2005
Project Name : A/R (Account Receivable)
Client Name : Konsep Dot Net, PT., Bandung - Indonesia
Description : Provide Data & A/R (Account Receivable) Analysis
Technology : Fedora Linux Core 3, JSP, Servlet, MySQL, Java Script
Url : -

RETAIL SYSTEM

Year : 2006
Project Name : YRS (Yogya Retail System)
Client Name : Akur Pratama, PT. a.k.a Yogya Group, Bandung - Indonesia
Description : Build an Application Integration for Retail System
Technology : Red Hat Enterprise Linux AS 4, Oracle Form Developer, Oracle Form Report, Oracle 10g
Url : -

PURCHASING SYSTEM

Year : 2003
Project Name : Bratatex
Client Name : Bratatex, PT, Bandung - Indonesia
Description : Involve on Analyzing OLAP Application
Technology : ASP, SQL Server, OLAP
Url : -

PRODUCTION & PACKAGING SYSTEM

Year : 2007
Project Name : Production & Packaging System
Client Name : Adira Semesta Industry, PT., Bandung - Indonesia
Description : Production & Packaging System (Software & Hardware)
Technology : PHP, AJAX, JavaScript, MySQL, Delphi, Scanner Control Unit, Remote Terminal Unit
Url : -

CUSTOMER CARE & BILLING SYSTEM

Year : 2008
Project Name : XL Traffic Info Trouble Ticket System
Client Name : PT Excelcomindo Pratama, Tbk., Jakarta - Indonesia
Description : Customer Support application for XL Traffic Info
Technology : Linux, PHP, MySQL, Java Script
Url : -

Year : 2007
Project Name : Tiny CCBS
Client Name : Jogja MediaNet, Yogyakarta - Indonesia
Description : Maintenance and Update Billing System for MediaNet Branch
Technology : Linux, PHP, MySQL, Java Script
Url : -

Year : 2007
Project Name : M2N CCBS
Client Name : Jogja MediaNet, Metro MediaNet, Yogyakarta - Indonesia
Description : Maintenance and Update Customer Care Billing System
Technology : Linux, PHP, MySQL, Java Script
Url : -

Year : 2007 - 2008
Project Name : JMN CCBS
Client Name : Jogja MediaNet, Yogyakarta - Indonesia
Description : Maintenance and Update Customer Care Billing System
Technology : Linux, PHP, MySQL, Java Script
Url : -

Year : 2006
Project Name : Corbec Billing CDR
Client Name : CORBEC Communication, PT., Jakarta - Indonesia
Description : Build a Billing Application based on CDR
Technology : Windows 2000 Server, PHP, MS SQL Server, Java Script
Url : -

SMS GATEWAY

Year : 2006
Project Name : MediaNet Sms Application
Client Name : Jogja MediaNet, Yogyakarta - Indonesia
Description : Build a sms gateway application for an Internet / Data Cable Provider
Technology : Fedora Linux Core 3, PHP, MySQL, Java Script, Gnokii, Nokia 5110, iTegno 3000
Url : -

Year : 2006
Project Name : GBIKA Sms Application
Client Name : GBI Keluarga Allah, Solo - Indonesia
Description : Build a sms gateway application for a church
Technology : Ubuntu Linux 5.10, PHP, MySQL, Java Script, Gnokii, Nokia 5110, iTegno 3000
Url : -

SECURITY & NETWORK CAMERA

Year : 2006
Project Name : GBIKA NCMS Application
Client Name : GBI Keluarga Allah, Solo - Indonesia
Description : Build an intranet network camera management system
Technology : Windows XP SP 2, PHP, MySQL, Java Script, Panasonic WV-NM100, DVR System
Url : -

FAIR VISITOR REGISTRATION

Year : 2004
Project Name : Bandung International Textile 2004
Client Name : Peraga Nusantara Jaya Sakti, PT, Jakarta - Indonesia
Description : Registration & Visitor Statistic (On-Site)
Technology : Windows 2000 Server, PHP, MySQL, Java Script
Url : -

Year : 2003
Project Name : Indonesian Pharmaceutical 2003
Client Name : Peraga Nusantara Jaya Sakti, PT, Jakarta - Indonesia
Description : Registration & Visitor Statistic (On-Site)
Technology : Windows 2000 Server, PHP, MySQL, Java Script
Url : -

Year : 2002
Project Name : Bandung International Textile 2002
Client Name : Peraga Nusantara Jaya Sakti, PT, Jakarta - Indonesia
Description : Build a system that handles a Registration & Visitor Statistics (On-Line, On-Site)
Technology : Windows 2000 Server, PHP, MySQL, Java Script
Url : -

Year : 2002
Project Name : Indonesian Pharmaceutical 2002
Client Name : Peraga Nusantara Jaya Sakti, PT, Jakarta - Indonesia
Description : Build a system that handles a Registration & Visitor Statistics (On-Site)
Technology : Windows 2000 Server, PHP, MySQL, Java Script
Url : -

E-COMMERCE, PORTAL AND CMS (Content Management System)

Year : 2008
Project Name : Avatar
Client Name : Teleakses Solusindo, PT., Bandung - Indonesia
Description : Create Avatar System for mobile telecommunication industry
Technology : PHP, MySQL, Javascript, AJAX, GraphicsMagick, FFMpeg
Url : -

Year : 2008
Project Name : GBIKA Re-Design
Client Name : GBI Keluarga Allah, Solo - Indonesia
Description : Official Site for GBI Keluarga Allah
Technology : PHP, MySQL, Javascript
Url : -

Year : 2007 - 2008
Project Name : Printers Post Auction
Client Name : Printers Post Pty Ltd, Sydney - Australia
Description : Moving system to adopt online auction system
Technology : Classic ASP, MS SQL Server, XHTML 1.0 Strict, CSS 2.0, 508 Accessibility, Javascript
Url : -

Year : 2007
Project Name : MediaNet Wizard
Client Name : Jogja MediaNet, Yogyakarta - Indonesia
Description : Official site, Web Generator, Templating System for MediaNet Services
Technology : PHP, MySQL, Javascript
Url : -

Year : 2007
Project Name : CMYK Directory
Client Name : BooDesign, Sydney - Australia
Description : Website for online printing and publishing directories
Technology : Classic ASP, MySQL Server, XHTML 1.0 Strict, CSS 2.0, 508 Accessibility, Javascript
Url : -

Year : 2007
Project Name : BooDesign Re-Design
Client Name : BooDesign, Sydney - Australia
Description : Company Profile
Technology : Classic ASP, MS SQL Server, XHTML 1.0 Strict, CSS 2.0, 508 Accessibility, Javascript
Url : -

Year : 2007
Project Name : Kodak Online Booking System
Client Name : Kodak Australia
Description : Maintenance & Update Booking System
Technology : .Net Framework 2.0, C#, MS SQL Server
Url : -

Year : 2007
Project Name : Balai Besar Keramik
Client Name : Balai Besar Keramik, Bandung - Indonesia
Description : Website for ceramics and related industry informations
Technology : PHP, MySQL
Url : -

Year : 2006 - 2007
Project Name : Printers Post - New and Used Printing Machines and Graphic Equipment and Services
Client Name : Printers Post Pty Ltd, Sydney - Australia
Description : Maintenance & migrating from an old HTML layout to be XHTML and CSS based layout
Technology : Classic ASP, MS SQL Server, XHTML 1.0 Strict, CSS 2.0, 508 Accessibility, Javascript
Url : -

Year : 2006
Project Name : DEPHAN File Management
Client Name : Departemen Pertahanan Republik Indonesia
Description : Build a File Management Application
Technology : PHP, MySQL, Java Script
Url : -

Year : 2005
Project Name : IT&S Intranet
Client Name : Akur Pratama, PT., Bandung - Indonesia
Description : Provide a professional technology and services to increase corporate user productivity
Technology : Fedora Linux Core 3, PHP, MySQL, Java Script
Url : -

Year : 2005
Project Name : KTA Online
Client Name : Konsorsium Telekomindo Aprotech
Description : Build a CMS (Content Management System)
Technology : PHP, MySQL, Java Script
Url : -

Year : 2004
Project Name : Konsep.NET Company Web
Client Name : Konsep Dot Net, PT. , Bandung - Indonesia
Description : Provide an information about company
Technology : PHP, MySQL, Java Script
Url : -

Year : 2003
Project Name : Pudak Scientific Product Catalogue
Client Name : Pudak Scientific, Bandung - Indonesia
Description : Product Catalogue (Content Management System)
Technology : Fedora Linux Core 3, PHP, MySQL, Java Script
Url : -

Year : 2002
Project Name : online.x-phones.com
Client Name : Konsep Dot Net, PT., Bandung - Indonesia
Description : Build a dynamic web that provide a Hand Phone Sales Online Order (Content Management System)
Technology : PHP, MySQL, Java Script
Url : -

Year : 2002
Project Name : www.textile.web.id
Client Name : Konsep Dot Net, PT, Bandung - Indonesia
Description : Build a dynamic web that provide an Indonesian Textile Portal (Content Management System)
Technology : PHP, MySQL, Java Script
Url : -

Year : 2002
Project Name : Product Catalogue
Client Name : Indosantosa, Bandung - Indonesia
Description : Build a dynamic web that provide a Product Catalogue & Online Order (Content Management System)
Technology : PHP, MySQL, Java Script
Url : -

Year : 2002
Project Name : www.harvest-works.com
Client Name : Harvest Indonesia, Bandung - Indonesia
Description : Build a dynamic web that provide a Product Catalogue & Online Order (Content Management System)
Technology : PHP, MySQL, Java Script
Url : -

Year : 2001
Project Name : www.inidia.com
Client Name : www.inidia.com, Bandung - Indonesia
Description : Build a dynamic web that provide a Statistics & Data Portal (Content Management System)
Technology : PHP, MySQL, Java Script
Url : -

Formal Education

Year 1997 - 2003 : STMIK Dharma Negara (previously known as STMIK PMBI), Bandung, West Java, Indonesia
Year 1994 - 1997 : SMUN 1 Ciamis, West Java, Indonesia
Year 1991 - 1994 : SMPN Buniseuri, Ciamis, West Java, Indonesia
Year 1985 - 1991 : SDN Muktisari, Ciamis, West Java, Indonesia

Non Formal Education

September 1999 : Supporting Windows NT, Networking Studio, Bandung, West Java, Indonesia
August 1999 : Novell Netware, Networking Studio, Bandung, West Java, Indonesia
July 1999 : Using Unix/Linux, Networking Studio, Bandung, West Java, Indonesia
June 1999 : Hardware and Networking, Networking Studio, Bandung, West Java, Indonesia

DNS and DynDNS

2006-12-21T15:13:00.000+07:00

I've installed an ADSL Internet connection on my home. Also i've an Apache web server installed on my PC and i want to publish my own web site over the internet without having to host to any webhosting services.

And now the question is "How to make my own site on my home PC can be accessed by other people out there over the internet ?"

You need a DynDNS. What is DNS ? What is DynDNS ?

The DNS (Domain Name System or Service) is a process that maps hostnames (how humans address servers) to IP addresses (how computers address servers). When you visted www.printerspost.com.au, your computer resolved that hostname as 202.60.65.31. This translation happens every time you access a website, FTP server, or an e-mail.

The Dynamic DNS allows you to alias a dynamic IP address like ADSL Internet connection to a static hostname in any of the domains, allowing your computer to be more easily accessed from various locations on the Internet. The Dynamic DNS service is ideal for a home website, file server, or just to keep a pointer back to your home PC so you can access those important documents while you're at work.

For a more information you can visit http://www.dyndns.com

TIMESTAMP or DATETIME on SQL Server 2000 ?

2006-12-04T10:15:00.000+07:00

Mmm ... when you're working on SQL Server 2000 database and you want to choose a field type between timestamp or datetime, it may this article helping you on thinking about that datatype. Unfortunately you really can't use TIMESTAMP for any type of comparison. Or really for much of anything.

This is the quote from SQL Server Books Online :

The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.

It further states Never use timestamp columns in keys, especially primary keys, because the timestamp value changes every time the row is modified.

It's very strange. The timestamp value changes every time the row is modified. So, it's better if you using a DATETIME or SMALLDATETIME column in this case. DATETIME columns can store dates from January 1st, 1753 through December 31st, 9999 (there's that Y10K problem) and are accurate to roughly 3 milliseconds. They use 8 bytes of storage. SMALLDATETIME columns can store dates from January 1st, 1900 through June 6th, 2079 and are accurate to the minute. SMALLDATETIME columns only use 4 bytes of storage.

You can insert values into DATETIME columns (or SMALLDATETIME) columns by enclosing them in quotes.

INSERT tblSales (salesDate) VALUES ('4/12/2006')

This will insert the date part with the time set to midnight (12:00:00 AM). You can insert the current system date and time using the GETDATE() function:

INSERT tblSales (salesDate) VALUES ( GETDATE() )

Your SELECT statement from above might look something like this:

SELECT * FROM tblSales WHERE salesDate = '2006-12-04'

This will run fine if you are putting dates in with no times. If you are adding times and want all the records for a particular day you can do something like this:

SELECT * FROM tblSales WHERE LEFT ( CONVERT ( varchar, salesDate, 120 ), 10 ) = '2006-12-04'

Using the CONVERT function makes SQL Server very picky about formats though (since that's what CONVERT does).

Auto Increment Primary Key in MS SQL Server

2006-11-25T11:47:00.000+07:00

MySQL database has a great functionality and one of them is auto_increment. How to make a field as an auto_increment field in SQL Server 2000 ?

The key is, set the table field to be an identity column.

You can do this in Enterprise Manager in the Design Table mode or through SQL Query Analyzer. The code below is the SQL sample to create an auto_increment field :

CREATE TABLE trel_user_menu
(
usermenu_id int IDENTITY(1,1)PRIMARY KEY CLUSTERED,
menu_id smallint NOT NULL,
user_nick varchar(16) NOT NULL,
usermenu_status tinyint NOT NULL
)

The 1's following the IDENTITY keyword indicate the SEED number (value for first record in table) and increment property (0 or 1).

Hope this helps.

Possible Reasons for +CMS ERROR: 302

2006-11-03T08:41:00.000+07:00

It's possible if we are working with AT Command we could get the +CMS ERROR: 302. But what circumstances do I get +CMS ERROR: 302?

CMS ERROR 302 means "Operation not allowed".
Possible reasons for this error are :
(1) The service may be unavailable during that time.
(2) Service provider has locked the service.
(3) Corporate lock is active
(4) Module was powered off by +CPOF, CFUN=0, unplug, or Low battery level
(5) Service not correctly loaded
(6) SIM does not support SMSCB

Hope this helps.

Bash Script to Handling gnokii Daemon

2006-11-01T07:38:00.000+07:00

Dear, if we are working with gnokii, sometimes after a few minutes gnokii got hang-up or the sms can not stored (save to the database) or can not send (get from the database and sent it out). So, we must stop the gnokii processed daemon and then start it again. But, i think it's a waste time if we are always stop and start it again. And the worst thing is we didn't know when the gnokii got hang-up. Below is my own bash script to handle this situation.

#!/bin/bash
#
# (c) Asep Andria I.W., ST.
# Email : <asep.andria@gmail.com>
# Mobile : +6285659969486

# ----------------------------------
# Check mysql.sock
# ----------------------------------

MYSQL_SOCK_DIR="/opt/lampp/var/mysql";
MYSQL_SOCK_NAME="mysql.sock";

if [ ! -x "$MYSQL_SOCK_DIR/$MYSQL_SOCK_NAME" ]; then

echo "Can not found $MYSQL_SOCK_NAME in $MYSQL_SOCK_DIR"
echo "Please check if MySQL Server is running or change the location of $MYSQL_SOCK_NAME"
echo "Exiting..."

exit 1

fi

# ----------------------------------
# Linking mysql.sock
# ----------------------------------

MYSQL_SOCK_LINK_DIR="/var/run/mysqld";
MYSQL_SOCK_LINK_NAME="mysqld.sock";

if [ ! -x "$MYSQL_SOCK_LINK_DIR/$MYSQL_SOCK_LINK_NAME" ]; then

echo "Can not found $MYSQL_SOCK_LINK_NAME in $MYSQL_SOCK_LINK_DIR"
echo ""
echo "Trying to linking $MYSQL_SOCK_DIR/$MYSQL_SOCK_NAME to $MYSQL_SOCK_LINK_DIR/$MYSQL_SOCK_LINK_NAME ..."

/bin/ln -s "$MYSQL_SOCK_DIR/$MYSQL_SOCK_NAME" "$MYSQL_SOCK_LINK_DIR/$MYSQL_SOCK_LINK_NAME"

if [ ! -x "$MYSQL_SOCK_LINK_DIR/$MYSQL_SOCK_LINK_NAME" ]; then

echo "Failed to linking $MYSQL_SOCK_DIR/$MYSQL_SOCK_NAME to $MYSQL_SOCK_LINK_DIR/$MYSQL_SOCK_LINK_NAME"

exit 1

else

echo "Success to linking $MYSQL_SOCK_DIR/$MYSQL_SOCK_NAME to $MYSQL_SOCK_LINK_DIR/$MYSQL_SOCK_LINK_NAME"

fi

fi

# ----------------------------------
# gnokii smsd path
# ----------------------------------
SMSD_PATH="/usr/local"

while true
do
killall smsd >/dev/null 2>&1
sleep 3
$SMSD_PATH/sbin/smsd -u usersms -d sms -c localhost -m mysql >/dev/null 2>&1 &
sleep 1m
done

Sometimes the mysql.sock location is differ from the os/machine to other. So, in the script above i tried to find the mysql.sock location. If exist ignore it but if not exist create a link one. We need this mysql.sock because gnokii didn't work if gnokii didn't find the mysql socket. Of course this script useful when you want to combine gnokii with MySql database.

Hope this script giving you a new inspiration.

Web Based SQL Server and MSDE Database Administration Tool

2006-10-30T09:56:00.000+07:00

If you are familiar with MySQL database, of course you are familiar too with phpMyAdmin (a web based MySQL administration tool). So you can manage your MySQL database anywhere over the internet. Now, the question is "Is there a tool for managing SQL Server database over the web?". The answer is Yes. There are several web based tools for managing SQL Server database. Ever you hear about myLittleAdmin?

myLittleAdmin is a web-based SQL Server and MSDE Database administration tool from myLittleTools.net. It is intended to handle the administration of SQL Server and MSDE databases over the WWW. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.

With myLittleAdmin, you will do through a browser almost everything you did before with Enterprise Manager. myLittleAdmin is the best solution to remotely administer SQL Server and MSDE. myLitteAdmin also includes several tools, including a "backup database" wizard, a "restore database" wizard, a "generate INSERT" wizard, an "import CSV file" wizard and much more.

Windows-based Web hosting companies can integrate myLittleAdmin as a part of their hosting product offering. Developers get a fast, easy-to-use administration tool. myLittleAdmin is script based and does not need installation of any component or DLL on your server. You can just put it in a Virtual webserver and start running it instantly.

At last, myLittleAdmin is available in source code format (ASP and VBScript). A lite version is available for free so you can test it in your own production environment.

+CMS ERROR

2006-09-01T09:16:00.000+07:00

If you're developing a sms application with GSM Modem, it may someday you would find a message service error. These are the error codes for +CMS ERROR. Below is an explanation :

Error code : 0-127
Meaning : GSM 04.11 Annex E-2 values

Error code : 128-255
Meaning : GSM 03.40 section 9.2.3.22 values

Error code : 300
Meaning : Phone failure

Error code : 301
Meaning : SMS service of phone reserved

Error code : 302
Meaning : Operation not allowed

Error code : 303
Meaning : Operation not supported

Error code : 304
Meaning : Invalid PDU mode parameter

Error code : 305
Meaning : Invalid text mode parameter

Error code : 310
Meaning : SIM not inserted

Error code : 311
Meaning : SIM PIN necessary

Error code : 312
Meaning : PH-SIM PIN necessary

Error code : 313
Meaning : SIM failure

Error code : 314
Meaning : SIM busy

Error code : 315
Meaning : SIM wrong

Error code : 320
Meaning : Memory failure

Error code : 321
Meaning : Invalid memory index

Error code : 322
Meaning : Memory full

Error code : 330
Meaning : SMSC (message service center) address unknown

Error code : 331
Meaning : No network service

Error code : 332
Meaning : Network timeout

Error code : 500
Meaning : Unknown error

Error code : 512
Meaning : Manufacturer specific

Hope this information helps.

configuring iTegno 3000 with gnokii

2006-08-28T09:41:00.000+07:00

Hi guys, in this time i want to share my experience on configuring iTegno 3000 with Linux.

I have bought a RS232 GSM modem iTegno 3000 from Data Sari Citra.
If you are an Indonesian, you can buy this modem at

EAZY PHONE
ITC Kuningan Lt.3 Blok C.1 No.3A
Ph 021 - 70233445
Fax 021 - 57934788

Below are the product specification :

Product Specification
Size / Weight: 93mm x 64mm x 12mm / 58g
Embedded antenna
GPRS Class 10:
Coding scheme CS1 to CS4
Max. packet-switched data transmission speed: 85.6kbps
Dual band GSM (ETSI GSM Phase 2+):
Class 4 (2W @ 900Mhz)
Class 1 (1W @ 1800Mhz)

After download, configure, make and install gnokii. I'm able to send a sms from gnokii CLI.

You can use this syntax from gnokii CLI for sending a sms :

root@asep-ubuntu:~# gnokii --sendsms +6285659969486

The gnokii identified iTegno 3000 as a Wavecom Modem

root@asep-ubuntu:~# gnokii --identify

GNOKII Version 0.6.10
LOG: debug mask is 0x1
LOG: xdebug mask is 0x1
phone instance config:
model: AT
port_device: /dev/ttyS0
connection_type: 0
init_length: 0
serial_baudrate: 115200
serial_write_usleep: -1
hardware_handshake: 0
require_dcd: 0
smsc_timeout: 100
connect_script:
disconnect_script:
rfcomm_cn: 1
sm_retry: off
Initializing AT capable mobile phone ...
Serial device: opening device /dev/ttyS0
Serial device: setting RTS to high and DTR to high
Message sent: 0x00 / 0x0004
41 54 5a 0d | ATZ
write: [ATZ]
read : [OK]
Message received: 0x00 / 0x0004
02 4f 4b 0d | OK
Received message type 00
Message sent: 0x00 / 0x0005
41 54 45 31 0d | ATE1
write: [ATE1]
read : [OK]
Message received: 0x00 / 0x0004
02 4f 4b 0d | OK
Received message type 00
Message sent: 0x00 / 0x000a
41 54 2b 43 4d 45 45 3d 31 0d | AT+CMEE=1
write: [AT+CMEE=1]
read : [AT+CMEE=1OK]
Message received: 0x00 / 0x0010
02 41 54 2b 43 4d 45 45 3d 31 0d 0d 0a 4f 4b 0d | AT+CMEE=1 OK
Received message type 00
Message sent: 0x06 / 0x0008
41 54 2b 43 47 4d 4d 0d | AT+CGMM
write: [AT+CGMM]
read : [AT+CGMM MULTIBAND 900E 1800 OK]
Message received: 0x06 / 0x0029
02 41 54 2b 43 47 4d 4d 0d 0d 0a 20 4d 55 4c 54 | AT+CGMM MULT
49 42 41 4e 44 20 20 39 30 30 45 20 20 31 38 30 | IBAND 900E 180
30 20 0d 0a 0d 0a 4f 4b 0d | 0 OK
Received message type 06
Message sent: 0x06 / 0x0008
41 54 2b 43 47 4d 49 0d | AT+CGMI
write: [AT+CGMI]
read : [AT+CGMI WAVECOM MODEMOK]
Message received: 0x06 / 0x0020
02 41 54 2b 43 47 4d 49 0d 0d 0a 20 57 41 56 45 | AT+CGMI WAVE
43 4f 4d 20 4d 4f 44 45 4d 0d 0a 0d 0a 4f 4b 0d | COM MODEM OK
Received message type 06
Message sent: 0x61 / 0x0009
41 54 2b 43 53 43 53 3f 0d | AT+CSCS?
write: [AT+CSCS?]
read : [AT+CSCS?+CSCS: "PCCP437"OK]
Message received: 0x61 / 0x0023
02 41 54 2b 43 53 43 53 3f 0d 0d 0a 2b 43 53 43 | AT+CSCS? +CSC
53 3a 20 22 50 43 43 50 34 33 37 22 0d 0a 0d 0a | S: "PCCP437"
4f 4b 0d | OK
Received message type 61
Initialisation completed
Message sent: 0x06 / 0x0008
41 54 2b 43 47 4d 4d 0d | AT+CGMM
write: [AT+CGMM]
read : [AT+CGMM MULTIBAND 900E 1800 OK]
Message received: 0x06 / 0x0029
02 41 54 2b 43 47 4d 4d 0d 0d 0a 20 4d 55 4c 54 | AT+CGMM MULT
49 42 41 4e 44 20 20 39 30 30 45 20 20 31 38 30 | IBAND 900E 180
30 20 0d 0a 0d 0a 4f 4b 0d | 0 OK
Received message type 06
Message sent: 0x06 / 0x0008
41 54 2b 43 47 4d 49 0d | AT+CGMI
write: [AT+CGMI]
read : [AT+CGMI WAVECOM MODEMOK]
Message received: 0x06 / 0x0020
02 41 54 2b 43 47 4d 49 0d 0d 0a 20 57 41 56 45 | AT+CGMI WAVE
43 4f 4d 20 4d 4f 44 45 4d 0d 0a 0d 0a 4f 4b 0d | COM MODEM OK
Received message type 06
Message sent: 0x06 / 0x0008
41 54 2b 43 47 4d 52 0d | AT+CGMR
write: [AT+CGMR]
read : [AT+CGMR543_09gg.Q2406A 1364028 020305 19:10OK]
Message received: 0x06 / 0x0036
02 41 54 2b 43 47 4d 52 0d 0d 0a 35 34 33 5f 30 | AT+CGMR 543_0
39 67 67 2e 51 32 34 30 36 41 20 31 33 36 34 30 | 9gg.Q2406A 13640
32 38 20 30 32 30 33 30 35 20 31 39 3a 31 30 0d | 28 020305 19:10
0a 0d 0a 4f 4b 0d | OK
Received message type 06
Message sent: 0x06 / 0x0008
41 54 2b 43 47 53 4e 0d | AT+CGSN
write: [AT+CGSN]
read : [AT+CGSN351621000201970OK]
Message received: 0x06 / 0x0021
02 41 54 2b 43 47 53 4e 0d 0d 0a 33 35 31 36 32 | AT+CGSN 35162
31 30 30 30 32 30 31 39 37 30 0d 0a 0d 0a 4f 4b | 1000201970 OK
0d |
Received message type 06
IMEI : 123456789012345
Manufacturer : WAVECOM MODEM
Model : MULTIBAND 900E 1800
Revision : 543_09gg.Q2406A 1364028 020305 19:10
Serial device: closing device

Below are a known .gnokiirc configuration that work with iTegno 3000 GSM modem :

[global]
port = /dev/ttyS0
model = AT
initlength = default
connection = serial
use_locking = yes
serial_baudrate = 115200
handshake = software
sm_retry = 1
smsc_timeout = 10

[gnokiid]
bindir = /usr/local/sbin/

[connect_script]
TELEPHONE = 12345678
[disconnect_script]

[logging]

# where to log the debug output (on: stderr, off: /dev/null)
debug = on

# where to log the rlp debug output (on: stderr, off: /dev/null)
rlpdebug = off

# where to log X debug output (on: stderr, off: /dev/null)
xdebug = on

How to Install mod_python on Linux Box

2006-08-09T07:34:00.000+07:00

What is mod_python?

Mod_python is an Apache module that embeds the Python interpreter within the server. With mod_python you can write web-based applications in Python that will run many times faster than traditional CGI and will have access to advanced features such as ability to retain database connections and other data between hits and access to Apache internals. You can get mod_python from www.modpython.org.

(1) Create configuration file and check dependency with this command

./configure --with-apxs=/data/opt/apache/bin/apxs

(2) Then continue with make command

make

(3) To install mod_python you need a root privileges

su

(4) Install mod_python

make install

For a note, if there is a trouble with -DEAPI, then add to Makefile after configuring : EXTRA_CFLAGS = -DEAPI

How to Change a Password on Oracle using SQL*Plus

2006-08-08T13:06:00.000+07:00

Sometimes we need to change an old password to be replaced with a new one. To change your Oracle password using SQL*Plus, use the instructions below :

(1) From the Programs menu, select SQL Plus.

(2) In the window that appears, enter your Oracle username and password in the appropriate spaces. Next to "Host String", enter the Net Service name of the Oracle database.

(3) You should now be in the SQL*Plus command line interface. To change your password, type the command below :

password

(4) You will be prompted for your old password. Then, you will be prompted to enter your new password, and then to retype your new password. If this is successful, SQL*Plus will tell you that your password has been changed.

Passwords must be 6 to 30 characters and begin with an alphabetic character, and can contain only alphanumeric characters and the characters _ , $ , and # .

Listing of Mime Types

2006-08-08T07:04:00.000+07:00

Multipurpose Internet Mail Extensions (MIME) is an Internet Standard for the format of e-mail. The combination of type and subtype is generally called a MIME type, although in modern applications, Internet media type is the favored term, indicating its applicability outside of MIME messages. Below is a listing of Mime Types

Extension__ MIME type
---------------------------------------
.3dm_______ x-world/x-3dmf
.3dmf______ x-world/x-3dmf
.a_________ application/octet-stream
.aab_______ application/x-authorware-bin
.aam_______ application/x-authorware-map
.aas_______ application/x-authorware-seg
.abc_______ text/vnd.abc
.acgi______ text/html
.afl_______ video/animaflex
.ai________ application/postscript
.aif_______ audio/aiff
.aif_______ audio/x-aiff
.aifc______ audio/aiff
.aifc______ audio/x-aiff
.aiff______ audio/aiff
.aiff______ audio/x-aiff
.aim_______ application/x-aim
.aip_______ text/x-audiosoft-intra
.ani_______ application/x-navi-animation
.aos_______ application/x-nokia-9000-communicator-add-on-software
.aps_______ application/mime
.arc_______ application/octet-stream
.arj_______ application/arj
.arj_______ application/octet-stream
.art_______ image/x-jg
.asf_______ video/x-ms-asf
.asm_______ text/x-asm
.asp_______ text/asp
.asx_______ application/x-mplayer2
.asx_______ video/x-ms-asf
.asx_______ video/x-ms-asf-plugin
.au________ audio/basic
.au________ audio/x-au
.avi_______ application/x-troff-msvideo
.avi_______ video/avi
.avi_______ video/msvideo
.avi_______ video/x-msvideo
.avs_______ video/avs-video
.bcpio_____ application/x-bcpio
.bin_______ application/mac-binary
.bin_______ application/macbinary
.bin_______ application/octet-stream
.bin_______ application/x-binary
.bin_______ application/x-macbinary
.bm________ image/bmp
.bmp_______ image/bmp
.bmp_______ image/x-windows-bmp
.boo_______ application/book
.book______ application/book
.boz_______ application/x-bzip2
.bsh_______ application/x-bsh
.bz________ application/x-bzip
.bz2_______ application/x-bzip2
.c_________ text/plain
.c_________ text/x-c
.c++_______ text/plain
.cat_______ application/vnd.ms-pki.seccat
.cc________ text/plain
.cc________ text/x-c
.ccad______ application/clariscad
.cco_______ application/x-cocoa
.cdf_______ application/cdf
.cdf_______ application/x-cdf
.cdf_______ application/x-netcdf
.cer_______ application/pkix-cert
.cer_______ application/x-x509-ca-cert
.cha_______ application/x-chat
.chat______ application/x-chat
.class_____ application/java
.class_____ application/java-byte-code
.class_____ application/x-java-class
.com_______ application/octet-stream
.com_______ text/plain
.conf______ text/plain
.cpio______ application/x-cpio
.cpp_______ text/x-c
.cpt_______ application/mac-compactpro
.cpt_______ application/x-compactpro
.cpt_______ application/x-cpt
.crl_______ application/pkcs-crl
.crl_______ application/pkix-crl
.crt_______ application/pkix-cert
.crt_______ application/x-x509-ca-cert
.crt_______ application/x-x509-user-cert
.csh_______ application/x-csh
.csh_______ text/x-script.csh
.css_______ application/x-pointplus
.css_______ text/css
.cxx_______ text/plain
.dcr_______ application/x-director
.deepv_____ application/x-deepv
.def_______ text/plain
.der_______ application/x-x509-ca-cert
.dif_______ video/x-dv
.dir_______ application/x-director
.dl________ video/dl
.dl________ video/x-dl
.doc_______ application/msword
.dot_______ application/msword
.dp________ application/commonground
.drw_______ application/drafting
.dump______ application/octet-stream
.dv________ video/x-dv
.dvi_______ application/x-dvi
.dwf_______ drawing/x-dwf (old)
.dwf_______ model/vnd.dwf
.dwg_______ application/acad
.dwg_______ image/vnd.dwg
.dwg_______ image/x-dwg
.dxf_______ application/dxf
.dxf_______ image/vnd.dwg
.dxf_______ image/x-dwg
.dxr_______ application/x-director
.el________ text/x-script.elisp
.elc_______ application/x-bytecode.elisp (compiled elisp)
.elc_______ application/x-elc
.env_______ application/x-envoy
.eps_______ application/postscript
.es________ application/x-esrehber
.etx_______ text/x-setext
.evy_______ application/envoy
.evy_______ application/x-envoy
.exe_______ application/octet-stream
.f_________ text/plain
.f_________ text/x-fortran
.f77_______ text/x-fortran
.f90_______ text/plain
.f90_______ text/x-fortran
.fdf_______ application/vnd.fdf
.fif_______ application/fractals
.fif_______ image/fif
.fli_______ video/fli
.fli_______ video/x-fli
.flo_______ image/florian
.flx_______ text/vnd.fmi.flexstor
.fmf_______ video/x-atomic3d-feature
.for_______ text/plain
.for_______ text/x-fortran
.fpx_______ image/vnd.fpx
.fpx_______ image/vnd.net-fpx
.frl_______ application/freeloader
.funk______ audio/make
.g_________ text/plain
.g3________ image/g3fax
.gif_______ image/gif
.gl________ video/gl
.gl________ video/x-gl
.gsd_______ audio/x-gsm
.gsm_______ audio/x-gsm
.gsp_______ application/x-gsp
.gss_______ application/x-gss
.gtar______ application/x-gtar
.gz________ application/x-compressed
.gz________ application/x-gzip
.gzip______ application/x-gzip
.gzip______ multipart/x-gzip
.h_________ text/plain
.h_________ text/x-h
.hdf_______ application/x-hdf
.help______ application/x-helpfile
.hgl_______ application/vnd.hp-hpgl
.hh________ text/plain
.hh________ text/x-h
.hlb_______ text/x-script
.hlp_______ application/hlp
.hlp_______ application/x-helpfile
.hlp_______ application/x-winhelp
.hpg_______ application/vnd
.hp-hpgl
.hpgl______ application/vnd.hp-hpgl
.hqx_______ application/binhex
.hqx_______ application/binhex4
.hqx_______ application/mac-binhex
.hqx_______ application/mac-binhex40
.hqx_______ application/x-binhex40
.hqx_______ application/x-mac-binhex40
.hta_______ application/hta
.htc_______ text/x-component
.htm_______ text/html
.html______ text/html
.htmls_____ text/html
.htt_______ text/webviewhtml
.htx_______ text/html
.ice_______ x-conference/x-cooltalk
.ico_______ image/x-icon
.idc_______ text/plain
.ief_______ image/ief
.iefs______ image/ief
.iges______ application/iges
.iges______ model/iges
.igs_______ application/iges
.igs_______ model/iges
.ima_______ application/x-ima
.imap______ application/x-httpd-imap
.inf_______ application/inf
.ins_______ application/x-internett-signup
.ip________ application/x-ip2
.isu_______ video/x-isvideo
.it________ audio/it
.iv________ application/x-inventor
.ivr_______ i-world/i-vrml
.ivy_______ application/x-livescreen
.jam_______ audio/x-jam
.jav_______ text/plain
.jav_______ text/x-java-source
.java______ text/plain
.java______ text/x-java-source
.jcm_______ application/x-java-commerce
.jfif______ image/jpeg
.jfif______ image/pjpeg.jfif-tbnl_ image/jpeg
.jpe_______ image/jpeg
.jpe_______ image/pjpeg
.jpeg______ image/jpeg
.jpeg______ image/pjpeg
.jpg_______ image/jpeg
.jpg_______ image/pjpeg
.jps_______ image/x-jps
.js________ application/x-javascript
.jut_______ image/jutvision
.kar_______ audio/midi
.kar_______ music/x-karaoke
.ksh_______ application/x-ksh
.ksh_______ text/x-script.ksh
.la________ audio/nspaudio
.la________ audio/x-nspaudio
.lam_______ audio/x-liveaudio
.latex_____ application/x-latex
.lha_______ application/lha
.lha_______ application/octet-stream
.lha_______ application/x-lha
.lhx_______ application/octet-stream
.list______ text/plain
.lma_______ audio/nspaudio
.lma_______ audio/x-nspaudio
.log_______ text/plain
.lsp_______ application/x-lisp
.lsp_______ text/x-script.lisp
.lst_______ text/plain
.lsx_______ text/x-la-asf
.ltx_______ application/x-latex
.lzh_______ application/octet-stream
.lzh_______ application/x-lzh
.lzx_______ application/lzx
.lzx_______ application/octet-stream
.lzx_______ application/x-lzx
.m_________ text/plain
.m_________ text/x-m
.m1v_______ video/mpeg
.m2a_______ audio/mpeg
.m2v_______ video/mpeg
.m3u_______ audio/x-mpequrl
.man_______ application/x-troff-man
.map_______ application/x-navimap
.mar_______ text/plain
.mbd_______ application/mbedlet
.mc$_______ application/x-magic-cap-package-1.0
.mcd_______ application/mcad
.mcd_______ application/x-mathcad
.mcf_______ image/vasa
.mcf_______ text/mcf
.mcp_______ application/netmc
.me________ application/x-troff-me
.mht_______ message/rfc822
.mhtml_____ message/rfc822
.mid_______ application/x-midi
.mid_______ audio/midi
.mid_______ audio/x-mid
.mid_______ audio/x-midi
.mid_______ music/crescendo
.mid_______ x-music/x-midi
.midi______ application/x-midi
.midi______ audio/midi
.midi______ audio/x-mid
.midi______ audio/x-midi
.midi______ music/crescendo
.midi______ x-music/x-midi
.mif_______ application/x-frame
.mif_______ application/x-mif
.mime______ message/rfc822
.mime______ www/mime
.mjf_______ audio/x-vnd.audioexplosion.mjuicemediafile
.mjpg______ video/x-motion-jpeg
.mm________ application/base64
.mm________ application/x-meme
.mme_______ application/base64
.mod_______ audio/mod
.mod_______ audio/x-mod
.moov______ video/quicktime
.mov_______ video/quicktime
.movie_____ video/x-sgi-movie
.mp2_______ audio/mpeg
.mp2_______ audio/x-mpeg
.mp2_______ video/mpeg
.mp2_______ video/x-mpeg
.mp2_______ video/x-mpeq2a
.mp3_______ audio/mpeg3
.mp3_______ audio/x-mpeg-3
.mp3_______ video/mpeg
.mp3_______ video/x-mpeg
.mpa_______ audio/mpeg
.mpa_______ video/mpeg
.mpc_______ application/x-project
.mpe_______ video/mpeg
.mpeg______ video/mpeg
.mpg_______ audio/mpeg
.mpg_______ video/mpeg
.mpga______ audio/mpeg
.mpp_______ application/vnd.ms-project
.mpt_______ application/x-project
.mpv_______ application/x-project
.mpx_______ application/x-project
.mrc_______ application/marc
.ms________ application/x-troff-ms
.mv________ video/x-sgi-movie
.my________ audio/make
.mzz_______ application/x-vnd.audioexplosion.mzz
.nap_______ image/naplps
.naplps____ image/naplps
.nc________ application/x-netcdf
.ncm_______ application/vnd.nokia.configuration-message
.nif_______ image/x-niff
.niff______ image/x-niff
.nix_______ application/x-mix-transfer
.nsc_______ application/x-conference
.nvd_______ application/x-navidoc
.o_________ application/octet-stream
.oda_______ application/oda
.omc_______ application/x-omc
.omcd______ application/x-omcdatamaker
.omcr______ application/x-omcregerator
.p_________ text/x-pascal
.p10_______ application/pkcs10
.p10_______ application/x-pkcs10
.p12_______ application/pkcs-12
.p12_______ application/x-pkcs12
.p7a_______ application/x-pkcs7-signature
.p7c_______ application/pkcs7-mime
.p7c_______ application/x-pkcs7-mime
.p7m_______ application/pkcs7-mime
.p7m_______ application/x-pkcs7-mime
.p7r_______ application/x-pkcs7-certreqresp
.p7s_______ application/pkcs7-signature
.part______ application/pro_eng
.pas_______ text/pascal
.pbm_______ image/x-portable-bitmap
.pcl_______ application/vnd.hp-pcl
.pcl_______ application/x-pcl
.pct_______ image/x-pict
.pcx_______ image/x-pcx
.pdb_______ chemical/x-pdb
.pdf_______ application/pdf
.pfunk_____ audio/make
.pfunk_____ audio/make.my.funk
.pgm_______ image/x-portable-graymap
.pgm_______ image/x-portable-greymap
.pic_______ image/pict
.pict______ image/pict
.pkg_______ application/x-newton-compatible-pkg
.pko_______ application/vnd.ms-pki.pko
.pl________ text/plain
.pl________ text/x-script.perl
.plx_______ application/x-pixclscript
.pm________ image/x-xpixmap
.pm________ text/x-script.perl-module
.pm4_______ application/x-pagemaker
.pm5_______ application/x-pagemaker
.png_______ image/png
.pnm_______ application/x-portable-anymap
.pnm_______ image/x-portable-anymap
.pot_______ application/mspowerpoint
.pot_______ application/vnd.ms-powerpoint
.pov_______ model/x-pov
.ppa_______ application/vnd.ms-powerpoint
.ppm_______ image/x-portable-pixmap
.pps_______ application/mspowerpoint
.pps_______ application/vnd.ms-powerpoint
.ppt_______ application/mspowerpoint
.ppt_______ application/powerpoint
.ppt_______ application/vnd.ms-powerpoint
.ppt_______ application/x-mspowerpoint
.ppz_______ application/mspowerpoint
.pre_______ application/x-freelance
.prt_______ application/pro_eng
.ps________ application/postscript
.psd_______ application/octet-stream
.pvu_______ paleovu/x-pv
.pwz_______ application/vnd.ms-powerpoint
.py________ text/x-script.phyton
.pyc_______ applicaiton/x-bytecode.python
.qcp_______ audio/vnd.qcelp
.qd3_______ x-world/x-3dmf
.qd3d______ x-world/x-3dmf
.qif_______ image/x-quicktime
.qt________ video/quicktime
.qtc_______ video/x-qtc
.qti_______ image/x-quicktime
.qtif______ image/x-quicktime
.ra________ audio/x-pn-realaudio
.ra________ audio/x-pn-realaudio-plugin
.ra________ audio/x-realaudio
.ram_______ audio/x-pn-realaudio
.ras_______ application/x-cmu-raster
.ras_______ image/cmu-raster
.ras_______ image/x-cmu-raster
.rast______ image/cmu-raster
.rexx______ text/x-script.rexx
.rf________ image/vnd.rn-realflash
.rgb_______ image/x-rgb
.rm________ application/vnd.rn-realmedia
.rm________ audio/x-pn-realaudio
.rmi_______ audio/mid
.rmm_______ audio/x-pn-realaudio
.rmp_______ audio/x-pn-realaudio
.rmp_______ audio/x-pn-realaudio-plugin
.rng_______ application/ringing-tones
.rng_______ application/vnd.nokia.ringing-tone
.rnx_______ application/vnd.rn-realplayer
.roff______ application/x-troff
.rp________ image/vnd.rn-realpix
.rpm_______ audio/x-pn-realaudio-plugin
.rt________ text/richtext
.rt________ text/vnd.rn-realtext
.rtf_______ application/rtf
.rtf_______ application/x-rtf
.rtf_______ text/richtext
.rtx_______ application/rtf
.rtx_______ text/richtext
.rv________ video/vnd.rn-realvideo
.s_________ text/x-asm
.s3m_______ audio/s3m
.saveme____ application/octet-stream
.sbk_______ application/x-tbook
.scm_______ application/x-lotusscreencam
.scm_______ text/x-script.guile
.scm_______ text/x-script.scheme
.scm_______ video/x-scm
.sdml______ text/plain
.sdp_______ application/sdp
.sdp_______ application/x-sdp
.sdr_______ application/sounder
.sea_______ application/sea
.sea_______ application/x-sea
.set_______ application/set
.sgm_______ text/sgml
.sgm_______ text/x-sgml
.sgml______ text/sgml
.sgml______ text/x-sgml
.sh________ application/x-bsh
.sh________ application/x-sh
.sh________ application/x-shar
.sh________ text/x-script.sh
.shar______ application/x-bsh
.shar______ application/x-shar
.shtml_____ text/html
.shtml_____ text/x-server-parsed-html
.sid_______ audio/x-psid
.sit_______ application/x-sit
.sit_______ application/x-stuffit
.skd_______ application/x-koan
.skm_______ application/x-koan
.skp_______ application/x-koan
.skt_______ application/x-koan
.sl________ application/x-seelogo
.smi_______ application/smil
.smil______ application/smil
.snd_______ audio/basic
.snd_______ audio/x-adpcm
.sol_______ application/solids
.spc_______ application/x-pkcs7-certificates
.spc_______ text/x-speech
.spl_______ application/futuresplash
.spr_______ application/x-sprite
.sprite____ application/x-sprite
.src_______ application/x-wais-source
.ssi_______ text/x-server-parsed-html
.ssm_______ application/streamingmedia
.sst_______ application/vnd.ms-pki.certstore
.step______ application/step
.stl_______ application/sla
.stl_______ application/vnd.ms-pki.stl
.stl_______ application/x-navistyle
.stp_______ application/step
.sv4cpio___ application/x-sv4cpio
.sv4crc____ application/x-sv4crc
.svf_______ image/vnd.dwg
.svf_______ image/x-dwg
.svr_______ application/x-world
.svr_______ x-world/x-svr
.swf_______ application/x-shockwave-flash
.t_________ application/x-troff
.talk______ text/x-speech
.tar_______ application/x-tar
.tbk_______ application/toolbook
.tbk_______ application/x-tbook
.tcl_______ application/x-tcl
.tcl_______ text/x-script.tcl
.tcsh______ text/x-script.tcsh
.tex_______ application/x-tex
.texi______ application/x-texinfo
.texinfo___ application/x-texinfo
.text______ application/plain
.text______ text/plain
.tgz_______ application/gnutar
.tgz_______ application/x-compressed
.tif_______ image/tiff
.tif_______ image/x-tiff
.tiff______ image/tiff
.tiff______ image/x-tiff
.tr________ application/x-troff
.tsi_______ audio/tsp-audio
.tsp_______ application/dsptype
.tsp_______ audio/tsplayer
.tsv_______ text/tab-separated-values
.turbot____ image/florian
.txt_______ text/plain
.uil_______ text/x-uil
.uni_______ text/uri-list
.unis______ text/uri-list
.unv_______ application/i-deas
.uri_______ text/uri-list
.uris______ text/uri-list
.ustar_____ application/x-ustar
.ustar_____ multipart/x-ustar
.uu________ application/octet-stream
.uu________ text/x-uuencode
.uue_______ text/x-uuencode
.vcd_______ application/x-cdlink
.vcs_______ text/x-vcalendar
.vda_______ application/vda
.vdo_______ video/vdo
.vew_______ application/groupwise
.viv_______ video/vivo
.viv_______ video/vnd.vivo
.vivo______ video/vivo
.vivo______ video/vnd.vivo
.vmd_______ application/vocaltec-media-desc
.vmf_______ application/vocaltec-media-file
.voc_______ audio/voc
.voc_______ audio/x-voc
.vos_______ video/vosaic
.vox_______ audio/voxware
.vqe_______ audio/x-twinvq-plugin
.vqf_______ audio/x-twinvq
.vql_______ audio/x-twinvq-plugin
.vrml______ application/x-vrml
.vrml______ model/vrml
.vrml______ x-world/x-vrml
.vrt_______ x-world/x-vrt
.vsd_______ application/x-visio
.vst_______ application/x-visio
.vsw_______ application/x-visio
.w60_______ application/wordperfect6.0
.w61_______ application/wordperfect6.1
.w6w_______ application/msword
.wav_______ audio/wav
.wav_______ audio/x-wav
.wb1_______ application/x-qpro
.wbmp______ image/vnd.wap.wbmp
.web_______ application/vnd.xara
.wiz_______ application/msword
.wk1_______ application/x-123
.wmf_______ windows/metafile
.wml_______ text/vnd.wap.wml
.wmlc______ application/vnd.wap.wmlc
.wmls______ text/vnd.wap.wmlscript
.wmlsc_____ application/vnd.wap.wmlscriptc
.word______ application/msword
.wp________ application/wordperfect
.wp5_______ application/wordperfect
.wp5_______ application/wordperfect6.0
.wp6_______ application/wordperfect
.wpd_______ application/wordperfect
.wpd_______ application/x-wpwin
.wq1_______ application/x-lotus
.wri_______ application/mswrite
.wri_______ application/x-wri
.wrl_______ application/x-world
.wrl_______ model/vrml
.wrl_______ x-world/x-vrml
.wrz_______ model/vrml
.wrz_______ x-world/x-vrml
.wsc_______ text/scriplet
.wsrc______ application/x-wais-source
.wtk_______ application/x-wintalk
.xbm_______ image/x-xbitmap
.xbm_______ image/x-xbm
.xbm_______ image/xbm
.xdr_______ video/x-amt-demorun
.xgz_______ xgl/drawing
.xif_______ image/vnd.xiff
.xl________ application/excel
.xla_______ application/excel
.xla_______ application/x-excel
.xla_______ application/x-msexcel
.xlb_______ application/excel
.xlb_______ application/vnd.ms-excel
.xlb_______ application/x-excel
.xlc_______ application/excel
.xlc_______ application/vnd.ms-excel
.xlc_______ application/x-excel
.xld_______ application/excel
.xld_______ application/x-excel
.xlk_______ application/excel
.xlk_______ application/x-excel
.xll_______ application/excel
.xll_______ application/vnd.ms-excel
.xll_______ application/x-excel
.xlm_______ application/excel
.xlm_______ application/vnd.ms-excel
.xlm_______ application/x-excel
.xls_______ application/excel
.xls_______ application/vnd.ms-excel
.xls_______ application/x-excel
.xls_______ application/x-msexcel
.xlt_______ application/excel
.xlt_______ application/x-excel
.xlv_______ application/excel
.xlv_______ application/x-excel
.xlw_______ application/excel
.xlw_______ application/vnd.ms-excel
.xlw_______ application/x-excel
.xlw_______ application/x-msexcel
.xm________ audio/xm
.xml_______ application/xml
.xml_______ text/xml
.xmz_______ xgl/movie
.xpix______ application/x-vnd.ls-xpix
.xpm_______ image/x-xpixmap
.xpm_______ image/xpm
.x-png_____ image/png
.xsr_______ video/x-amt-showrun
.xwd_______ image/x-xwd
.xwd_______ image/x-xwindowdump
.xyz_______ chemical/x-pdb
.z_________ application/x-compress
.z_________ application/x-compressed
.zip_______ application/x-compressed
.zip_______ application/x-zip-compressed
.zip_______ application/zip
.zip_______ multipart/x-zip
.zoo_______ application/octet-stream
.zsh_______ text/x-script.zsh

mod_python on Apache

2006-08-07T07:01:00.000+07:00

Python .... hmmm, it's sound like a snake. But what i meant is a programming language. After succeed installing mod_python, i'm trying to add this line below in to the Apache httpd.conf :

LoadModule python_module libexec/mod_python.so
AddHandler python-program .py

Then i'm restarting the Apache web server. After that, i create a file named "test.py" under "pypublish" directory, and the code look like below :

def index():
return "This is only a test."
def peyton():
return "Peyton wrote this."

The problem is, why when i'm calling http://python.intranet/pypublish/test.py in the browser, the code above shown again. It's like that file not known as a python file or look like no handler for that file?

To solve the problem, in the httpd.conf configuration i'm adding the line like this below :

# To load python module:
LoadModule python_module libexec/mod_python.so

# Python Project
<VirtualHost 172.16.3.87:80>
DocumentRoot /data/data/project/learn/python/
ServerName python.intranet
<Directory /data/data/project/learn/python/pypublish>
AddHandler python-program .py
PythonHandler mptest
PythonDebug On
</Directory>
</VirtualHost>

Sorry, i create a new file named "mptest.py" with the content :

from mod_python import apache

def handler(req):
req.send_http_header()
req.write("Hello Toserba Yogya IT&S Developer, welcome to the Python World!")
return apache.OK

And then when it running to the browser with http://python.intranet/pypublish/mptest.py the program running well.

What is the difference between the OCI and ORA extension modules?

2006-08-04T15:58:00.000+07:00

PHP offers two extension modules that can be used to connect to Oracle:

(1) The normal Oracle functions (ORA)
(2) The Oracle Call-Interface functions (OCI)

OCI should be used whenever possible since it is optimized and provides more options. For example, ORA doesn't include support for CLOBs, BLOBs, BFILEs, ROWIDs, etc.

But it doesn't matter what module do you used, the important thing is your project finished on schedule and satisfy your client. How about me? I'm using the ORA module in my Oracle project. I'm not using CLOB or BLOB to save my image or file on the Oracle database but only the path to the image or the file. So, our database not to be burden to handle images or file.

mod_python Installation Error

2006-08-04T15:55:00.000+07:00

Still with Python. At this time i will share my experience while python installation. My wish is, i want to make a web based application based on python. After asking to Uncle Google, if i want to make my wish to be a something real then i must installing mod_python and then load the mod_python module to the Apache.

I've download mod_python 3.1.4. My Apache version is 2.0.54.

But, there are a problem when installing mod_python. The configure work fine. I'm configuring with this syntax below :

./configure --with-apxs=/data/opt/apache2/bin/apxs --with-python=/usr/bin/python2.4

The problem occurs when a make process

The error look like this below :

make[1]: Entering directory
`/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src\
'

Compiling for DSO.

/data/opt/apache2/bin/apxs
-I/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/sr\
c/include
-I/data/opt/apache2/include -I/usr/include/python2.4 -c mod_python.c
_apachemodule.c requestobject.c tableobject.c util.c serverobject.c
connobject.c filterobject.c hlist.c hlistobject.c -lm
/usr/lib/python2.4/config/libpython2.4.a
/data/opt/apache2/build/libtool --silent --mode=compile gcc -prefer-pic
-DAP_HAVE_DESIGNATED_INITIALIZER -DLINUX=2 -D_REENTRANT
-D_XOPEN_SOURCE=500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE -g -O2
-pthread -I/data/opt/apache2/include -I/data/opt/apache2/include
-I/data/opt/apache2/include
-I/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/sr\
c/include
-I/data/opt/apache2/include -I/usr/include/python2.4 -c -o
mod_python.lo mod_python.c && touch mod_python.slo
In file included from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:57:20:
error: Python.h: No such file or directory
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:58:26:
error: structmember.h: No such file or directory
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:76,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:31:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:31:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:32:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:32:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:33:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:33:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:34:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:34:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:37:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:37:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:37:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:38:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/util.h:38:
warning: data definition has no type or storage class
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:78,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:35:
error: syntax error before 'PyObject_HEAD'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:35:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:38:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:38:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:40:
error: syntax error before 'MpHList_Type'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:40:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:44:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:45:
error: syntax error before 'MpHList_Append'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/hlistobject.h:46:
error: syntax error before 'MpHList_Append'
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:79,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:37:
error: syntax error before 'PyObject_VAR_HEAD'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:37:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:40:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:40:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:42:
error: syntax error before 'MpTable_Type'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:42:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:43:
error: syntax error before 'MpTableIter_Type'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:43:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:47:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/tableobject.h:48:
error: syntax error before '*' token
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:80,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:32:
error: syntax error before 'PyObject_HEAD'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:32:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:35:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:35:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:36:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:36:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:38:
error: syntax error before 'MpServer_Type'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:38:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:42:
error: syntax error before '*' token
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:81,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:42:
error: syntax error before 'PyObject_HEAD'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:42:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:44:
error: conflicting types for 'server'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:34:
error: previous declaration of 'server' was here
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:44:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:45:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:45:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:46:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:46:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:47:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:47:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:48:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:48:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:50:
error: syntax error before 'MpConn_Type'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:50:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/connobject.h:54:
error: syntax error before '*' token
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:82,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/_apachemodule.h:31:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/_apachemodule.h:32:
error: syntax error before 'init_apache'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/_apachemodule.h:32:
warning: data definition has no type or storage class
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:83,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:32:
error: syntax error before 'PyObject_HEAD'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:32:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:34:
error: 'request_rec' redeclared as different kind of symbol
/data/opt/apache2/include/httpd.h:662: error: previous declaration of
'request_rec' was here
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:35:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:35:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:36:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:36:
error: conflicting types for 'server'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/serverobject.h:34:
error: previous declaration of 'server' was here
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:36:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:37:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:37:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:38:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:38:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:39:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:39:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:40:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:40:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:41:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:41:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:42:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:42:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:43:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:43:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:44:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:44:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:45:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:45:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:49:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:49:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:53:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:53:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:55:
error: syntax error before 'MpRequest_Type'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:55:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:59:
error: syntax error before '*' token
In file included from
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:84,
from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:32:
error: syntax error before 'PyObject_HEAD'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:32:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:53:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:53:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:55:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:55:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:57:
error: syntax error before 'MpFilter_Type'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:57:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:61:
error: syntax error before '*' token
In file included from mod_python.c:28:
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:115:
error: syntax error before 'PyInterpreterState'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:115:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:116:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:117:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:117:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:142:
error: syntax error before 'request_rec'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:142:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:143:
error: 'server_rec' redeclared as different kind of symbol
/data/opt/apache2/include/httpd.h:658: error: previous declaration of
'server_rec' was here
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:144:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:144:
error: conflicting types for 'handler'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/filterobject.h:50:
error: previous declaration of 'handler' was here
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:144:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:145:
error: conflicting types for 'interpreter'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/requestobject.h:47:
error: previous declaration of 'interpreter' was here
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:146:
error: syntax error before '*' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:146:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:147:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:147:
warning: data definition has no type or storage class
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:152:
error: syntax error before 'requestobject'
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:152:
warning: no semicolon at end of struct or union
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:155:
error: syntax error before '}' token
/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src/\
include/mod_python.h:155:
warning: data definition has no type or storage class
mod_python.c:32: error: syntax error before '*' token
mod_python.c:32: warning: data definition has no type or storage class
mod_python.c:42: error: syntax error before '*' token
mod_python.c:42: error: syntax error before 'server_rec'
mod_python.c: In function 'make_interpreter':
mod_python.c:44: error: 'PyThreadState' undeclared (first use in this
function)
mod_python.c:44: error: (Each undeclared identifier is reported only once
mod_python.c:44: error: for each function it appears in.)
mod_python.c:44: error: 'tstate' undeclared (first use in this function)
mod_python.c:51: error: 'srv' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:76: error: syntax error before '*' token
mod_python.c:76: error: syntax error before '*' token
mod_python.c: In function 'make_obcallback':
mod_python.c:79: error: 'PyObject' undeclared (first use in this function)
mod_python.c:79: error: 'm' undeclared (first use in this function)
mod_python.c:80: error: 'obCallBack' undeclared (first use in this function)
mod_python.c:96: error: 's' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:117: error: syntax error before '*' token
mod_python.c:117: error: syntax error before 'server_rec'
mod_python.c: In function 'get_interpreter':
mod_python.c:119: error: 'PyObject' undeclared (first use in this function)
mod_python.c:119: error: 'p' undeclared (first use in this function)
mod_python.c:120: error: 'PyThreadState' undeclared (first use in this
function)
mod_python.c:120: error: 'tstate' undeclared (first use in this function)
mod_python.c:121: error: 'idata' undeclared (first use in this function)
mod_python.c:123: error: 'name' undeclared (first use in this function)
mod_python.c:136: error: 'PyInterpreterState' undeclared (first use in
this function)
mod_python.c:136: error: 'istate' undeclared (first use in this function)
mod_python.c:136: error: 'srv' undeclared (first use in this function)
mod_python.c:138: error: syntax error before ')' token
mod_python.c:147: error: syntax error before ')' token
mod_python.c: In function 'release_interpreter':
mod_python.c:195: error: 'PyThreadState' undeclared (first use in this
function)
mod_python.c:195: error: 'tstate' undeclared (first use in this function)
mod_python.c: In function 'python_cleanup':
mod_python.c:213: error: 'idata' undeclared (first use in this function)
mod_python.c:215: error: 'ci' undeclared (first use in this function)
mod_python.c:215: error: syntax error before ')' token
mod_python.c:234: error: 'PyObject' undeclared (first use in this function)
mod_python.c:234: error: 'ptype' undeclared (first use in this function)
mod_python.c:235: error: 'pvalue' undeclared (first use in this function)
mod_python.c:236: error: 'ptb' undeclared (first use in this function)
mod_python.c:238: error: 'stype' undeclared (first use in this function)
mod_python.c:239: error: 'svalue' undeclared (first use in this function)
mod_python.c:242: warning: assignment makes pointer from integer without
a cast
mod_python.c: At top level:
mod_python.c:285: error: syntax error before '*' token
mod_python.c: In function 'init_mutexes':
mod_python.c:330: error: 's' undeclared (first use in this function)
mod_python.c:335: error: 'glb' undeclared (first use in this function)
mod_python.c:336: error: 'p' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:400: error: syntax error before '*' token
mod_python.c: In function 'reinit_mutexes':
mod_python.c:404: error: 'glb' undeclared (first use in this function)
mod_python.c:414: error: 'p' undeclared (first use in this function)
mod_python.c:417: error: 's' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:434: error: syntax error before '*' token
mod_python.c: In function 'python_create_global_config':
mod_python.c:436: error: 's' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:464: error: syntax error before 'server_rec'
mod_python.c: In function 'python_init':
mod_python.c:472: error: 's' undeclared (first use in this function)
mod_python.c:480: error: 'p' undeclared (first use in this function)
mod_python.c:508: warning: assignment makes pointer from integer without
a cast
mod_python.c: At top level:
mod_python.c:576: error: syntax error before 'server_rec'
mod_python.c: In function 'python_create_srv_config':
mod_python.c:579: error: 'p' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:795: error: syntax error before '*' token
mod_python.c:795: error: syntax error before '*' token
mod_python.c: In function 'get_request_object':
mod_python.c:797: error: 'req_config' undeclared (first use in this
function)
mod_python.c:798: error: invalid operands to binary *
mod_python.c:801: error: syntax error before ')' token
mod_python.c:801: error: 'req' undeclared (first use in this function)
mod_python.c:833: error: 'Py_BEGIN_ALLOW_THREADS' undeclared (first use
in this function)
mod_python.c:833: error: syntax error before 'ap_add_cgi_vars'
mod_python.c:836: error: 'Py_END_ALLOW_THREADS' undeclared (first use in
this function)
mod_python.c:852: error: 'interp_name' undeclared (first use in this
function)
mod_python.c:853: error: request for member 'interpreter' in something
not a structure or union
mod_python.c:855: error: request for member 'interpreter' in something
not a structure or union
mod_python.c:858: error: request for member 'phase' in something not a
structure or union
mod_python.c:860: error: request for member 'phase' in something not a
structure or union
mod_python.c:862: error: request for member 'phase' in something not a
structure or union
mod_python.c: At top level:
mod_python.c:877: error: syntax error before '*' token
mod_python.c: In function 'select_interp_name':
mod_python.c:882: error: 'conf' undeclared (first use in this function)
mod_python.c:890: error: 'req' undeclared (first use in this function)
mod_python.c:915: error: 'fname' undeclared (first use in this function)
mod_python.c:927: error: 'hle' undeclared (first use in this function)
mod_python.c:937: error: 'con' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:952: error: syntax error before '*' token
mod_python.c: In function 'python_handler':
mod_python.c:955: error: 'PyObject' undeclared (first use in this function)
mod_python.c:955: error: 'resultobject' undeclared (first use in this
function)
mod_python.c:956: error: 'idata' undeclared (first use in this function)
mod_python.c:957: error: invalid operands to binary *
mod_python.c:965: error: 'req_conf' undeclared (first use in this function)
mod_python.c:968: error: 'req' undeclared (first use in this function)
mod_python.c:1000: error: syntax error before ')' token
mod_python.c:1026: error: request for member 'extension' in something
not a structure or union
mod_python.c:1029: error: request for member 'hlo' in something not a
structure or union
mod_python.c:1029: error: syntax error before ')' token
mod_python.c:1033: error: request for member 'hlo' in something not a
structure or union
mod_python.c:1067: warning: passing argument 1 of 'strlen' from
incompatible pointer type
mod_python.c:1067: warning: passing argument 1 of '__builtin_strcmp'
from incompatible pointer type
mod_python.c:1067: warning: passing argument 1 of 'strlen' from
incompatible pointer type
mod_python.c:1067: warning: passing argument 1 of '__builtin_strcmp'
from incompatible pointer type
mod_python.c:1067: warning: passing argument 1 of '__builtin_strcmp'
from incompatible pointer type
mod_python.c:1067: warning: passing argument 1 of '__builtin_strcmp'
from incompatible pointer type
mod_python.c: In function 'python_cleanup_handler':
mod_python.c:1138: error: 'req_config' undeclared (first use in this
function)
mod_python.c:1139: error: 'req' undeclared (first use in this function)
mod_python.c:1139: error: syntax error before ')' token
mod_python.c:1141: error: syntax error before ')' token
mod_python.c:1143: error: syntax error before ')' token
mod_python.c:1148: error: 'idata' undeclared (first use in this function)
mod_python.c:1149: error: invalid operands to binary *
mod_python.c: In function 'python_connection':
mod_python.c:1175: error: 'PyObject' undeclared (first use in this function)
mod_python.c:1175: error: 'resultobject' undeclared (first use in this
function)
mod_python.c:1176: error: 'idata' undeclared (first use in this function)
mod_python.c:1177: error: 'conn_obj' undeclared (first use in this function)
mod_python.c:1206: error: syntax error before ')' token
mod_python.c:1209: error: syntax error before ')' token
mod_python.c: In function 'python_filter':
mod_python.c:1258: error: 'PyObject' undeclared (first use in this function)
mod_python.c:1258: error: 'resultobject' undeclared (first use in this
function)
mod_python.c:1259: error: 'idata' undeclared (first use in this function)
mod_python.c:1260: error: invalid operands to binary *
mod_python.c:1263: error: 'req' undeclared (first use in this function)
mod_python.c:1264: error: 'filter' undeclared (first use in this function)
mod_python.c:1313: error: syntax error before ')' token
mod_python.c: In function 'directive_PythonOptimize':
mod_python.c:1548: error: 'Py_OptimizeFlag' undeclared (first use in
this function)
mod_python.c: In function 'python_finalize':
mod_python.c:1705: error: 'idata' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1728: error: syntax error before 'server_rec'
mod_python.c: In function 'PythonChildInitHandler':
mod_python.c:1733: error: 's' undeclared (first use in this function)
mod_python.c:1751: error: 'p' undeclared (first use in this function)
mod_python.c:1775: error: 'idata' undeclared (first use in this function)
mod_python.c:1789: error: 'PyObject' undeclared (first use in this function)
mod_python.c:1789: error: 'globals' undeclared (first use in this function)
mod_python.c:1789: error: 'locals' undeclared (first use in this function)
mod_python.c:1789: error: 'newpath' undeclared (first use in this function)
mod_python.c:1789: error: 'sys' undeclared (first use in this function)
mod_python.c:1799: error: 'Py_eval_input' undeclared (first use in this
function)
mod_python.c: At top level:
mod_python.c:1838: error: syntax error before '*' token
mod_python.c: In function 'PythonAccessHandler':
mod_python.c:1839: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1841: error: syntax error before '*' token
mod_python.c: In function 'PythonAuthenHandler':
mod_python.c:1842: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1844: error: syntax error before '*' token
mod_python.c: In function 'PythonAuthzHandler':
mod_python.c:1845: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1847: error: syntax error before '*' token
mod_python.c: In function 'PythonFixupHandler':
mod_python.c:1848: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1850: error: syntax error before '*' token
mod_python.c: In function 'PythonHandler':
mod_python.c:1857: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1863: error: syntax error before '*' token
mod_python.c: In function 'PythonHeaderParserHandler':
mod_python.c:1867: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1874: error: syntax error before '*' token
mod_python.c: In function 'PythonLogHandler':
mod_python.c:1875: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1877: error: syntax error before '*' token
mod_python.c: In function 'PythonPostReadRequestHandler':
mod_python.c:1881: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1888: error: syntax error before '*' token
mod_python.c: In function 'PythonTransHandler':
mod_python.c:1889: error: 'req' undeclared (first use in this function)
mod_python.c: At top level:
mod_python.c:1891: error: syntax error before '*' token
mod_python.c: In function 'PythonTypeHandler':
mod_python.c:1892: error: 'req' undeclared (first use in this function)
apxs:Error: Command failed with rc=65536
.
make[1]: *** [mod_python.so] Error 1
make[1]: Leaving directory
`/data/data/software/script_engine/python/MODULE/mod_python/mod_python-3.1.4/src\
'
make: *** [do_dso] Error 2

Why this is happen? It's happen because i'm not yet installing the python development package. After installing python2.4-dev now mod_python installed successfully. Thank you to Dody Suria Wijaya and Mico Siahaan for helping me on solve the problem.

How to get a MAC Address from an IP

2006-08-04T07:31:00.000+07:00

Sometimes we need an information about MAC Address from an IP. How to do that? You can use arp command on both Windows and Linux area.

On Windows, only type arp -a IP_ADDRESS. For example :

C:\Documents and Settings\Administrator>arp -a 172.16.3.157

And the DOS prompt would echoing something like this

Interface: 172.16.3.87 --- 0x2
Internet Address Physical Address Type
172.16.3.157 00-11-09-97-ac-66 dynamic

On Linux, you can type arp IP_ADDRESS. For example :

[root@ppbj upload]# arp 172.16.3.157

And the terminal would echoing something like this

Address HWtype HWaddress Flags Mask Iface
172.16.3.157 ether 00:11:09:97:AC:66 C eth0

For a note, if there are no information after typing the command above, please try to ping the destination IP first. For example :

ping 172.16.3.157

Python AttributeError: 'Cursor' object has no attribute 'insert_id'

2006-08-04T07:12:00.000+07:00

Hello guys. At this time, i would share my previous experience and still about python.

I've a database table named "test" with the structure below :

+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | tinyint(4) | | PRI | NULL | auto_increment |
| nama | varchar(30) | YES | | NULL | |
+-------+-------------+------+-----+---------+----------------+

And below is my python script :

#!/usr/bin/python

# import MySQL module
import MySQLdb

# get user input
name = raw_input("Please enter a name: ")

# connect
db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody", db="qestar", unix_socket="/tmp/mysql.sock")

# create a cursor
cursor = db.cursor()

# execute SQL statement
cursor.execute("INSERT INTO test (nama) VALUES (%s)", name)

# get ID of last inserted record
print "ID of inserted record is ", int(cursor.insert_id())

For a note, the data successfully inserted to the database, but when i wanna get the last inserted record there are an error like this below :

ID of inserted record is
Traceback (most recent call last):
File "./mysql_06.py", line 19, in ?
print "ID of inserted record is ", int(cursor.insert_id())
AttributeError: 'Cursor' object has no attribute 'insert_id'

Why i got an error like that? Is that the attribute calling name changed and not insert_id() any more ???
Ok, i would explaining to you.

To get the last inserted record on MySQL with python use cursor.lastrowid
So, the python source code would be like this :

#!/usr/bin/python

# import MySQL module
import MySQLdb

# get user input
name = raw_input("Please enter a name: ")

# connect
db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody", db="qestar", unix_socket="/tmp/mysql.sock")

# create a cursor
cursor = db.cursor()

# execute SQL statement
cursor.execute("INSERT INTO test (nama) VALUES (%s)", name)

# get ID of last inserted record
print "ID of inserted record is ", int(cursor.lastrowid)

Thank you to Mico Siahaan for helping me on solve the problem.

Yahoo! Mail Bug

2006-08-03T16:23:00.000+07:00

Is this Yahoo! Mail bug?

Look in to the picture. Find what kind of bug on there. You'll look if "There are no messages in your Bulk folder." but why in left menu written "Bulk (10) [Empty]" ???

I hope the yahoo mail developer's correct this problem as soon as possible. The picture taked on August 3rd, 2006.

Python can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock

2006-08-03T06:59:00.000+07:00

A few months ago, when i am trying on learning python, i found a problem on connection between python and MySQL database. I got an error code like this below

Traceback (most recent call last):
File "./mysql_01.py", line 7, in ?
db = MySQLdb.connect(host="localhost", user="nobody",
passwd="nobody", db="qestar")
File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 66,
in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line
134, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL
server through socket '/var/run/mysqld/mysqld.sock' (2)")

For a note :
(1) MySQL Server had been activated, running, and when i am trying to get on the database via MySQL command shell with that user and password it's success.
(2) I've test using the other application that made with php using the same user and password and then no problem.
(3) python2.4-mysqldb package had been installed

My previous python source code look like this below

#!/usr/bin/python

# import MySQL module
import MySQLdb

# connect
db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody", db="qestar")

# create a cursor
cursor = db.cursor()

# execute SQL statement
cursor.execute("SELECT * FROM t_member_transaction")

# get the resultset as a tuple
result = cursor.fetchall()

# iterate through resultset
for record in result:
print record[0] , "-->", record[1]

When i'am using IDLE it's the same result:

IDLE 1.1.2
>>> import MySQLdb
>>> db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody", db="qestar")

Traceback (most recent call last):
File "", line 1, in -toplevel-
db = MySQLdb.connect(host="localhost", user="nobody",
passwd="nobody", db="qestar")
File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 66,
in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line
134, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2002, "Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (2)")
>>>

So, is there any clue to explain this? Ok. I'll try to explain.

If we are looking on this :
_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL
server through socket '/var/run/mysqld/mysqld.sock' (2)")

It's mean that MySQLdb module in Linux, if connecting to MySQL Server in the same computer, it's look like using "unix socket" instead of 127.0.0.1 tcp stack. I think this is for efficiency and speed. "address" on unix socket usually placed base on file, so the other process who need connect can read and know. Of course in the assume that the file address is in the same place.

It may MySQLdb didn't find it on "/var/run/mysqld/mysqld.sock". This can be happen if we are compiling MySQL our self or MySQLdb compiled with include file mysql whereas did not same as the MySQL server running. If it's the problem you can passing parameter "unix_socket" to the connection:

db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody", db="qestar", unix_socket="/var/lib/mysql/mysql.sock")

Read my previous article about Where is my MySQL socket? So, the source code would be look like this below.

#!/usr/bin/python

# import MySQL module
import MySQLdb

# connect
db = MySQLdb.connect(host="localhost", user="nobody", passwd="nobody", db="qestar", unix_socket="/tmp/mysql.sock")

# create a cursor
cursor = db.cursor()

# execute SQL statement
cursor.execute("SELECT * FROM t_member_transaction")

# get the resultset as a tuple
result = cursor.fetchall()

# iterate through resultset
for record in result:
print record[0] , "-->", record[1]

Thank you to Dody Suria Wijaya for helping me on solving the problem. Happy python coding. Cheers.

Where is my MySQL socket?

2006-08-02T07:10:00.000+07:00

As a default, MySQL socket would be placed on /var/run/mysqld/mysqld.sock. But, sometimes on some installer MySQL would be placed on a different location. So, how do exactly we know where is our MySQL socket?

(1) Go to the MySQL\bin directory
(2) Type this command below

[root@web ~]# mysqladmin variables | grep socket

Then the mysqladmin would echoing something like this below

| socket | /var/lib/mysql/mysql.sock |

It's mean that your MySQL socket located on /var/lib/mysql/mysql.sock

Or, if you want to echoing all MySQL variables then type

[root@web ~]# mysqladmin variables

Then the mysqladmin would echoing something like this below

+---------------------------------+--------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 32768 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | YES |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | YES |
| have_ndbcluster | NO |
| have_openssl | YES |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 1024 |
| pid_file | /var/run/mysqld/mysqld.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sql_notes | ON |
| sql_warnings | ON |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | WIT |
| table_cache | 64 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.12 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 13, 2005) |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | redhat-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+--------------------------------------------------------+

AT commands to operate GSM modems

2006-08-01T07:13:00.000+07:00

It may some AT commands below useful for you on operating GSM modems.

Enter PIN
AT+CPIN="<pin>"

Enter PUK
AT+CPIN="<puk>","<new pin>"

PIN state
AT+CPIN?

Register network
AT+CREG?
("0,1" means logged in and "0,2" means logged out)

Show network
AT+COPS?

Show signal strength
AT+CSQ?
(somewhere between 0 and 31.99)

Data call
ATD912555666

Voice call
ATD912555666;

Enter SMS center
AT+CSCA="+351912333444"

Set to text mode and send SMS
AT+CMGF=1
AT+CMGS="+351912555666"
Please call office^Z

Preferred message service
AT+CPMS?
(+CPMS: <mem1>,<used1>,<total1>,<mem2>,<used2>,<total2>,...)

Select SIM card messages
AT+CPMS="SM","SM","SM"

Select memory messages
AT+CPMS="ME","ME","ME"

Read SMS on memory number n
AT+CMGR=<n>

Delete SMS on memory number n
AT+CMGD=<n>

How to count a string length on Oracle

2006-08-01T07:05:00.000+07:00

To count a string length on Oracle, simply using LENGTH function. For an example :

Select LENGTH('Live Oracle') From Dual;

Then the Oracle would produce a return 11

Who's IP?

2006-07-31T07:25:00.000+07:00

If we are working on a network, then how do we know the owner of the IP Address? We can using nbtstat command (if you are Windows user) to get the information about that IP. Only type this command below on your DOS prompt

nbtstat -A 172.16.3.157

And then the DOS prompt would echoing the information you entered. For example it look like this below :

Local Area Connection:
Node IpAddress: [172.16.3.87] Scope Id: []

NetBIOS Remote Machine Name Table

Name Type Status
---------------------------------------------
GIA <00> UNIQUE Registered
MIS <00> GROUP Registered
GIA <20> UNIQUE Registered
MIS <1e> GROUP Registered

MAC Address = 00-11-09-97-AC-66

It describes that the owner of this IP Address is GIA and as a member of MIS workgroup/domain.

How many hops to get your site?

2006-07-31T07:16:00.000+07:00

Sometimes if we are going to a website, it takes a long time until the page is being loaded.
Why does this happen? It's a many reason to explain this. I'll describe one. The hops. Yes, the hops.

More and more a hops you get, more and more a time to take.
If you are a Windows users you can using tracert command and if you are a Linux users you can using traceroute command.

Type this command below on your DOS prompt :

tracert asepandria.blogspot.com

or on your Linux terminal type :

traceroute asepandria.blogspot.com

And then the DOS prompt or Linux terminal would echoing the hops of your destination site. For example, it would echoing something like this :

Tracing route to blogspot.blogger.com [66.102.15.101]
over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms 172.16.1.3
2 <1 ms <1 ms <1 ms ws2.yogya-ho.melsa.net.id [202.138.229.195]
3 10 ms 7 ms 10 ms fe3-1-gw3-bdg.melsa.net.id [202.138.237.129]
4 16 ms 13 ms 7 ms fe0-3-gw-bdg.melsa.net.id [202.138.225.81]
5 74 ms 16 ms 64 ms fe1-1-gw-jkt.melsa.net.id [202.138.225.26]
6 * 91 ms 112 ms ip-240049 [202.93.240.49]
7 98 ms * 17 ms 202.93.240.18
8 44 ms 57 ms 29 ms 202.152.164.185
9 18 ms 22 ms 96 ms 202.93.46.189
10 * * * Request timed out.
11 304 ms 324 ms 230 ms 12.118.124.89
12 291 ms 279 ms 335 ms tbr1-p012101.la2ca.ip.att.net [12.122.2.250]
13 235 ms 312 ms 391 ms ggr2-p310.la2ca.ip.att.net [12.123.222.25]
14 374 ms 249 ms 269 ms so-8-1.car4.LosAngeles1.Level3.net [4.68.127.133]
15 241 ms 302 ms 266 ms ae-2-56.bbr2.LosAngeles1.Level3.net [4.68.102.161]
16 229 ms 313 ms 280 ms as-2-0.bbr2.SanJose1.Level3.net [4.68.128.157]
17 308 ms 306 ms 237 ms ae-22-52.car2.SanJose1.Level3.net [4.68.123.48]
18 251 ms 278 ms 403 ms unknown.Level3.net [209.247.202.218]
19 267 ms 234 ms 254 ms 66.249.94.227
20 346 ms 288 ms 242 ms 72.14.233.123
21 287 ms 237 ms 248 ms 66.102.15.101

Trace complete.

How to remove mysqld as a Windows service

2006-07-28T07:38:00.000+07:00

(1) Go to the bin directory of your MySQL

cd C:\mysql\bin

(2) Type this command to remove mysqld as a windows service

mysqld --remove MySQL-4.0.26

(3) Done.

How to make mysqld as a Windows service

2006-07-28T07:37:00.000+07:00

For a new MySQL 4.1 / MySQL 5.0 and up, if we are installing the database then mysqld would automatically installed as a windows service. But, if we are using MySQL 4.0 then we must manually installing mysqld as a windows service. How to do that ?

(1) Install your MySQL 4.0 database on your computer. For example on C:\mysql directory
(2) Choose your MySQL configuration file (my-huge.cnf, my-innodb-heavy-4G, my-large, my-medium, my-small)
(3) Copy your selected MySQL configuration file to C:\ and rename that configuration file with a new name

ren my-huge.cnf my-4.0.26.cnf

(4) Go to the bin directory of your MySQL

cd C:\mysql\bin

(5) Type this command to install mysqld as a windows service

mysqld --install MySQL-4.0.26 --defaults-file=C:\my-4.0.26.cnf

(6) Done. If you want your mysqld automatically running every your computer starting up then you must go to the Start -> Control Panel -> Administrative Tools -> Services

(7) Right click your MySQL service name on services list and choose Properties
(8) Choose Startup type: Automatic
(9) Click OK and your mysqld would automatically running every your computer starting up.

Ever you hear about gnokii?

2006-07-28T07:04:00.000+07:00

gnokii is an open source project. gnokii provides tools and a user space driver for use with mobile phones under Linux, various unices and Win32. With gnokii you can do such things as make data calls, update your address book, change calendar entires, send and receive SMS messages and load ring tones depending on the phone you have.

If you need a more information, please feel free to go to gnokii official site on http://www.gnokii.org/
If you need gnokii Wiki, please go to http://wiki.gnokii.org/
If you want to join to the mailing list, please go to gnokii-users@nongnu.org or http://lists.nongnu.org/mailman/listinfo/gnokii-users

Me, my friends Pawel Kot, Borbely Zoltan, and others gnokii users would like to help you on using gnokii for your mobile phones.

How to interact Apache-Tomcat with Apache-HTTP server

2006-07-27T07:37:00.000+07:00

As a default, we can accessing Apache-Tomcat web server on port 8080. But, in a production server, Apache-Tomcat must be accessed on port 80.

Below are step-by-step to do that.

(1) Download mod_jk2.so from http://apache.cbn.net.id/tomcat/tomcat-connectors/jk2/binaries/ unzip and put file mod_jk2.so to the {APACHE_DIR}\modules directory

(2) Add this line below to the {APACHE_DIR}\conf\httpd.conf file

LoadModule jk2_module modules/mod_jk2.so

(3) Create a file workers2.properties and save to {APACHE_DIR}\conf

Below are the content file of workers2.properties :

[shm]
info=Scoreboard. Requried for reconfiguration and status with multiprocess servers.
file=anon

# Defines a load balancer named lb. Use even if you only have one machine.
[lb:lb]

# Example socket channel, override port and host.
[channel.socket:localhost:8009]
port=8009
host=127.0.0.1

# define the worker
[ajp13:localhost:8009]
channel=channel.socket:localhost:8009
group=lb

# Map the Tomcat examples webapp to the Web server uri space
[uri:/examples/*]
group=lb

# Map the AR (Account Receivable Project) to the Web server uri space
[uri:/ar/*]
group=lb

[status:]
info=Status worker, displays runtime information

[uri:/jkstatus/*]
info=The Tomcat /jkstatus handler
group=status:

(4) Now, restart your Apache-Tomcat and Apache web server.

(5) Done.

Install Java Plugin to Browser

2006-07-27T07:11:00.000+07:00

After installing JRE on linux of course we want our browser enable running java. Below are step-by-step on how to do that.

(1) Go to your browser plugins directory. For example, if you are using Netscape then type this command

cd /usr/lib/Netscape6/plugins

(2) Create a soft link to your libjavaplugin

ln -s /usr/java/j2re-1_4_2_09/plugin/i386/ns610-gcc32/libjavaplugin_oji.so .

(3) Restart your browser

(4) Change your browser preference

Choose Edit -> Preferences

(5) Enable Java checkbox

(6) Done

How to install JRE on Linux

2006-07-27T07:10:00.000+07:00

It's easy to install JRE (Java Runtime Environment) on linux. Below are step-by-step on how to do that.

(1) Get a JRE installer from java.sun.com

(2) Change as a superuser with this command

su

(3) Go to the directory where JRE would be installed. For a sample

cd /usr/java

(4) Change the JRE installer mode so the installer can be execute by linux

chmod a+x jre-1_4_2_09_linux.bin

(5) Execute an installer

./jre-1_4_2_09_linux.bin

(6) Done.

How to make your ATX machine automatically shutting down on Linux

2006-07-26T07:32:00.000+07:00

For some ATX machine, it may cannot automatically shutting down on Linux. How to fix this ?

(1) Find a file name rc.modules
(2) You can find this file by typing a command :

locate rc.modules

(3) Edit that file with this command :

vi rc.modules

(4) Find a row containing "/sbin/modprobe apm"
(5) If there is a comment "#", uncomment that or delete the "#" sign on that row
(6) Rebooting your machine to test an effect.

How to make your ATX machine automatically shutting down on windows XP

2006-07-26T07:24:00.000+07:00

For some ATX machine, it may cannot automatically shutting down on WIndows XP. How to fix this ?

(1) Go to the Control Panel
(2) Go to the Power Options (on some Windows XP version it may Performance and Maintenance)
(3) Click on the ATM tab
(4) Enable Advanced Power Management Support checkbox.
(5) Shutting down your machine to test the effect.

Burning CD on Slackware 8.1 with cdrecord

2006-07-26T07:07:00.000+07:00

In this article, i'll show you how to burning CD on Slackware Linux version 8.1

(1) If you want to burning a CD data, for a first time you must convert your data to ISO format. For example, if you want burning all *.mp3 files then you must create your ISO with this command :

mkisofs -J -l -r -o song.iso *.mp3

And then you can burning your ISO files with this command :

cdrecord -v -multi -data speed=24 dev=0,0,0 song.iso

For your attention, this command used if you want to burn a data on a fresh blank CD. The option -multi used in order to make your CD multi session.

(2) To continuing your burning on the same CD with multi session, you need to find where is the start location of your next burning. You can do this by typing this command :

cdrecord -msinfo dev=0,0,0

To burn a next data, it's same as the first step. Create a second ISO file, for example :

mkisofs -J -l -r -o doc.iso -M /dev/cdrw -c 0,49354 *.doc

And then to burning your ISO use :

cdrecord -v -multi -data speed=24 dev=0,0,0 doc.iso

It's easy. Isn't it ? It may all step above useful for the other Slackware or Linux version.

Oracle Standard Exceptions

2006-07-25T09:08:00.000+07:00

Below are Oracle Standard Exceptions.

Exception Name : DUP_VAL_ON_INDEX 
Oracle Error : ORA-00001 
Explanation : You tried to execute an INSERT or UPDATE
statement that has created a duplicate value in a field
restricted by a unique index.

Exception Name : TIMEOUT_ON_RESOURCE
Oracle Error : ORA-00051
Explanation : You were waiting for a resource and you
timed out.

Exception Name : TRANSACTION_BACKED_OUT
Oracle Error : ORA-00061
Explanation : The remote portion of a transaction has
rolled back.

Exception Name : INVALID_CURSOR
Oracle Error : ORA-01001
Explanation : You tried to reference a cursor that does
not yet exist. This may have happened because you've
executed a FETCH cursor or CLOSE cursor before
OPENing the cursor.

Exception Name : NOT_LOGGED_ON
Oracle Error : ORA-01012
Explanation : You tried to execute a call to Oracle before
logging in.

Exception Name : LOGIN_DENIED
Oracle Error : ORA-01017
Explanation : You tried to log into Oracle with an invalid
username/password combination.

Exception Name : NO_DATA_FOUND
Oracle Error : ORA-01403
Explanation : You tried one of the following:

1. You executed a SELECT INTO statement and no rows
were returned.
2. You referenced an uninitialized row in a table.
3. You read past the end of file with the UTL_FILE package.

Exception Name : TOO_MANY_ROWS
Oracle Error : ORA-01422
Explanation : You tried to execute a SELECT INTO
statement and more than one row was returned.

Exception Name : ZERO_DIVIDE
Oracle Error : ORA-01476
Explanation : You tried to divide a number by zero.

Exception Name : INVALID_NUMBER
Oracle Error : ORA-01722
Explanation : You tried to execute an SQL statement that
tried to convert a string to a number, but it was unsuccessful.

Exception Name : STORAGE_ERROR
Oracle Error : ORA-06500
Explanation : You ran out of memory or memory was
corrupted.

Exception Name : PROGRAM_ERROR
Oracle Error : ORA-06501
Explanation : This is a generic "Contact Oracle support"
message because an internal problem was encountered.

Exception Name : VALUE_ERROR
Oracle Error : ORA-06502
Explanation : You tried to perform an operation and there
was a error on a conversion, truncation, or invalid
constraining of numeric or character data.

Exception Name : CURSOR_ALREADY_OPEN
Oracle Error : ORA-06511
Explanation : You tried to open a cursor that is already open.

Connecting Java Server Pages (JSP) with MySQL

2006-07-25T07:32:00.000+07:00

If we learn a new software technology, of course we want to know how the software connected to the database. In this article, i'll explain how Java Server Pages (JSP) connected with MySQL.

For a note :

(1) If you installed Apache-Tomcat Web Server, the default directory for JSP are in "/webapps/examples/jsp". It can be different for any version of Apache-Tomcat depending of your Apache-Tomcat version.

(2) If you want to use your own .class, make a new .class and put on "/webapps/examples/WEB-INF/classes/your_class_name". If that directory doesn't exist please fill free to create a new one. Only your .class file is needed.

To connect with MySQL, you need mysql-connector-java. You can download it from MySQL official site. Copy "mysql-connector-java-3.0.8-stable-bin.jar" to "$JAVA_HOME/jre/lib/ext" and then restart your Apache-Tomcat web server.

Below is an example script how JSP get a data from MySQL database.

<%@ page import="java.sql.*" %>
<%
String connectionURL = "jdbc:mysql://localhost:3306/pudak2?user=;password=";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
%>
<html>
<body>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL,"","");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM t_admin");
while (rs.next()) {
out.println (rs.getString("adm_code")+"<br/>");
}
rs.close();
%>
</body>
</html>

That's all. In the next article, i'll explain how to interact Apache-Tomcat with Apache-HTTP server, so Apache-Tomcat can use port 80. Happy learning Java Server Pages.

Step by Step Rebuilding Kernel on Ubuntu Breezy 5.10

2006-07-25T07:12:00.000+07:00

Sometimes, we need to configure our own kernel to fulfill our need. Below are step by step on rebuilding kernel on Ubuntu Breezy 5.10

(1) Make sure you have build-essential, bin86, and kernel-package package installed on your system. If no, please install with this command

apt-get install build-essential bin86 kernel-package

(2) Make sure you have development package libncurses-dev installed on your system. If no, please install with this command

apt-get install libncurses-dev

(3) Make sure you have package linux-tree installed on your system. If no, please install with this command

apt-get install linux-tree-2.6.8.1

(4) Go to the /usr/src directory

cd /usr/src

(5) Extract your linux source

tar jxf linux-source-2.6.8.1.tar.bz2

(6) Create soft link

ln -s linux-source-2.6.8.1 linux

(7) Go to /usr/src/linux directory

cd /usr/src/linux

(8) Copy config file

cp /boot/config-2.6.8.1-3-688 .config

(9) Make oldconfig with this command

make oldconfig

(10) Make kpkg clean with this command

make-kpkg clean

(11) Edit Makefile and suit with your needs

vi Makefile

(12) Make package installer with this command

make-kpkg --initrd --stem linux-revision=n3120 kernel_image

(13) Up one level directory with this command

cd ..

(14) Install a new package installer with this command

dpkg -i linux-image-2.6.8.1_n3120_i386.deb

(15) Ok. Now everything done. Reboot your machine and use your new configured kernel

The Meaning of > /dev/null 2>&1

2006-07-24T12:03:00.000+07:00

Sometimes, if we work under Linux world, we would find the "> /dev/null 2>&1" syntax. What it's mean?

The first part, "> /dev/null" means send standard output to the "bit bucket" or in other words, throw it away.
The second part, "2>&1" means "redirect standard error (2) to the same place as standard output (1)

That's all. Happy using Linux.

The Important of Project Document

2006-07-24T08:44:00.000+07:00

Maybe for some developer's who got a new job or a new position in a new place, not only developing a new application but he/she must and have a duty to maintain other application that had been running for many times and may be many years.

It's important that the Project Leader must forcing the developer to make a well documented project document.

As this happen to me. I have to shoot directly to the database from a thousand member data from the other database type - in this case .DBF - so, i have to converti it to the csv and then load to the database. But, what is the important? I have to know the database design firstly. What happen if there are no documented. I have to trace and re-engineered a database so i can tracert the logic or relationship of database.

It's something difficult. So, keep your project well documented.

How to DROP COLUMN On Oracle TABLE

2006-07-24T08:05:00.000+07:00

Sometimes we need to DROP COLUMN from the database table. But, how it works on Oracle?

First, you must set the column as the unused column.
ALTER TABLE TABLE_NAME SET UNUSED COLUMN COLUMN_NAME;

Second, you must drop the unused column.
ALTER TABLE TABLE_NAME DROP UNUSED COLUMNS;

Note :
TABLE_NAME is your database table name.
COLUMN_NAME is your database column on the table.

Is TOAD Incompatible with Oracle 10g ?

2006-07-24T07:25:00.000+07:00

As a software developer, of course there are many tools that i need to try and choose what are the best tools for developing the application.

On my experience, i have found that TOAD and PL/SQL Developer is a good tools for managing Oracle databases. But, since Oracle 10g released there is a strange between TOAD and Oracle. Especially if we DROP the Oracle TABLE from TOAD. It would evoke the Oracle 10g to raise the fake TABLE like BIN$9+bny8IM+WbgMBCsHAEm/A==$0 who's mean that this is DDL/DML objects in Recycle Bin.

At the first time, i think this is the incompatibility between TOAD and Oracle 10g. But, next i found that the recycle bin is the new featured on Oracle 10g. So, TOAD still work with Oracle 10g without any incompatibility.

mysql_connect(): Client does not support authentication protocol

2006-07-21T17:04:00.000+07:00

When you are upgrading MySQL from MySQL 3 or MySQL 4.0 to MySQL 4.1, you may find this error message

mysql_connect(): Client does not support authentication protocol

So, what should we do?

If, you have a lot of application then you may add the following statement to the [mysqld] section on MySQL configuration file (my.cnf)

old-passwords=1

Then, all of your application will be working like your MySQL prior plus you can maximize the new features on MySQL 4.1.

A Little Bit Lack of Java

2006-07-21T17:01:00.000+07:00

The first my interesting of Java is the ability to hide the scripting code from the .java to .class. So, I can put or give the source without any worry if the others can look at my code.

I know in the world of open source is to open the source we have so anyone can learn and give the action if there is a lack on our code. But, sometimes i want to hide the code.

Now, there is a tools to decompile the .class to .java. So, its a little bit to reduce the strength of Java and my interest. I don't know if Sun Microsystem do a new technology or improvement to compile the source, so no one can look at the original source code.

The Lack of Oracle

2006-07-21T16:59:00.000+07:00

As of my own experience, i can told that i found some lack of Oracle. Previously i am a MySQL database user.

Here is a lack of Oracle :
1. There is no LIMIT feature like a MySQL databases.
2. If you want to change a field in a database like insert a new field between 2 field, you can not do it. It always added on the last field.

For the first lack I do this statement :

In MySQL :
----------
"SELECT DIVISION_CODE, DIVISION_NAME, LKP_NAME FROM T_DIVISION T1, TSYS_LKP T2 WHERE T1.IS_ACTIVE = T2.LKP_CODE AND LKP_TYPE = 'IS_ACTIVE_TYPE' ORDER BY 1 ASC LIMIT 0, 30"

In Oracle :
-----------
"SELECT DIVISION_CODE, DIVISION_NAME, LKP_NAME, NO_RECORD FROM (SELECT DIVISION_CODE, DIVISION_NAME, T2.LKP_NAME, ROW_NUMBER() OVER (ORDER BY DIVISION_CODE ASC) NO_RECORD FROM T_DIVISION T1, TSYS_LKP T2 WHERE T1.IS_ACTIVE = T2.LKP_CODE AND LKP_TYPE = 'IS_ACTIVE_TYPE' ) WHERE NO_RECORD BETWEEN 1 AND 30 ORDER BY 1 ASC"

For the second, you must drop and recreate table with a new structure.

Changing BIOS Date via Linux

2006-07-21T15:40:00.000+07:00

Sometimes if we change the date on linux with date or time function, whenever the computer starting up again, the date setting is back to the BIOS time. It's mean that the date or time function only affect to the linux operating system but not to the BIOS.

So, you can do this :

[root@ppbj root]#hwclock --set --date="2006-07-21 10:15:00"
[root@ppbj root]#hwclock --hctosys

Restart your computer. And then you'll find your BIOS time changed with your new setting.

Script for Shutting Down Oracle10g

2006-07-21T14:47:00.000+07:00

Below is the script to make you easier to shutting down your Oracle10g database on Linux. Create a file, for example : dbstop.sh and then fill the content of file like this :

#!/bin/sh
#(c) 2005 Asep Andria
#
lsnrctl stop
sleep 2
sqlplus "/ as sysdba" << EOF
shutdown immediate

exit
EOF

emctl stop dbconsole

#--- end of script ---#

Script for Starting Up Oracle10g

2006-07-21T14:38:00.000+07:00

Below is the script to make you easier to starting up your Oracle10g database on Linux. Create a file, for example : dbstart.sh and then fill the content of file like this :

#!/bin/sh
#(c) 2005 Asep Andria
#
lsnrctl start
sleep 2
sqlplus "/ as sysdba" << EOF
startup

exit
EOF

sleep 2

emctl start dbconsole
sleep 2

#--- end of script ---#

MySQL Error Handling

2006-07-21T13:28:00.000+07:00

Sometimes, if we work with MySQL database, when there are an error (like cannot dumping database or table corrupt), MySQL would echoing the error code, so the Database Administrator can recognize the error and recover the database.

But, what should we do? What kind of error is that?

Ok. Just go to the MySQL bin directory and then type perror ERROR_CODE. For example, if your MySQL echoing error 127 then you must type perror 127. MySQL would give you an explanation what kind of error of it.

If there are a table corrupt, you can use myisamchk or mysqlcheck syntax to analyze, check, repair or optimize the database.

What is the different between myisamchk and mysqlcheck ?

If you use myisamchk, your MySQL database must be shutting down.
If you use mysqlcheck, you can repair the database while your MySQL database is running up.

Example syntax :

This is to analyze the its database with root user :

[root@ppbj root]# mysqlcheck -a its -u root -p
Enter password:

And then the terminal would echoing the status of MySQL tables like below :

its.adminweb OK
its.t_activity OK
its.t_activity_image OK
its.t_branch OK
its.t_category OK
its.t_contact OK
its.t_division OK
its.t_download OK
its.t_event OK
its.t_group_access OK
its.t_menu OK
its.t_menu_level OK
its.t_news OK
its.t_news_review Table is already up to date
its.t_polling OK
its.t_polling_log OK
its.t_polling_option OK
its.t_procedure Table is already up to date
its.t_profile OK
its.t_profile_group OK
its.t_retailnews OK
its.t_retailnews_image Table is already up to date
its.trel_profile_group OK
its.tsys_lkp OK
its.tsys_sql Table is already up to date
its.tsys_string OK
its.tsys_user OK
its.tsys_var OK

Another mysqlcheck option is :
-a, to analyze the database
-c, to check the database
-r, to repair the database
-o, to optimize the database