diff options
Diffstat (limited to 'debian/email-service-0.postinst')
-rwxr-xr-x | debian/email-service-0.postinst | 487 |
1 files changed, 487 insertions, 0 deletions
diff --git a/debian/email-service-0.postinst b/debian/email-service-0.postinst new file mode 100755 index 0000000..10eff1c --- /dev/null +++ b/debian/email-service-0.postinst @@ -0,0 +1,487 @@ +#!/bin/sh + +################################################################# +# Add preset account information +################################################################# +echo "[EMAIL-SERVICE] Start adding preset account information..." + +################################################################# +# Email Settings +################################################################# + +if [ ${USER} = "root" ] +then + + ## Setting + # Sending + vconftool set -g 5000 -t bool db/Services/Email/Sending/KeepCopy "1" + vconftool set -g 5000 -t bool db/Services/Email/Sending/SendMeCopy "1" + vconftool set -g 5000 -t bool db/Services/Email/Sending/ReqDeliveryRep "0" + vconftool set -g 5000 -t bool db/Services/Email/Sending/ReqReadRep "0" + vconftool set -g 5000 -t int db/Services/Email/Sending/Priority "1" + vconftool set -g 5000 -t string db/Services/Email/Sending/ActiveAccount "" + vconftool set -g 5000 -t bool db/Services/Email/Sending/IncBodyReply "1" + vconftool set -g 5000 -t bool db/Services/Email/Sending/IncAttachFwd "1" + # Receiving + vconftool set -g 5000 -t int db/Services/Email/Receiving/AutoPoll "0" + vconftool set -g 5000 -t int db/Services/Email/Receiving/PollTime "0" + vconftool set -g 5000 -t int db/Services/Email/Receiving/SendReadRep "2" + vconftool set -g 5000 -t int db/Services/Email/Receiving/Reclimit "0" + vconftool set -g 5000 -t int db/Services/Email/Receiving/FetchOption "0" + vconftool set -g 5000 -t bool db/Services/Email/Receiving/KeepServer "1" + vconftool set -g 5000 -t int db/Services/Email/Receiving/ServDelOption "1" + + vconftool set -g 5000 -t int db/Services/Email/NbAccount "6" + + ## Accounts + + # Gmail + vconftool set -g 5000 -t string db/Services/Email/1/General/NetworkName "default" + vconftool set -g 5000 -t string db/Services/Email/1/General/AccountName "Gmail" + vconftool set -g 5000 -t string db/Services/Email/1/General/EmailAddr "" + vconftool set -g 5000 -t string db/Services/Email/1/General/UserId "" + vconftool set -g 5000 -t string db/Services/Email/1/General/Password "" + vconftool set -g 5000 -t string db/Services/Email/1/General/LoginType "username_type" + + # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service + vconftool set -g 5000 -t int db/Services/Email/1/Incoming/MailboxType "1" + vconftool set -g 5000 -t string db/Services/Email/1/Incoming/ServAddr "imap.gmail.com" + vconftool set -g 5000 -t int db/Services/Email/1/Incoming/Port "993" + vconftool set -g 5000 -t int db/Services/Email/1/Incoming/Secure "1" + vconftool set -g 5000 -t bool db/Services/Email/1/Incoming/Apop "0" + vconftool set -g 5000 -t bool db/Services/Email/1/Incoming/AutoEmailSync "0" + vconftool set -g 5000 -t bool db/Services/Email/1/Incoming/IncludeAttach "0" + vconftool set -g 5000 -t int db/Services/Email/1/Incoming/ImapFetchOpt "1" + + vconftool set -g 5000 -t string db/Services/Email/1/Outgoing/ServAddr "smtp.gmail.com" + vconftool set -g 5000 -t int db/Services/Email/1/Outgoing/Port "465" + vconftool set -g 5000 -t bool db/Services/Email/1/Outgoing/SmtpAuth "0" + vconftool set -g 5000 -t int db/Services/Email/1/Outgoing/Secure "1" + vconftool set -g 5000 -t bool db/Services/Email/1/Outgoing/SameIdPwd "1" + vconftool set -g 5000 -t bool db/Services/Email/1/Outgoing/PopBeforeSmtp "0" + + # Hotmail + vconftool set -g 5000 -t string db/Services/Email/2/General/NetworkName "default" + vconftool set -g 5000 -t string db/Services/Email/2/General/AccountName "Hotmail" + vconftool set -g 5000 -t string db/Services/Email/2/General/EmailAddr "" + vconftool set -g 5000 -t string db/Services/Email/2/General/UserId "" + vconftool set -g 5000 -t string db/Services/Email/2/General/Password "" + vconftool set -g 5000 -t string db/Services/Email/2/General/LoginType "username_type" + + # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service + vconftool set -g 5000 -t int db/Services/Email/2/Incoming/MailboxType "0" + vconftool set -g 5000 -t string db/Services/Email/2/Incoming/ServAddr "pop3.live.com" + vconftool set -g 5000 -t int db/Services/Email/2/Incoming/Port "995" + vconftool set -g 5000 -t int db/Services/Email/2/Incoming/Secure "1" + vconftool set -g 5000 -t bool db/Services/Email/2/Incoming/Apop "0" + vconftool set -g 5000 -t bool db/Services/Email/2/Incoming/AutoEmailSync "0" + vconftool set -g 5000 -t bool db/Services/Email/2/Incoming/IncludeAttach "0" + vconftool set -g 5000 -t int db/Services/Email/2/Incoming/ImapFetchOpt "1" + + vconftool set -g 5000 -t string db/Services/Email/2/Outgoing/ServAddr "smtp.live.com" + vconftool set -g 5000 -t int db/Services/Email/2/Outgoing/Port "587" + vconftool set -g 5000 -t bool db/Services/Email/2/Outgoing/SmtpAuth "0" + vconftool set -g 5000 -t int db/Services/Email/2/Outgoing/Secure "2" + vconftool set -g 5000 -t bool db/Services/Email/2/Outgoing/SameIdPwd "1" + vconftool set -g 5000 -t bool db/Services/Email/2/Outgoing/PopBeforeSmtp "0" + + # AOL + vconftool set -g 5000 -t string db/Services/Email/3/General/NetworkName "default" + vconftool set -g 5000 -t string db/Services/Email/3/General/AccountName "AOL" + vconftool set -g 5000 -t string db/Services/Email/3/General/EmailAddr "" + vconftool set -g 5000 -t string db/Services/Email/3/General/UserId "" + vconftool set -g 5000 -t string db/Services/Email/3/General/Password "" + vconftool set -g 5000 -t string db/Services/Email/3/General/LoginType "username_type" + + # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service + vconftool set -g 5000 -t int db/Services/Email/3/Incoming/MailboxType "1" + vconftool set -g 5000 -t string db/Services/Email/3/Incoming/ServAddr "imap.aol.com" + vconftool set -g 5000 -t int db/Services/Email/3/Incoming/Port "143" + vconftool set -g 5000 -t int db/Services/Email/3/Incoming/Secure "0" + vconftool set -g 5000 -t bool db/Services/Email/3/Incoming/Apop "0" + vconftool set -g 5000 -t bool db/Services/Email/3/Incoming/AutoEmailSync "0" + vconftool set -g 5000 -t bool db/Services/Email/3/Incoming/IncludeAttach "0" + vconftool set -g 5000 -t int db/Services/Email/3/Incoming/ImapFetchOpt "0" + + vconftool set -g 5000 -t string db/Services/Email/3/Outgoing/ServAddr "smtp.aol.com" + vconftool set -g 5000 -t int db/Services/Email/3/Outgoing/Port "587" + vconftool set -g 5000 -t bool db/Services/Email/3/Outgoing/SmtpAuth "0" + vconftool set -g 5000 -t int db/Services/Email/3/Outgoing/Secure "0" + vconftool set -g 5000 -t bool db/Services/Email/3/Outgoing/SameIdPwd "1" + vconftool set -g 5000 -t bool db/Services/Email/3/Outgoing/PopBeforeSmtp "0" + + # Yahoo + vconftool set -g 5000 -t string db/Services/Email/6/General/NetworkName "default" + vconftool set -g 5000 -t string db/Services/Email/6/General/AccountName "Yahoomail" + vconftool set -g 5000 -t string db/Services/Email/6/General/EmailAddr "" + vconftool set -g 5000 -t string db/Services/Email/6/General/UserId "" + vconftool set -g 5000 -t string db/Services/Email/6/General/Password "" + vconftool set -g 5000 -t string db/Services/Email/6/General/LoginType "username_type" + + # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service + vconftool set -g 5000 -t int db/Services/Email/6/Incoming/MailboxType "0" + vconftool set -g 5000 -t string db/Services/Email/6/Incoming/ServAddr "pop.mail.yahoo.co.kr" + vconftool set -g 5000 -t int db/Services/Email/6/Incoming/Port "995" + vconftool set -g 5000 -t int db/Services/Email/6/Incoming/Secure "1" + vconftool set -g 5000 -t bool db/Services/Email/6/Incoming/Apop "0" + vconftool set -g 5000 -t bool db/Services/Email/6/Incoming/AutoEmailSync "0" + vconftool set -g 5000 -t bool db/Services/Email/6/Incoming/IncludeAttach "0" + vconftool set -g 5000 -t int db/Services/Email/6/Incoming/ImapFetchOpt "1" + + vconftool set -g 5000 -t string db/Services/Email/6/Outgoing/ServAddr "smtp.mail.yahoo.co.kr" + vconftool set -g 5000 -t int db/Services/Email/6/Outgoing/Port "465" + vconftool set -g 5000 -t bool db/Services/Email/6/Outgoing/SmtpAuth "0" + vconftool set -g 5000 -t int db/Services/Email/6/Outgoing/Secure "1" + vconftool set -g 5000 -t bool db/Services/Email/6/Outgoing/SameIdPwd "1" + vconftool set -g 5000 -t bool db/Services/Email/6/Outgoing/PopBeforeSmtp "0" + +fi + + +################################################################################################ + +if [ ${USER} = "root" ] +then + +vconftool set -t string db/email/preset_account/aol/sending_address "smtp.aol.com" +vconftool set -t int db/email/preset_account/aol/sending_port "587" +vconftool set -t int db/email/preset_account/aol/sending_ssl "0" +vconftool set -t int db/email/preset_account/aol/receiving_type "2" +vconftool set -t string db/email/preset_account/aol/receiving_address "imap.aol.com" +vconftool set -t int db/email/preset_account/aol/receiving_port "143" +vconftool set -t int db/email/preset_account/aol/receiving_ssl "0" + +vconftool set -t string db/email/preset_account/gmail/sending_address "smtp.gmail.com" +vconftool set -t int db/email/preset_account/gmail/sending_port "465" +vconftool set -t int db/email/preset_account/gmail/sending_ssl "1" +vconftool set -t int db/email/preset_account/gmail/receiving_type "2" +# for POP3 server +#vconftool set -t string db/email/preset_account/gmail/receiving_address "pop.gmail.com" +#vconftool set -t int db/email/preset_account/gmail/receiving_port "995" +# for IMAP4 server +vconftool set -t string db/email/preset_account/gmail/receiving_address "imap.gmail.com" +vconftool set -t int db/email/preset_account/gmail/receiving_port "993" +vconftool set -t int db/email/preset_account/gmail/receiving_ssl "1" + +vconftool set -t string db/email/preset_account/yahoo/sending_address "smtp.mail.yahoo.co.kr" +vconftool set -t int db/email/preset_account/yahoo/sending_port "465" +vconftool set -t int db/email/preset_account/yahoo/sending_ssl "1" +vconftool set -t int db/email/preset_account/yahoo/receiving_type "1" +vconftool set -t string db/email/preset_account/yahoo/receiving_address "pop.mail.yahoo.co.kr" +vconftool set -t int db/email/preset_account/yahoo/receiving_port "995" +vconftool set -t int db/email/preset_account/yahoo/receiving_ssl "1" + +vconftool set -t string db/email/preset_account/hotmail/sending_address "smtp.live.com" +vconftool set -t int db/email/preset_account/hotmail/sending_port "587" +vconftool set -t int db/email/preset_account/hotmail/sending_ssl "2" +vconftool set -t int db/email/preset_account/hotmail/receiving_type "1" +vconftool set -t string db/email/preset_account/hotmail/receiving_address "pop3.live.com" +vconftool set -t int db/email/preset_account/hotmail/receiving_port "995" +vconftool set -t int db/email/preset_account/hotmail/receiving_ssl "1" + +# for Active Sync - Let email app create this key +#vconftool set -t int db/email_handle/active_sync_handle "0" + +# for contact sync - sync from the first contact change +vconftool set -t int db/email/last_sync_time "0" + +# for contact sync - sync from the first contact change +vconftool set -t int db/email/slot_size "100" + +# for badge +vconftool set -t int db/badge/org.tizen.email "0" + +fi + +echo "[EMAIL-SERVICE] Finish adding preset account information" + + +################################################################# +# Set executin script +################################################################# +echo "[EMAIL-SERVICE] Set executing script ..." +EMAIL_SERVICE_EXEC_SCRIPT=/etc/rc.d/init.d/email-service +EMAIL_SERVICE_BOOT_SCRIPT=/etc/rc.d/rc3.d/S70email-service +EMAIL_SERVICE_FASTBOOT_SCRIPT=/etc/rc.d/rc5.d/S70email-service +echo '#!/bin/sh' > ${EMAIL_SERVICE_EXEC_SCRIPT} +echo '/usr/bin/email-service &' >> ${EMAIL_SERVICE_EXEC_SCRIPT} +chmod 755 ${EMAIL_SERVICE_EXEC_SCRIPT} +rm -rf ${EMAIL_SERVICE_BOOT_SCRIPT} +rm -rf ${EMAIL_SERVICE_FASTBOOT_SCRIPT} +ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_BOOT_SCRIPT} +ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_FASTBOOT_SCRIPT} +echo "[EMAIL-SERVICE] Finish executing script ..." + +################################################################# +# Create DB file and tables. +################################################################# +echo "[EMAIL-SERVICE] Creating Email Tables ..." +sqlite3 /opt/dbspace/.email-service.db 'PRAGMA journal_mode = PERSIST; +CREATE TABLE mail_account_tbl +( + account_bind_type INTEGER, + account_name VARCHAR(51), + receiving_server_type INTEGER, + receiving_server_addr VARCHAR(51), + email_addr VARCHAR(129), + user_name VARCHAR(51), + password VARCHAR(51), + retrieval_mode INTEGER, + port_num INTEGER, + use_security INTEGER, + sending_server_type INTEGER, + sending_server_addr VARCHAR(51), + sending_port_num INTEGER, + sending_auth INTEGER, + sending_security INTEGER, + sending_user VARCHAR(51), + sending_password VARCHAR(51), + display_name VARCHAR(31), + reply_to_addr VARCHAR(129), + return_addr VARCHAR(129), + account_id INTEGER PRIMARY KEY, + keep_on_server INTEGER, + flag1 INTEGER, + flag2 INTEGER, + pop_before_smtp INTEGER, + apop INTEGER, + logo_icon_path VARCHAR(256), + preset_account INTEGER, + target_storage INTEGER, + check_interval INTEGER, + priority INTEGER, + keep_local_copy INTEGER, + req_delivery_receipt INTEGER, + req_read_receipt INTEGER, + download_limit INTEGER, + block_address INTEGER, + block_subject INTEGER, + display_name_from VARCHAR(256), + reply_with_body INTEGER, + forward_with_files INTEGER, + add_myname_card INTEGER, + add_signature INTEGER, + signature VARCHAR(256), + add_my_address_to_bcc INTEGER, + my_account_id INTEGER, + index_color INTEGER, + sync_status INTEGER +); + +CREATE TABLE mail_attachment_tbl +( + attachment_id INTEGER PRIMARY KEY, + attachment_name VARCHAR(257), + attachment_path VARCHAR(257), + attachment_size INTEGER, + mail_id INTEGER, + account_id INTEGER, + mailbox_name VARCHAR(129), + file_yn INTEGER, + flag1 INTEGER, + flag2 INTEGER, + flag3 INTEGER +); + +CREATE TABLE mail_box_tbl +( + mailbox_id INTEGER, + account_id INTEGER, + local_yn INTEGER, + mailbox_name VARCHAR(256), + mailbox_type INTEGER, + alias VARCHAR(256), + sync_with_server_yn INTEGER, + modifiable_yn INTEGER, + total_mail_count_on_server INTEGER, + has_archived_mails INTEGER, + mail_slot_size INTEGER +); +CREATE TABLE mail_read_mail_uid_tbl +( + account_id INTEGER , + local_mbox VARCHAR(129) , + local_uid INTEGER , + mailbox_name VARCHAR(129) , + s_uid VARCHAR(129) , + data1 INTEGER , + data2 VARCHAR(257) , + flag INTEGER , + idx_num INTEGER PRIMARY KEY +); +CREATE TABLE mail_rule_tbl +( + account_id INTEGER , + rule_id INTEGER PRIMARY KEY, + type INTEGER , + value VARCHAR(257) , + action_type INTEGER , + dest_mailbox VARCHAR(129), + flag1 INTEGER , + flag2 INTEGER +); +CREATE TABLE mail_tbl +( + mail_id INTEGER PRIMARY_KEY, + account_id INTEGER, + mailbox_name VARCHAR(129), + mailbox_type INTEGER, + subject UCS2TEXT, + date_time VARCHAR(129), + server_mail_status INTEGER, + server_mailbox_name VARCHAR(129), + server_mail_id VARCHAR(129), + message_id VARCHAR(257), + full_address_from UCS2TEXT, + full_address_reply UCS2TEXT, + full_address_to UCS2TEXT, + full_address_cc UCS2TEXT, + full_address_bcc UCS2TEXT, + full_address_return UCS2TEXT, + email_address_sender UCS2TEXT collation user1, + email_address_recipient UCS2TEXT collation user1, + alias_sender UCS2TEXT, + alias_recipient UCS2TEXT, + body_download_status INTEGER, + file_path_plain VARCHAR(257), + file_path_html VARCHAR(257), + mail_size INTEGER, + flags_seen_field BOOLEAN, + flags_deleted_field BOOLEAN, + flags_flagged_field BOOLEAN, + flags_answered_field BOOLEAN, + flags_recent_field BOOLEAN, + flags_draft_field BOOLEAN, + flags_forwarded_field BOOLEAN, + DRM_status INTEGER, + priority INTEGER, + save_status INTEGER, + lock_status INTEGER, + report_status INTEGER, + attachment_count INTEGER, + inline_content_count INTEGER, + thread_id INTEGER, + thread_item_count INTEGER, + preview_text UCS2TEXT, + meeting_request_status INTEGER, + FOREIGN KEY(account_id) REFERENCES mail_account_tbl(account_id) +); +CREATE TABLE mail_meeting_tbl +( + mail_id INTEGER PRIMARY KEY, + account_id INTEGER, + mailbox_name UCS2TEXT , + meeting_response INTEGER, + start_time INTEGER, + end_time INTEGER, + location UCS2TEXT , + global_object_id UCS2TEXT , + offset INTEGER, + standard_name UCS2TEXT , + standard_time_start_date INTEGER, + standard_bias INTEGER, + daylight_name UCS2TEXT , + daylight_time_start_date INTEGER, + daylight_bias INTEGER +); +CREATE TABLE mail_local_activity_tbl +( + activity_id INTEGER, + account_id INTEGER, + mail_id INTEGER, + activity_type INTEGER, + server_mailid VARCHAR(129), + src_mbox VARCHAR(129), + dest_mbox VARCHAR(129) +); + + +CREATE UNIQUE INDEX mail_account_idx1 ON mail_account_tbl (account_bind_type, account_id); +CREATE UNIQUE INDEX mail_attachment_idx1 ON mail_attachment_tbl (mail_id, attachment_id); +CREATE UNIQUE INDEX mail_box_idx1 ON mail_box_tbl (account_id, local_yn, mailbox_name); +CREATE UNIQUE INDEX mail_idx1 ON mail_tbl (mail_id, account_id); +CREATE UNIQUE INDEX mail_read_mail_uid_idx1 ON mail_read_mail_uid_tbl (account_id, local_mbox, local_uid, mailbox_name, s_uid); +CREATE UNIQUE INDEX mail_meeting_idx1 ON mail_meeting_tbl (mail_id); +CREATE INDEX mail_idx_date_time ON mail_tbl (date_time); +CREATE INDEX mail_idx_thread_item_count ON mail_tbl (thread_item_count); +' + +echo "[EMAIL-SERVICE] Finish Creating Email Tables." + + +################################################################# +# Change file permission +################################################################# +#echo "[EMAIL-SERVICE] Start setting permission ..." +# 1. libraries +#chmod 644 /usr/lib/libemail-ipc.so.0.0.0 +#chmod 644 /usr/lib/libemail-core.so.0.0.0 +#chmod 644 /usr/lib/libemail-emn-storage.so.0.0.0 +#chmod 644 /usr/lib/libemail-base.so.0.0.0 +#chmod 644 /usr/lib/libem-storage.so.0.0.0 +#chmod 644 /usr/lib/libem-network.so.0.0.0 +#chmod 644 /usr/lib/libemail-mapi.so.0.0.0 +#chmod 644 /usr/lib/libem-storage.so +#chmod 644 /usr/lib/libemail-base.so.0 +#chmod 644 /usr/lib/libem-network.so.0 +#chmod 644 /usr/lib/libemail-core.so.0 +#chmod 644 /usr/lib/libemail-emn-storage.so +#chmod 644 /usr/lib/libemail-ipc.so +#chmod 644 /usr/lib/libemail-mapi.so.0 +#chmod 644 /usr/lib/libem-storage.so.0 +#chmod 644 /usr/lib/libem-network.so +#chmod 644 /usr/lib/libemail-ipc.so.0 +#chmod 644 /usr/lib/libemail-core.so +#chmod 644 /usr/lib/libemail-base.so +#chmod 644 /usr/lib/libemail-mapi.so +#chmod 644 /usr/lib/libemail-emn-storage.so.0 + +# 2. executables +#chmod 700 /usr/bin/email-service_initDB +#chmod 700 /usr/bin/email-service + +# 3. DB files +chmod 644 /opt/dbspace/.email-service.db +chmod 644 /opt/dbspace/.email-service.db-journal + + +################################################################# +# Change file owner +################################################################# +#echo "[EMAIL-SERVICE] Start setting owner ..." + + # 1. libraries +# chown root:root /usr/lib/libemail-ipc.so.0.0.0 +# chown root:root /usr/lib/libemail-core.so.0.0.0 +# chown root:root /usr/lib/libemail-emn-storage.so.0.0.0 +# chown root:root /usr/lib/libemail-base.so.0.0.0 +# chown root:root /usr/lib/libem-storage.so.0.0.0 +# chown root:root /usr/lib/libem-network.so.0.0.0 +# chown root:root /usr/lib/libemail-mapi.so.0.0.0 +# chown root:root /usr/lib/libem-storage.so +# chown root:root /usr/lib/libemail-base.so.0 +# chown root:root /usr/lib/libem-network.so.0 +# chown root:root /usr/lib/libemail-core.so.0 +# chown root:root /usr/lib/libemail-emn-storage.so +# chown root:root /usr/lib/libemail-ipc.so +# chown root:root /usr/lib/libemail-mapi.so.0 +# chown root:root /usr/lib/libem-storage.so.0 +# chown root:root /usr/lib/libem-network.so +# chown root:root /usr/lib/libemail-ipc.so.0 +# chown root:root /usr/lib/libemail-core.so +# chown root:root /usr/lib/libemail-base.so +# chown root:root /usr/lib/libemail-mapi.so +# chown root:root /usr/lib/libemail-emn-storage.so.0 + + # 2. executables +# chown root:root /usr/bin/email-service_initDB +# chown root:root /usr/bin/email-service + + # 3. DB files +if [ ${USER} = "root" ] +then + chown root:root /opt/dbspace/.email-service.db + chown root:root /opt/dbspace/.email-service.db-journal +fi + +exit 0 |