Fórum

Can't install SO anymore

thumbnail
Michael Dolphin, modificado 11 Anos atrás.

Can't install SO anymore

Junior Member Postagens: 48 Data de Entrada: 09/01/13 Postagens Recentes
From time to time I do a fresh Liferay and/or Social Office Installation for demonstration purposes in preparation for customer pre-sales pitches. Last time, three weeks ago everything worked like a charm. But now I'm unable to set up a brand new Liferay 6.1.1 CE2 Liferay Installation with Social Office. I tried it several times on different machines today. What I did today was:

- created a brand new DB schema in MySQL
- Installed a fresh Liferay 6.1.1 CE2 Tomcat Bundle
- created a portal-ext.properties file to use the new DB Schema
- deleted welcome-theme and resources-importer-web from Web-apps folder
- fired up Liferay and gone through the initial setup process
- went to control panel and downloaded social office
- installed social office
- saw several exceptions in tomcats log file

Results:

- no changes in the Liferay tool bar
- the SO theme is available, Login Page has been changed, but the "default social office site" site template is empty

Problems seem to have been started here in the logs:

19:21:23,954 ERROR [pool-2-thread-2][JDBCExceptionReporter:76] Incorrect string value: '\xE4\xB8\xBB\xE9\xA1\xB5...' for column 'name' at row 1
19:21:23,960 ERROR [pool-2-thread-2][InstanceUtil:78] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:193)
...
...


I've attached the whole Tomcat log, from first startup until the end of my tests (only 60kemoticon
thumbnail
James Falkner, modificado 11 Anos atrás.

RE: Can't install SO anymore

Liferay Legend Postagens: 1399 Data de Entrada: 17/09/10 Postagens Recentes
Michael Dolphin:
From time to time I do a fresh Liferay and/or Social Office Installation for demonstration purposes in preparation for customer pre-sales pitches. Last time, three weeks ago everything worked like a charm. But now I'm unable to set up a brand new Liferay 6.1.1 CE2 Liferay Installation with Social Office. I tried it several times on different machines today. What I did today was:

- created a brand new DB schema in MySQL
- Installed a fresh Liferay 6.1.1 CE2 Tomcat Bundle
- created a portal-ext.properties file to use the new DB Schema
- deleted welcome-theme and resources-importer-web from Web-apps folder
- fired up Liferay and gone through the initial setup process
- went to control panel and downloaded social office
- installed social office
- saw several exceptions in tomcats log file

Results:

- no changes in the Liferay tool bar
- the SO theme is available, Login Page has been changed, but the "default social office site" site template is empty

Problems seem to have been started here in the logs:

19:21:23,954 ERROR [pool-2-thread-2][JDBCExceptionReporter:76] Incorrect string value: '\xE4\xB8\xBB\xE9\xA1\xB5...' for column 'name' at row 1
19:21:23,960 ERROR [pool-2-thread-2][InstanceUtil:78] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:193)
...
...


I've attached the whole Tomcat log, from first startup until the end of my tests (only 60kemoticon



Looks like you didn't set the encoding on your DB properly. How did you create the database in MySQL? I usually use


create database foo default character set utf8;
thumbnail
Hitoshi Ozawa, modificado 11 Anos atrás.

RE: Can't install SO anymore

Liferay Legend Postagens: 7942 Data de Entrada: 24/03/10 Postagens Recentes
I usually just execute the following command without the "default" but it shouldn't make too much of a difference.
If you're using MySQL Admin tools, I think they didn't have an option to specify encoding. So, you'll have to execute the following command from the sql command line.

CREATE DATABASE lportal CHARACTER SET utf8;
thumbnail
Michael Dolphin, modificado 11 Anos atrás.

RE: Can't install SO anymore

Junior Member Postagens: 48 Data de Entrada: 09/01/13 Postagens Recentes
Thanks, that was really part of the problem. Anyway: I'can't get SO installed properly. I've tried it several times for hours now, without any success.
Everytime I did a really fresh install with a new DB-Schema (UTF-8 of course), and a fresh extracted Liferay 6.1.1 CE2 Tomcat Bundle.

I've only run through the initial Install procedure, and as soon as my standard user "test@liferay.com" accesses the portal for the first time, I go to the control panel -> Marketplace->purchased, then I download an install SO.

Afterwards the SO Theme is available but not used by the default site, the SO Site Templates are selectable under CP->Site-Templates (Default Social Office Site, Social Office User Home, Social Office User Profile) but that's all. The Toolbar stays unchanged, the Users Profile Pages are still standard Liferay L&F, no Social Office Theme used by default, no changed Login Screen (meaning http://myserver/web/guest/so/login isn't available) etc.

There where no Exceptions in the Logs during Liferay Setup or while deploying the SO package. The Exceptions at the end of the attached log file started, while I created another "real" user, but I'm not sure if that's not only coincidence.

What am I missing? Can't rember that I ever had this kind of trouble when installing SO, and I really already did it often in the past.
thumbnail
Jamie L Sammons, modificado 11 Anos atrás.

RE: Can't install SO anymore

Junior Member Postagens: 33 Data de Entrada: 18/11/08 Postagens Recentes
Hi Michael,

Do you have your users added to the Social Office User Role? Even test@liferay.com does not get added to that Role be default when you deploy SO. Once added the Dashboard link should appear at the top.

As for the stack trace it almost looks like maybe you have Liferay Sync deployed somewhere trying to hit an old instance of Liferay? Not sure on that one but thought I would ask.

Thanks,
Jamie
thumbnail
Michael Dolphin, modificado 11 Anos atrás.

RE: Can't install SO anymore

Junior Member Postagens: 48 Data de Entrada: 09/01/13 Postagens Recentes
Jamie You're brilliant!

Yes, I have several other Liferay Installations on my "Customer Demo" Machine, and one of them is especially for showing the document management capabilities of Liferay. So it has Liferay Sync installed (and all those document preview generating external services). I just installed that yesterday in the other Liferay instance, so I've never seen these Exceptions before. I thought Liferay Sync would be implemented using Hooks (which shouldn't affect any other Liferay Installation while the server isn't running), but obviusly I was wrong.

Back to SO: Here you are also right. In my former SO Installations I always already had some users, organisations, groups etc. configured when I installed SO. When I switched to one of those users after SO installation, the dashboard was shown immediatly. But not in a really "Clean" install without any users besided the "test" user. Just added another user to the Social Office User role - é voilá! Social Office is there.

Thanks a lot to all of you, who took the time to investigate my problem.

Kind Regards

Michael
stephan raju, modificado 10 Anos atrás.

RE: Can't install SO anymore

New Member Postagens: 4 Data de Entrada: 29/05/13 Postagens Recentes
Thanks for providing the command i think it would be help for me