codayblue / libmyemail Goto Github PK

cannot Build at centos 8

with below error

fatal error: Poco/Net/SecureSMTPClientSession.h: No such file or directory
#include "Poco/Net/SecureSMTPClientSession.h" /* Send the email over TLS this is needed */
^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
compilation terminated.
make[2]: *** [CMakeFiles/myemail.dir/build.make:63: CMakeFiles/myemail.dir/myemail.cc.o] Error 1
make[1]: *** [CMakeFiles/Makefile2:68: CMakeFiles/myemail.dir/all] Error 2
make: *** [Makefile:130: all] Error 2

Should make username and password optional and have another option to be able to pull it out of a config file also it should be looked into encrypting these values so that it is a little more secure.

It could be very interesting to not have any authentication required and be usable with:
SELECT sendmail('from@mydomain', 'to@mydomain', 'subject', 'body', 'localhost', 25);

Hi,
I'm trying to use libmyemail on Gentoo with mysql 8.0.23
I never used plugin with mysql...
What I did:

• installed dev-libs/poco-1.9.0-r2
• git clone https://github.com/codayblue/libmyemail.git
• cd libmyemail/
• mkdir build && cd build
• cmake -DINSTALL_DIR=/usr/lib64/mysql/plugin/ ../source
• make
  but get an error:

[ 50%] Building CXX object CMakeFiles/myemail.dir/myemail.cc.o
/usr/local/src/libmyemail/source/myemail.cc:33:4: erreur: « my_bool » ne nomme pas un type; vouliez-vous utiliser « bool » ?
   33 |    my_bool sendmail_init(UDF_INIT *initid, UDF_ARGS *args, char *message);
      |    ^~~~~~~
      |    bool
/usr/local/src/libmyemail/source/myemail.cc:41:1: erreur: « my_bool » ne nomme pas un type; vouliez-vous utiliser « bool » ?
   41 | my_bool sendmail_init(UDF_INIT *initid, UDF_ARGS *args, char *message) {
      | ^~~~~~~
      | bool
make[2]: *** [CMakeFiles/myemail.dir/build.make:82 : CMakeFiles/myemail.dir/myemail.cc.o] Erreur 1
make[1]: *** [CMakeFiles/Makefile2:95 : CMakeFiles/myemail.dir/all] Erreur 2

• sed -i 's/my_bool/bool/g' ../source/myemail.cc
• make
• make install
• ls /usr/lib64/mysql/plugin/libmyemail.so
  /usr/lib64/mysql/plugin/libmyemail.so
• rc-service mysql restart
• mysql -uroot -p -e "CREATE FUNCTION sendmail RETURNS STRING SONAME 'libmyemail.so';"
  But:
  Testing with:
  mysql > SELECT sendmail('from@mydomain', 'to@mydomain', 'subject', 'body', 'localhost', 587, 'myuser', 'mypwd', 1);
  crashes the mysql server.
  SMTP logs:
  postfix/smtpd[16100]: warning: TLS library problem: error:14094418:SSL routines:ssl3_read_bytes:tlsv1 alert unknown ca:ssl/record/rec_layer_s3.c:1543:SSL alert number 48:
  Testing with:
  mysql > SELECT sendmail('from@mydomain', 'to@mydomain', 'subject', 'body', 'localhost', 25, '', '', 0);
  nothing really happens.
  SMTP logs:

Apr 27 00:54:57 mysmtpserver postfix/smtpd[15375]: connect from mysmtpserver[myip]
Apr 27 00:54:57 mysmtpserver postfix/smtpd[15375]: disconnect from mysmtpserver[myip] ehlo=1 quit=1 commands=2

Any idea ?