Welcome to Centmin Mod Community
Register Now

Any Sendy.co Users ?

Discussion in 'Other Web Apps usage' started by eva2000, Feb 7, 2016.

  1. ModeltogTossen

    ModeltogTossen I wish I could??

    313
    97
    28
    Dec 20, 2015
    Denmark
    Ratings:
    +143
    Local Time:
    12:06 AM
    1.9.12
    10.0.23
    Its fine on my posteo.de (show both html/plain) and my linux sylpheed email client which is stripping html..

    upload_2016-2-11_15-40-46.png

    upload_2016-2-11_15-41-12.png

     
  2. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    @ModeltogTossen thanks for confirmation

    Had a sendy.co bug with the tracking image code (t.php) in emails in gmail web browser being broken so didn't track opened newsletter email stats. Sendy.co author said he doesn't officially support nginx only apache. So finally fixed the problem myself, it was due to sendy.co's php code from their geoinc.php file file causing 500 errors.

    Now it's fixed, got newsletter image tracking and open mail stats working :D

    upload_2016-2-16_3-43-6.png
     
  3. Andy

    Andy Active Member

    544
    89
    28
    Aug 6, 2014
    Ratings:
    +133
    Local Time:
    5:06 PM
    Can you post your complete nginx rules as well as any fixes on sendy.co forum as well as here so people can use it on their nginx server?
    I will be using it for sure.
     
  4. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    centmin mod based nginx rewrites are still same as posted at https://community.centminmod.com/posts/25831/

    sendy.co forum is moderated each post goes to private inbox message to dev and he filters each to see which gets posted on the sendy.co forums

    i've contacted Ben at sendy.co confirming the geoinc.php bug so wait to see what he says due to timezone differences heh

    As sendy.co is a paid script posting the actual code isn't the right thing to do. so here's just a diff patch https://gist.github.com/centminmod/dec1f71718386264e7ef. Not a 100% fix just hack job to get t.php tracking images working with php-fpm which already has geoip php extension loaded
     
  5. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    Hi @eva2000

    I also use Sendy currently on a Apache server, and i'm considering migrating my current installation to a new server using the latest CentminMOD V1.2.3-Eva2000.09 beta.

    But before i do the migration, i really need to know if you have your Sendy working at 100% with no problems. So with your nginx rules + the patch for the tracking images, is your Sendy installation working at 100% with no issues?

    I'm asking this because as you said Sendy official don't support nginx. But it seems you and other users on the forum are using it with CentminMOD.

    Also it would be great if you could insert on your website menu Resourses > Nginx configurations, a new article for Sendy. Besides helping current users, i think it could attract more users to CentminMOD.

    Thanks and Keep up the good work. CentminMOD is great!
     
  6. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    I haven't touched my sendy install in a while as focused on getting other things done. But can confirm latest sendy.co script version still needs the nginx patch for php file to fix the tracking code outlined at Any Sendy.co Users ? | Page 3 | Centmin Mod Community Seems the author just totally ignored my bug report for Nginx php-fpm compatibility.

    Will find some time to retest eventually and may add to resources page.
     
  7. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    Hi @eva2000

    About the patch you made to fix the tracking code, i have try to find the file: includes/helpers/geo/geoinc.php, but this file does not exist in my Sendy installation. Do i need to create that file?

    Can you please explain to me in a different / easier way what steps i must do to implement the patch fix?

    Note: Sorry to hear that Ben from Sendy ignored your bug report. He seems to be a great guy and always available to help, so being a nginx server must be the reason he ignored, because he says he only gives support to Apache servers. But i will also try to talk in Sendy forum and with other users to see if together we can make Ben from Sendy to also support nginx.

    Thanks
     
  8. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    file should be there, it's there in 2.0.6.1 and 2.1.0.2 versions i tried

    IIRC, technically it isn't a nginx bug but php-fpm/php issue which could happen with apache or nginx if php-fpm/php has already installed geoip php extension and is not using sendy.co included version. The patch just bypasses sendy.co version if geoip php extension is detected as already installed. Centmin Mod LEMP stacks more likely to run into this issue as geoip php extension is installed by default with php-fpm. While many Apache installs don't have geoip php extension, hence why Sendy.co includes its own bundled in version.

    and the errors logged before patch
    Code (Text):
    PHP Fatal error: Cannot redeclare geoip_country_code_by_name_v6() in .../includes/helpers/geo/geoip.inc on line 430
    
    PHP Notice: Constant GEOIP_COUNTRY_EDITION already defined in .../includes/helpers/geo/geoip.inc on line 31
    
     
    Last edited: Sep 1, 2016
  9. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    Hi @eva2000

    Thanks for the information. There is a typo error on your message and that was the reason why i could not find the file. The file name is not "geoinc.php". The correct file name is: "geoip.inc"

    So the final file location is: includes/helpers/geo/geoip.inc

    You should correct this on this thread and also on Github - sendy.co includes/helpers/geo/geoinc.php patch fix for nginx / php-fpm when php geoip extension is loaded - fixes broken sendy.co t.php tracking images which give 500 internal server errors · GitHub
     
  10. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    whoops :)

    updated
     
  11. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    Hi all,

    I'm having a small problem with Sendy running on Centminmod + PHP 7 (with PHP 5.6 all works fine). The problem is that in some specific cases, it shows "NAN%" error's on the Campaign Report as you can see on the screenshot image link i leave bellow:

    Imgur: The most awesome images on the Internet

    I have already talked with Sendy developer and he said that to resolve this I should disable "ONLY_FULL_GROUP_BY" function and i already done that, but the problem still exists.

    So I please ask all Sendy users running PHP 7, if you can give me a small help by just making a quick test on your Sendy installation. To make the test you just have to follow the next 3 steps:

    1- Create a new list with just 1 subscriber (the Amazon SES test bounce email): bounce@simulator.amazonses.com
    2- Send 1 campaign just to that list.
    3- After campaign is sent, check the Campaign Report to see if you see "NAN%" errors.

    Thanks
     
  12. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Thanks for heads up @nqservices i only use Sendy with PHP 5.6 right now :)

    MariaDB 10 default sql_mode
    Code (Text):
    mysql -e "select @@sql_mode;"
    +--------------------------------------------+
    | @@sql_mode                                 |
    +--------------------------------------------+
    | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
    +--------------------------------------------+


    ONLY_FULL_GROUP_BY is not set anyway MySQL :: MySQL 5.6 Reference Manual :: 5.1.8 Server SQL Modes
     
    Last edited: Sep 29, 2016
  13. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    Hi @eva2000

    Can you please make the test (the 3 steps) on a server using PHP7 to see if you also confirm the NAN% errors?

    I need to really confirm if this is a Sendy bug or a problem with my server setup.

    Thanks
     
  14. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    No time right now, so you'd have to test on your own. What happens if there's more than 1 subscriber to the list ?
     
  15. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    If there is more than 1 subscriber the problem does not happen. But for example if the subscriber is not a bounce, the problem will also not happen.

    Also something strange, is that after i see the NAN% error if i go to the Bounce list and delete the bounced email, and then go back to the campaign, the error is resolved.

    As said before this is a strange and specific problem that happens is just a few cases. The everyday Sendy user with multiple subscribers will never notice this problem. But it can result in incorrect campaign reports.

    I have already made many tests on 2 different servers, so that is why i need someone else to check on their end.

    Hope you can have the time soon or any other user here on the forum.

    Thanks
     
  16. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    reading the google results sounds like it's a php division or math issue ???
     
  17. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    Thanks for also searching about this. I have too.. but at this point and after all the tests i made, i really need some other user to test on it's own Sendy server. This is the only way i can be sure if this is a problem related with Sendy or just my own specific installation.

    If anyone else confirm this problem i can again contact Sendy developer and tell him that this is a Sendy bug.

    @eva2000 if in a near future you have the time to test your Sendy with PHP 7 i would really appreciate!

    And to all the other Sendy users here, can anyone make the simple test?

    Thanks
     
  18. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Sendy.co doesn't seem to be 100% ready for PHP 7.0.11 at least but the author won't do anything if it's php-fpm related like the other geoip bug we had

    Code (Text):
    tail -150 /var/log/php-fpm/www-php.error.log
    [29-Sep-2016 19:16:32 UTC] PHP Notice:  Undefined index: userID in /home/nginx/domains/domain.com/public/includes/functions.php on line 1
    [29-Sep-2016 19:16:32 UTC] PHP Notice:  Undefined index: license in /home/nginx/domains/domain.com/public/includes/functions.php on line 1
    [29-Sep-2016 19:16:32 UTC] PHP Notice:  Undefined index: license in /home/nginx/domains/domain.com/public/includes/functions.php on line 1
    [29-Sep-2016 19:16:33 UTC] PHP Notice:  Undefined index: license in /home/nginx/domains/domain.com/public/includes/functions.php on line 1
    [29-Sep-2016 19:16:33 UTC] PHP Notice:  Undefined index: license in /home/nginx/domains/domain.com/public/includes/functions.php on line 1
    [29-Sep-2016 19:16:33 UTC] PHP Warning:  session_destroy(): Trying to destroy uninitialized session in /home/nginx/domains/domain.com/public/includes/functions.php on line 1
    [30-Sep-2016 05:16:37 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:16:37 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:25:21 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:25:21 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:40:24 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:40:25 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:40:56 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:40:56 Australia/Brisbane] PHP Notice:  Undefined property: stdClass::$body in /home/nginx/domains/domain.com/public/includes/helpers/ses.php on line 619
    [30-Sep-2016 05:46:24 Australia/Brisbane] PHP Notice:  Undefined index: e in /home/nginx/domains/domain.com/public/delete-from-list.php on line 76
    [30-Sep-2016 05:46:24 Australia/Brisbane] PHP Notice:  Undefined index: e in /home/nginx/domains/domain.com/public/delete-from-list.php on line 81
    [30-Sep-2016 05:46:24 Australia/Brisbane] PHP Notice:  Undefined index: e in /home/nginx/domains/domain.com/public/delete-from-list.php on line 117


    Code (Text):
    php -v
    PHP 7.0.11 (cli) (built: Sep 29 2016 19:37:09) ( NTS )
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
        with Zend OPcache v7.0.11, Copyright (c) 1999-2016, by Zend Technologies


    Code (Text):
    php -m
    [PHP Modules]
    bcmath
    bz2
    calendar
    Core
    ctype
    curl
    date
    dom
    enchant
    exif
    filter
    ftp
    gd
    geoip
    gettext
    gmp
    hash
    iconv
    igbinary
    imagick
    imap
    intl
    json
    ldap
    libxml
    mailparse
    mbstring
    mcrypt
    memcache
    memcached
    mysqli
    mysqlnd
    openssl
    pcntl
    pcre
    PDO
    pdo_mysql
    pdo_sqlite
    Phar
    posix
    pspell
    readline
    redis
    Reflection
    session
    shmop
    SimpleXML
    snmp
    soap
    sockets
    SPL
    sqlite3
    standard
    sysvmsg
    sysvsem
    sysvshm
    tidy
    tokenizer
    xml
    


    I am unable to add bounce@simulator.amazonses.com subscriber manually to my lists with PHP 7.0.11, works fine on PHP 5.6.26

    Sendy.co Version 2.1.1.4
     
    Last edited: Sep 30, 2016
  19. nqservices

    nqservices Member

    70
    14
    8
    Jun 17, 2016
    Ratings:
    +28
    Local Time:
    11:06 PM
    Yes, i know that and i really hope Sendy author can consider supporting nginx/php-fpm in a near future...

    That is why that i tested on 2 different servers, one running CentminMOD and the other running a LAMP stack.

    Many other users on the forum say that they use Sendy with PHP7 and Sendy author also says Sendy is fully compatible with PHP7.. but looking at your logs it seems not..

    Anyway i will wait until anyone can test Sendy with PHP7 + CentminMOD in order to see if my error can be reproduced.

    Thanks
     
  20. eva2000

    eva2000 Administrator Staff Member

    55,223
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,831
    Local Time:
    8:06 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+