Re: sqlite tables
fair enough On Mon, Sep 03, 2018 at 07:44:12AM -0400, Matt Schwartz wrote: > Yes, I'm interested in getting those going so I can update the > table_sqlite(5) page for you. :-) Basic files do work well enough though. > > On Mon, Sep 3, 2018, 4:29 AM Gilles Chehade wrote: > > > On Sun, Sep 02, 2018 at 10:26:15PM -0400, Matt Schwartz wrote: > > > Does anyone know how the following tables work? > > > query_netaddr > > > query_userinfo > > > query_source > > > query_mailaddr > > > query_addrname > > > > > > I am trying to convert my setup entirely to sqlite. > > > > > > > any particular reason ? > > > > > > -- > > Gilles Chehade > > > > https://www.poolp.org @poolpOrg > > -- Gilles Chehade https://www.poolp.org @poolpOrg -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: sqlite tables
Yes, I'm interested in getting those going so I can update the table_sqlite(5) page for you. :-) Basic files do work well enough though. On Mon, Sep 3, 2018, 4:29 AM Gilles Chehade wrote: > On Sun, Sep 02, 2018 at 10:26:15PM -0400, Matt Schwartz wrote: > > Does anyone know how the following tables work? > > query_netaddr > > query_userinfo > > query_source > > query_mailaddr > > query_addrname > > > > I am trying to convert my setup entirely to sqlite. > > > > any particular reason ? > > > -- > Gilles Chehade > > https://www.poolp.org @poolpOrg >
Re: sqlite tables
On Sun, Sep 02, 2018 at 10:26:15PM -0400, Matt Schwartz wrote: > Does anyone know how the following tables work? > query_netaddr > query_userinfo > query_source > query_mailaddr > query_addrname > > I am trying to convert my setup entirely to sqlite. > any particular reason ? -- Gilles Chehade https://www.poolp.org @poolpOrg -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: sqlite tables
On Sun, Sep 02, 2018 at 10:12:13PM -0500, ed...@pettijohn-web.com wrote: > > On Sep 2, 2018 9:26 PM, Matt Schwartz wrote: > > > > Does anyone know how the following tables work? > > query_netaddr > > query_userinfo > > query_source > > query_mailaddr > > query_addrname > > > > I am trying to convert my setup entirely to sqlite. > > > > Thanks, > > Matt > > > > -- > > You received this mail because you are subscribed to misc@opensmtpd.org > > To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org > > > > My bad just realized you were specifically asking about the ones not > mentioned in the manual. I haven't used them, but I imagine it would be > similar to how those tables work as described in table(5) just via SQL > statements. indeed -- Gilles Chehade https://www.poolp.org @poolpOrg -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: sqlite tables
On Sep 2, 2018 9:26 PM, Matt Schwartz wrote: > > Does anyone know how the following tables work? > query_netaddr > query_userinfo > query_source > query_mailaddr > query_addrname > > I am trying to convert my setup entirely to sqlite. > > Thanks, > Matt > > -- > You received this mail because you are subscribed to misc@opensmtpd.org > To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org > My bad just realized you were specifically asking about the ones not mentioned in the manual. I haven't used them, but I imagine it would be similar to how those tables work as described in table(5) just via SQL statements.
Re: sqlite tables
On Sep 2, 2018 9:26 PM, Matt Schwartz wrote: > > Does anyone know how the following tables work? > query_netaddr > query_userinfo > query_source > query_mailaddr > query_addrname > > I am trying to convert my setup entirely to sqlite. > > Thanks, > Matt > > -- > You received this mail because you are subscribed to misc@opensmtpd.org > To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org > https://github.com/OpenSMTPD/OpenSMTPD-extras/blob/master/extras/tables/table-sqlite/table-sqlite.5 Or if you already have extras installed: $ man 5 table-sqlite It is extremely detailed.
sqlite tables
Does anyone know how the following tables work? query_netaddr query_userinfo query_source query_mailaddr query_addrname I am trying to convert my setup entirely to sqlite. Thanks, Matt -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: [Extras] Problems with sqlite tables
On 07/26/15 02:47, Joerg Jung wrote: Am 25.07.2015 um 22:18 schrieb James Lott ja...@lottspot.com mailto:ja...@lottspot.com: Interestingly, it looks to me like opensmtpd does actually check the /usr/local/libexec/opensmtpd directory for modules. When I remove the module from that directory, smtpd does not even start anymore (as opposed to starting and instantly giving up). root@smtp:/usr/local/etc/mail-config # mv /usr/local/libexec/opensmtpd/table-sqlite /usr/libexec/smtpd/ root@smtp:/usr/local/etc/mail-config # service smtpd onestart Performing sanity check on smtpd configuration: fatal: table_create: backend sqlite does not exist /usr/local/etc/rc.d/smtpd: WARNING: failed precmd routine for smtpd If that path is hardcoded in the upstream OpenSMTPD source, then I would guess I'm dealing with a patched codebase... I guess I'll have to try grabbing the upstream sources directly and see if I run into the same issue. Forget that, the path is not hardcoded and not your problem. I misread an #ifdef in the portable code. Sorry for the noise!! On 07/25/2015 12:08 PM, Joerg Jung wrote: On Sat, Jul 25, 2015 at 10:52:36AM -0700, James Lott wrote: Hey folks, I'm running OpenSMTPD 5.7.1 + table-sqlite from extras. I'm simply trying to get the sqlite tables to work at all. I haven't even gotten as far as trying to use them in my rules. I have the following config files: == smtpd.conf table aliasesfile:/etc/mail/aliases table mxdb sqlite:/usr/local/etc/mail-config/mxdb/smtpd.sqlite.conf listen on localhost port 2587 accept for local alias aliases deliver to mbox accept for any relay ==smtpd.sqlite.conf dbpath /usr/local/var/mxdb.sqlite query_domainselect name from domain where domain = ? query_alias select destination from alias where alias_user||'@'||alias_domain = ? OpenSMTPD will pass the config tests and start, but will then immediately die. Jul 25 10:36:36 smtp smtpd[61374]: info: OpenSMTPD 5.7.1p1 starting Jul 25 10:36:36 smtp smtpd[61375]: info: startup [debug mode] Jul 25 10:36:36 smtp smtpd[61378]: warn: table-proc: pipe closed Jul 25 10:36:36 smtp smtpd[61378]: fatal: table-proc: exiting Jul 25 10:36:36 smtp smtpd[61376]: warn: queue - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61377]: warn: control - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61375]: warn: parent - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61380]: warn: pony - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61379]: warn: scheduler - queue: pipe closed Jul 25 10:36:36 smtp smtpd[61381]: warn: ca - control: pipe closed Smtpd will start and run just fine if I comment out the table mxdb line. Are you starting like so: # smtpd -d If so add some v's: # smtpd -d Otherwise maybe just make sure smtpd.sqlite.conf and mxdb.sqlite exist ie no typos. I'm not sure, but I have a guess for you: I think -extras configure.ac has a bug where tables, filters, etc are installed in $prefix/libexec/opensmtpd But smtpd explicitly looks in (hardcoded) /usr/libexec/smtpd for them. Thus, your table-sqlite is not loaded correctly and smtpd dies. Regards, Joerg Unrelated to OP problem, but this is an issue for OpenBSD version. It installs to /usr/libexec/opensmtpd, but smtpd wants it in /usr/libexec/smtpd. ./configure --libexecdir=/usr/libexec/smtpd makes it install to /usr/libexec/smtpd/opensmtpd.
Re: [Extras] Problems with sqlite tables
Am 25.07.2015 um 22:18 schrieb James Lott ja...@lottspot.com: Interestingly, it looks to me like opensmtpd does actually check the /usr/local/libexec/opensmtpd directory for modules. When I remove the module from that directory, smtpd does not even start anymore (as opposed to starting and instantly giving up). root@smtp:/usr/local/etc/mail-config # mv /usr/local/libexec/opensmtpd/table-sqlite /usr/libexec/smtpd/ root@smtp:/usr/local/etc/mail-config # service smtpd onestart Performing sanity check on smtpd configuration: fatal: table_create: backend sqlite does not exist /usr/local/etc/rc.d/smtpd: WARNING: failed precmd routine for smtpd If that path is hardcoded in the upstream OpenSMTPD source, then I would guess I'm dealing with a patched codebase... I guess I'll have to try grabbing the upstream sources directly and see if I run into the same issue. Forget that, the path is not hardcoded and not your problem. I misread an #ifdef in the portable code. Sorry for the noise!! On 07/25/2015 12:08 PM, Joerg Jung wrote: On Sat, Jul 25, 2015 at 10:52:36AM -0700, James Lott wrote: Hey folks, I'm running OpenSMTPD 5.7.1 + table-sqlite from extras. I'm simply trying to get the sqlite tables to work at all. I haven't even gotten as far as trying to use them in my rules. I have the following config files: == smtpd.conf table aliases file:/etc/mail/aliases table mxdb sqlite:/usr/local/etc/mail-config/mxdb/smtpd.sqlite.conf listen on localhost port 2587 accept for local alias aliases deliver to mbox accept for any relay ==smtpd.sqlite.conf dbpath /usr/local/var/mxdb.sqlite query_domainselect name from domain where domain = ? query_alias select destination from alias where alias_user||'@'||alias_domain = ? OpenSMTPD will pass the config tests and start, but will then immediately die. Jul 25 10:36:36 smtp smtpd[61374]: info: OpenSMTPD 5.7.1p1 starting Jul 25 10:36:36 smtp smtpd[61375]: info: startup [debug mode] Jul 25 10:36:36 smtp smtpd[61378]: warn: table-proc: pipe closed Jul 25 10:36:36 smtp smtpd[61378]: fatal: table-proc: exiting Jul 25 10:36:36 smtp smtpd[61376]: warn: queue - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61377]: warn: control - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61375]: warn: parent - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61380]: warn: pony - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61379]: warn: scheduler - queue: pipe closed Jul 25 10:36:36 smtp smtpd[61381]: warn: ca - control: pipe closed Smtpd will start and run just fine if I comment out the table mxdb line. I'm not sure, but I have a guess for you: I think -extras configure.ac has a bug where tables, filters, etc are installed in $prefix/libexec/opensmtpd But smtpd explicitly looks in (hardcoded) /usr/libexec/smtpd for them. Thus, your table-sqlite is not loaded correctly and smtpd dies. Regards, Joerg This issue is being experienced on FreeBSD 10.1. Am I doing something wrong that anyone might be able to point to? Thanks in advance for any pointers! -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: [Extras] Problems with sqlite tables
On Sun, 26 Jul 2015 08:03:45 -0700, Edgar Pettijohn ed...@pettijohn-web.com wrote: # smtpd -d If so add some v's: # smtpd -d Do the extra stmpd 'v' flags produce more verbose output on all platforms? I just tried this on Arch linux and can't tell that smptd -d yields any more output than smtpd -dv -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: [Extras] Problems with sqlite tables
On 07/26/15 13:42, Seth wrote: On Sun, 26 Jul 2015 08:03:45 -0700, Edgar Pettijohn ed...@pettijohn-web.com wrote: # smtpd -d If so add some v's: # smtpd -d Do the extra stmpd 'v' flags produce more verbose output on all platforms? I just tried this on Arch linux and can't tell that smptd -d yields any more output than smtpd -dv I don't think it does. Its just a habit for me because httpd does behave that way. -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: [Extras] Problems with sqlite tables
Well it turns out I had some incorrect paths and an error in my query config, so certainly no one could have saved me from myself... `smtpd -d` is exactly what I needed in order to figure out my problems though. Thanks for all the help everyone! On Sunday, July 26, 2015 10:03:45 Edgar Pettijohn wrote: On 07/26/15 02:47, Joerg Jung wrote: Am 25.07.2015 um 22:18 schrieb James Lott ja...@lottspot.com mailto:ja...@lottspot.com: Interestingly, it looks to me like opensmtpd does actually check the /usr/local/libexec/opensmtpd directory for modules. When I remove the module from that directory, smtpd does not even start anymore (as opposed to starting and instantly giving up). root@smtp:/usr/local/etc/mail-config # mv /usr/local/libexec/opensmtpd/table-sqlite /usr/libexec/smtpd/ root@smtp:/usr/local/etc/mail-config # service smtpd onestart Performing sanity check on smtpd configuration: fatal: table_create: backend sqlite does not exist /usr/local/etc/rc.d/smtpd: WARNING: failed precmd routine for smtpd If that path is hardcoded in the upstream OpenSMTPD source, then I would guess I'm dealing with a patched codebase... I guess I'll have to try grabbing the upstream sources directly and see if I run into the same issue. Forget that, the path is not hardcoded and not your problem. I misread an #ifdef in the portable code. Sorry for the noise!! On 07/25/2015 12:08 PM, Joerg Jung wrote: On Sat, Jul 25, 2015 at 10:52:36AM -0700, James Lott wrote: Hey folks, I'm running OpenSMTPD 5.7.1 + table-sqlite from extras. I'm simply trying to get the sqlite tables to work at all. I haven't even gotten as far as trying to use them in my rules. I have the following config files: == smtpd.conf table aliasesfile:/etc/mail/aliases table mxdb sqlite:/usr/local/etc/mail- config/mxdb/smtpd.sqlite.conf listen on localhost port 2587 accept for local alias aliases deliver to mbox accept for any relay ==smtpd.sqlite.conf dbpath /usr/local/var/mxdb.sqlite query_domainselect name from domain where domain = ? query_alias select destination from alias where alias_user||'@'||alias_domain = ? OpenSMTPD will pass the config tests and start, but will then immediately die. Jul 25 10:36:36 smtp smtpd[61374]: info: OpenSMTPD 5.7.1p1 starting Jul 25 10:36:36 smtp smtpd[61375]: info: startup [debug mode] Jul 25 10:36:36 smtp smtpd[61378]: warn: table-proc: pipe closed Jul 25 10:36:36 smtp smtpd[61378]: fatal: table-proc: exiting Jul 25 10:36:36 smtp smtpd[61376]: warn: queue - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61377]: warn: control - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61375]: warn: parent - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61380]: warn: pony - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61379]: warn: scheduler - queue: pipe closed Jul 25 10:36:36 smtp smtpd[61381]: warn: ca - control: pipe closed Smtpd will start and run just fine if I comment out the table mxdb line. Are you starting like so: # smtpd -d If so add some v's: # smtpd -d Otherwise maybe just make sure smtpd.sqlite.conf and mxdb.sqlite exist ie no typos. I'm not sure, but I have a guess for you: I think -extras configure.ac has a bug where tables, filters, etc are installed in $prefix/libexec/opensmtpd But smtpd explicitly looks in (hardcoded) /usr/libexec/smtpd for them. Thus, your table-sqlite is not loaded correctly and smtpd dies. Regards, Joerg Unrelated to OP problem, but this is an issue for OpenBSD version. It installs to /usr/libexec/opensmtpd, but smtpd wants it in /usr/libexec/smtpd. ./configure --libexecdir=/usr/libexec/smtpd makes it install to /usr/libexec/smtpd/opensmtpd. -- James Lott -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
[Extras] Problems with sqlite tables
Hey folks, I'm running OpenSMTPD 5.7.1 + table-sqlite from extras. I'm simply trying to get the sqlite tables to work at all. I haven't even gotten as far as trying to use them in my rules. I have the following config files: == smtpd.conf table aliases file:/etc/mail/aliases table mxdb sqlite:/usr/local/etc/mail-config/mxdb/smtpd.sqlite.conf listen on localhost port 2587 accept for local alias aliases deliver to mbox accept for any relay ==smtpd.sqlite.conf dbpath /usr/local/var/mxdb.sqlite query_domainselect name from domain where domain = ? query_alias select destination from alias where alias_user||'@'||alias_domain = ? OpenSMTPD will pass the config tests and start, but will then immediately die. Jul 25 10:36:36 smtp smtpd[61374]: info: OpenSMTPD 5.7.1p1 starting Jul 25 10:36:36 smtp smtpd[61375]: info: startup [debug mode] Jul 25 10:36:36 smtp smtpd[61378]: warn: table-proc: pipe closed Jul 25 10:36:36 smtp smtpd[61378]: fatal: table-proc: exiting Jul 25 10:36:36 smtp smtpd[61376]: warn: queue - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61377]: warn: control - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61375]: warn: parent - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61380]: warn: pony - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61379]: warn: scheduler - queue: pipe closed Jul 25 10:36:36 smtp smtpd[61381]: warn: ca - control: pipe closed Smtpd will start and run just fine if I comment out the table mxdb line. This issue is being experienced on FreeBSD 10.1. Am I doing something wrong that anyone might be able to point to? Thanks in advance for any pointers! -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
Re: [Extras] Problems with sqlite tables
Interestingly, it looks to me like opensmtpd does actually check the /usr/local/libexec/opensmtpd directory for modules. When I remove the module from that directory, smtpd does not even start anymore (as opposed to starting and instantly giving up). root@smtp:/usr/local/etc/mail-config # mv /usr/local/libexec/opensmtpd/table-sqlite /usr/libexec/smtpd/ root@smtp:/usr/local/etc/mail-config # service smtpd onestart Performing sanity check on smtpd configuration: fatal: table_create: backend sqlite does not exist /usr/local/etc/rc.d/smtpd: WARNING: failed precmd routine for smtpd If that path is hardcoded in the upstream OpenSMTPD source, then I would guess I'm dealing with a patched codebase... I guess I'll have to try grabbing the upstream sources directly and see if I run into the same issue. On 07/25/2015 12:08 PM, Joerg Jung wrote: On Sat, Jul 25, 2015 at 10:52:36AM -0700, James Lott wrote: Hey folks, I'm running OpenSMTPD 5.7.1 + table-sqlite from extras. I'm simply trying to get the sqlite tables to work at all. I haven't even gotten as far as trying to use them in my rules. I have the following config files: == smtpd.conf table aliases file:/etc/mail/aliases table mxdb sqlite:/usr/local/etc/mail-config/mxdb/smtpd.sqlite.conf listen on localhost port 2587 accept for local alias aliases deliver to mbox accept for any relay ==smtpd.sqlite.conf dbpath /usr/local/var/mxdb.sqlite query_domainselect name from domain where domain = ? query_alias select destination from alias where alias_user||'@'||alias_domain = ? OpenSMTPD will pass the config tests and start, but will then immediately die. Jul 25 10:36:36 smtp smtpd[61374]: info: OpenSMTPD 5.7.1p1 starting Jul 25 10:36:36 smtp smtpd[61375]: info: startup [debug mode] Jul 25 10:36:36 smtp smtpd[61378]: warn: table-proc: pipe closed Jul 25 10:36:36 smtp smtpd[61378]: fatal: table-proc: exiting Jul 25 10:36:36 smtp smtpd[61376]: warn: queue - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61377]: warn: control - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61375]: warn: parent - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61380]: warn: pony - lka: pipe closed Jul 25 10:36:36 smtp smtpd[61379]: warn: scheduler - queue: pipe closed Jul 25 10:36:36 smtp smtpd[61381]: warn: ca - control: pipe closed Smtpd will start and run just fine if I comment out the table mxdb line. I'm not sure, but I have a guess for you: I think -extras configure.ac has a bug where tables, filters, etc are installed in $prefix/libexec/opensmtpd But smtpd explicitly looks in (hardcoded) /usr/libexec/smtpd for them. Thus, your table-sqlite is not loaded correctly and smtpd dies. Regards, Joerg This issue is being experienced on FreeBSD 10.1. Am I doing something wrong that anyone might be able to point to? Thanks in advance for any pointers! -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org