Although quite frustrated with what i have encountered in the last few days, everyday i have to struggle with my own research and stay up to work on the open source project, but all my efforts are not recognized at all. Anyway it's better to keep a log of what i have done and then take some time to think how things should go on.
These are the things I've accomplished in the second week of GSoC 2012:
1. Set up a cron job for the rtmplite server to automatically check whether the process is still running or not. If it is stopped, restart it. This will allow the server to stay up if the machine gets rebooted, and will allow the server to spawn subprocesses without being stopped by job control as happens when the process is put into the background from a terminal shell. To accomplish this, I first created a .process file in my home directory with the rtmplite server's process id number as its sole contents. You can use 'top' or 'ps' to find out the process id of the server. Then I created this shell script file to check the status of the rtmplite server process:
pidfile=~/.process if [ -e "$pidfile" ] then # check whether the process is running rtmppid=`/usr/bin/head -n 1 ${pidfile} | /usr/bin/awk '{print $1}'`; # restart the process if not running if [ ! -d /proc/${rtmppid} ] then /usr/bin/python ${exefile} -r ${dataroot} & rtmppid=$! echo "${rtmppid}" > ${pidfile} echo `/bin/date` "### rtmplite process restarted with pid: ${rtmppid}" fi fi
This script first checks whether the .process file exists or not. If we don't want the cron job to check for this process temporarily (such as when we apply patches to the program), we can simply delete this file and it won't check on or try to restart the server; after out maintenance, recreate the file with the new process id, and the checking will automatically resume.
The last and also the most important step is to schedule this task in cron by creating following item with the command crontab -e
* * * * * [path_to_the_script]/check_status.sh
This causes the cron system to run this script every minute, thereby checking the rtmplite server process every minute.
2. Implemented web server user login and registration pages using MySQL and HTML. We use a MySQL database for storing user information, so I designed and created this table for user information in the server's mysql database:
| Field | Type | Comments |
|---|---|---|
| userid | INTEGER | Compulsory, automatically increased, primary key |
| VARCHAR(200) | Compulsory, users are identified by emails | |
| password | VARCHAR(50) | Compulsory, encrypted using SHA1, at least 8 alphanumeric characters |
| name | VARCHAR(100) | Not compulsory, default 'NULL' |
| age | INTEGER | Not compulsory, default 'NULL', accepted values [0,150] |
| sex | CHAR(1) | Not compulsory, default 'NULL', accepted values {'M', 'F'} |
| native | CHAR(1) | Not compulsory, default 'NULL', accepted values {'Y', 'N'}. Indicating the user is a native English speaker or not. |
| place | VARCHAR(1000) | Not compulsory, default 'NULL'. Indicating the place when the user lived at the age between 6 and 8. |
| accent | CHAR(1) | Not compulsory, default 'NULL', accepted values {'Y', 'N'}. Indicating the user has a self-reported accent or not. |
This table was created by the following SQL command:
CREATE TABLE users (
userid INTEGER NOT NULL AUTO_INCREMENT,
email VARCHAR(200) NOT NULL,
password VARCHAR(50) NOT NULL,
name VARCHAR(100),
age INTEGER,
sex SET('M', 'F'),
native SET('Y', 'N') DEFAULT 'N',
place VARCHAR(1000),
accent SET('Y', 'N'),
CONSTRAINT PRIMARY KEY (userid),
CONSTRAINT chk_age CHECK (age>=0 AND age<=150)
);
I also prototyped the login and simple registration pages are in HTML. Here are their preliminary screenshots:
If you like, you can go to this page to help us test the system: http://talknicer.net/~li-bo/datacollection/login.php. On the server, we use PHP to retrive the form information from the login and registration pages, perform an update or query in mysql database, and then send data back in HTML.
The recording interface, has also been modified to use HTML instead of pure Flex as earlier. The page currently displays well, but there is no event interaction between HTML and Flash yet.
3. Database schema design for the entire project: Several SQL tables have been designed to store the various information used by all aspects of this project. Detailed table information can be found on our wiki page: http://talknicer.net/w/Database_schema. Here is a brief discussion.
First, the user table shown above will be augmented to keep two additional kinds of user information: one for normal student users and one for those who are providing exemplar recordings. Student users, when they can provide correct pronunciation, should also be allowed to contribute to the exemplar recordings. Also if exemplar recorders register through the website, they have to show they are proficient enough to contribute a qualified exemplar recording, so we should be able to use the student evaluation system to qualify them for uploading exemplar contributions.
There are several other tables for additional information such as languages for a list of languages defined by the ISO in case we may extend our project to other languages; a region table to store some idea of the user's accent; prompts table for the list of text resources will be used for pronunciation evaluation. Then are also tables to log the recordings the users do and tables for set of tests stored in the system.
Here are my plans for the coming week:
1. Discuss details of the game specification to finish the last part of schema design.
2. Figure out how to integrate the Flash audio recorder with the HTML interface using bidirectional communication between ActionScript and JavaScript.
3. Implement the student recording interface.
4. Further tasks can be found at: http://talknicer.net/w/To_do_list