Life in Mexico

NIO or ARP Protocol is needed to use comet in tomcat, so you should have something like following:

1
2

<!-- server.xml in tomcat -->
<Connector port="8080" protocol="org.apache.coyote.http11.Http11NioProtocol" connectionTimeout="20000" redirectPort="8443" />

Here is a test servlet:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

import java.io.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import org.apache.catalina.CometEvent;
import org.apache.catalina.CometProcessor;
import org.apache.catalina.CometEvent.EventType;
 
public class CometServlet extends HttpServlet implements CometProcessor {
    public void event(CometEvent e) throws IOException, ServletException {
        if (e.getEventType() == EventType.BEGIN) {
            // ...
            HttpServletResponse response = e.getHttpServletResponse();
            PrintWriter out = response.getWriter();
            out.write("Hello world");
            out.flush();
            System.out.println("message is sent out");
        }
        if (e.getEventType() == EventType.READ) {
            // ...
        }
        // more codes
    }
}

Login as postgres user

1

$ su postgres

The postgres command shell is

1

$ psql

Being inside of psql, you can drop and create database:

1
2
3
4
5
6
7
8

# get help
postgresql=# \h
 
# create database
postgresql=# CREATE DATABASE dbname;
 
# delete database
postgresql=# DROP DATABASE dbname;

To import .sql file into a database:

1

$ psql -U postgres -d dbname -f sqlfilepath

Recently i bought a Blackberry 8830 from ebay.com which is great, it just costed me a little but really a pretty phone, the only defect is that there is no camera, haviing one is ideal, anyway i dont use camera so much. it’s ok then.

Cause it’s from Verizon USA, for carriers in Mexico, they call it “extranjero”, which means you cannot get support from local carrier, in this case, it’s Iusacell. after quite a lot of effort, now 8830 has been adapted to iusacell, that is voice + sms + evdo. wow, viva EVDO, the connection is great, tried to download a 5mb file and the speed maintened in about 80kB/s. oh, have to comment that, i have a great data plan, i am paying about 170 pesos for unlimited evdo connection! it’s about 12 dollars. whatever, this plan is not offering to any new customers any more.

so here i would write down the steps to get it work for others who might need.

1. first of all, you would take your phone to iusacell so they can assign the line for you. it’s free. that means, the activation of phone line.(probably you could configure it by yourself)

2. at this point, you would have the voice and sms service already. then you would follow this post to configure the data service. After the firsts three steps, you probably get data service configured, any way, it could be not EVDO, you woudl see ‘1x’, ‘1X’ beside of the signal in the screen, but not ‘1XEV’ or ‘1xev’.

Now what you have to is update the prl file. you would call *228 to get a new update from iusacell(option 1 then 0). Reset the mobile network connection, it says EVDO? if yes, then congratulations, you got it. if no, dont worry, iusacell is just playing with us, i think iusacell just dont want us to use evdo because we have one cellphone “extranjero”. hehe. now you would want to download a new prl from here and load it into your phone using QPST. here i use the prl 232, maybe you want to use prl 252, your choice.

tips: download MML(MFI Multiloader), QPST from shopcel.com. there all tools you need. for unlocking GSM and GPS, you need MML too.

OpenBox + tint2(panel) + xcompmgr + Airborne(theme)