Fórum

Installing Social Office for MySQL

praveen orvakanti, modificado 12 Anos atrás.

Installing Social Office for MySQL

Junior Member Postagens: 51 Data de Entrada: 10/08/11 Postagens Recentes
Hi All,
I'm trying to make the Social Office run on the MySQL server in my system rather than the embedded HSQL.
As mentioned in the link: http://www.liferay.com/documentation/social-office/1.5/user-guide/-/ai/installing-social-office-for-production-use,
Should the portal-ext.properties for me jus look like this:

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

mail.session.mail.pop3.host=localhost
mail.session.mail.pop3.password=
mail.session.mail.pop3.port=110
mail.session.mail.pop3.user=
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=
mail.session.mail.store.protocol=pop3
mail.session.mail.transport.protocol=smtp


I mean, there is no other start or no other end???? IT says i have to substitute my mail server information. Where do i get my mail server information?
praveen orvakanti, modificado 12 Anos atrás.

RE: Installing Social Office for MySQL

Junior Member Postagens: 51 Data de Entrada: 10/08/11 Postagens Recentes
I was basically looking for details like:

* username and password for pop3/smtp server.

I'm using Outlook and i tried looking in tools -> account settings..
But couldn't find any details there.
praveen orvakanti, modificado 12 Anos atrás.

RE: Installing Social Office for MySQL

Junior Member Postagens: 51 Data de Entrada: 10/08/11 Postagens Recentes
Ok, So my portal-ext.properties file looks like this:

#
# MySQL
#
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEn- coding=UTF-8&useFastDateParsing=false
jdbc.default.username=abc
jdbc.default.password=xyz


mail.session.mail.pop3.host=localhost
mail.session.mail.pop3.password=1234
mail.session.mail.pop3.port=110
mail.session.mail.pop3.user=abc.xyz@def.com
mail.session.mail.smtp.auth=false
mail.session.mail.smtp.host=localhost
mail.session.mail.smtp.password=1234
mail.session.mail.smtp.port=25
mail.session.mail.smtp.user=abc.xyz@def.com
mail.session.mail.store.protocol=pop3
mail.session.mail.transport.protocol=smtp

I have used my usernam and password details for the Outlook here.

Is it fine?