String index out of range: -4

CM1
1

Hi team,

I amtrying to install  cm1 5.25 and getting below error:

setupEmbeddedDB:     [echo] Installing repository…
[PSTableAction] Connecting to: jdbc:mysql://localhost:3306/rxmaster?useUnicode=yes&characterEncoding=UTF-8
[PSTableAction] Wed Feb 07 17:29:55 IST 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[PSTableAction] Exception : Could not create connection to database server.
[PSTableAction] Connection failed : No suitable driver found for jdbc:mysql://localhost:3306/rxmaster?useUnicode=yes&characterEncoding=UTF-8
Wed Feb 07 17:29:55 IST 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Wed Feb 07 17:29:55 IST 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Wed Feb 07 17:29:55 IST 2018 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

BUILD FAILED
java.lang.StringIndexOutOfBoundsException: String index out of range: -4
at java.lang.String.substring(Unknown Source)
at com.percussion.installanywhere.RxIAUtils.truncateMsg(RxIAUtils.java:309)
at com.percussion.installer.action.RxInstall.messageLogged(RxInstall.java:245)
at org.apache.tools.ant.Project.fireMessageLoggedEvent(Project.java:2200)
at org.apache.tools.ant.Project.fireMessageLogged(Project.java:2237)
at org.apache.tools.ant.Project.fireMessageLogged(Project.java:2219)
at org.apache.tools.ant.Project.demuxFlush(Project.java:1274)
at org.apache.tools.ant.DemuxOutputStream.processFlush(DemuxOutputStream.java:186)
at org.apache.tools.ant.DemuxOutputStream.flush(DemuxOutputStream.java:211)
at java.io.PrintStream.flush(Unknown Source)
at org.apache.tools.ant.Project.fireTaskFinished(Project.java:2148)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
at org.apache.tools.ant.Main.runBuild(Main.java:758)
at org.apache.tools.ant.Main.startAnt(Main.java:217)
at com.percussion.installer.action.RxInstall.launchInstall(RxInstall.java:351)
at com.percussion.installer.action.RxInstall.execute(RxInstall.java:145)
at com.percussion.installanywhere.RxIAAction.install(RxIAAction.java:57)
at com.zerog.ia.installer.actions.CustomAction.installSelf(Unknown Source)
at com.zerog.ia.installer.InstallablePiece.install(Unknown Source)
at com.zerog.ia.installer.InstallablePiece.install(Unknown Source)
at com.zerog.ia.installer.GhostDirectory.install(Unknown Source)
at com.zerog.ia.installer.InstallablePiece.install(Unknown Source)
at com.zerog.ia.installer.Installer.install(Unknown Source)
at com.zerog.ia.installer.actions.InstallProgressAction.af(Unknown Source)
at com.zerog.ia.installer.actions.ProgressPanelAction$1.run(Unknown Source)

As a result follwing tables and view are unavaibale:

An error has occurred while creating one of the following views: 
CONTENTVARIANTS
PSX_COMMUNITYPERMISSION_VIEW
PSX_DISPLAYFORMATPROPERTY_VIEW
PSX_MENUVISIBILITY_VIEW
PSX_SEARCHPROPERTIES_VIEW
RXCONTENTTYPECOMMUNITY
RXSITECOMMUNITY
RXVARIANTCOMMUNITY
RXWORKFLOWCOMMUNITY

I am selecting advanced option fo installation and using my sql database. Also the connector that I am using is mysql-connector-java-5.1.45-bin.

Please help ASAP

2

On your MySQL server can you set useSSL=false and restart the service?  The installer isn’t aware of the SSL setting. Alternatively if you edit the /rxconfig/Installer/rxrepository.properties file you could change this line:

DB_SERVER=//localhost:3306/CM1?useUnicode=yes&characterEncoding=UTF-8&useSSL=false

And then try running the upgrade.

-n

3

Hi Nate,

As suggested I made changes in rxrepository.properties file and again ran setup in upgrade mode but still getting the same error:

An error has occurred while creating one of the following views: 
CONTENTVARIANTS
PSX_COMMUNITYPERMISSION_VIEW
PSX_DISPLAYFORMATPROPERTY_VIEW
PSX_MENUVISIBILITY_VIEW
PSX_SEARCHPROPERTIES_VIEW
RXCONTENTTYPECOMMUNITY
RXSITECOMMUNITY
RXVARIANTCOMMUNITY
RXWORKFLOWCOMMUNITY

Each of these views is required for Percussion to function properly.  Please see rxconfig/Installer/install.log for details.

Please help.

4

I am creating a Support ticket so that we can better troubleshoot this.

-n

5

Any update on this Nate as I am totally stuck at this point.

Please suggest how to proceed with this.

Thanks in advance.

6

Hi,

I see a request on the support portal from a Support engineer for a few log files but no response from you.  Did you see the support ticket in email or on the support portal?  https://support.percussion.com

Let me know if you have trouble logging in. 

-n

7

Thanks, Nate!  I am able to login to the support portal and have provided the log files to the Support Engineer.

8