ReportServer Forum

hvupadhye

Member

From: Mumbai, India

Registered: 2016-05-13

Mail server configuration

Hello friends, I have installed Bitnami ReportServer Stack 2.2.2.5639-4.  while I was installing, I have configured my mail server to send scheduled reports. But now I want to change some configurations. Where should I do that? Please help. Thank you inn advance.

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Mail server configuration

Hello.

Have a look at the internal file server (Administration / File sever). The folder etc contains various configurations. The mail configuration can be found in /etc/mail/mail.cf.

Cheers,
Arno

hvupadhye

Member

From: Mumbai, India

Registered: 2016-05-13

Re: Mail server configuration

Hello Arno, and sorry I forgot to mentioned that I have installed the report server on Windows operating system.

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Mail server configuration

The location of the mail configuration is the same. It is the internal file system (that is, log in to ReportServer, go to the Administration Module, then to File Server).

Hope this helps,
Arno

hvupadhye

Member

From: Mumbai, India

Registered: 2016-05-13

Re: Mail server configuration

Thank you Arno. Definitely it is helping me.

hvupadhye

Member

From: Mumbai, India

Registered: 2016-05-13

Re: Mail server configuration

Hello Friends,

I have configured the mail.cf as below

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <smtp>
      <host>smtp.gmail.com</host>
      <port>25</port>
      <username>hvupadhye@gmail.com</username>
      <password>*******</password>
     
      <ssl>true</ssl>
      <tls>
         <enable>false</enable>
         <require>false</require>
      </tls>
   </smtp>
   <mail>
      <sender>rs@datenwerke.net</sender>
      <forceSender>false</forceSender>
      <encryptionPolicy>allow_mixed</encryptionPolicy>
   </mail>
</configuration>

but on schedule execution I am getting following error

125350

java.lang.RuntimeException: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 25;
  nested exception is:
    java.net.ConnectException: Connection refused: connect
    at net.datenwerke.rs.scheduler.service.scheduler.mail.MailReportAction$1.handleException(MailReportAction.java:134)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl.sendMailSync(MailServiceImpl.java:244)
    at net.datenwerke.rs.scheduler.service.scheduler.mail.MailReportAction.doExecute(MailReportAction.java:125)
    at net.datenwerke.scheduler.service.scheduler.entities.AbstractAction.execute(AbstractAction.java:59)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeAction(SchedulerTask.java:495)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions(SchedulerTask.java:385)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:209)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:101)
    at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 25;
  nested exception is:
    java.net.ConnectException: Connection refused: connect
    at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1972)
    at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:642)
    at javax.mail.Service.connect(Service.java:317)
    at javax.mail.Service.connect(Service.java:176)
    at javax.mail.Service.connect(Service.java:125)
    at javax.mail.Transport.send0(Transport.java:194)
    at javax.mail.Transport.send(Transport.java:124)
    at net.datenwerke.rs.core.service.mail.MailServiceImpl.sendMailSync(MailServiceImpl.java:234)
    ... 11 more
Caused by: java.net.ConnectException: Connection refused: connect
    at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    at java.net.PlainSocketImpl.connect(Unknown Source)
    at java.net.SocksSocketImpl.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at java.net.Socket.connect(Unknown Source)
    at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:319)
    at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:233)
    at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1938)
    ... 18 more

Please help. Thanks in advance.

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Mail server configuration

-> http://forum.reportserver.net/viewtopic … 2291#p2291