Tuesday, December 26, 2006

Gnokii : Upgrade From Nokia 5110 To iTegno 3000

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

Friday, December 22, 2006

Curriculum Vitae

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

Thursday, December 21, 2006

DNS and DynDNS

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

Monday, December 04, 2006

TIMESTAMP or DATETIME on SQL Server 2000 ?

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

Saturday, November 25, 2006

Auto Increment Primary Key in MS SQL Server

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.

Friday, November 03, 2006

Possible Reasons for +CMS ERROR: 302

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.

Wednesday, November 01, 2006

Bash Script to Handling gnokii Daemon

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.

Monday, October 30, 2006

Web Based SQL Server and MSDE Database Administration Tool

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.

Friday, September 01, 2006

+CMS ERROR

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.

Monday, August 28, 2006

configuring iTegno 3000 with gnokii

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

Wednesday, August 09, 2006

How to Install mod_python on Linux Box

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

Tuesday, August 08, 2006

How to Change a Password on Oracle using SQL*Plus

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

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

Monday, August 07, 2006

mod_python on Apache

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.

Friday, August 04, 2006

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

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

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.