Due to initial mysql schema failure, a new install will ask for current admin password and fail due to non-existent schema

Description

A user reports, that fresh installation of Openfire asks for the old admin password when some other database is used and not the embedded one. I can confirm, that there is no such issue with the embedded one. Can't test with other option though.

Environment

None

Linked work items

is related to

OF-1167

Fresh installation asks for a current password

OF-1255

Invalid SQL syntax in Mysql installation script.

Activity

Show:

Daryl Herzmann

December 31, 2016 at 4:03 AM

Just to note that the source code change made by Guus related to this ticket has the admin console emit an error in this situation instead of silently ignoring the non-auth related bug

Guus der Kinderen

December 30, 2016 at 9:29 AM

Can this issue be closed as a duplicate of OF-1255?

James Rome

December 24, 2016 at 1:42 PM

I did. As I said, the tables were made.

Daryl Herzmann

December 24, 2016 at 2:08 AM

Did you fix the typo with your connection string to MySQL? Otherwise, lets continue the discussion on the community fourms

James Rome

December 24, 2016 at 12:50 AM

Glad I was not crazy. Openfire did create the tables, so my previous posting of a java error was probably not right.
1. How do I fix this?
2. Is there a way to import my users from the embedded db into a real mysql db if I switch? They are throwing things at me because each time I update Openfire, they have to readd all their buddies. And as an aside, the Openfire update instructions say to save the old directories, but do not tell us what to do to restore all the old information.

Resize issue view side panel

Fixed

Details

Assignee

Dave Cridland

Reporter

wroot

Labels

Priority

Major

Created December 21, 2016 at 9:18 PM

Updated December 31, 2016 at 4:03 AM

Resolved December 31, 2016 at 3:24 AM