Environment
iPrint Appliance 2.0
iPrint Appliance 2.0 patch 1
iPrint Appliance 2.0 patch 1
Situation
After import iprintconfig.zip from 1.1 iPrint Appliance into an iPrint 2.0 Appliance, accessing the 2.0 web console's configuration page returns an RPC error. Clicking on the details returns the following:
Jul 14, 2016 4:35:25 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Allocate exception for servlet appServlet
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Generic+PostScript+Printer+Foomatic%2FPostscript+%28recommended%' for key 'UK_5spxwd4doey4jvgem7dgda955'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:86)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:58)
at java.lang.reflect.Constructor.newInstance(Constructor.java:542)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
Resolution
- Apply Patch 5 to the 1.1 iPrint Appliance.
- This will bring the iPrint Appliance server to version 420.
- Again export the iprintconfig.zip
- Configure a new 2.x iPrint Appliance.
- Use the newly generated iprintconfig.zip to Upgrade or Migrate to the 2.x iPrint Appliance.
Cause
Having Patch 5 applied to 1.1 iPrint Appliance is a requirement to upgrading to 2.x. Without having Patch 5, the default driver will not be set on the MYSQL database, resulting in a MYSQL syntax violation.