migrating Pulse database to new server - wrong user name or password


#1

I have just installed Pulse on a new server and wanted to migrate the Pulse database.

I have copied all the folders and ran the ServerNameUpdate.bat as administrator and get the following error:

image

Can anyone help?


#2

Hi @mmacdonnell,

Could you please try with the server names in capital case?

We also have an alternative to these scripts, you can also use the ServerNameOverride parameter, more details here: https://code.cubewise.com/docs/keep-pulse-history-while-migrating?rq=servernameoverride

Regards,

Erik


#3

Thanks Erik.

Now the script works (with the uppercase) however the Pulse website doesn’t start up.

from pulse.log:

018-12-12 12:16:00 INFO InitContextListener Connecting to the database with the default password
2018-12-12 12:16:01 WARN InitContextListener Cannot connect to database with new password
2018-12-12 12:16:01 INFO InitContextListener Connecting to the database with the legacy password
2018-12-12 12:16:02 FATAL InitContextListener Cannot connect to the h2 database with legacy password
2018-12-12 12:16:02 INFO ro.isdc.wro.http.WroFilter wro4j version: 1.7.7
2018-12-12 12:16:02 INFO ro.isdc.wro.http.WroFilter wro4j configuration: ro.isdc.wro.config.jmx.WroConfiguration@6f81e719[

Thanks
Mal


#4

So I’ve tried this a number of times now on different servers with the same results.

I’ve installed Pulse on the new server (same version as the old server)

I’ve shut down the pulse services (on both servers)

I’ve copied conf, db, dump, history, packages and vcs from the old server to the new.

I’ve run ServerNameUpdate.bat.

I’ve restarted Pulse services

I get this page cannot be displayed and pulse.log “could not find a connection to the docs database”

Version is 5.7.5 which I will upgrade when it’s migrated.

I did try migrating straight to the latest version, but that didn’t work either.

Please Help


#5

Hi @mmacdonnell,

Could you please send us a support Ticket, so we can perform a web meeting to troubleshoot.

Regards,

Erik


#6

Hi Erik,

I am not sure how to create a support ticket. I am a vendor, not a client.

Regards
Mal


#7

Hi @mmacdonnell,

Send us an email to pulse@cubewise.com, I will answer you shortly

Regards,

Erik


#8

Hi @mmacdonnell

As concluded in our support version, using the ServerNameOverride parameter is the better option when migrating data across servers.

But also, I will check that this bug in the Server Name rename script on Pulse 5.7.5 is not present in the more recent releases of Pulse.

Thanks for helping us make Pulse Better.

Best Regards,

Erik


#9

Thanks Erik

Malcolm MacDonnell

Executive Consultant

02 6181 0550

0418 812 112

mmacdonnell@excelerated.com.au

33 Murray Crescent, Manuka ACT 2603

PO Box 4188, Manuka ACT 2603

www.excelerated.com.au