- 142 -
7. Saving managed data to the database
7
7. Saving managed data to the database
This section explains how to export the log, Job Account ID, and fee charge definition to
the database, and how to browse the log, Job Account ID, and fee charge definition from a
web browser. The log can be exported to the database from the point at which it is obtained
from the printer. The Job Account ID can be exported to the database at the point when it
is registered to or deleted form the printer, or when the settings are changed. To export the
managed information to the database, the following settings need to be configured.
• Database software settings (page 132)
• Settings for connecting to the database (page 143)
In order to export the managed log and Job Account ID information to the database, the
following settings also need to be configured in addition to the settings listed above.
• Settings for recording information to the database of the printer that you want to export
managed information to must be enabled (page 144)
Configuring the database
software settings
Connecting using Microsoft
SQL Server or Microsoft SQL
Server Express
When the server software is installed
in the Windows 2000 operating system
and connects to Microsoft SQL Server
or Microsoft SQL Server Express, it is
necessary to install version 2.7 or higher of
MDAC (Microsoft Data Access Components)
to the Windows 2000 operating system.
MDAC can be downloaded from the
Microsoft website.
Connecting to MySQL
Database
When using MySQL on a different computer
to that which contains the server software,
libmysql.dll needs to exist in the server
software installation folder.
1
Copy libmysql.dll from the "bin" folder or
"lib" folder of the installation folder of the
MySQL installation to be used
2
Paste the file into the installation folder of
the server software.
Depending on the MySQL version, the
administrator "root" permissions may not
be sufficient. In this case, increase the
permission level.
1
Start [MySQL Server Instance Config
Wizard] and check the [Include Bin
Directory in Windows PATH] check box to
complete the settings.
2
Start the command prompt in Windows
OS.
3
Execute the following command.
Mysql –u root –p
4
Enter the administrator "root" password
that was set when MySQL was installed.
5
Execute the following command.
grant all privileges on *.* to 'root'@'%'
with grant option;
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
