OKI C9800GA MFP [142/239] Configuring the database software settings

OKI C9800GA MFP [142/239] Configuring the database software settings
-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denitionto
thedatabase,andhowtobrowsethelog,JobAccountID,andfeechargedenition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congured.
•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congured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)
Conguring 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leintotheinstallationfolderof
theserversoftware.
DependingontheMySQLversion,the
administrator"root"permissionsmaynot
besufcient.Inthiscase,increasethe
permissionlevel.
1
Start[MySQLServerInstanceCong
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;

Содержание

Скачать