Re: Digest for scriptella@googlegroups.com - 1 update in 1 topic

15 views
Skip to first unread message

pd

unread,
May 29, 2020, 5:26:58 PM5/29/20
to scrip...@googlegroups.com
why not posting the complete code you're using?

On Fri, May 29, 2020 at 4:14 AM <scrip...@googlegroups.com> wrote:
Standly lee <polk...@gmail.com>: May 27 10:22PM -0700

Hi;
 
Please help me out about sending mail.
I've got a error message while executing etl.xml even though two email
addresss <test...@coresolutions.co.kr> that is sender and
<pol...@naver.com> that is receiver are valid.
I have no idea what's wrong with me.
 
I enclosed "mail.properties".
 
 
 
 
 
 
 
 
 
 
*#mail.smtp.starttls.enable=true#mail.smtp.ssl.enabled=truemail.smtp.sasl.enable=truemail.smtp.host=smtp.cafe24.commail.smtp.port=587mail.user=test_etlmail.password=mail.from=ETLADMIN
<test...@coresolutions.co.kr>mail.debug=truetype=html*
 
Thank you in advance.
 
==========================================================================
DEBUG SMTP: enable SASL
DEBUG SMTP: useEhlo true, useAuth false
DEBUG SMTP: trying to connect to host "smtp.cafe24.com", port 587, isSSL
false
220 ESMTP Postfix
DEBUG SMTP: connected to host "smtp.cafe24.com", port: 587
 
EHLO DESKTOP-HO0QRU8
250-smtp-003.cafe24.com
250-PIPELINING
250-SIZE 30720000
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH LOGIN PLAIN
250-AUTH=LOGIN PLAIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
DEBUG SMTP: Found extension "PIPELINING", arg ""
DEBUG SMTP: Found extension "SIZE", arg "30720000"
DEBUG SMTP: Found extension "VRFY", arg ""
DEBUG SMTP: Found extension "ETRN", arg ""
DEBUG SMTP: Found extension "STARTTLS", arg ""
DEBUG SMTP: Found extension "AUTH", arg "LOGIN PLAIN"
DEBUG SMTP: Found extension "AUTH=LOGIN", arg "PLAIN"
DEBUG SMTP: Found extension "ENHANCEDSTATUSCODES", arg ""
DEBUG SMTP: Found extension "8BITMIME", arg ""
DEBUG SMTP: Found extension "DSN", arg ""
DEBUG SMTP: use8bit false
MAIL FROM:<test...@coresolutions.co.kr>
250 2.1.0 Ok
RCPT TO:<pol...@naver.com>
*554 5.7.1 <unknown[211.108.168.56]>: Client host rejected: Access denied*
DEBUG SMTP: Invalid Addresses
DEBUG SMTP: pol...@naver.com
*DEBUG SMTP: Sending failed because of invalid destination addresses*
RSET
250 2.0.0 Ok
DEBUG SMTP: MessagingException while sending
javax.mail.SendFailedException: Invalid Addresses;
nested exception is:
*com.sun.mail.smtp.SMTPAddressFailedException: 554 5.7.1
<unknown[211.108.168.56]>: Client host rejected: Access denied*
==========================================================================
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to scriptella+...@googlegroups.com.

Standly lee

unread,
Jun 1, 2020, 12:49:56 AM6/1/20
to Scriptella ETL
Hi;

I posted my whole code here.

<!DOCTYPE etl SYSTEM "http://scriptella.org/dtd/etl.dtd">
<etl>
    <description>
        Sends emails to a list selected from the database.
    </description>

    <!-- In-memory database for demo purpose -->
    <connection id="db" driver="mssql">
        #autocommit=true
    </connection>

    <!-- JavaMail driver connection to a SMTP server -->
    <connection id="mail" driver="mail" url="mailto:$mail?subject=Hello $name" classpath="mail.jar;activation.jar">
        <include href="mail.properties"/>
    </connection>

    <!-- Prepare User table and fill with data -->
    <script connection-id="db">
        DELETE FROM EMAIL_USERS;
        <include href="users.sql"/>
    </script>

    <!-- For each user in a database, execute script -->
    <query connection-id="db">
        SELECT MAIL, NAME FROM EMAIL_USERS;
        <script connection-id="mail">
            <![CDATA[
                <html>
                    <body>
                        Hello $name,
                        <p>This message has been generated by Scriptella ETL Mail example.
                        <hr>
                        <a href="http://scriptella.org/" title="Powered by Scriptella ETL">
                            <img src="http://scriptella.org/images/scriptella-powered.gif" width="88" height="31" border="0" alt="Powered by Scriptella ETL">
                        </a>
                    </body>
                </html>
            ]]>
        </script>
    </query>
</etl>

2020년 5월 30일 토요일 오전 6시 26분 58초 UTC+9, pd 님의 말:
To unsubscribe from this group and stop receiving emails from it send an email to scrip...@googlegroups.com.

pd

unread,
Jun 2, 2020, 12:08:15 PM6/2/20
to scrip...@googlegroups.com
It should be verter if you include mail.properties and log

El mar., 2 jun. 2020 4:14, <scrip...@googlegroups.com> escribió:
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to scriptella+...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages