[ppmt]

yes I think they are good. Was there any reason you decided to switch to swiftmailer?

[ppmt]

me again.

I decided to install a version on SI on my hosted account with byethost and originally I had the exact same problem.

They advised me to use port 384 instead of 290 and success it worked!!!

Only problem is that using the same port on my locally hosted is still not working. But I get a different error this time in php.log. I have replaced the name of the hostname and its ip in the log.

[04-Oct-2019 04:01:34 America/Los_Angeles] PHP Fatal error:  Uncaught Swift_TransportException: Expected response code 354 but got code "503", with message "503-All RCPT commands were rejected with this error:^M
503-Please turn on SMTP Authentication in your mail client.  <hostname>^M
503-(invoices.master2019.org) [<my IP>]:60170 is not permitted to relay^M
503-through this server without authentication.^M
503 Valid RCPT command must precede DATA^M
" in /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php:457
Stack trace:
#0 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(341): Swift_Transport_AbstractSmtpTransport->assertResponseCode('503-All RCPT co...', Array)
#1 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/EsmtpTransport.php(305): Swift_Transport_AbstractSmtpTransport->executeCommand('DATA\r\n', Array, Array, false, N in /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php on line 457

[ppmt]

I tried with SSL and TLS and got the same printout in both case

2019-09-29T11:19:09-07:00 DEBUG (7): init.php - authentication-enabled[] fake_auth[1]
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - After init.php - module(invoices] view[email]
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - After processing init.php for extensions
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - module[invoices] view[email] databaseBuilt[1] databasePopulated[1]
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - apply_db_patches[1]
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - config->authentication->enabled[] auth_session->id: 1
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - module - invoices
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - still_doing_setup[]
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - module[invoices] view[email] action[] id[1] menu[1]
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - After invoices/template
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - After api/xml or ajax
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - After extension_jquery_files
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - after custom/hooks.tpl
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - after header.tpl
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - After extension_php_insert_files, etc.
2019-09-29T11:19:09-07:00 DEBUG (7): index.php - my_path[modules/invoices/email.php]
2019-09-29T11:19:09-07:00 DEBUG (7): email.php - _GET stage[2]
2019-09-29T11:19:09-07:00 DEBUG (7): Export::getData() module:[invoice]
2019-09-29T11:19:09-07:00 DEBUG (7): Export::getData() - logo[http://invoices.master2019.org/templates/invoices/logos/_default_blank_logo.png]
2019-09-29T11:19:09-07:00 DEBUG (7): Export::getData() - templatePath[templates/invoices/default/template.tpl]
2019-09-29T11:19:09-07:00 DEBUG (7): Export::showData() - format[pdf]
2019-09-29T11:19:09-07:00 DEBUG (7): Pdf::generate() - pdfname[Invoice_1.pdf] destination[S]
2019-09-29T11:19:09-07:00 DEBUG (7): Pdf::generate() - Before WriteHTML
2019-09-29T11:19:09-07:00 DEBUG (7): Pdf::generate() - Before Output
2019-09-29T11:19:09-07:00 DEBUG (7): Pdf::generate() - returning Output result
2019-09-29T11:19:09-07:00 DEBUG (7): email.php - After execute
2019-09-29T11:19:09-07:00 DEBUG (7): email.php - Before send
2019-09-29T11:19:09-07:00 DEBUG (7): Email::send() - Before Swift_Mailer send()

I really don’t know what else to do at this stage and will probably stay with the version that is not using swiftmail as it is working

[ppmt]

Me again.

I send an email to one of the host that doesn’t work (migadu) asking them if there was anything they could do to help me and here is what they told me:

When sending via our SMTP you have to authenticate. Please configure your email client to use plain text authentication over StartTLS.

Here is the config I am supposed to enter:

host: smtp.migadu.com
user: my email
password: my password
port: 587
security: STARTTLS

I tried the config in SI with TLS and STARTTLS but the result is the same

Here is again the error I get with it.

response code 250 but got code "550", with message "550 Authentication required " in /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php:457 
Stack trace: #0 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(341): Swift_Transport_AbstractSmtpTransport->assertResponseCode('550 Authenticat...', Array) #1 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/EsmtpTransport.php(305): Swift_Transport_AbstractSmtpTransport->executeCommand('MAIL FROM:<phil...', Array, Array, false, NULL) #2 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(390): Swift_Transport_EsmtpTransport->executeCommand('DATA\r\n', Array, Array) #3 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(497): Swift_Transport_AbstractSmtpTransport->doDataCommand(Array) #4 /var/www/html/vendor/swiftm in /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php on line 457

[ppmt]

Just a question for you. DO you use your own smtp or a hosted one ?

I am asking because I have access to a few smtp server and not one of them is working. They all give different errors but bottom line is that I can’t get any of them to work!

Sorry to be such a pain !

[ppmt]

I am using the premium byethost and what is strange is that if I use the old version of SI (pre swtiftmailer) it works fine so their config is working.

I have tried another email provider and with them I get a different error.

Fatal error: Uncaught Swift_TransportException: Expected response code 250 but got code "550", with message "550 Authentication required " in /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php:457 
Stack trace: #0 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(341): Swift_Transport_AbstractSmtpTransport->assertResponseCode('550 Authenticat...', Array) #1 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/EsmtpTransport.php(305): Swift_Transport_AbstractSmtpTransport->executeCommand('MAIL FROM:<phil...', Array, Array, false, NULL) #2 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(390): Swift_Transport_EsmtpTransport->executeCommand('DATA\r\n', Array, Array) #3 /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(497): Swift_Transport_AbstractSmtpTransport->doDataCommand(Array) #4 /var/www/html/vendor/swiftm in /var/www/html/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php on line 457

so no timeout. The config says to use STARTTLS which I assume is TLS?

[ppmt]

I have set up the section as per my host. The setting are the same as on the working machine running the old version of SI

email.host = sv4.byethost4.org
email.smtp_auth = true
email.username = myemail@mydomain.com
email.password = mypassword
email.smtpport = 290
email.secure = SSL
email.ack = false
email.use_local_sendmail = false

[ppmt]

On the production machine

PHP 7.2.19-0ubuntu0.18.04.2 (cli) (built: Aug 12 2019 19:34:28) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.2.19-0ubuntu0.18.04.2, Copyright (c) 1999-2018, by Zend Technologies

and on the test machine

PHP 7.3.9 (cli) (built: Sep 12 2019 10:15:36) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.9, Copyright (c) 1998-2018 Zend Technologies

[ppmt]

Ok I have made some progress. I decided to install the master2010_2 version on the “production” machine.

I created a new database so I can start from scratch. During the database installation I have a 504 Gateway timeout but pressing reload allowed me to continue.

I then tested sending an email with my “production” version of SI and it worked well.

When I used the master2019_2 version then I ended with the same grey screen but this time there was a message printed. I edited the smtp host.

So there is a timeout but I am not sure why since it works for the production version.

Fatal error: Uncaught Swift_IoException: Connection to my_smtp_host:290 Timed Out in /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/StreamBuffer.php:166 Stack trace: #0 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(467): Swift_Transport_StreamBuffer->readLine(0) #1 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(358): Swift_Transport_AbstractSmtpTransport->getFullResponse(0) #2 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php(147): Swift_Transport_AbstractSmtpTransport->readGreeting() #3 /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Mailer.php(65): Swift_Transport_AbstractSmtpTransport->start() #4 /var/www/simpleinvoices/simpleinvoi in /var/www/simpleinvoices/simpleinvoices-master_2019.2/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php on line 473

[ppmt]

I am not sure how to run the composer command as I can’t find any command like that in the SI directory.

I attached an si.log extract as for some reason I can’t paste it in he message itself.

PS: ignore the si_extract.log file. It’s the same as the txt one

• This reply was modified 5 years, 5 months ago by ppmt.
• This reply was modified 5 years, 5 months ago by ppmt.

Attachments:

1. si_extract.txt

[ppmt]

Here is what I do:

I click the email icon on the invoice and I get redirected to that url:
http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1

I fill in the content box and when I press Email I eventually after a some seconds get redirected to that url:
http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=2&id=1

Here is the access.log from nginx.

192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /index.php?module=invoices&view=email&stage=1&id=1 HTTP/1.1" 200 14257 "http://192.168.1.83:8000/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"
192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /images/common/required-small.png HTTP/1.1" 200 1676 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"
192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /images/common/help-small.png HTTP/1.1" 200 1193 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"
192.168.1.100 - - [26/Sep/2019:09:51:32 +0000] "GET /images/common/tick.png HTTP/1.1" 200 537 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"

<this is where I press Email>

172.29.0.1 - - [26/Sep/2019:09:53:40 +0000] "GET /templates/invoices/default/style.css HTTP/1.0" 200 1009 "-" "-" "-"
172.29.0.1 - - [26/Sep/2019:09:53:40 +0000] "GET /templates/invoices/logos/_default_blank_logo.png HTTP/1.0" 200 168 "-" "-" "-"
172.29.0.1 - - [26/Sep/2019:09:53:40 +0000] "GET /templates/invoices/logos/_default_blank_logo.png HTTP/1.0" 200 168 "-" "-" "-"

<about 10 to 20 second delay before I get redirected to the url below with a empty grey screen>

192.168.1.100 - - [26/Sep/2019:09:54:11 +0000] "POST /index.php?module=invoices&view=email&stage=2&id=1 HTTP/1.1" 200 6097 "http://192.168.1.83:8000/index.php?module=invoices&view=email&stage=1&id=1" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0" "-"

Nothing in error.log nor the php.log.

[ppmt]

My bad the error above was because I forgot to copy my invoices template.

After that the error above is gone but I am back to the grey screen!

[ppmt]

Ok. I managed to install the lastest version after a bit of timeout issue. Not sure if it is because my test machine is a bit slow but during the database upgrade I had a 504 Gateway timeout.

After reload the page I still wanted to apply the last patch (the one about the foreign key)

Eventually it worked so I could test sending email…and it still fails…I get the following message

Both pdf_string and pdf_file_name must be set or left empty

[ppmt]

I have downloaded the master_2019.2.1 and when I load it tells me to update the database. When I do it after a few second I get this error:

SqlPatchManager::runSqlPatch() error. See error log for more information.

in php.log I see this:

/var/www/html/tmp/log # cat php.log 
[25-Sep-2019 09:42:39 Europe/London] PdoDb - debugger(): ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
[25-Sep-2019 09:42:39 Europe/London] PdoDb - query(): Execute error.Array
(
    [0] => 42000
    [1] => 1091
    [2] => Can't DROP INDEX <code>id</code>; check that it exists
)

[25-Sep-2019 09:42:39 Europe/London] PdoDb - backtrace: Array
(
    [0] => Array
        (
            [file] => /var/www/html/Inc/Claz/SqlPatchManager.php
            [line] => 241
            [function] => query
            [class] => Inc\Claz\PdoDb
            [object] => Inc\Claz\PdoDb Object
                (
                    [caseStmts:Inc\Claz\PdoDb:private] => 
                    [debug:Inc\Claz\PdoDb:private] => 
                    [debug_label:Inc\Claz\PdoDb:private] => 
                    [debug_microtime:Inc\Claz\PdoDb:private] => 0
                    [distinct:Inc\Claz\PdoDb:private] => 
                    [excludedFields:Inc\Claz\PdoDb:private] => Array
                        (
                        )

                    [fauxPost:Inc\Claz\PdoDb:private] => 
                    [fieldPrefix:Inc\Claz\PdoDb:private] => 
                    [functions:Inc\Claz\PdoDb:private] => 
                    [groupBy:Inc\Claz\PdoDb:private] => 
                    [havings:Inc\Claz\PdoDb:private] => 
                    [joinStmts:Inc\Claz\PdoDb:private] => 
                    [keyPairs:Inc\Claz\PdoDb:private] => 
                    [lastCommand:Inc\Claz\PdoDb:private] => 
                    [limit:Inc\Claz\PdoDb:private] => 0
                    [noErrorLog:Inc\Claz\PdoDb:private] => 
                    [onDuplicateKey:Inc\Claz\PdoDb:private] => 
                    [orderBy:Inc\Claz\PdoDb:private] => 
                    [pdoDb:Inc\Claz\PdoDb:private] => PDO Object
                        (
                        )

                    [pdoDb2:Inc\Claz\PdoDb:private] => PDO Object
                        (
                        )

                    [saveLastCommand:Inc\Claz\PdoDb:private] => 
                    [selectAll:Inc\Claz\PdoDb:private] => 
                    [selectList:Inc\Claz\PdoDb:private] => 
                    [selectStmts:Inc\Claz\PdoDb:private] => 
                    [table_columns:Inc\Claz\PdoDb:private] => 
                    [table_constraints:Inc\Claz\PdoDb:private] => 
                    [table_engine:Inc\Claz\PdoDb:private] => InnoDB
                    [table_schema:Inc\Claz\PdoDb:private] => fear_invoices
                    [transaction:Inc\Claz\PdoDb:private] => 1
                    [usePost:Inc\Claz\PdoDb:private] => 1
                    [whereClause:Inc\Claz\PdoDb:private] => 
                )

            [type] => ->
            [args] => Array
                (
                    [0] => ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
                )

        )

    [1] => Array
        (
            [file] => /var/www/html/Inc/Claz/SqlPatchManager.php
            [line] => 314
            [function] => runSqlPatch
            [class] => Inc\Claz\SqlPatchManager
            [type] => ::
            [args] => Array
                (
                    [0] => 308
                    [1] => Array
                        (
                            [name] => Remove dup id key from invoice_item_attachments and fix products_attributes type_id data type
                            [patch] => ALTER TABLE <code>si_invoice_item_attachments</code> DROP INDEX <code>id</code>;ALTER TABLE <code>si_products_attributes</code> MODIFY <code>type_id</code> INT(11) UNSIGNED NULL;
                            [date] => 20190329
                            [source] => fearless359
                        )

                )

        )

    [2] => Array
        (
            [file] => /var/www/html/index.php
            [line] => 183
            [function] => runPatches
            [class] => Inc\Claz\SqlPatchManager
            [type] => ::
            [args] => Array
                (
                )

        )

)

[25-Sep-2019 09:42:39 Europe/London] SqlPatchManager::runSqlPatch() - PdoDb - query(): Execute error. See error_log.

Whis other logs should I be looking at? si.log is empty

[ppmt]

I have it set to en_GB and it did not fix the issue

[Author]

Posts