mail configuration spagobi server 2.6

hello,

i would like to automatically sending email from spagobi server with the scheduler function.

i try to edit the file mail.xml with those values smtphost= localhost,smptport=25,user="",password="" , but in the spagobi log i have a authentification failed java error.

could you explain if except the xml file i need to configure a other thing ?

for information spagobi server run on opensuse linux with sendmail install and running (i can send mail from the server)

thank you for any help.

Have you configured it like this:
<PROFILE name="scheduler"
smtphost="mail.eng.it"
smtpport="110"
from="spagobi@eng.it"
user=""
password=""/>
Where from is you address and name has to be scheduler!
It should work.
If you want to test the functionality configure also the user part:
<PROFILE name="user"
smtphost="mail.eng.it"
smtpport="110"
from="spagobi@eng.it"
user=""
password=""/>
then execute a report an click on the mail button on the top right corner. If you get to send it, it will work also in the scheduler with the same credentials.
Regards
Chiara

can u tell me where i can find mail.xml file

Hi!

In SpagoBI 2.6 you can find this file in webapps/SpagoBI/WEB-INF/conf/config/mail.xml

Cheers

i m using All in one Spagobi 3.3
and there is no such file.

In SPagoBI 3.3 there is a GUI for manage configuartion. Connect as admin and you'll find it out it in one of the menus.

yes i know and i have tried to configure from there...
kindly have a look for the error
http://www.spagoworld.org/jforum/posts/list/1016.page

i have got this error

com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. i10sm46508660pbg.10

at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:138

at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:959)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:583)
at javax.mail.Transport.send0(Transport.java:169)
at javax.mail.Transport.send(Transport.java:9

at it.eng.spagobi.analiticalmodel.execution.service.ExecuteAndSendAction.service(ExecuteAndSendAction.java:26

at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15

at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:423)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:86)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)

Do you use a GMail accout?

yes i m using Gmail Account....

if it doesn't work
kindly name any free mail service which works better with SpagoBi V3.3

hi
i am still unable to send mail through GMAIL account

kindly help me
thanks