Error while trying to set up Social Office for MySQL

[12年前 に praveen orvakanti によって更新されました。]

Hi All,
I have set up Social Office on my system. I have set up MySQL database and then i created a portal-ext.properties file to point the SO towards my 'MySQL' database. The SO started fine, but when i created an account and tried to save it gave me the following error page:

An unexpected system error occurred.

java.lang.NullPointerException

I'm also attaching the image file of the error page. Please do see it.

Funny thing:
After i stop the Liferay and start it again, it tries to go to my home page to the user id i tried to create previously but again i get the same error page.

My guess is that, Though the SO is set up now for MySQL, and though it has created all the default tables and data in the database it is somehow facing a conflict between its embedded HSQL and MySQL.

Also find, the error messages on the console attached in a notepad.

Please do let me know what i'm doing wrong.

[12年前 に praveen orvakanti によって更新されました。]

Hi All,
Please see the error attached here. I dont understand why i'm getting this error.

[12年前 に Michael Harper によって更新されました。]

I had a similar issue when trying to set my SO up on mysql.

The way I ended up fixing it was to drop the current database in mysql, and create a new empty one.

Making sure that it is created with the UTF-8 and/or UTF-8 bin formatting.

If it is not created with the UTF-8 you will have errors connecting to it.

As for the email, I'm not sure as I haven't tried setting that part up yet. I'm still having issues trying to login after importing my users with ldap from our ADS.

[12年前 に praveen orvakanti によって更新されました。]

Hi Michael,
Thanks for your response. I ve been stuck with the same error for the past two days.

Now, i have actually done the exercise that is to "remove the database and create a new one empty one", multiple times and ended up with the same output.

So how do i make sure that i create the database wit h UTF-8 or UTF-8 bin formatting???

Please find my portal-ext.properties file contents below:

#
# MySQL
#
#jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEn- coding=UTF-8&useFastDateParsing=false

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal_so?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=viq

##
## Mail
##
mail.session.mail.pop3.host=localhost
mail.session.mail.pop3.password=
mail.session.mail.pop3.port=110
mail.session.mail.pop3.user=[e-mail]
mail.session.mail.smtp.auth=false
mail.session.mail.smtp.host=localhost
mail.session.mail.smtp.password=
mail.session.mail.smtp.port=25
mail.session.mail.smtp.user=[e-mail]
mail.session.mail.store.protocol=pop3
mail.session.mail.transport.protocol=smtp


So how do i fix the error?

Thanks

[12年前 に jelmer kuperus によって更新されました。]

So how do i make sure that i create the database wit h UTF-8 or UTF-8 bin formatting???

You use the following command :

create database lportal_so character set utf8;

[12年前 に praveen orvakanti によって更新されました。]

Thanks Michael,
It worked

Thanks jelmer for that tip as well

But the 'java null pointer exception' is still thrown at the beginning of the SO launch. But i can do all the stuuf on my home page.
Any idea y that error persists????

[12年前 に jelmer kuperus によって更新されました。]

It's unlikely that the error you are seeing is the cause of your problem. Check in the logs if there are any other errors in there predating this one

[12年前 に praveen orvakanti によって更新されました。]

And Michael, Just so to be clear, when you say 'drop the current database' you mean just the database that you want Social Office to use right???? Like for in my case 'lportal' is the schema or database that i use with Social Office.