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/org.tizen.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),
286 CREATE TABLE mail_box_tbl
291 mailbox_name VARCHAR(256),
292 mailbox_type INTEGER,
294 sync_with_server_yn INTEGER,
295 modifiable_yn INTEGER,
296 total_mail_count_on_server INTEGER,
297 has_archived_mails INTEGER,
298 mail_slot_size INTEGER
300 CREATE TABLE mail_read_mail_uid_tbl
303 local_mbox VARCHAR(129) ,
305 mailbox_name VARCHAR(129) ,
310 idx_num INTEGER PRIMARY KEY
312 CREATE TABLE mail_rule_tbl
315 rule_id INTEGER PRIMARY KEY,
318 action_type INTEGER ,
319 dest_mailbox VARCHAR(129),
323 CREATE TABLE mail_tbl
325 mail_id INTEGER PRIMARY_KEY,
327 mailbox_name VARCHAR(129),
328 mailbox_type INTEGER,
330 date_time VARCHAR(129),
331 server_mail_status INTEGER,
332 server_mailbox_name VARCHAR(129),
333 server_mail_id VARCHAR(129),
334 message_id VARCHAR(257),
335 full_address_from UCS2TEXT,
336 full_address_reply UCS2TEXT,
337 full_address_to UCS2TEXT,
338 full_address_cc UCS2TEXT,
339 full_address_bcc UCS2TEXT,
340 full_address_return UCS2TEXT,
341 email_address_sender UCS2TEXT collation user1,
342 email_address_recipient UCS2TEXT collation user1,
343 alias_sender UCS2TEXT,
344 alias_recipient UCS2TEXT,
345 body_download_status INTEGER,
346 file_path_plain VARCHAR(257),
347 file_path_html VARCHAR(257),
349 flags_seen_field BOOLEAN,
350 flags_deleted_field BOOLEAN,
351 flags_flagged_field BOOLEAN,
352 flags_answered_field BOOLEAN,
353 flags_recent_field BOOLEAN,
354 flags_draft_field BOOLEAN,
355 flags_forwarded_field BOOLEAN,
360 report_status INTEGER,
361 attachment_count INTEGER,
362 inline_content_count INTEGER,
364 thread_item_count INTEGER,
365 preview_text UCS2TEXT,
366 meeting_request_status INTEGER,
367 FOREIGN KEY(account_id) REFERENCES mail_account_tbl(account_id)
369 CREATE TABLE mail_meeting_tbl
371 mail_id INTEGER PRIMARY KEY,
373 mailbox_name UCS2TEXT ,
374 meeting_response INTEGER,
378 global_object_id UCS2TEXT ,
380 standard_name UCS2TEXT ,
381 standard_time_start_date INTEGER,
382 standard_bias INTEGER,
383 daylight_name UCS2TEXT ,
384 daylight_time_start_date INTEGER,
385 daylight_bias INTEGER
387 CREATE TABLE mail_local_activity_tbl
392 activity_type INTEGER,
393 server_mailid VARCHAR(129),
394 src_mbox VARCHAR(129),
395 dest_mbox VARCHAR(129)
399 CREATE UNIQUE INDEX mail_account_idx1 ON mail_account_tbl (account_bind_type, account_id);
400 CREATE UNIQUE INDEX mail_attachment_idx1 ON mail_attachment_tbl (mail_id, attachment_id);
401 CREATE UNIQUE INDEX mail_box_idx1 ON mail_box_tbl (account_id, local_yn, mailbox_name);
402 CREATE UNIQUE INDEX mail_idx1 ON mail_tbl (mail_id, account_id);
403 CREATE UNIQUE INDEX mail_read_mail_uid_idx1 ON mail_read_mail_uid_tbl (account_id, local_mbox, local_uid, mailbox_name, s_uid);
404 CREATE UNIQUE INDEX mail_meeting_idx1 ON mail_meeting_tbl (mail_id);
405 CREATE INDEX mail_idx_date_time ON mail_tbl (date_time);
406 CREATE INDEX mail_idx_thread_item_count ON mail_tbl (thread_item_count);
409 echo "[EMAIL-SERVICE] Finish Creating Email Tables."
412 #################################################################
413 # Change file permission
414 #################################################################
415 #echo "[EMAIL-SERVICE] Start setting permission ..."
417 #chmod 644 /usr/lib/libemail-ipc.so.0.0.0
418 #chmod 644 /usr/lib/libemail-core.so.0.0.0
419 #chmod 644 /usr/lib/libemail-emn-storage.so.0.0.0
420 #chmod 644 /usr/lib/libemail-base.so.0.0.0
421 #chmod 644 /usr/lib/libem-storage.so.0.0.0
422 #chmod 644 /usr/lib/libem-network.so.0.0.0
423 #chmod 644 /usr/lib/libemail-mapi.so.0.0.0
424 #chmod 644 /usr/lib/libem-storage.so
425 #chmod 644 /usr/lib/libemail-base.so.0
426 #chmod 644 /usr/lib/libem-network.so.0
427 #chmod 644 /usr/lib/libemail-core.so.0
428 #chmod 644 /usr/lib/libemail-emn-storage.so
429 #chmod 644 /usr/lib/libemail-ipc.so
430 #chmod 644 /usr/lib/libemail-mapi.so.0
431 #chmod 644 /usr/lib/libem-storage.so.0
432 #chmod 644 /usr/lib/libem-network.so
433 #chmod 644 /usr/lib/libemail-ipc.so.0
434 #chmod 644 /usr/lib/libemail-core.so
435 #chmod 644 /usr/lib/libemail-base.so
436 #chmod 644 /usr/lib/libemail-mapi.so
437 #chmod 644 /usr/lib/libemail-emn-storage.so.0
440 #chmod 700 /usr/bin/email-service_initDB
441 #chmod 700 /usr/bin/email-service
444 chmod 644 /opt/dbspace/.email-service.db
445 chmod 644 /opt/dbspace/.email-service.db-journal
448 #################################################################
450 #################################################################
451 #echo "[EMAIL-SERVICE] Start setting owner ..."
454 # chown root:root /usr/lib/libemail-ipc.so.0.0.0
455 # chown root:root /usr/lib/libemail-core.so.0.0.0
456 # chown root:root /usr/lib/libemail-emn-storage.so.0.0.0
457 # chown root:root /usr/lib/libemail-base.so.0.0.0
458 # chown root:root /usr/lib/libem-storage.so.0.0.0
459 # chown root:root /usr/lib/libem-network.so.0.0.0
460 # chown root:root /usr/lib/libemail-mapi.so.0.0.0
461 # chown root:root /usr/lib/libem-storage.so
462 # chown root:root /usr/lib/libemail-base.so.0
463 # chown root:root /usr/lib/libem-network.so.0
464 # chown root:root /usr/lib/libemail-core.so.0
465 # chown root:root /usr/lib/libemail-emn-storage.so
466 # chown root:root /usr/lib/libemail-ipc.so
467 # chown root:root /usr/lib/libemail-mapi.so.0
468 # chown root:root /usr/lib/libem-storage.so.0
469 # chown root:root /usr/lib/libem-network.so
470 # chown root:root /usr/lib/libemail-ipc.so.0
471 # chown root:root /usr/lib/libemail-core.so
472 # chown root:root /usr/lib/libemail-base.so
473 # chown root:root /usr/lib/libemail-mapi.so
474 # chown root:root /usr/lib/libemail-emn-storage.so.0
477 # chown root:root /usr/bin/email-service_initDB
478 # chown root:root /usr/bin/email-service
481 if [ ${USER} = "root" ]
483 chown root:root /opt/dbspace/.email-service.db
484 chown root:root /opt/dbspace/.email-service.db-journal