1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
|
Name: email-service
Summary: E-mail Framework Middleware package
Version: 0.10.90
Release: 1
Group: System/Libraries
License: TBD
Source0: %{name}-%{version}.tar.gz
Source1: email.service
Requires: connman
Requires: webkit2-efl
Requires(post): /sbin/ldconfig
Requires(post): systemd
Requires(post): /usr/bin/sqlite3
Requires(post): /usr/bin/vconftool
Requires(preun): systemd
Requires(postun): /sbin/ldconfig
Requires(postun): systemd
BuildRequires: cmake
BuildRequires: pkgconfig(glib-2.0)
BuildRequires: pkgconfig(gthread-2.0)
BuildRequires: pkgconfig(aul)
BuildRequires: pkgconfig(vconf-internal-keys)
BuildRequires: pkgconfig(vconf)
BuildRequires: pkgconfig(dlog)
BuildRequires: pkgconfig(db-util)
BuildRequires: pkgconfig(dbus-1)
BuildRequires: pkgconfig(dbus-glib-1)
BuildRequires: pkgconfig(contacts-service2)
BuildRequires: pkgconfig(uw-imap-toolkit)
BuildRequires: pkgconfig(drm-client)
BuildRequires: pkgconfig(openssl)
BuildRequires: pkgconfig(alarm-service)
BuildRequires: pkgconfig(mm-player)
BuildRequires: pkgconfig(mm-session)
BuildRequires: pkgconfig(secure-storage)
BuildRequires: pkgconfig(notification)
BuildRequires: pkgconfig(accounts-svc)
BuildRequires: pkgconfig(libsystemd-daemon)
BuildRequires: pkgconfig(capi-base-common)
BuildRequires: pkgconfig(libcurl)
BuildRequires: pkgconfig(libxml-2.0)
BuildRequires: pkgconfig(gconf-2.0)
BuildRequires: pkgconfig(cert-svc)
BuildRequires: pkgconfig(badge)
BuildRequires: pkgconfig(feedback)
%description
E-mail Framework Middleware Library/Binary package
%package devel
Summary: E-mail Framework Middleware Development package
Group: Development/Libraries
Requires: %{name} = %{version}-%{release}
%description devel
E-mail Framework Middleware Development package
%prep
%setup -q
%build
export CFLAGS="${CFLAGS} -fPIC -Wall -g -fvisibility=hidden"
export CXXFLAGS="${CXXFLAGS} -fPIC -Wall -g -fvisibility=hidden"
export LDFLAGS="${LDFLAGS} -Wl,--hash-style=both -Wl,--rpath=%{_prefix}/lib -Wl,--as-needed"
cmake . -DCMAKE_INSTALL_PREFIX=%{_prefix}
make %{?_smp_mflags}
%install
mkdir -p %{buildroot}/usr/share/license
%make_install
mkdir -p %{buildroot}%{_libdir}/systemd/user/tizen-middleware.target.wants
install -m 0644 %SOURCE1 %{buildroot}%{_libdir}/systemd/user/
ln -sf ../email.service %{buildroot}%{_libdir}/systemd/user/tizen-middleware.target.wants/
%post
/sbin/ldconfig
#################################################################
# Add preset account information
#################################################################
echo "[EMAIL-SERVICE] Start adding preset account information..."
################################################################################################
# for default mail slot szie
vconftool set -t int db/private/email-service/slot_size "100" -g 6514
# for latest mail id
vconftool set -t int db/private/email-service/latest_mail_id "0" -g 6514
# for default account id
vconftool set -t int db/private/email-service/default_account_id "0" -g 6514
# for badge
vconftool set -t int db/badge/com.samsung.email "0" -g 6514
# for default account id
vconftool set -t int memory/sync/email "0" -i -g 6514
# for priority send
vconftool set -t string db/private/email-service/noti_ringtone_path "Whistle.mp3" -g 6514
vconftool set -t int db/private/email-service/noti_rep_type "0" -g 6514
vconftool set -t bool db/private/email-service/noti_notification_ticker "0" -g 6514
vconftool set -t bool db/private/email-service/noti_display_content_ticker "0" -g 6514
vconftool set -t bool db/private/email-service/noti_badge_ticker "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/1 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/2 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/3 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/4 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/5 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/6 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/7 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/8 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/9 "0" -i -g 6514
vconftool set -t int db/private/email-service/noti_private_id/10 "0" -i -g 6514
#################################################################
# 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 'account_count=$(sqlite3 /opt/usr/dbspace/.email-service.db "select COUNT(*) from mail_account_tbl")' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo 'if [ "$(echo "$account_count" | cut -c0-1)" == "0" ]' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo 'then' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo ' echo 'There is no account'' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo 'elif [ "$(echo "$account_count" | cut -c0-1)" == "" ]' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo 'then' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo ' echo 'DB failure'' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo 'else' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo ' /usr/bin/email-service & ' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
echo 'fi' >> ${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 ..."
mkdir -p /opt/usr
mkdir -p /opt/usr/dbspace
sqlite3 /opt/usr/dbspace/.email-service.db 'PRAGMA journal_mode = PERSIST;
CREATE TABLE mail_account_tbl
(
account_id INTEGER PRIMARY KEY,
account_name VARCHAR(51),
logo_icon_path VARCHAR(256),
user_data BLOB,
user_data_length INTEGER,
account_svc_id INTEGER,
sync_status INTEGER,
sync_disabled INTEGER,
default_mail_slot_size INTEGER,
user_display_name VARCHAR(31),
user_email_address VARCHAR(129),
reply_to_address VARCHAR(129),
return_address VARCHAR(129),
incoming_server_type INTEGER,
incoming_server_address VARCHAR(51),
incoming_server_port_number INTEGER,
incoming_server_user_name VARCHAR(51),
incoming_server_password VARCHAR(51),
incoming_server_secure_connection INTEGER,
retrieval_mode INTEGER,
keep_mails_on_pop_server_after_download INTEGER,
check_interval INTEGER,
auto_download_size INTEGER,
outgoing_server_type INTEGER,
outgoing_server_address VARCHAR(51),
outgoing_server_port_number INTEGER,
outgoing_server_user_name VARCHAR(51),
outgoing_server_password VARCHAR(51),
outgoing_server_secure_connection INTEGER,
outgoing_server_need_authentication INTEGER,
outgoing_server_use_same_authenticator 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,
pop_before_smtp INTEGER,
incoming_server_requires_apop INTEGER,
smime_type INTEGER,
certificate_path VARCHAR(256),
cipher_type INTEGER,
digest_type 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_id INTEGER,
attachment_save_status INTEGER,
attachment_drm_type INTEGER,
attachment_drm_method INTEGER,
attachment_inline_content_status INTEGER,
attachment_mime_type VARCHAR(257)
);
CREATE TABLE mail_box_tbl
(
mailbox_id INTEGER PRIMARY KEY,
account_id INTEGER,
local_yn INTEGER,
mailbox_name VARCHAR(256),
mailbox_type INTEGER,
alias VARCHAR(256),
deleted_flag INTEGER,
modifiable_yn INTEGER,
total_mail_count_on_server INTEGER,
has_archived_mails INTEGER,
mail_slot_size INTEGER,
no_select INTEGER,
last_sync_time DATETIME
);
CREATE TABLE mail_read_mail_uid_tbl
(
account_id INTEGER ,
mailbox_id INTEGER ,
local_uid INTEGER ,
mailbox_name VARCHAR(256) ,
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 ,
target_mailbox_id INTEGER ,
flag1 INTEGER ,
flag2 INTEGER
);
CREATE TABLE mail_tbl
(
mail_id INTEGER PRIMARY KEY,
account_id INTEGER,
mailbox_id INTEGER,
mailbox_name VARCHAR(129),
mailbox_type INTEGER,
subject TEXT,
date_time DATETIME,
server_mail_status INTEGER,
server_mailbox_name VARCHAR(129),
server_mail_id VARCHAR(129),
message_id VARCHAR(257),
reference_mail_id INTEGER,
full_address_from TEXT,
full_address_reply TEXT,
full_address_to TEXT,
full_address_cc TEXT,
full_address_bcc TEXT,
full_address_return TEXT,
email_address_sender TEXT collation user1,
email_address_recipient TEXT collation user1,
alias_sender TEXT,
alias_recipient TEXT,
body_download_status INTEGER,
file_path_plain VARCHAR(257),
file_path_html VARCHAR(257),
file_path_mime_entity 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 TEXT,
meeting_request_status INTEGER,
message_class INTEGER,
digest_type INTEGER,
smime_type 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_id INTEGER,
meeting_response INTEGER,
start_time INTEGER,
end_time INTEGER,
location TEXT ,
global_object_id TEXT ,
offset INTEGER,
standard_name TEXT ,
standard_time_start_date INTEGER,
standard_bias INTEGER,
daylight_name TEXT ,
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 TABLE mail_certificate_tbl
(
certificate_id INTEGER,
issue_year INTEGER,
issue_month INTEGER,
issue_day INTEGER,
expiration_year INTEGER,
expiration_month INTEGER,
expiration_day INTEGER,
issue_organization_name VARCHAR(256),
email_address VARCHAR(129),
subject_str VARCHAR(256),
filepath VARCHAR(256),
password VARCHAR(51)
);
CREATE TABLE mail_task_tbl
(
task_id INTEGER PRIMARY KEY,
task_type INTEGER,
task_status INTEGER,
task_priority INTEGER,
task_parameter_length INTEGER,
task_parameter BLOB,
date_time DATETIME
);
CREATE UNIQUE INDEX mail_account_idx1 ON mail_account_tbl (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 (mailbox_id);
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, mailbox_id, local_uid, mailbox_name, s_uid);
CREATE UNIQUE INDEX mail_meeting_idx1 ON mail_meeting_tbl (mail_id);
CREATE UNIQUE INDEX task_idx1 ON mail_task_tbl (task_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."
chgrp 6006 /opt/usr/dbspace/.email-service.db*
chmod 664 /opt/usr/dbspace/.email-service.db
chmod 664 /opt/usr/dbspace/.email-service.db-journal
mkdir -m775 -p /opt/usr/data/email/.email_data
chgrp 6006 /opt/usr/data/email/.email_data
mkdir -m775 -p /opt/usr/data/email/.email_data/tmp
chgrp 6006 /opt/usr/data/email/.email_data/tmp
mkdir -p /opt/share/cert-svc/certs/trusteduser/email
chgrp 6006 /opt/share/cert-svc/certs/trusteduser/email
if [ -f /opt/usr/dbspace/.email-service.db ]
then
chsmack -a 'email-service::db' /opt/usr/dbspace/.email-service.db*
fi
systemctl daemon-reload
if [ $1 == 1 ]; then
systemctl restart email.service
fi
%preun
if [ $1 == 0]; then
systemctl stop email.service
fi
%postun
/sbin/ldconfig
systemctl daemon-reload
%files
%manifest email-service.manifest
%exclude /usr/bin/email-test-app
%{_bindir}/email-service
/opt/usr/data/email/res/*
%{_libdir}/lib*.so.*
%{_libdir}/systemd/user/email.service
%{_libdir}/systemd/user/tizen-middleware.target.wants/email.service
/usr/share/dbus-1/services/email-service.service
/usr/share/license/email-service/LICENSE
%files devel
%{_includedir}/email-service/*.h
%{_libdir}/lib*.so
%{_libdir}/pkgconfig/*.pc
|