[xwiki-users] Missing step in apt-get installation
I am having problems installing and configuring XWiki on a fresh install of Ubuntu 12.04. I am using the package method described in this tutorial: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationViaAPT I have tried 3 different packages now and each of them result in different errors (all of them database configuration related). xwiki-enterprise-tomcat7-mysql xwiki-enterprise-tomcat7-psql xwiki-enterprise-tomcat6-psql I think there is either a missing step, or the package is not setting the configuration properly. I have used the dbconfig installer to set the passwords for mysql root and xwiki user, so I don't know what else to try other than another package, or configure manually. Can anyone confirm this bug and/or provide a solution? Thanks, Andrew Havens
I figured out the problem. The user and permissions were screwed up somehow. I was able to fix the issues by removing the user and recreating it, granting the appropriate permissions: DROP USER 'xwiki'@'localhost'; CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'passwordhere'; GRANT ALL PRIVILEGES ON xwiki.* TO 'xwiki'@'localhost'; FLUSH PRIVILEGES; On Feb 19, 2013, at 2:34 PM, Andrew Havens <andrewh@copiousinc.com> wrote:
I am having problems installing and configuring XWiki on a fresh install of Ubuntu 12.04. I am using the package method described in this tutorial: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationViaAPT
I have tried 3 different packages now and each of them result in different errors (all of them database configuration related).
xwiki-enterprise-tomcat7-mysql xwiki-enterprise-tomcat7-psql xwiki-enterprise-tomcat6-psql
I think there is either a missing step, or the package is not setting the configuration properly. I have used the dbconfig installer to set the passwords for mysql root and xwiki user, so I don't know what else to try other than another package, or configure manually.
Can anyone confirm this bug and/or provide a solution?
Thanks,
Andrew Havens
I just tried xwiki-enterprise-tomcat7-mysql but I don't seem to have any issue, I can access xwiki using http://127.0.0.1:8080/xwiki/ right after dpkg is done installing it. It's also the first time I see this issue reported. Note that the whole process or creating the database/user is done by dbconfig, the xwiki package just generate the hibernate file accordingly and I can see that the password I choose properly ends up in hibernate configuration file. On pgsql now I also got an issue but it's actually a bug in XWiki itself. In the meantime you can fix it you can workaround it by adding <property name="xwiki.virtual_mode">schema</property> in hibernate.xfg.xml file (right after <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> for example). On Wed, Feb 20, 2013 at 12:30 AM, Andrew Havens <andrewh@copiousinc.com> wrote:
I figured out the problem. The user and permissions were screwed up somehow. I was able to fix the issues by removing the user and recreating it, granting the appropriate permissions:
DROP USER 'xwiki'@'localhost'; CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'passwordhere'; GRANT ALL PRIVILEGES ON xwiki.* TO 'xwiki'@'localhost'; FLUSH PRIVILEGES;
On Feb 19, 2013, at 2:34 PM, Andrew Havens <andrewh@copiousinc.com> wrote:
I am having problems installing and configuring XWiki on a fresh install of Ubuntu 12.04. I am using the package method described in this tutorial: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationViaAPT
I have tried 3 different packages now and each of them result in different errors (all of them database configuration related).
xwiki-enterprise-tomcat7-mysql xwiki-enterprise-tomcat7-psql xwiki-enterprise-tomcat6-psql
I think there is either a missing step, or the package is not setting the configuration properly. I have used the dbconfig installer to set the passwords for mysql root and xwiki user, so I don't know what else to try other than another package, or configure manually.
Can anyone confirm this bug and/or provide a solution?
Thanks,
Andrew Havens
_______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
On Wed, Feb 20, 2013 at 2:05 PM, Thomas Mortagne <thomas.mortagne@xwiki.com> wrote:
I just tried xwiki-enterprise-tomcat7-mysql but I don't seem to have any issue, I can access xwiki using http://127.0.0.1:8080/xwiki/ right after dpkg is done installing it. It's also the first time I see this issue reported.
Note that the whole process or creating the database/user is done by dbconfig, the xwiki package just generate the hibernate file accordingly and I can see that the password I choose properly ends up in hibernate configuration file.
On pgsql now I also got an issue but it's actually a bug in XWiki itself. In the meantime you can fix it you can workaround it by adding <property name="xwiki.virtual_mode">schema</property> in hibernate.xfg.xml file (right after <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> for example).
The jira issue is http://jira.xwiki.org/browse/XWIKI-8835.
On Wed, Feb 20, 2013 at 12:30 AM, Andrew Havens <andrewh@copiousinc.com> wrote:
I figured out the problem. The user and permissions were screwed up somehow. I was able to fix the issues by removing the user and recreating it, granting the appropriate permissions:
DROP USER 'xwiki'@'localhost'; CREATE USER 'xwiki'@'localhost' IDENTIFIED BY 'passwordhere'; GRANT ALL PRIVILEGES ON xwiki.* TO 'xwiki'@'localhost'; FLUSH PRIVILEGES;
On Feb 19, 2013, at 2:34 PM, Andrew Havens <andrewh@copiousinc.com> wrote:
I am having problems installing and configuring XWiki on a fresh install of Ubuntu 12.04. I am using the package method described in this tutorial: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationViaAPT
I have tried 3 different packages now and each of them result in different errors (all of them database configuration related).
xwiki-enterprise-tomcat7-mysql xwiki-enterprise-tomcat7-psql xwiki-enterprise-tomcat6-psql
I think there is either a missing step, or the package is not setting the configuration properly. I have used the dbconfig installer to set the passwords for mysql root and xwiki user, so I don't know what else to try other than another package, or configure manually.
Can anyone confirm this bug and/or provide a solution?
Thanks,
Andrew Havens
_______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
-- Thomas Mortagne
participants (2)
-
Andrew Havens -
Thomas Mortagne