Home » Oki Manuals » Printers » Oki B430d-beige » Manual Viewer

Oki B430d-beige Print Job Accounting Users Manual - Page 146

Saving managed data to the database, Configuring the database software settings

Add to My Manuals
Save this manual to your list of manuals

Page 146 highlights

7. Saving managed data to the database 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 146) • Settings for connecting to the database (page 147) 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 148) Configuring the database 7 software settings Connecting to MySQL Database When using MySQL on a different computer that contains the server software, libmysql. dll needs to exist in the server software installation folder. ❶ Copy libmysql.dll from the "bin" folder or "lib" folder of the installation folder of the MySQL installation to be used. ❷ 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. ❸ Start [MySQL Server Instance Config Wizard] and check the [Include Bin Directory in Windows PATH] check box to complete the settings. ❹ Start the command prompt in Windows OS. ❺ Execute the following command. Mysql -u root -p ❻ Enter the administrator "root" password that was set when MySQL was installed. ❼ Execute the following command. grant all privileges on *.* to 'root'@'%' with grant option; - 146 -

Section	Page
About this Manual	2
Notations	2
Terms	2
Important	3
Trademark Information	3
About This Manual	3
Manual Copyright	3
License Agreement	4
Contents	5
1. Before Setup	12
What is Print Job Accounting?	12
Special Features of Print Job Accounting	12
Print Job Accounting Mechanisms	13
Print Job Accounting Configuration	14
Print Job Accounting Installation Process	15
Setting up server software	15
Setting up Client Software	15
Preparing User Information	16
Information required for settings	16
Example of assigning the Job Account ID	18
2. Setting up the server software	22
Operating Environment	22
Installing the server software	22
Activating the license for the server software	24
Server software window configuration	25
Starting the server software	26
Setting up the server software	26
Configuring Active Directory settings (Only Enterprise edition)	26
Configuring Database settings (Only Enterprise edition)	26
Adding a printer that acquires the log	27
Registering the Job Account ID and Name	31
Managing multiple printers as a group	34
Changing the printer group	35
Deleting the printer group	35
Backing up printer settings	35
Restoring printer settings	36
3. Setting up the client software	40
Setting up in Windows	40
Operating Environment	40
Installing the Client Software	40
Setting Job Accounting Mode	41
Setting up in Mac OS	43
Configuring the plugins	43
Setting up in Mac OS X	43
Operating Environment	43
Installing Client Software	43
Registering the JobAccountingID	43
Registering multiple users together	44
Changing the JobAccountingID and UserName	45
Deleting the JobAccountingID and UserName	45
4. Job Account ID Management	48
Adding the Job Account ID	48
Adding manually	48
Creating a CSV file to add in a batch	50
Importing users registered in Windows	52
Setting functions or use restrictions	53
Registering the same Job Account ID to multiple printers	56
Managing multiple users as a group	57
Changing the user group	61
Deleting a Job Account ID or User Group	62
Changing Job Account ID and User Group settings	63
Job Account ID tab	63
User Restriction tab	64
Limit Value tab	64
Valid Period	65
Checking the usage status of individual Job Account IDs and User Groups	65
Checking the usage status	65
Resetting the usage status	66
Receiving log results by e-mail	67
Associating Job Account IDs to authentication users	68
Adding manually	68
Creating a CSV file to add in a batch	70
Importing users registered in Windows	71
Importing from a different printer	73
5. Managing use restrictions	76
Setting use restrictions to the login name	76
Adding manually	76
Adding from the log	77
Creating a CSV file to add in a batch	78
Importing users registered in Windows	80
Adding unregistered item settings	81
Setting use restrictions to the application name	82
Adding manually	82
Adding from the log	84
Adding unregistered item settings	85
Setting use restrictions to the document name	86
Adding manually	86
Adding from the log	87
Adding unregistered item settings	88
Setting use restrictions to the host name	89
Adding manually	89
Adding from the log	91
Adding unregistered item settings	92
Adding settings to printers	93
Displaying use restrictions that are already registered in printers	93
Deleting use restrictions	94
Changing use restrictions	95
Deleting all use restrictions	97
Temporarily disabling use restrictions	98
Enabling use restrictions	99
6. Syncing with Active Directory User Information	102
Setting the printer to be linked with Active Directory	102
Configuring the Active Directory settings	104
Connecting to an Active Directory in a specified domain	106
To add attributes to the displayed user list	108
To hide attributes in the user list	109
To change the order of attributes displayed in the user list	110
Specifying attributes for obtaining IC card information	111
Adding an Active Directory user	112
Searching for users	112
Referencing members that belong to groups	114
Setting use restrictions or limit values	114
Copying user settings from other groups	117
Applying settings to the printer	117
Changing Active Directory user settings	119
Changing the priority level of groups	122
Applying settings to the printer	123
Deleting an Active Directory user	124
Assigning a Job Account ID to an Active Directory user	125
Automatically assigning a Job Account ID	125
Manually assigning a Job Account ID	126
Assigning a Job Account ID from a file	127
Changing the assigned Job Account ID	129
Exporting data for client software	130
Exporting the IC card compatibility table	131
Setting the printer to which the IC card compatibility table is registered	131
Creating an IC card compatibility table	133
Adding IC card information to the IC card compatibility table	134
Registering the IC card compatibility table to the printer	137
Displaying error messages at server software startup	138
Sending an error notification mail to the administrator	139
Permitting alternative authentication to IC cards	140
Setting the automatic update service	141
Immediately updating user settings	143
Selecting the users to apply settings to	143
7. Saving managed data to the database	146
Configuring the database software settings	146
Connecting to MySQL Database	146
Settings for connecting to the database	147
Setting the printer for recording managed data to the database	148
Exporting the fees to the database	150
Deleting fees from the database	151
Exporting the log to the database	153
Deleting logs from the database	154
Exporting the printer users to the database	155
Registering database connection users	156
Changing the permissions for database connection users	158
Changing the password for database connection users	160
Deleting database connection users	161
Updating the database to the newest version	163
Displaying error messages at server software startup	164
Sending an error notification mail to the administrator	165
Creating a website[Microsoft Windows 8.1]	166
Creating a website[Microsoft WindowsServer 2012 R2]	166
Creating a website [Microsoft Windows 8]	166
Creating a website [Microsoft Windows Server 2012]	166
Creating a website [Microsoft Windows 7]	166
Installing the internet information service	166
Configure settings forbrowsing a Microsoft Accessdatabase	167
Configure settings forbrowsing a MySQL database	167
Checking the version ofMicrosoft SQL Server orMicrosoft SQL Server Express	167
Creating a website	167
Setting the website	169
Accessing using the Windowsauthentication method	169
Accessing using the Userauthentication method	169
Creating a website [Microsoft Windows Server 2008]	169
Installing the internet information service	169
Configure settings for browsing a Microsoft Access database	169
Configure settings for browsing a MySQL database	170
Checking the version of Microsoft SQL Server or Microsoft SQL Server Express	170
Creating a website	170
Setting the website	171
Accessing using the Windows authentication method	171
Accessing using the User authentication method	171
Creating a website [Microsoft Windows Vista]	171
Installing the internet information service	171
Configure settings for browsing a Microsoft Access database	172
Configure settings for browsing a MySQL database	172
Checking the version of Microsoft SQL Server or Microsoft SQL Server Express	172
Creating a website	173
Setting the website	174
Accessing using the Windows authentication method	174
Accessing using the User authentication method	174
Creating a website [Microsoft Windows Server 2003 ]	175
Creating a website	175
Setting the website	176
Accessing using the Windows authentication method	176
Accessing using the User authentication method	176
Browsing the database from the website	176
8. Fees	180
Creating fee charge definitions	180
Creating a definition	180
Setting printer fee definitions	185
Changing fee charge definitions	186
Deleting fee charge definitions	186
9. Operating the Log	188
What is the Log?	188
Acquiring the Log	188
Information that can be acquired	188
Changing the log acquisition interval and time	194
Changing the deadline	195
Immediately acquiring the log	196
Notifying the printer of the time	196
Changing the log save location	197
Displaying the Log	197
Displaying the Log	197
Displaying all log items (detail display)	199
Changing log items to be displayed	199
Deleting the Log	200
Outputting the Log as a CSV file	200
Outputting as a CSV file	200
Changing log items to be exported	201
Automatically outputting the Log as a CSV file	201
Sending a mail to the log administrator	202
Exiting log acquisition	202
10. Aggregating logs	206
Aggregating logs	206
Items that can be aggregated	206
Displaying the aggregate	209
Displaying all aggregated items (detail display)	210
Changing aggregate items	211
Outputting the aggregation results as a CSV file	211
Outputting as a CSV file	211
Changing the log items to be exported	212
11. Client Software	214
Changing Job Accounting Mode	214
Types of Job Accounting Mode	214
Using Tab Mode	215
Using Popup Mode	216
Switching each user for a Job Account ID in hidden mode	217
Acquiring user information from files in hide mode	219
Using the same Job Account ID for all users in hide mode	220
Using in an unsupported mode	221
12. Operation and Management	224
Operation and Management	224
Setting the outgoing mail function	224
Sending print prohibited/permitted by mail	227
Notifying the log acquisition status by email	228
Limiting the size and number of attachments	228
Carrying over the unused print limit quantity	229
Deleting a registered printer	230
Changing the printer connection destination or IP address	231
Automatically reconnecting when the printer IP address is changed	232
To change the server to a different computer	233
Checking the server ID	233
Installing/uninstalling a built-in hard disk or SD memory card to the printer	234
Prohibiting initialization of the built-in hard disk, SD memory card, or flash memory	234
Operations when the log is full	235
Updating setting information when an option is installed (Only Enterprise edition)	235
Changing the number of printers connected at the same time	236
Export job information ina file if this utility acquireslogs	237
Uninstalling software	239
Uninstalling server software	239
Uninstalling the client software (Windows)	239
Uninstalling plugins (MacOS)	239
Uninstalling client software (Mac OS X)	239