www.papercut.com
Open in
urlscan Pro
34.95.115.145
Public Scan
URL:
https://www.papercut.com/help/manuals/ng-mf/common/ext-db-upsizing/
Submission: On January 19 via manual from GB — Scanned from GB
Submission: On January 19 via manual from GB — Scanned from GB
Form analysis 1 forms found in the DOM
POST https://forms.hsforms.com/submissions/v3/public/submit/formsnext/multipart/8186336/525b820a-c332-44a2-b743-cfacfa396ead
<form id="hsForm_525b820a-c332-44a2-b743-cfacfa396ead" method="POST" accept-charset="UTF-8" enctype="multipart/form-data" novalidate=""
action="https://forms.hsforms.com/submissions/v3/public/submit/formsnext/multipart/8186336/525b820a-c332-44a2-b743-cfacfa396ead"
class="hs-form-private hsForm_525b820a-c332-44a2-b743-cfacfa396ead hs-form-525b820a-c332-44a2-b743-cfacfa396ead hs-form-525b820a-c332-44a2-b743-cfacfa396ead_af5c3fb7-bfc0-42e2-b41f-268ddb69d0a6 hs-form stacked"
target="target_iframe_525b820a-c332-44a2-b743-cfacfa396ead" data-instance-id="af5c3fb7-bfc0-42e2-b41f-268ddb69d0a6" data-form-id="525b820a-c332-44a2-b743-cfacfa396ead" data-portal-id="8186336"
data-test-id="hsForm_525b820a-c332-44a2-b743-cfacfa396ead">
<div class="hs_email hs-email hs-fieldtype-text field hs-form-field"><label id="label-email-525b820a-c332-44a2-b743-cfacfa396ead" class="" placeholder="Enter your " for="email-525b820a-c332-44a2-b743-cfacfa396ead"><span></span></label>
<legend class="hs-field-desc" style="display: none;"></legend>
<div class="input"><input id="email-525b820a-c332-44a2-b743-cfacfa396ead" name="email" required="" placeholder="Email*" type="email" class="hs-input" inputmode="email" autocomplete="email" value=""></div>
</div>
<div class="hs_amplitude_device_id hs-amplitude_device_id hs-fieldtype-text field hs-form-field" style="display: none;"><label id="label-amplitude_device_id-525b820a-c332-44a2-b743-cfacfa396ead" class="" placeholder="Enter your Amplitude Device ID"
for="amplitude_device_id-525b820a-c332-44a2-b743-cfacfa396ead"><span>Amplitude Device ID</span></label>
<legend class="hs-field-desc" style="display: none;"></legend>
<div class="input"><input name="amplitude_device_id" class="hs-input" type="hidden" value=""></div>
</div>
<div class="legal-consent-container">
<div>
<div class="hs-dependent-field">
<div class="hs_LEGAL_CONSENT.subscription_type_20660050 hs-LEGAL_CONSENT.subscription_type_20660050 hs-fieldtype-booleancheckbox field hs-form-field">
<legend class="hs-field-desc" style="display: none;"></legend>
<div class="input">
<ul class="inputs-list" required="">
<li class="hs-form-booleancheckbox"><label for="LEGAL_CONSENT.subscription_type_20660050-525b820a-c332-44a2-b743-cfacfa396ead" class="hs-form-booleancheckbox-display"><input
id="LEGAL_CONSENT.subscription_type_20660050-525b820a-c332-44a2-b743-cfacfa396ead" class="hs-input" type="checkbox" name="LEGAL_CONSENT.subscription_type_20660050" value="true"><span>
<p>Yes, subscribe me to PaperCut news, offers, product updates, newsletters and events.</p><span class="hs-form-required">*</span>
</span></label></li>
</ul>
</div>
</div>
</div>
<legend class="hs-field-desc checkbox-desc" style="display: none;"></legend>
</div>
<div class="hs-richtext">
<p>By filling out and submitting this form, you agree that you have read our <a href="https://www.papercut.com/privacy-policy/" target="_blank">Privacy Policy</a>, and agree to PaperCut handling your data in accordance with its terms.</p>
</div>
</div>
<div class="hs_recaptcha hs-recaptcha field hs-form-field">
<div class="input">
<div class="grecaptcha-badge" data-style="inline" style="width: 256px; height: 60px; box-shadow: gray 0px 0px 5px;">
<div class="grecaptcha-logo"><iframe title="reCAPTCHA" width="256" height="60" role="presentation" name="a-xypmeu4fkxm7" frameborder="0" scrolling="no"
sandbox="allow-forms allow-popups allow-same-origin allow-scripts allow-top-navigation allow-modals allow-popups-to-escape-sandbox allow-storage-access-by-user-activation"
src="https://www.google.com/recaptcha/enterprise/anchor?ar=1&k=6Ld_ad8ZAAAAAAqr0ePo1dUfAi0m4KPkCMQYwPPm&co=aHR0cHM6Ly93d3cucGFwZXJjdXQuY29tOjQ0Mw..&hl=en&v=Ya-Cd6PbRI5ktAHEhm9JuKEu&size=invisible&badge=inline&cb=q1rr4h2jc6y9"></iframe>
</div>
<div class="grecaptcha-error"></div><textarea id="g-recaptcha-response" name="g-recaptcha-response" class="g-recaptcha-response"
style="width: 250px; height: 40px; border: 1px solid rgb(193, 193, 193); margin: 10px 25px; padding: 0px; resize: none; display: none;"></textarea>
</div><iframe style="display: none;"></iframe>
</div><input type="hidden" name="g-recaptcha-response" id="hs-recaptcha-response" value="">
</div>
<div class="hs_submit hs-submit">
<div class="hs-field-desc" style="display: none;"></div>
<div class="actions"><input type="submit" class="hs-button primary large" value="Submit"></div>
</div><input name="hs_context" type="hidden"
value="{"embedAtTimestamp":"1705651203890","formDefinitionUpdatedAt":"1658376130808","lang":"en","legalConsentOptions":"{\"communicationConsentCheckboxes\":[{\"communicationTypeId\":20660050,\"label\":\"<p>Yes, subscribe me to PaperCut news, offers, product updates, newsletters and events.</p>\",\"required\":true}],\"legitimateInterestLegalBasis\":\"LEGITIMATE_INTEREST_PQL\",\"processingConsentType\":\"IMPLICIT\",\"processingConsentText\":\"<p>By filling out and submitting this form, you agree that you have read our <a href=\\\"https://www.papercut.com/privacy-policy/\\\" target=\\\"_blank\\\">Privacy Policy</a>, and agree to PaperCut handling your data in accordance with its terms.</p>\",\"processingConsentCheckboxLabel\":\"<p>Yes, subscribe me to PaperCut news, offers, product updates, newsletters and events.</p>\",\"isLegitimateInterest\":false}","embedType":"REGULAR","renderRawHtml":"true","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.224 Safari/537.36","pageTitle":"Upsize to an external database (RDBMS) | PaperCut","pageUrl":"https://www.papercut.com/help/manuals/ng-mf/common/ext-db-upsizing/","isHubSpotCmsGeneratedPage":false,"hutk":"0fb9dc93b8938dfcc9b2c1a16c523331","__hsfp":412147705,"__hssc":"154692263.1.1705651207601","__hstc":"154692263.0fb9dc93b8938dfcc9b2c1a16c523331.1705651207601.1705651207601.1705651207601.1","formTarget":"#hbspt-form-af5c3fb7-bfc0-42e2-b41f-268ddb69d0a6","boolCheckBoxFields":"LEGAL_CONSENT.subscription_type_20660050","rumScriptExecuteTime":918,"rumTotalRequestTime":1203.1999998092651,"rumTotalRenderTime":1265.6999998092651,"rumServiceResponseTime":285.19999980926514,"rumFormRenderTime":62.60000038146973,"connectionType":"4g","firstContentfulPaint":0,"largestContentfulPaint":0,"locale":"en","timestamp":1705651207612,"originalEmbedContext":{"portalId":"8186336","formId":"525b820a-c332-44a2-b743-cfacfa396ead","region":"na1","target":"#hbspt-form-af5c3fb7-bfc0-42e2-b41f-268ddb69d0a6","isBuilder":false,"isTestPage":false,"isPreview":false,"isMobileResponsive":true},"correlationId":"af5c3fb7-bfc0-42e2-b41f-268ddb69d0a6","renderedFieldsIds":["email","amplitude_device_id","LEGAL_CONSENT.subscription_type_20660050"],"captchaStatus":"LOADED","emailResubscribeStatus":"NOT_APPLICABLE","isInsideCrossOriginFrame":false,"source":"forms-embed-1.4529","sourceName":"forms-embed","sourceVersion":"1.4529","sourceVersionMajor":"1","sourceVersionMinor":"4529","allPageIds":{},"_debug_embedLogLines":[{"clientTimestamp":1705651203989,"level":"INFO","message":"Retrieved pageContext values which may be overriden by the embed context: {\"pageTitle\":\"Upsize to an external database (RDBMS) | PaperCut\",\"pageUrl\":\"https://www.papercut.com/help/manuals/ng-mf/common/ext-db-upsizing/\",\"userAgent\":\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.6099.224 Safari/537.36\",\"isHubSpotCmsGeneratedPage\":false}"},{"clientTimestamp":1705651203990,"level":"INFO","message":"Retrieved countryCode property from normalized embed definition response: \"GB\""},{"clientTimestamp":1705651207608,"level":"INFO","message":"Retrieved analytics values from API response which may be overriden by the embed context: {\"hutk\":\"0fb9dc93b8938dfcc9b2c1a16c523331\"}"}]}"><iframe
name="target_iframe_525b820a-c332-44a2-b743-cfacfa396ead" style="display: none;"></iframe>
</form>Text Content
Hey there! We use cookies. Why? They let us personalize content, track usage,
and analyze data on our end to improve your experience. To learn more about the
different cookies we’re using, check out our Privacy Policy.
OK, I understand
Skip to content
URGENT security message for all NG/MF customers
Everything you need to know about cloud printing
Language
Choose your language
* No results
* Global (English)
* Français (Français)
* España (Español)
* Deutschland (Deutsche)
* Suomi (Suomalainen)
* Italia (Italiano)
* Nederland (Nederlands)
* Portugal (Português)
* Россия (Pусский)
* Sverige (Svenska)
* Bolivia (Español)
* Brazil (Português)
* Colombia (Español)
* Ecuador (Español)
* El Salvador (Español)
* República Dominicana (Español)
* Guatemala (Español)
* Honduras (Español)
* Mexico (Español)
* Nicaragua (Español)
* Panamá (Español)
* Paraguay (Español)
* Peru (Español)
* Uruguay (Español)
* Venezuela (Español)
* 中国（简体中文)
* 台灣（繁體中文)
* 香港（繁體中文)
* 日本 (日本語)
* ประเทศไทย (ไทย)
Login
Choose your login
* No results
* PaperCut Hive
* PaperCut Pocket
* Partner Portal
* Students / Teachers
Contact
Contact us
* No results
* Sales
* Support
Search
Software
Our products
* PaperCut MF
Powerful print management server for printers and MFDs
* PaperCut Hive
Complete cloud-native print management for business
* PaperCut NG
DIY print management server for everyone
* PaperCut Pocket
Cloud print management solution for businesses with simple needs
* Compare features
PaperCut Product Suite comparison
Free tools
* PaperCut Mobility Print
A free Google Cloud Print alternative
* PaperCut QRdoc
The power of digital documents – on paper
* PaperCut Views
Real-time print analytics, insights and forecasts
Sustainability
* PaperCut Grows
Grow your sustainability story.
In the percolator
* Projects in beta
Features in progress
Popular Features
* Print rooms
Track and manage all your printing activity
* Forest Positive Printing
Go further than waste reduction
* Print Deploy
Print queues made easy
* Microsoft Universal Print
Take control of your Universal Print environment
Speak with sales
Solutions
For industries
* High School / K-12
Protect student information, cut costs, reduce waste
* Higher Education
Easy printing for coworking and serviced offices
* Healthcare
Safeguard patient information with compliance features
* Local Government
Reduce budget spend while increasing compliance
* Legal
Secure confidential client info and assign costs
* Small to medium business
Grow your business while reducing costs
* Large Enterprise
Protect your systems, information, and future growth
* Coworking
Easy printing for coworking and serviced offices
* Life Sciences
Protect your intellectual property and reduce your costs
What our customers say
“Sustainability is very important to Google nowadays,” says Ofer. “So the idea
that we could literally save paper on printing was appealing to us from the
get-go.”
Ofer Bar-Zakai, Google, US
* Customer Stories
100 million delighted users and counting. Read their stories
* Testimonials
Quotes written by our own customers
Speak with sales
Resources
Discover everything we do
* Easy printing
We’ve simplified printing for you and your end-users
* Cloud and print
Review our full suite of management solutions for cloud
* Waste control
Explore why this should be important to everyone
* Scanning
We’ve made scanning easier and more secure
* Overview
Explore all our products, and find real-world examples
Popular Resources
* Grid® Report for Print Management | Winter 2024
* Complete Guide to Printing in Education
* Get Print Resiliency and Security Without Servers
* Securing Your Print System with PaperCut Whitepaper
* Find more
Reports, White Papers, Case Studies, Ebooks and more
Have a read
* Blog
Read our latest news in tech, product updates, and more
Support
* Overview
* Help Center
* Manuals
* Knowledge base
* Known issues
* FAQs
Speak with sales
Software
Our products
* PaperCut MF
Powerful print management server for printers and MFDs
* PaperCut Hive
Complete cloud-native print management for business
* PaperCut NG
DIY print management server for everyone
* PaperCut Pocket
Cloud print management solution for businesses with simple needs
* Compare features
PaperCut Product Suite comparison
Free tools
* PaperCut Mobility Print
A free Google Cloud Print alternative
* PaperCut QRdoc
The power of digital documents – on paper
* PaperCut Views
Real-time print analytics, insights and forecasts
Sustainability
* PaperCut Grows
Grow your sustainability story.
In the percolator
* Projects in beta
Features in progress
Popular Features
* Print rooms
Track and manage all your printing activity
* Forest Positive Printing
Go further than waste reduction
* Print Deploy
Print queues made easy
* Microsoft Universal Print
Take control of your Universal Print environment
Speak with sales
Solutions
For industries
* High School / K-12
Protect student information, cut costs, reduce waste
* Higher Education
Easy printing for coworking and serviced offices
* Healthcare
Safeguard patient information with compliance features
* Local Government
Reduce budget spend while increasing compliance
* Legal
Secure confidential client info and assign costs
* Small to medium business
Grow your business while reducing costs
* Large Enterprise
Protect your systems, information, and future growth
* Coworking
Easy printing for coworking and serviced offices
* Life Sciences
Protect your intellectual property and reduce your costs
What our customers say
“Sustainability is very important to Google nowadays,” says Ofer. “So the idea
that we could literally save paper on printing was appealing to us from the
get-go.”
Ofer Bar-Zakai, Google, US
* Customer Stories
100 million delighted users and counting. Read their stories
* Testimonials
Quotes written by our own customers
Speak with sales
Resources
Discover everything we do
* Easy printing
We’ve simplified printing for you and your end-users
* Cloud and print
Review our full suite of management solutions for cloud
* Waste control
Explore why this should be important to everyone
* Scanning
We’ve made scanning easier and more secure
* Overview
Explore all our products, and find real-world examples
Popular Resources
* Grid® Report for Print Management | Winter 2024
* Complete Guide to Printing in Education
* Get Print Resiliency and Security Without Servers
* Securing Your Print System with PaperCut Whitepaper
* Find more
Reports, White Papers, Case Studies, Ebooks and more
Have a read
* Blog
Read our latest news in tech, product updates, and more
Support
* Overview
* Help Center
* Manuals
* Knowledge base
* Known issues
* FAQs
Speak with sales
CONTACT SALES
* Home
* ›
* Help
* ›
* Manuals
* ›
* NG MF
* ›
* Common
* ›
* Ext Db Upsizing
* Help Center home
* Product manuals
* PaperCut NG and MF manual
* Overview
* How does PaperCut NG/MF work?
* The Top-Ten Hidden Features!
* Example user information sheets
* Example 1: Printing with the popup confirmation window
* Example 2: Printing with shared accounts (for staff)
* Example 3: Printing using a Release Station
* Example 4: Refunding a print job (for staff)
* Example 5: Adding credit using a TopUp/Pre-Paid Card
* Example 6: Printing from a wireless network or laptop (Web Print)
* About This Guide
* Prerequisites
* Terminology used in this document
* Licensing and support
* Installing a license
* Technical support & further information
* End User License Agreement (EULA)
* PaperCut MF as a Subscription (EULA)
* Installation
* Implementation by example
* Scenario: The small school
* Scenario: The large school
* Scenario: The university
* Scenario: The small business
* Scenario: The medium to large business
* Scenario: The public library or Internet cafe/kiosk
* Capacity planning
* Database sizing and growth
* Print archives sizing and growth
* Network bandwidth planning
* Manage large client billing databases
* Installation on Windows
* Quick install: Windows
* Running in a Workgroup environment
* Option 1: Common username and passwords on all systems
* Option 2: Authenticating via popup
* Installation on Mac
* Quick install: Apple Mac
* Mac printing in detail
* Mac hosted print queues
* Windows hosted print queues
* Installation on Linux (CUPS and Samba)
* Quick install: Linux (CUPS and/or Samba)
* PaperCut NG/MF on Linux
* The installation process
* Advanced configuration & logs
* Backups & system management
* User directory and authentication
* Unix command-line Release Station client
* Remove PaperCut NG/MF from a Linux server
* Linux FAQ
* Installation on Novell OES Linux (iPrint)
* Testing the installation
* Advanced implementation
* Multi-Server and Multi-Site Deployments
* Resiliency with Site Servers
* Technical overview
* Offline operations
* Install a Site Server
* Common questions about Site Servers
* Configuring secondary print servers and locally attached printers
* Configure a Windows secondary print server
* Configure a Macintosh secondary print server
* Configure a Linux or Novell iPrint secondary print server
* Print monitoring architecture
* Multiple print servers
* Automating secondary server deployment on Windows
* Configuring Direct Printing
* Install the Direct Print Monitor
* Install the Direct Print Monitor on Windows computers
* Install the Direct Print Monitor on a Macintosh computer
* Install the Direct Print Monitor on a Linux computer
* Link direct print queues to a printer
* View linked print queues
* Link a print queue to a printer
* Unlink a print queue from a printer
* Configure a directly connected printer
* Configure Find-Me Printing for directly connected printers
* Clustering and high availability
* Application Server failover
* Microsoft Failover Cluster Manager (MSFCM) on Windows server
2012/2016
* Microsoft Cluster Server (MSCS) on Windows
* Virtual Machine clustering
* Veritas Cluster Server (VCS) on Windows
* Novell Cluster Services (NCS) on Novell OES Linux
* PaperCut User Client configuration
* Deployment on an external database (RDBMS)
* Upsize to an external RDBMS
* Configuring Microsoft SQL Express
* Configuring Microsoft SQL Server
* Configuring MySQL
* Configuring Oracle (and Oracle Express Edition)
* Configuring Azure SQL
* Web browser Single Sign-on (SSO)
* Plan for web SSO Implementation
* Configure web SSO
* Advanced LDAP Configuration
* LDAP Server Default Configuration
* Print authentication
* About authentication and printing
* Handling unauthenticated (non-domain) laptops
* The authentication cookbook - recipes by example
* PaperCut LPD service
* The PaperCut LPD service
* User Client
* Install the User Client on Windows
* Install the User Client with Microsoft Intune
* Install the User Client on macOS
* Install the User Client on Linux and Unix
* Tour
* Navigation
* Menu
* Basic user operations
* Basic printer operations
* Client software
* Interface levels
* Assigning administrator level access
* Charting, statistics, reports, and logs
* Configuration
* Services for Users
* User Client
* User web interface - original
* User web interface - new
* Environmental Dashboard / Windows Live Tiles
* Using the Environmental Dashboard
* Windows Live Tile installation
* Mobile User web interface
* Web widgets
* User management
* Group management
* Creating internal groups
* Set new user creation rules
* Set up quota allocations
* Set overdraft limits
* Enable username aliasing
* Add/update username aliases
* Maintain office/department history
* Disable printing for a user
* User card and ID numbers
* Prevent username clashes in Windows multi-domain environments
* Bulk user operations
* Batch import and update user data
* User management FAQs
* Guest and anonymous user management
* Internal users (users managed by PaperCut NG/MF)
* Anonymous guest printing
* Multiple personal accounts
* Why use multiple personal accounts?
* Configure multiple personal accounts
* Configuration examples
* Shared accounts
* Create a shared account
* Shared account naming guidelines
* Search for a shared account
* Batch import and update shared accounts
* Synchronize shared accounts with external source
* Bulk shared account operations
* Allocate a shared account quota
* Apply a cost multiplier to a shared account
* Customize shared accounts
* Grant access to shared accounts
* Account selection
* Account selection in non-domain environments (Workgroups)
* Printer management
* Add and remove/delete/ignore printers
* The template printer
* Copy printer settings
* Rename a printer
* Disable printers with time latches
* Set up differential charging
* Convert or block print jobs - filters and restrictions
* Manage printer groups
* Define cost adjustments
* Popup authentication
* Set the color detection method
* Switch to using SNMPv3
* Validate page counts using hardware checks
* Watermarking/job annotation
* Behavior on server connection failures
* Toner Levels (for supported printers)
* Refund print jobs
* Define custom printer fields
* Extract usernames in enterprise print environments (e.g. SAP,
Unix)
* Printer FAQs
* Find-Me printing and printer load balancing
* Find-Me printing
* Global Print Driver
* Requirements for job redirection (load balancing or Find-Me
printing)
* Advanced configuration
* Printer load balancing
* Find-Me printing and printer load balancing FAQ
* Secure print release
* Release Station interfaces
* Hold/release usage scenarios
* Install a Release Station
* Install a Release Station on Windows
* Install a Release Station on a Mac
* Configure a Release Station
* Secure print jobs at the printer while they're waiting to be
printed
* Prevent jobs being released when a printer/device is in error
* Prevent jobs being released from an MFD Release Station when a
device is in error
* Prevent jobs being released from a Standard Release Station
when a printer is in error
* Prevent jobs being released from a web-based Release Station
when a printer is in error
* Frequently Asked Questions: Prevent jobs being released when a
printer is in error
* Configure mobile print release
* Copier integration
* Overview
* Setup
* Device List and statuses
* Manage copiers
* Authentication methods
* About filters and restrictions
* Advanced configuration
* Release Stations and Find Me Printing
* Configure Secure Print Release
* Configure Secure Print Release with Find-Me printing
* Configure Secure Print Release with load balancing
* Configure Secure Print Release to support multiple operating
systems
* Allocating accounts to print jobs at the device
* System requirements PaperCut MF
* Configure the ability to allocate accounts to print jobs at
the device
* Changing attributes of print jobs at the device
* System requirements PaperCut MF
* Configure the ability to change attributes of print jobs at
the device
* Frequently Asked Questions
* Viewing attributes of print jobs at the device
* System requirements
* Configure the ability to view attributes of print jobs at
the device
* Frequently Asked Questions
* Prevent jobs from being released from an MFD Release Station
when a device is in error
* Frequently Asked Questions: Prevent jobs being released when a
printer is in error
* Integrated Scanning
* Integrated Scanning overview
* What is Integrated Scanning?
* Integrated Scanning at the MFD
* Scan PDF compression
* Scan to Fax explained
* Document Processing for Scans
* PaperCut MF Cloud Services
* Example Integrated Scanning implementations
* Setting up Integrated Scanning
* Prepare for Integrated Scanning implementation
* Configure Integrated Scanning / scan actions
* Configure Integrated Scanning notifications
* Enable Advanced Scan to Fax actions
* Configure advanced Integrated Scanning (config keys)
* Set up self-hosted Document Processing
* Substitution variables/macros
* Troubleshooting Integrated Scanning
* Troubleshooting Scan to Cloud Storage
* Troubleshooting Document Processing scans, including OCR
* Integration with Electronic Document Management Systems
* Mobile & BYOD printing
* Mobility Print
* Print Deploy (deploy print queues and drivers)
* Universal Print
* Email to Print
* Web Print (driver-less printing via a web browser)
* Set up Web Print
* Set up Web Print: Default mode
* Set up Web Print: Sandbox mode
* Enable Web Print on a printer
* Modify default Web Print settings (optional)
* Create a Web Print printer map or custom printer list
(optional)
* Advanced Web Print configuration (optional)
* Submit a Web Print job
* Scaling your Web Print environment
* Add or remove a Web Print server
* Monitor a Web Print server
* Troubleshooting Web Print problems
* Mobile Print Release-releasing print jobs on your mobile
* Mobile web client
* Self association for emails and email verification/validation
* TopUp/Pre-Paid Cards
* The card system
* Create new cards
* Redeem a card
* Reports
* Report types
* Report formats
* Generate filtered reports
* Create custom reports
* Schedule and email reports
* Export usage data from PaperCut NG/MF to a 3rd party tool
* Advanced reporting options
* Central Reports
* Prerequisites for Central Reports
* Set up Central Reports
* Run Central Reports
* Print Scripting (advanced feature)
* Creating print scripts
* Print script API reference
* Troubleshooting print scripts
* Tips for print scripts
*
* Device Scripting (advanced feature)
* Creating device scripts
* Device script API reference
* Device scripting examples
* Example: Set a daily color copying quota for all users
* Example: Prevent access to devices out of business hours
* Example: Discount the copying price for students during
off-peak hours and for staff at all times
* Troubleshooting device scripts
* Tips for device scripting
* Security (for advanced features)
* Print, device, and other advanced scripting
* Using extended Java classes in scripts
* Customization
* Customize the Login page
* Customize the Forgot Login Details page
* Customize the Admin web interface
* Customize the User web interface
* Customize the User Client
* Customize Mobile Print Release
* Customize report headers
* Limit the list of interface languages/translations
* Data access and custom reports
* Automation and scripting
* Custom user directory information providers
* Enable ports 80 (HTTP) and 443 (HTTPS)
* Web Cashier
* Set up Web Cashier
* Assign Web Cashier admin permissions
* Process purchases
* Deposit funds in a Web Cashier account
* View Web Cashier order history
* Customize the Web Cashier interface text
* Generate a Web Cashier report
* Advanced: Apply a regular expression to convert a card number
* Job Ticketing
* Print Archiving (viewing and content capture)
* Technical overview: How does archiving work?
* Set up Print Archiving
* Advanced archiving options and features
* Troubleshooting and known limitations
* Administration
* System management
* The dashboard
* Synchronize user and group details
* With Active Directory
* With LDAP
* With Azure AD - Standard or Secure LDAP
* Synchronize user and group details with standard Azure AD
* Synchronize user and group details with Azure AD Secure
LDAP
* With Google Cloud Directory
* Google Cloud Directory Group Names
* Synchronize users from multiple Google Cloud Directory
domains
* Google Cloud Directory: Education scenario
* Google Cloud Directory: FAQs
* Google Cloud Directory: Troubleshooting
* With custom programs (advanced feature)
* Manually synchronize with a user directory
* Create users on demand
* Assign administrator level access
* Set up system notifications and emails
* Configure email
* Configure an SMTP server for Office 365 or Microsoft 365 (*
Deprecated)
* Configure an SMTP server for Office 365 or Microsoft 365
Over OAuth2
* Configure an SMTP server for Google Workspace (*
Deprecated)
* Configure an SMTP server for Gmail Over OAuth2
* Configure an SMTP server for Gmail, Yahoo, or Outlook.com
* Configure a custom SMTP server
* Configure system notifications
* Manage system backups
* Set system security options
* Change the Application Server ports
* Configure how the Print Provider communicate over HTTPS
* Enforce HTTPS communication
* Restrict access to the Application Server
* Change the web session inactivity timeout
* Change the environmental impact reference values
* Set privacy options
* Using the Advanced Config Editor
* Add third-party integrations
* Logging
* Temp folder cleanup
* Server management
* Change the server address
* Change the network interface that PaperCut listens on
* Override the "Host" header for redirects
* Temp folder cleanup
* Tools - database, server-command scripting, and APIs (Advanced)
* Server commands (server-command)
* Database tool (db-tools)
* The XML Web Services API
* Generate SSL/HTTPS keys
* Use the PaperCut NG/MF self-signed certificate
* Use a trusted certificate
* Purchase and install a new trusted certificate
* Use an existing trusted PaperCut NG/MF certificate
* Use an existing trusted IIS certificate
* Renew an SSL certificate
* Advanced customization
* Troubleshoot SSL/HTTPS key generation
* Configure the User Client using the command-line
* Stop and start the Application Server
* Automate installation on Windows
* Import print job details
* Monitor print system health
* PaperCut system health monitoring overview
* Examples: Monitoring system health
* Example 1: Overall print system health monitoring
* Example 2: Printer health monitoring
* Example 3: Advanced system health monitoring
* Configure PaperCut NG/MF system health monitoring
* Discover the System Health interface authorization key
* Discover the printer and device status URLs
* System Health interface reference
* Status summary URLs
* Status per printer and per device URLs
* Status per Web Print application
* Advanced system statistics URLs
* Advanced system information URLs
* PDL transform language
* Upgrading
* Upgrade MF/NG from a previous version (upgrade steps)
* Troubleshooting upgrade issues
* (Legacy) Upgrade from PaperCut ChargeBack
* (Legacy) Upgrade from PaperCut Quota
* Troubleshooting & technical FAQs
* PaperCut Pocket and Hive manual
* Overview
* Data center locations
* How it works
* Edge Mesh and edge nodes
* Security considerations
* Printer discovery
* Authentication
* Mobile apps
* Getting started for administrators
* System requirements
* Supported printers
* Planning your install
* Multifunction device deployment checklist
* Set up local language
* Bulk deploy PaperCut software to users
* Deployment with Microsoft Intune
* Deployment with MS EndPoint Manager
* Deployment with Jamf
* Deployment with JumpCloud (Windows)
* Deployment with Microsoft Group Policy
* Deployment with ManageEngine Endpoint Central (Windows)
* Deployment to ChromeOS
* Network environments
* Onsite - no firewall port restrictions
* Onsite - multi-site with WAN connection
* Onsite - multi-site with no WAN connection
* Onsite - multi-subnet restricted network
* Off network - remote printing
* Getting started for end users
* Features in detail
* Print security
* Access control
* Secure print release
* Job removal
* Printer error alerts
* Watermarking and digital signatures
* Print job thumbnails
* Reduce waste
* Double sided printing
* Black and white printing
* More cost saving tips
* Easy Print & Scan
* Customizing the signup process
* Administration tools
* Print Tracking
* Integrated Scanning
* Scan PDF compression
* Quick Scan capture fields
* Other administration
* Managing your users
* Users
* Administrators
* Access codes & access cards
* Managing your printers
* Adding, removing or updating printers
* Choosing the print job delivery method
* Publishing or unpublishing printers
* Renaming a printer
* Changing a printer's IP address
* Printing printer labels
* Installing printer apps
* Print job finishing options (stapling units)
* Managing deployed print queues
* Preparing a print queue and driver
* Deploying your queue and driver
* How it works
* Technical and security details
* FAQs
* Managing Integrated Scanning
* Scan to automatically create folders
* Scan to email using an address book
* Scan to fax
* Managing your Edge Mesh
* Best practices for super nodes
* Reports and insights
* Logs and Story Tree
* Purchasing PaperCut Pocket
* Troubleshooting
* Installation
* Printer discovery
* Sending the print job
* Releasing the print job
* Queues & drivers
* A super node is offline
* Embedded app not connecting
* Users can’t install the PaperCut Printer app
* Job Trace
* Activity Log
* Email delivery
* Enable/download Deep Logs
* Help resources
* Knowledge base
* Known issues
* Service status
* Release notes
* Terms of Service
* Service Description
* End user license agreement
* Print Deploy manual
* Print Deploy overview
* Why is Print Deploy awesome?
* Print Deploy / Mobility Print - What product to use when
* How Print Deploy works
* Print environments supported by Print Deploy
* How it works - the basics
* How it works - the geeky version
* Set up Print Deploy
* System requirements: Print Deploy & PaperCut NG/MF
* Step 1: Determine your print environment
* Step 2: Add and configure zones in Print Deploy
* Step 3: Set up Print Deploy
* In a print server environment
* Computers are joined to a local domain
* Computers are not joined to a local domain
* Set up Print Deploy in a print serverless (Direct Print)
environment
* Import Mobility Print queues
* Support IPP(S) Print Servers on Windows computers
* Using an external PostgreSQL DB
* Roll out the client
* Choose your print queue/Print Deploy client installation method
* Manual Installation
* Install the Print Deploy client manually on computers
* Users install the Print Deploy client themselves
* Deploy print queues but not the monitoring tool
* Managed / MDM Installation
* Deploy print queues to Chromebooks using Google Chrome Enterprise
Administration and Print Deploy
* Deploy print queues using Jamf and Print Deploy
* Deploy print queues using VMWare Workspace ONE
* Deploy queues using another macOS compatible MDM
* Deploy print queues using Microsoft Intune and Print Deploy
* Deploy print queues using GPO and Print Deploy
* Deploy print queues using Kandji and Print Deploy
* List of installation parameters and filename configurations
* Configure Print Deploy (optional)
* Shared computers (Windows only)
* Configure the client
* Configure the Direct Print Monitor for large sites
* Customize the user login popup branding and text
* Change the client polling time
* Set the method used to determine the user’s identity
* Allow the client to update printers when a network change is
detected
* Configure Print Deploy in Virtual Desktop Infrastructure (VDI)
* Print Deploy VDI client overview
* Citrix
* Azure RDS
* Microsoft RDS
* VMWare Horizon
* VDI FAQs
* Troubleshooting - log analysis
* Enhance Print Deploy security (optional)
* Enhance Print Deploy security with a CA-signed certificate
* Enhance Print Deploy server security with a custom TLS setting
* Enable SSL certificate checking
* Print Deploy antivirus exclusions
* (Advanced) Set up an SSL/TLS certificate for Print Deploy
* (Advanced) Set up an SSL/TLS certificate for Mobility Print
* Maintain your print environment
* Troubleshooting
* FAQs
* Release History
* I want to give Print Deploy feedback?
* Mobility Print manual
* Overview
* Why is Mobility Print awesome?
* The Mobility Story
* What product to use when
* Which product is right for me?
* How it works
* Printer discovery - which method is best for you?
* Print job delivery and examples
* Mobility Print architecture
* Ghost Trap and Ghostscript
* Setting up Mobility Print
* System requirements
* Step 1: Install Mobility Print
* Step 2: Configure Mobility Print
* Select the printers to publish
* Printer discovery using mDNS
* Printer discovery using DNS
* Printer discovery using 'known host'
* Print authentication mode
* Cost allocation
* Advanced configuration
* Change the Mobility Print password
* Configure a server behind a firewall or NAT
* Disabling server auto-updates
* Configure Mobility Print behind a Network Load Balancer
* Restrict printer access per subnet
* Enhance Mobility Print server security with a custom TLS
setting
* Automatically disable new printers
* Implement a Trusted SSL Certificate for the Mobility Print
Administrator Interface
* Manage Single sign on for Chromebooks
* Set up Guest printing for Chromebook users
* Set up Mobility Print with a Site Server
* Step 3: Set up and test client printing
* Step 4: Roll out Mobility Print
* Setting up Cloud Print for Mobility Print
* Overview
* Step 1: Configure Cloud Print
* Step 2: Set up Cloud Print on the clients
* Chromebooks / ChromeOS
* Windows
* Mac / macOS
* Managing Cloud Print
* Cloud Print Security
* Setting up a device (mDNS/DNS)
* Windows
* Mac / macOS
* iPhone / iPad / iOS
* Android
* Chromebook / ChromeOS
* Setting up a device (known host)
* Setting up a device (Cloud Print)
* Troubleshooting
* Printer discovery problems in an mDNS environment
* Printer discovery problems in a DNS environment
* Troubleshooting Chromebook issues
* Troubleshooting Mobility Print Cloud Print
* Missing print jobs
* Subnet filtering
* Authentication
* End user and non-admin help
* FAQs
* Release history
* Job Ticketing manual
* Overview
* Getting Started
* Setup and Configuration
* Installation
* Install the software
* Logging in
* Explore the interfaces
* Configuration
* Manage rooms
* Configure room contact details
* Configure delivery options
* Define the Workflow
* Example customized Workflows
* Customize the Workflow
* Configure email notifications
* Personalize an operator profile
* Using JSON
* Using markdown
* Setting up products
* Job Ticketing scenarios: products
* Configure a product
* Product attribute reference
* Configure costs
* Step 1: Allocate a cost to product and delivery options
* Step 2: Setting up draft products
* Step 3: Create or change a cost script
* About the estimateCost(order) function
* Using functions
* Description functions (conditional statement)
* Cost calculation functions (For Loop)
* Date comparison functions (dateDiff)
* Using variables
* Using Order object attributes
* Using the Cost Script editor
* Using JavaScript
* Example cost scripts
* Step 4: Assign a cost script to each product
* Go live
* Test order submission
* Test order processing
* Publish your products
* Assign access to the Operator interface
* Enable Job Ticketing in the PaperCut MF User interface
* Share Job Ticketing with your customers
* System management
* Configure the maximum uploaded file size
* Configure the file storage location
* Change the currency symbol
* Configure the number of decimal places used for prices
* Enable or disable Gravatar
* Configure PDF page counter mode
* Prevent specific file types from being uploaded
* Configure the server address for links in emails
* Configure the database storage location
* Start and stop the Job Ticketing service
* Define your data backup strategy
* Archiving print job files
* Troubleshooting
* Managing orders
* Submit an order for a customer
* Process an order
* Change the status of an order
* Send comments to a customer
* Add an internal note to an order
* View notifications
* Download the file to print
* Print a job ticket
* Charge an order to an account
* Cancel an order
* Refund an order
* Order processing examples
* View order details
* View a summary of orders
* Workflow view
* Order List view
* View individual order details
* Manage customer announcements
* Placing an order
* Place a Print Room or FabLab order
* Approve a quote or proof
* Add comments to an order
* View comments from the print room
* Cancel an order
* Release notes
* Video tutorials
* FAQs
* Knowledge base
* KB Home
* FAQs
* How-to-articles
* Reference
* Troubleshooting
* Known Issues
* Sales and Licensing
* End-user articles
* Release notes
* PaperCut MF release notes
* PaperCut NG release notes
* System requirements
* PaperCut NG
* PaperCut MF
* PaperCut Pocket and Hive
* Support
* Home
*
* PaperCut NG and MF
*
* Common
*
* Ext Db Upsizing
* Home
*
* PaperCut NG and MF
*
* Common
*
* Ext Db Upsizing
* Home
*
* * PaperCut NG and MF
* Common
*
* Ext Db Upsizing
UPSIZE TO AN EXTERNAL DATABASE (RDBMS)
AVAILABLE TO CUSTOMERS ON:
Contents
* Overview
* Step 1: Stop the PaperCut NG/MF Application Server
* Step 2: Perform a backup of the existing data
* Step 3: Create a new database in the external RDBMS
* Step 4: Configure the database
* Step 5: Change the PaperCut NG/MF connection details
* Step 6: Initialize the new database
* Step 7: Load the data into the new database
* Step 8: Restart PaperCut NG/MF
Contents
* Overview
* Step 1: Stop the PaperCut NG/MF Application Server
* Step 2: Perform a backup of the existing data
* Step 3: Create a new database in the external RDBMS
* Step 4: Configure the database
* Step 5: Change the PaperCut NG/MF connection details
* Step 6: Initialize the new database
* Step 7: Load the data into the new database
* Step 8: Restart PaperCut NG/MF
Contents
* Overview
* Step 1: Stop the PaperCut NG/MF Application Server
* Step 2: Perform a backup of the existing data
* Step 3: Create a new database in the external RDBMS
* Step 4: Configure the database
* Step 5: Change the PaperCut NG/MF connection details
* Step 6: Initialize the new database
* Step 7: Load the data into the new database
* Step 8: Restart PaperCut NG/MF
By default, PaperCut NG/MF uses an internal database product known as Apache
Derby. You might, however, consider running PaperCut NG/MF on an external RDBMS
if your organization:
* has existing database infrastructure and wants to consolidate all
applications on the same database platform.
* has an existing database maintenance and backup procedure and wants PaperCut
NG/MF to take advantage of this
* uses 3rd party reporting and analysis tools (like Crystal Reports or
Microsoft Access) to view and analyze the PaperCut NG/MF database
* is very large and requires the performance benefits of a dedicated RDBMS.
This also allows the database to reside on a separate server to PaperCut
NG/MF, which improves the system scalability.
The high-level steps to upsize the database are:
1. Stop the PaperCut NG/MF Application Server
2. Perform a backup of the existing data
3. Create a new database in the external RDBMS
4. Configure the database
5. Change the PaperCut NG/MF connection details
6. Initialize the new database
7. Load the data into the new database
8. Restart the application
Important
Each Application Server requires exclusive access to an external database. i.e.
A single database cannot be shared between more than one Application Server. If
you are running multiple Application Servers (e.g. a test and production
instance), then each must have a separate database.
STEP 1: STOP THE PAPERCUT NG/MF APPLICATION SERVER
Stop the Application Server. This allows you to back up the data, guaranteeing
that all data is saved and ready to load into the new database.
For more information, see Stop and start the Application Server .
STEP 2: PERFORM A BACKUP OF THE EXISTING DATA
Perform a backup of the database. This data is loaded into the application in a
later step. For more information, see Manage system backups .
To back up the database:
1. On the Application Server, open a command prompt. (If you see ‘Access
Denied’ errors, run the command prompt as an Administrator).
2. On Linux or Mac, use su or equivalent to become the identity of papercut.
e.g.
Mac: sudo su - papercut
Linux: su - papercut
3. Change (cd) to the server binaries directory. e.g.
Windows: cd "C:\Program Files\PaperCut NG/MF\server\bin\win"
Mac: cd “/Applications/PaperCut NG/MF/server/bin/mac”
Linux: cd ~papercut/server/bin/linux-*
4. Run the following command:
db-tools export-db
The output of the above command shows the name of the backup file.
5. Take note of the backup file name because it is required in a later step.
STEP 3: CREATE A NEW DATABASE IN THE EXTERNAL RDBMS
This step differs depending on the external database you are using. It is
assumed that the administrator knows how to create a new database. The following
steps must be performed regardless of the chosen database:
1. Create a new empty database for dedicated use by PaperCut NG/MF. When
creating the database, make sure you select the correct character encoding
for your language.
Important
Create the database with a character encoding suitable for your language. For
SQL Server, the character encoding is set in Collation on the new database
screen. For other databases, such as PostgreSQL or MySQL, select a unicode
character set (UNICODE or UTF8) that allows all possible characters to be
stored.
2. Create a new database user (and password) for PaperCut NG/MF to use to
connect to the database.
3. Assign the appropriate permissions to the new user to give them full access
to the new database (for example, permission to create/drop tables, and
select/insert/update/delete in all tables).
Important
Make sure you have enough disk space for the growth of your PaperCut NG/MF
database. A full disk can corrupt the PaperCut NG/MF database. For more
information, see Database sizing and growth . We also recommend you set up
notifications for low disk space as described here: Alert Email Notification
through SCOM 2012 R2 .
STEP 4: CONFIGURE THE DATABASE
After you have created you database, you must configure it for PaperCut NG/MF.
For more information, see:
* Configuring Microsoft SQL Server
* Configuring Microsoft SQL Server Express
* Configuring MySQL
* Configuring Oracle (and Oracle Express Edition)
* Configuring Microsoft Azure SQL
STEP 5: CHANGE THE PAPERCUT NG/MF CONNECTION DETAILS
This section walks through the connection settings needed for the PaperCut NG/MF
Application Server to connect to your external database—including
authentication, connection strings, and any database driver requirements.
1. On the Application Server, open the server config file in a text editor (for
example, Notepad):
[app-path]/server/server.properties
2. (New installations only) Comment out the line:
database.type=Internal by adding a # (hash) character at the start of the
line.
3. (New installations only) Find the database connection details for SQL Server
( or PostgreSQL), and uncomment the lines by deleting the # (hash) character
at the start of the line.
4. (New installations only) Set the username and password to connect to the
database, and delete the left [ and right ] brackets:
database.username=[your-db-user]
database.password=[your-db-password]
5. Set the database connection URL, which describes the location and connection
details of the external database.
SQL Server database connection URL format
Example
An example of the SQL Server database connection entry, used in the
server.properties config file (where bold textis site specific):
database.type=SQLServer
database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
database.url=jdbc:sqlserver:// sqlserverhostname:1433;databaseName=
databasename;socketTimeout=600000
database.username= username
database.password= password
Do I need to download the database driver?
No! From version 19.0 of PaperCut NG/MF, the SQL Server driver is included in
the PaperCut installation. However it’s worth reviewing the Configuring
Microsoft SQL Server for more detail, especially if you’re upgrading; the driver
and URL strings might need updating. Also, if you’re using PaperCut NG/MF
version 18.3.9 or older, please see Configuring Microsoft SQL Server .
Notes
The SQL Server URL format is:
jdbc:sqlserver://[server][:port];databaseName=[database];socketTimeout=600000
The default port is 1433.
When using SQL Server instances, specify the instance name in the connection URL
as follows ( do not include the [ ]s ):
jdbc:sqlserver://[server][\\instanceName][:port];databaseName=[database];socketTimeout=600000
Where:
* [server] is the name of the server running the SQL Server database, and must
be resolvable from the PaperCut NG/MF server. If the SQL Server instance is
running on the same machine, then you can use localhost.
* [port] is the port the SQL Server edition is configured to listen on. For
more information on configuring SQL, see Configuring Microsoft SQL Server .
* [database] is the name of the SQL Server database you created in the external
RDBMS.
For more information see Microsoft’s information on building the connection URL.
Important
See for specific instructions to configure SQL Server.
If you want to enable Windows authentication, add ;integratedSecurity=true to
the connection string:
jdbc:sqlserver://[server][:port];databaseName=[database];socketTimeout=600000;integratedSecurity=true
SQL Server Express database connection URL format
Example
An example of the SQL Server Express database connection entry, used in the
server.properties config file (where bold textis site specific):
database.type=SQLServer
database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
database.url=jdbc:sqlserver:// sqlserverhostname:1433;databaseName=
databasename;socketTimeout=600000
database.username= username
database.password= password
Do I need to download the database driver?
No! From version 19.0 of PaperCut, the SQL Server Express driver is included in
the PaperCut NG/MF installation. See Configuring Microsoft SQL Server Express
for more information.
Notes
The SQL Server Express format is ( not including the [ ]s ):
jdbc:sqlserver://[server][:port];databaseName=[database]
Where:
* [server] is the name of the server running the SQL Server Express database,
and must be resolvable from the PaperCut NG/MF server. If the SQL Server
instance is running on the same machine, then you can use localhost.
* [port] is the port the SQL Server Express edition is configured to listen on.
For more information on configuring SQL Express, see Configuring Microsoft
SQL Server Express .
* [database] is the name of the SQL Server database you created in the external
RDBMS.
Important
See for specific instructions to configure SQL Server Express.
If you want to enable Windows authentication, add ;integratedSecurity=true to
the connection string ( do not include the [ ]s ):
jdbc:sqlserver://[server][:port];databaseName=[database];integratedSecurity=true
PostgreSQL database connection URL format
Example
An example of the PostgreSQL database connection entry, used in the
server.properties config file (where bold textis site specific):
database.type=PostgreSQL
database.driver=org.postgresql.Driver
database.url=jdbc:postgresql:// postgresserverhostname/ databasename
database.username= username
database.password= password
Do I need to download the database driver?
No! The PostgreSQL driver is included in the PaperCut NG/MF installation.
Notes
The Postgres URL format is ( not including the [ ]s ):
jdbc:postgresql://[server]/[database]
Where:
* [server] is the name of the server running the PostgreSQL database, and must
be resolvable from the PaperCut NG/MF server. If the PostgreSQL instance is
running on the same machine, then you can use localhost.
* [database] is the name of the PostgreSQL database you created in Step 3
above.
MySQL database connection URL format
Example
An example of the MySQL database connection entry, used in the server.properties
config file (where bold textis site specific):
database.type=MySQL
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql:// mysqlserverhostname/ databasename
database.username= username
database.password= password
Do I need to download the database driver?
Yes! For more information on obtaining the MySQL driver, see Configuring MySQL .
Notes
The MySQL URL format is not including the [ ]s ):
jdbc:mysql://[server]/[database]
Where:
* [server] is the name of the server running the MySQL database, and must be
resolvable from the PaperCut NG/MF server. If the MySQL instance is running
on the same machine, then you can use localhost.
* [database] is the name of the MySQL database you created in Step 3 above.
Important
See for specific instructions to configure MySQL.
Oracle database connection URL format
Example
An example of the Oracle database connection entry, used in the
server.properties config file (where bold textis site specific):
database.type=Oracle
database.driver=oracle.jdbc.driver.OracleDriver
database.url=jdbc:oracle:thin:@ oracleserverhostname:1521/ myServiceName
database.username= username
database.password= password
Do I need to download the database driver?
Yes! For more information on obtaining the Oracle driver, see Configuring Oracle
(and Oracle Express Edition) .
Notes
The Oracle URL format is ( not including the [ ]s ):
jdbc:oracle:thin:@[server]:[port]/[ServiceName]
Where:
* [server] is the name of the server running the Oracle database, and must be
resolvable from the PaperCut server. If the Oracle instance is running on the
same machine, then you can use localhost.
* [port] specifies the port number that the Oracle services are listening on.
By default this is 1521.
* [ServiceName] specifies the Oracle service name or identifier used to
identify the database. For Oracle Express edition this is XE.
For example, for an Oracle Express Edition installation on the same server as
PaperCut, running on the default port and SID, use:
jdbc:oracle:thin:@localhost:1521/XE
Important
See for specific instructions to configure Oracle.
Azure SQL database connection URL format
Where do I find the database.url entry?
The Azure SQL database URL (to populate the database.url string in the config
above) is found within your Azure Portal, under Azure SQL > [select your
PaperCut database] > Settings > Connection Strings > JDBC.
Important: make sure that you update the string to include your actual database
password, instead of the placeholder they provide.
For example in the Azure SQL portal:
Example config
An example of the Azure SQL Server database connection entry, used in the
server.properties config file (where bold text is site specific):
database.type=SQLServer
database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
database.url=jdbc:sqlserver://sqlserverhostname:1433;database=
databasename;user=username;password=password;encrypt=true;
trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;
loginTimeout=30;
database.username= username
database.password= password
Note that the above has been formatted for the website. In your config file, the
database.url string will be one long line!
Do I need to download the database driver?
No! From version 19.0 of PaperCut NG/MF, the SQL Server driver is included in
the PaperCut installation. However it’s worth reviewing the Configuring
Microsoft SQL Server for more detail, especially if you’re upgrading.
Notes
The default port is 1433.
STEP 6: INITIALIZE THE NEW DATABASE
The next step is to initialize the new database, creating the required database
tables and initial data. To initialize the database:
1. On the server, open a command prompt. (If you see ‘Access Denied’ errors,
run the command prompt as an Administrator).
2. On Linux or Mac, use su or equivalent to become the identity of papercut.
e.g.
Mac: sudo su - papercut
Linux: su - papercut
3. Change (cd) to the server binaries directory. e.g.
Windows: cd "C:\Program Files\PaperCut NG/MF\server\bin\win"
Mac: cd "/Applications/PaperCut NG/MF/server/bin/mac"
Linux (64-bit): cd ~papercut/server/bin/linux-x64
4. Run the following command: db-tools init-db.
A message is displayed to indicate that the connection details are correct and
the database was initialized correctly.
STEP 7: LOAD THE DATA INTO THE NEW DATABASE
This step loads the data (that was exported in Step 2) into the database. To
import the data:
1. On the server, open a command prompt. (If you see ‘Access Denied’ errors,
run the command prompt as an Administrator).
2. On Linux or Mac, use su or equivalent to become the identity of papercut.
e.g.
Mac: sudo su - papercut
Linux: su - papercut
3. Change (cd) to the server binaries directory. e.g.
Windows: cd "C:\Program Files\PaperCut NG/MF\server\bin\win"
Mac: cd "/Applications/PaperCut NG/MF/server/bin/mac"
Linux (64-bit): cd ~papercut/server/bin/linux-x64
4. Run the following command: db-tools import-db "backup file name". This
command shows the data import progress.
If no errors occur, the application is ready to restart.
STEP 8: RESTART PAPERCUT NG/MF
The data is now in the new database and you can restart the server.
For more information, see Stop and start the Application Server .
Wait 30 seconds for the server to start, then log in to the Admin web interface.
If you can log in successfully, then the upsizing process worked successfully.
Note
You can check that the PaperCut NG/MF Application Server is using the external
DB by checking the system information in the PaperCut admin interface.
Navigate to the About tab > System info > Database, and you’ll see the type of
database server listed.
COMMENTS
Please enable JavaScript to view the comments powered by Disqus.
Subscribe to PaperCut communications
Amplitude Device ID
* Yes, subscribe me to PaperCut news, offers, product updates, newsletters and
events.
*
By filling out and submitting this form, you agree that you have read our
Privacy Policy, and agree to PaperCut handling your data in accordance with its
terms.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of
Service apply.
Products
* Product Overview
* PaperCut NG
* PaperCut MF
* PaperCut Pocket
* PaperCut Hive
* Product comparison
Free Tools
* PaperCut Mobility Print
* PaperCut QRDoc
* PaperCut Views
Beta
* In the Percolator
Solutions for Industries
* High school/K-12
* Higher education
* Healthcare
* Coworking
* Life sciences
* Legal
* Small businesses
* Large enterprise
* Local government
What our customers say
* Customer Stories
* Testimonials
Discover
* Discover overview
* Easy printing
* Print security
* Cloud and Print
* Waste control
* Scanning
* Integrations
* Products at a Glance
* Best practices
* Forest Positive
Have a Read
* Blog
* Resources
Support
* Support Overview
Get PaperCut
* Contact Sales
About
* About us
* Careers
Misc
* Become a Reseller
* Privacy Policy
* Cookie Settings
Hey there! We use cookies. Why? They let us personalize content, track
usage, and analyze data on our end to improve your experience. To learn more
about the different cookies we’re using, check out our Privacy Policy.
OK, I understand
PaperCut, the P symbol, and PaperCut products are trademarks of the PaperCut
group of companies.
© PaperCut Software Pty Ltd
Survey
SHARE YOUR THOUGHTS
How easy was it to find what you were looking for on our website?
Submit now