[exim] Re: MySQL connection with SSL

2024-05-26 Thread Victor Ustugov via Exim-users
Gandalf Corvotempesta via Exim-users wrote on 25.05.2024 9:32: > any help on this? > im rally stuck, the new mysql server only accept ssl connections and i have > to connect an exim to it but doesn't work You should probably receive an error message "ERROR 3159 (HY000): Connections using insecure

[exim] Re: MySQL connection with SSL

2024-05-24 Thread Gandalf Corvotempesta via Exim-users
any help on this? im rally stuck, the new mysql server only accept ssl connections and i have to connect an exim to it but doesn't work anyone had success using SSL with mysql? Il gio 23 mag 2024, 20:54 Gandalf Corvotempesta < gandalf.corvotempe...@gmail.com> ha scritto: > This is a strace when

[exim] Re: MySQL connection with SSL

2024-05-23 Thread Gandalf Corvotempesta via Exim-users
This is a strace when trying to connect to a mysql server that has SSL forced (that's why i'm hitting an access denied) Now the configuration file is read as expected, but the option group that is forcing the ssl-mode seems to be ignored (honestly, as default, ssl is preferred, it should connect vi

[exim] Re: MySQL connection with SSL

2024-05-22 Thread Gandalf Corvotempesta via Exim-users
ok now the file is read as expected, i can see it from the trace, but i'm still getting access denied because the connection is not made with SSL. I'm out of ideas Il giorno ven 17 mag 2024 alle ore 21:39 Gandalf Corvotempesta ha scritto: > > Il giorno ven 17 mag 2024 alle ore 16:37 Jeremy Harri

[exim] Re: MySQL connection with SSL

2024-05-17 Thread Gandalf Corvotempesta via Exim-users
Il giorno ven 17 mag 2024 alle ore 16:37 Jeremy Harris via Exim-users ha scritto: > If there were, then it should go on to try those files. > This is not an Exim problem. This is the issue: https://jira.mariadb.org/browse/CONC-396 -- ## subscription configuration (requires account): ## https:

[exim] Re: MySQL connection with SSL

2024-05-17 Thread Jeremy Harris via Exim-users
On 17/05/2024 10:41, Gandalf Corvotempesta via Exim-users wrote: That's the standard workflow .. mysql tries to look for my.cnf in the /etc, then in /etc/mysql/my.cnf (and it finds there), then in other location (not found, as expected) But /etc/mysql/my.cnf exists and there are some includes in

[exim] Re: MySQL connection with SSL

2024-05-17 Thread Gandalf Corvotempesta via Exim-users
Il giorno gio 16 mag 2024 alle ore 22:55 Jeremy Harris via Exim-users ha scritto: > ... (I'm guessing) say to look fist in a directory called conf.d - > and we don't see the strace doing that either. > > I think you're not running the mysql configuration you think you are running. That's the sta

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Jeremy Harris via Exim-users
On 16/05/2024 21:28, Gandalf Corvotempesta via Exim-users wrote: # strace exim -be 2>&1 | grep my.cnf ${lookup mysql{SELECT password AS password}} access("/etc/my.cnf", R_OK) = -1 ENOENT (No such file or directory) access("/etc/mysql/my.cnf", R_OK) = 0 openat(AT_FDCWD, "/etc/my

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Gandalf Corvotempesta via Exim-users
# strace exim -be 2>&1 | grep my.cnf ${lookup mysql{SELECT password AS password}} access("/etc/my.cnf", R_OK) = -1 ENOENT (No such file or directory) access("/etc/mysql/my.cnf", R_OK) = 0 openat(AT_FDCWD, "/etc/mysql/my.cnf", O_RDONLY) = 3 access("/etc/mysql/conf.d//my.cnf", R_OK

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Gandalf Corvotempesta via Exim-users
Il giorno gio 16 mag 2024 alle ore 22:21 Jeremy Harris ha scritto: > If my.cnf is beaing read, but does not contain the actual conn spec > you want used, then there's something wrong with your "include" setup. > > That configuration can't get read by magic. The config is read, and it's the standa

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Jeremy Harris via Exim-users
On 16/05/2024 21:12, Gandalf Corvotempesta wrote: Not read because that file is included from my.cnf and my.cnf is read. If my.cnf is beaing read, but does not contain the actual conn spec you want used, then there's something wrong with your "include" setup. That configuration can't get read

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Gandalf Corvotempesta via Exim-users
Il giorno gio 16 mag 2024 alle ore 16:52 Jeremy Harris via Exim-users ha scritto: > Run a test using "exim -be" of a mysql expansion, under strace. > Is that file accessed? Not read because that file is included from my.cnf and my.cnf is read. But seems that the [exim] node is ignored (or the ss

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Jeremy Harris via Exim-users
On 16/05/2024 15:41, Gandalf Corvotempesta via Exim-users wrote: hide mysql_servers = 10.23.105.2[exim]/mail/username/dsHg*Qw!eNt6n%nH # cat /etc/mysql/mariadb.conf.d/99-exim.cnf [exim] ssl-mode=REQUIRED Run a test using "exim -be" of a mysql expansion, under strace. Is that file accessed?

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Gandalf Corvotempesta via Exim-users
Il giorno gio 16 mag 2024 alle ore 15:39 Gandalf Corvotempesta ha scritto: > EXACTLY THAT ! > thank you .. but it doesnt' work hide mysql_servers = 10.23.105.2[exim]/mail/username/dsHg*Qw!eNt6n%nH # cat /etc/mysql/mariadb.conf.d/99-exim.cnf [exim] ssl-mode=REQUIRED (ssl-mode default's

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Gandalf Corvotempesta via Exim-users
Il giorno gio 16 mag 2024 alle ore 13:01 Jeremy Harris via Exim-users ha scritto: > Use a Mysql option file giving the required connection specifications. > > See > https://exim.org/exim-html-current/doc/html/spec_html/ch-file_and_database_lookups.html#SECTsql > on "option group name". EXACTLY

[exim] Re: MySQL connection with SSL

2024-05-16 Thread Jeremy Harris via Exim-users
On 16/05/2024 11:11, Gandalf Corvotempesta via Exim-users wrote: another question: a new mysql server i've created has SSL required for all connections. How can I setup exim to use an SSL connection to mysql server ? Use a Mysql option file giving the required connection specifications. See h