3 #################################################################
4 # Add preset account information
5 #################################################################
6 echo "[EMAIL-SERVICE] Start adding preset account information..."
8 #################################################################
10 #################################################################
12 if [ ${USER} = "root" ]
17 vconftool set -g 5000 -t bool db/Services/Email/Sending/KeepCopy "1"
18 vconftool set -g 5000 -t bool db/Services/Email/Sending/SendMeCopy "1"
19 vconftool set -g 5000 -t bool db/Services/Email/Sending/ReqDeliveryRep "0"
20 vconftool set -g 5000 -t bool db/Services/Email/Sending/ReqReadRep "0"
21 vconftool set -g 5000 -t int db/Services/Email/Sending/Priority "1"
22 vconftool set -g 5000 -t string db/Services/Email/Sending/ActiveAccount ""
23 vconftool set -g 5000 -t bool db/Services/Email/Sending/IncBodyReply "1"
24 vconftool set -g 5000 -t bool db/Services/Email/Sending/IncAttachFwd "1"
26 vconftool set -g 5000 -t int db/Services/Email/Receiving/AutoPoll "0"
27 vconftool set -g 5000 -t int db/Services/Email/Receiving/PollTime "0"
28 vconftool set -g 5000 -t int db/Services/Email/Receiving/SendReadRep "2"
29 vconftool set -g 5000 -t int db/Services/Email/Receiving/Reclimit "0"
30 vconftool set -g 5000 -t int db/Services/Email/Receiving/FetchOption "0"
31 vconftool set -g 5000 -t bool db/Services/Email/Receiving/KeepServer "1"
32 vconftool set -g 5000 -t int db/Services/Email/Receiving/ServDelOption "1"
34 vconftool set -g 5000 -t int db/Services/Email/NbAccount "6"
39 vconftool set -g 5000 -t string db/Services/Email/1/General/NetworkName "default"
40 vconftool set -g 5000 -t string db/Services/Email/1/General/AccountName "Gmail"
41 vconftool set -g 5000 -t string db/Services/Email/1/General/EmailAddr ""
42 vconftool set -g 5000 -t string db/Services/Email/1/General/UserId ""
43 vconftool set -g 5000 -t string db/Services/Email/1/General/Password ""
44 vconftool set -g 5000 -t string db/Services/Email/1/General/LoginType "username_type"
46 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
47 vconftool set -g 5000 -t int db/Services/Email/1/Incoming/MailboxType "1"
48 vconftool set -g 5000 -t string db/Services/Email/1/Incoming/ServAddr "imap.gmail.com"
49 vconftool set -g 5000 -t int db/Services/Email/1/Incoming/Port "993"
50 vconftool set -g 5000 -t int db/Services/Email/1/Incoming/Secure "1"
51 vconftool set -g 5000 -t bool db/Services/Email/1/Incoming/Apop "0"
52 vconftool set -g 5000 -t bool db/Services/Email/1/Incoming/AutoEmailSync "0"
53 vconftool set -g 5000 -t bool db/Services/Email/1/Incoming/IncludeAttach "0"
54 vconftool set -g 5000 -t int db/Services/Email/1/Incoming/ImapFetchOpt "1"
56 vconftool set -g 5000 -t string db/Services/Email/1/Outgoing/ServAddr "smtp.gmail.com"
57 vconftool set -g 5000 -t int db/Services/Email/1/Outgoing/Port "465"
58 vconftool set -g 5000 -t bool db/Services/Email/1/Outgoing/SmtpAuth "0"
59 vconftool set -g 5000 -t int db/Services/Email/1/Outgoing/Secure "1"
60 vconftool set -g 5000 -t bool db/Services/Email/1/Outgoing/SameIdPwd "1"
61 vconftool set -g 5000 -t bool db/Services/Email/1/Outgoing/PopBeforeSmtp "0"
64 vconftool set -g 5000 -t string db/Services/Email/2/General/NetworkName "default"
65 vconftool set -g 5000 -t string db/Services/Email/2/General/AccountName "Hotmail"
66 vconftool set -g 5000 -t string db/Services/Email/2/General/EmailAddr ""
67 vconftool set -g 5000 -t string db/Services/Email/2/General/UserId ""
68 vconftool set -g 5000 -t string db/Services/Email/2/General/Password ""
69 vconftool set -g 5000 -t string db/Services/Email/2/General/LoginType "username_type"
71 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
72 vconftool set -g 5000 -t int db/Services/Email/2/Incoming/MailboxType "0"
73 vconftool set -g 5000 -t string db/Services/Email/2/Incoming/ServAddr "pop3.live.com"
74 vconftool set -g 5000 -t int db/Services/Email/2/Incoming/Port "995"
75 vconftool set -g 5000 -t int db/Services/Email/2/Incoming/Secure "1"
76 vconftool set -g 5000 -t bool db/Services/Email/2/Incoming/Apop "0"
77 vconftool set -g 5000 -t bool db/Services/Email/2/Incoming/AutoEmailSync "0"
78 vconftool set -g 5000 -t bool db/Services/Email/2/Incoming/IncludeAttach "0"
79 vconftool set -g 5000 -t int db/Services/Email/2/Incoming/ImapFetchOpt "1"
81 vconftool set -g 5000 -t string db/Services/Email/2/Outgoing/ServAddr "smtp.live.com"
82 vconftool set -g 5000 -t int db/Services/Email/2/Outgoing/Port "587"
83 vconftool set -g 5000 -t bool db/Services/Email/2/Outgoing/SmtpAuth "0"
84 vconftool set -g 5000 -t int db/Services/Email/2/Outgoing/Secure "2"
85 vconftool set -g 5000 -t bool db/Services/Email/2/Outgoing/SameIdPwd "1"
86 vconftool set -g 5000 -t bool db/Services/Email/2/Outgoing/PopBeforeSmtp "0"
89 vconftool set -g 5000 -t string db/Services/Email/3/General/NetworkName "default"
90 vconftool set -g 5000 -t string db/Services/Email/3/General/AccountName "AOL"
91 vconftool set -g 5000 -t string db/Services/Email/3/General/EmailAddr ""
92 vconftool set -g 5000 -t string db/Services/Email/3/General/UserId ""
93 vconftool set -g 5000 -t string db/Services/Email/3/General/Password ""
94 vconftool set -g 5000 -t string db/Services/Email/3/General/LoginType "username_type"
96 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
97 vconftool set -g 5000 -t int db/Services/Email/3/Incoming/MailboxType "1"
98 vconftool set -g 5000 -t string db/Services/Email/3/Incoming/ServAddr "imap.aol.com"
99 vconftool set -g 5000 -t int db/Services/Email/3/Incoming/Port "143"
100 vconftool set -g 5000 -t int db/Services/Email/3/Incoming/Secure "0"
101 vconftool set -g 5000 -t bool db/Services/Email/3/Incoming/Apop "0"
102 vconftool set -g 5000 -t bool db/Services/Email/3/Incoming/AutoEmailSync "0"
103 vconftool set -g 5000 -t bool db/Services/Email/3/Incoming/IncludeAttach "0"
104 vconftool set -g 5000 -t int db/Services/Email/3/Incoming/ImapFetchOpt "0"
106 vconftool set -g 5000 -t string db/Services/Email/3/Outgoing/ServAddr "smtp.aol.com"
107 vconftool set -g 5000 -t int db/Services/Email/3/Outgoing/Port "587"
108 vconftool set -g 5000 -t bool db/Services/Email/3/Outgoing/SmtpAuth "0"
109 vconftool set -g 5000 -t int db/Services/Email/3/Outgoing/Secure "0"
110 vconftool set -g 5000 -t bool db/Services/Email/3/Outgoing/SameIdPwd "1"
111 vconftool set -g 5000 -t bool db/Services/Email/3/Outgoing/PopBeforeSmtp "0"
114 vconftool set -g 5000 -t string db/Services/Email/6/General/NetworkName "default"
115 vconftool set -g 5000 -t string db/Services/Email/6/General/AccountName "Yahoomail"
116 vconftool set -g 5000 -t string db/Services/Email/6/General/EmailAddr ""
117 vconftool set -g 5000 -t string db/Services/Email/6/General/UserId ""
118 vconftool set -g 5000 -t string db/Services/Email/6/General/Password ""
119 vconftool set -g 5000 -t string db/Services/Email/6/General/LoginType "username_type"
121 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
122 vconftool set -g 5000 -t int db/Services/Email/6/Incoming/MailboxType "0"
123 vconftool set -g 5000 -t string db/Services/Email/6/Incoming/ServAddr "pop.mail.yahoo.co.kr"
124 vconftool set -g 5000 -t int db/Services/Email/6/Incoming/Port "995"
125 vconftool set -g 5000 -t int db/Services/Email/6/Incoming/Secure "1"
126 vconftool set -g 5000 -t bool db/Services/Email/6/Incoming/Apop "0"
127 vconftool set -g 5000 -t bool db/Services/Email/6/Incoming/AutoEmailSync "0"
128 vconftool set -g 5000 -t bool db/Services/Email/6/Incoming/IncludeAttach "0"
129 vconftool set -g 5000 -t int db/Services/Email/6/Incoming/ImapFetchOpt "1"
131 vconftool set -g 5000 -t string db/Services/Email/6/Outgoing/ServAddr "smtp.mail.yahoo.co.kr"
132 vconftool set -g 5000 -t int db/Services/Email/6/Outgoing/Port "465"
133 vconftool set -g 5000 -t bool db/Services/Email/6/Outgoing/SmtpAuth "0"
134 vconftool set -g 5000 -t int db/Services/Email/6/Outgoing/Secure "1"
135 vconftool set -g 5000 -t bool db/Services/Email/6/Outgoing/SameIdPwd "1"
136 vconftool set -g 5000 -t bool db/Services/Email/6/Outgoing/PopBeforeSmtp "0"
141 ################################################################################################
143 if [ ${USER} = "root" ]
146 vconftool set -t string db/email/preset_account/aol/sending_address "smtp.aol.com"
147 vconftool set -t int db/email/preset_account/aol/sending_port "587"
148 vconftool set -t int db/email/preset_account/aol/sending_ssl "0"
149 vconftool set -t int db/email/preset_account/aol/receiving_type "2"
150 vconftool set -t string db/email/preset_account/aol/receiving_address "imap.aol.com"
151 vconftool set -t int db/email/preset_account/aol/receiving_port "143"
152 vconftool set -t int db/email/preset_account/aol/receiving_ssl "0"
154 vconftool set -t string db/email/preset_account/gmail/sending_address "smtp.gmail.com"
155 vconftool set -t int db/email/preset_account/gmail/sending_port "465"
156 vconftool set -t int db/email/preset_account/gmail/sending_ssl "1"
157 vconftool set -t int db/email/preset_account/gmail/receiving_type "2"
159 #vconftool set -t string db/email/preset_account/gmail/receiving_address "pop.gmail.com"
160 #vconftool set -t int db/email/preset_account/gmail/receiving_port "995"
162 vconftool set -t string db/email/preset_account/gmail/receiving_address "imap.gmail.com"
163 vconftool set -t int db/email/preset_account/gmail/receiving_port "993"
164 vconftool set -t int db/email/preset_account/gmail/receiving_ssl "1"
166 vconftool set -t string db/email/preset_account/yahoo/sending_address "smtp.mail.yahoo.co.kr"
167 vconftool set -t int db/email/preset_account/yahoo/sending_port "465"
168 vconftool set -t int db/email/preset_account/yahoo/sending_ssl "1"
169 vconftool set -t int db/email/preset_account/yahoo/receiving_type "1"
170 vconftool set -t string db/email/preset_account/yahoo/receiving_address "pop.mail.yahoo.co.kr"
171 vconftool set -t int db/email/preset_account/yahoo/receiving_port "995"
172 vconftool set -t int db/email/preset_account/yahoo/receiving_ssl "1"
174 vconftool set -t string db/email/preset_account/hotmail/sending_address "smtp.live.com"
175 vconftool set -t int db/email/preset_account/hotmail/sending_port "587"
176 vconftool set -t int db/email/preset_account/hotmail/sending_ssl "2"
177 vconftool set -t int db/email/preset_account/hotmail/receiving_type "1"
178 vconftool set -t string db/email/preset_account/hotmail/receiving_address "pop3.live.com"
179 vconftool set -t int db/email/preset_account/hotmail/receiving_port "995"
180 vconftool set -t int db/email/preset_account/hotmail/receiving_ssl "1"
182 # for Active Sync - Let email app create this key
183 #vconftool set -t int db/email_handle/active_sync_handle "0"
185 # for contact sync - sync from the first contact change
186 vconftool set -t int db/email/last_sync_time "0"
188 # for contact sync - sync from the first contact change
189 vconftool set -t int db/email/slot_size "100"
192 vconftool set -t int db/badge/com.samsung.email "0"
196 echo "[EMAIL-SERVICE] Finish adding preset account information"
199 #################################################################
200 # Set executin script
201 #################################################################
202 echo "[EMAIL-SERVICE] Set executing script ..."
203 EMAIL_SERVICE_EXEC_SCRIPT=/etc/rc.d/init.d/email-service
204 EMAIL_SERVICE_BOOT_SCRIPT=/etc/rc.d/rc3.d/S70email-service
205 EMAIL_SERVICE_FASTBOOT_SCRIPT=/etc/rc.d/rc5.d/S70email-service
206 echo '#!/bin/sh' > ${EMAIL_SERVICE_EXEC_SCRIPT}
207 echo '/usr/bin/email-service &' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
208 chmod 755 ${EMAIL_SERVICE_EXEC_SCRIPT}
209 rm -rf ${EMAIL_SERVICE_BOOT_SCRIPT}
210 rm -rf ${EMAIL_SERVICE_FASTBOOT_SCRIPT}
211 ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_BOOT_SCRIPT}
212 ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_FASTBOOT_SCRIPT}
213 echo "[EMAIL-SERVICE] Finish executing script ..."
215 #################################################################
216 # Create DB file and tables.
217 #################################################################
218 echo "[EMAIL-SERVICE] Creating Email Tables ..."
219 sqlite3 /opt/dbspace/.email-service.db 'PRAGMA journal_mode = PERSIST;
220 CREATE TABLE mail_account_tbl
222 account_bind_type INTEGER,
223 account_name VARCHAR(51),
224 receiving_server_type INTEGER,
225 receiving_server_addr VARCHAR(51),
226 email_addr VARCHAR(129),
227 user_name VARCHAR(51),
228 password VARCHAR(51),
229 retrieval_mode INTEGER,
231 use_security INTEGER,
232 sending_server_type INTEGER,
233 sending_server_addr VARCHAR(51),
234 sending_port_num INTEGER,
235 sending_auth INTEGER,
236 sending_security INTEGER,
237 sending_user VARCHAR(51),
238 sending_password VARCHAR(51),
239 display_name VARCHAR(31),
240 reply_to_addr VARCHAR(129),
241 return_addr VARCHAR(129),
242 account_id INTEGER PRIMARY KEY,
243 keep_on_server INTEGER,
246 pop_before_smtp INTEGER,
248 logo_icon_path VARCHAR(256),
249 preset_account INTEGER,
250 target_storage INTEGER,
251 check_interval INTEGER,
253 keep_local_copy INTEGER,
254 req_delivery_receipt INTEGER,
255 req_read_receipt INTEGER,
256 download_limit INTEGER,
257 block_address INTEGER,
258 block_subject INTEGER,
259 display_name_from VARCHAR(256),
260 reply_with_body INTEGER,
261 forward_with_files INTEGER,
262 add_myname_card INTEGER,
263 add_signature INTEGER,
264 signature VARCHAR(256),
265 add_my_address_to_bcc INTEGER,
266 my_account_id INTEGER,
271 CREATE TABLE mail_attachment_tbl
273 attachment_id INTEGER PRIMARY KEY,
274 attachment_name VARCHAR(257),
275 attachment_path VARCHAR(257),
276 attachment_size INTEGER,
279 mailbox_name VARCHAR(129),
280 attachment_save_status INTEGER,
281 attachment_drm_type INTEGER,
282 attachment_drm_method INTEGER,
283 attachment_inline_content_status INTEGER,
284 attachment_mime_type VARCHAR(257)
287 CREATE TABLE mail_box_tbl
292 mailbox_name VARCHAR(256),
293 mailbox_type INTEGER,
295 sync_with_server_yn INTEGER,
296 modifiable_yn INTEGER,
297 total_mail_count_on_server INTEGER,
298 has_archived_mails INTEGER,
299 mail_slot_size INTEGER
301 CREATE TABLE mail_read_mail_uid_tbl
304 local_mbox VARCHAR(129) ,
306 mailbox_name VARCHAR(129) ,
311 idx_num INTEGER PRIMARY KEY
313 CREATE TABLE mail_rule_tbl
316 rule_id INTEGER PRIMARY KEY,
319 action_type INTEGER ,
320 dest_mailbox VARCHAR(129),
324 CREATE TABLE mail_tbl
326 mail_id INTEGER PRIMARY_KEY,
329 mailbox_name VARCHAR(129),
330 mailbox_type INTEGER,
333 server_mail_status INTEGER,
334 server_mailbox_name VARCHAR(129),
335 server_mail_id VARCHAR(129),
336 message_id VARCHAR(257),
337 full_address_from TEXT,
338 full_address_reply TEXT,
339 full_address_to TEXT,
340 full_address_cc TEXT,
341 full_address_bcc TEXT,
342 full_address_return TEXT,
343 email_address_sender TEXT collation user1,
344 email_address_recipient TEXT collation user1,
346 alias_recipient TEXT,
347 body_download_status INTEGER,
348 file_path_plain VARCHAR(257),
349 file_path_html VARCHAR(257),
351 flags_seen_field BOOLEAN,
352 flags_deleted_field BOOLEAN,
353 flags_flagged_field BOOLEAN,
354 flags_answered_field BOOLEAN,
355 flags_recent_field BOOLEAN,
356 flags_draft_field BOOLEAN,
357 flags_forwarded_field BOOLEAN,
362 report_status INTEGER,
363 attachment_count INTEGER,
364 inline_content_count INTEGER,
366 thread_item_count INTEGER,
368 meeting_request_status INTEGER,
369 FOREIGN KEY(account_id) REFERENCES mail_account_tbl(account_id)
371 CREATE TABLE mail_meeting_tbl
373 mail_id INTEGER PRIMARY KEY,
376 meeting_response INTEGER,
380 global_object_id TEXT ,
383 standard_time_start_date INTEGER,
384 standard_bias INTEGER,
386 daylight_time_start_date INTEGER,
387 daylight_bias INTEGER
389 CREATE TABLE mail_local_activity_tbl
394 activity_type INTEGER,
395 server_mailid VARCHAR(129),
396 src_mbox VARCHAR(129),
397 dest_mbox VARCHAR(129)
401 CREATE UNIQUE INDEX mail_account_idx1 ON mail_account_tbl (account_bind_type, account_id);
402 CREATE UNIQUE INDEX mail_attachment_idx1 ON mail_attachment_tbl (mail_id, attachment_id);
403 CREATE UNIQUE INDEX mail_box_idx1 ON mail_box_tbl (account_id, local_yn, mailbox_name);
404 CREATE UNIQUE INDEX mail_idx1 ON mail_tbl (mail_id, account_id);
405 CREATE UNIQUE INDEX mail_read_mail_uid_idx1 ON mail_read_mail_uid_tbl (account_id, local_mbox, local_uid, mailbox_name, s_uid);
406 CREATE UNIQUE INDEX mail_meeting_idx1 ON mail_meeting_tbl (mail_id);
407 CREATE INDEX mail_idx_date_time ON mail_tbl (date_time);
408 CREATE INDEX mail_idx_thread_item_count ON mail_tbl (thread_item_count);
411 echo "[EMAIL-SERVICE] Finish Creating Email Tables."
414 #################################################################
415 # Change file permission
416 #################################################################
417 #echo "[EMAIL-SERVICE] Start setting permission ..."
419 #chmod 644 /usr/lib/libemail-ipc.so.0.0.0
420 #chmod 644 /usr/lib/libemail-core.so.0.0.0
421 #chmod 644 /usr/lib/libemail-emn-storage.so.0.0.0
422 #chmod 644 /usr/lib/libemail-base.so.0.0.0
423 #chmod 644 /usr/lib/libem-storage.so.0.0.0
424 #chmod 644 /usr/lib/libem-network.so.0.0.0
425 #chmod 644 /usr/lib/libemail-mapi.so.0.0.0
426 #chmod 644 /usr/lib/libem-storage.so
427 #chmod 644 /usr/lib/libemail-base.so.0
428 #chmod 644 /usr/lib/libem-network.so.0
429 #chmod 644 /usr/lib/libemail-core.so.0
430 #chmod 644 /usr/lib/libemail-emn-storage.so
431 #chmod 644 /usr/lib/libemail-ipc.so
432 #chmod 644 /usr/lib/libemail-mapi.so.0
433 #chmod 644 /usr/lib/libem-storage.so.0
434 #chmod 644 /usr/lib/libem-network.so
435 #chmod 644 /usr/lib/libemail-ipc.so.0
436 #chmod 644 /usr/lib/libemail-core.so
437 #chmod 644 /usr/lib/libemail-base.so
438 #chmod 644 /usr/lib/libemail-mapi.so
439 #chmod 644 /usr/lib/libemail-emn-storage.so.0
442 #chmod 700 /usr/bin/email-service_initDB
443 #chmod 700 /usr/bin/email-service
446 chmod 644 /opt/dbspace/.email-service.db
447 chmod 644 /opt/dbspace/.email-service.db-journal
450 #################################################################
452 #################################################################
453 #echo "[EMAIL-SERVICE] Start setting owner ..."
456 # chown root:root /usr/lib/libemail-ipc.so.0.0.0
457 # chown root:root /usr/lib/libemail-core.so.0.0.0
458 # chown root:root /usr/lib/libemail-emn-storage.so.0.0.0
459 # chown root:root /usr/lib/libemail-base.so.0.0.0
460 # chown root:root /usr/lib/libem-storage.so.0.0.0
461 # chown root:root /usr/lib/libem-network.so.0.0.0
462 # chown root:root /usr/lib/libemail-mapi.so.0.0.0
463 # chown root:root /usr/lib/libem-storage.so
464 # chown root:root /usr/lib/libemail-base.so.0
465 # chown root:root /usr/lib/libem-network.so.0
466 # chown root:root /usr/lib/libemail-core.so.0
467 # chown root:root /usr/lib/libemail-emn-storage.so
468 # chown root:root /usr/lib/libemail-ipc.so
469 # chown root:root /usr/lib/libemail-mapi.so.0
470 # chown root:root /usr/lib/libem-storage.so.0
471 # chown root:root /usr/lib/libem-network.so
472 # chown root:root /usr/lib/libemail-ipc.so.0
473 # chown root:root /usr/lib/libemail-core.so
474 # chown root:root /usr/lib/libemail-base.so
475 # chown root:root /usr/lib/libemail-mapi.so
476 # chown root:root /usr/lib/libemail-emn-storage.so.0
479 # chown root:root /usr/bin/email-service_initDB
480 # chown root:root /usr/bin/email-service
483 if [ ${USER} = "root" ]
485 chown root:root /opt/dbspace/.email-service.db
486 chown root:root /opt/dbspace/.email-service.db-journal