[Bug 890377] New: postfix doesn't work with sqlite
https://bugzilla.novell.com/show_bug.cgi?id=890377 https://bugzilla.novell.com/show_bug.cgi?id=890377#c0 Summary: postfix doesn't work with sqlite Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: x86-64 OS/Version: openSUSE 13.1 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: irv@tenso-m.ru QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0 I'm using postfix with sqlite. Here is lines from main.cf: virtual_alias_domains = sqlite:/etc/postfix/mapfiles/sql-domain-aliases.cf virtual_alias_maps = sqlite:/etc/postfix/mapfiles/sql-aliases.cf, sqlite:/etc/postfix/mapfiles/sql-domain-aliases-mailboxes.cf, sqlite:/etc/postfix/mapfiles/sql-catchall-aliases.cf virtual_uid_maps = static:5000 virtual_gid_maps = static:5000 virtual_minimum_uid = 5000 virtual_mailbox_base = /var/vmail virtual_mailbox_domains = sqlite:/etc/postfix/mapfiles/sql-domains.cf I see folowing lines in /var/log/mail.err: postfix/cleanup[30287]: fatal: dict_open: unsupported dictionary type: sqlite: Is the postfix-sqlite package installed? Reproducible: Always Information for package postfix: -------------------------------- Repository: @System Name: postfix Version: 2.11.0-209.1 Arch: x86_64 Vendor: obs://build.opensuse.org/server:mail Installed: Yes Status: up-to-date Installed Size: 2.8 MiB Summary: A fast, secure, and flexible mailer Description: Postfix aims to be an alternative to the widely-used sendmail program. Information for package sqlite3: -------------------------------- Repository: openSUSE-13.1-Oss Name: sqlite3 Version: 3.7.17-2.1.2 Arch: x86_64 Vendor: openSUSE Installed: Yes Status: up-to-date Installed Size: 56.4 KiB Summary: Embeddable SQL Database Engine Description: SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. SQLite is not a client library used to connect to a big database server. SQLite is a server and the SQLite library reads and writes directly to and from the database files on disk. SQLite can be used via the sqlite command line tool or via any application that supports the Qt database plug-ins. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=890377 https://bugzilla.novell.com/show_bug.cgi?id=890377#c1 Bernhard Wiedemann <bwiedemann@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bwiedemann@suse.com, | |hrgyster@gmail.com, | |varkoly@suse.com --- Comment #1 from Bernhard Wiedemann <bwiedemann@suse.com> 2014-08-12 13:27:25 CEST --- It seems there was once a postfix-sqlite package at https://build.opensuse.org/package/show?project=home%3Ahrongyorgy&package=postfix but this seems to have mostly bitrotten, so I guess going with postfix-postgresql or postfix-mysql would be the easier way atm. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=890377 https://bugzilla.novell.com/show_bug.cgi?id=890377#c2 --- Comment #2 from Gabor Garami <hrgyster@gmail.com> 2014-08-12 14:26:55 UTC --- So, I was the author of the mentioned postfix-sqlite package. Basically it was based on this guide: http://technology.mattrude.com/2009/09/installing-postfix-with-sqlite-suppor... and I made some work to fit it with SuSE requirements. The most important part of this package is the https://build.opensuse.org/package/view_file/home:hrongyorgy/postfix/postfix... patch, what - I'm pretty sure - can be applied to any 2.6-2.7 version of the Postfix. According to the Postfix documentation (http://www.postfix.org/SQLITE_README.html) the SQlite support added to the core Postfix in 2.8 version, so it should work without an extra package requirement (except if SuSE packages the module separatedly). I do not use SuSE anymore, so I cannot confirm the issue, but if SQlite support is really broken, then it is a bug, and moving to other RDBMS (like MySQL or PgSQL) is just a workaround, but the bug remains unresolved. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply@novell.com