Configuring Mail server in Liferay , Mail server configuration in liferay, could not connect to smtp host localhost port 25

Add this lines of code in your portal-ext.properties

    mail.session.mail.pop3.host=pop.gmail.com
    mail.session.mail.pop3.password=PASSWORD
    mail.session.mail.pop3.port=110
    mail.session.mail.pop3.user=USER
    mail.session.mail.imap.host=imap.gmail.com
    mail.session.mail.imap.port=993
    mail.session.mail.store.protocol=imap
    mail.session.mail.transport.protocol=smtp
    mail.session.mail.smtp.host=smtp.gmail.com
    mail.session.mail.smtp.password=PASSWD
    mail.session.mail.smtp.user=USERID@gmail.com
    mail.session.mail.smtp.port=465
    mail.session.mail.smtp.auth=true
    mail.session.mail.smtp.starttls.enable=true
    mail.session.mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
  
     * Please user your password in place of PASSWD and your gmail user id in place of USERID.
     By three different ways we can configure mail server in Liferay. I am using Liferay 6.2 and initially I got an error that could not connect to smtp host localhost port 25 in liferay by using different code. So I used above code and my mail server is configured properly and my application is able to send mail to the user in forgot password case.
And please see this link. This link help me to solve the issue.
https://www.permeance.com.au/web/tim.telcik/home/-/blogs/how-do-i-configure-liferay-portal-to-use-google-mail
Thanks
asif aftab

MS SQL Server Management studion Express 2008 r2 connection with Liferay 6.2

Hi
First brief description
1) I am using Liferay 6.2.
2) I want to connect with MS SQL Server Management Studio Express 2008 r2 (This is similar to MS SQL Server but with  lots of limitations).

Error: That I got was
IOExcpetion: refuse to connect.


Now the solution is
1) Configuration of MS SQL Server connection in portal-ext.properties file

   

      jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver

      jdbc.default.url=jdbc:jtds:sqlserver://localhost:1433/lportal

      jdbc.default.username=sa (this is default login name )

      jdbc.default.password=your password

    
The main thing is we have to change the port of tcp/ip to 1433 the default port of MS SQL Server Management Studio Express 2008 r2.
Start menu of windows then

 

1. MS SQL Server 2008 r2 -> configuration tool -> SQL Server configuration manager -> yes(pop up)

  then on extreme left select there is a tree structure then

2. SQL Server network configuration -> Protocols for sql server -> rt click on tcp/ip and enable it

3. Double click on tcp/ip then one pop up will display

4. Select IP Adrees tab, lots of IPAdress block you can see and inside this block you can see one label IP Address value having different values. You have to check which IP Adress having value 127.0.0.1 then change its tcp port value to 1433.

5. Some time tcp port is not enable so please enable and also makes ip4 and all ip tcp port value

is 1433(default port of sql server express 2008 r2).

Hence try to connect, this time this will work.
Thanks
asif aftab