[vchkpw] vpopmail 5.4.0 make fails on OpenBSD 3.4, MySQL 4.0.16
Hello. Just joined the list after consulting the archives and finding a message detailing what looks like a very similar problem to the one I'm having, though on Solaris 9. If I were more knowledgeable, I'm sure this would be enough, but I'm afraid I need a bit more hand-holding. I'm attempting to get vpopmail set up with all the MySQL additions on a fully DJB-ified install of OpenBSD 3.4. I'm using the OpenBSD distribution of MySQL (mysql-standard-4.0.16-unknown-openbsd3.4-i386), which seems to be the cause of the problem, as I compiled and installed successfully without MySQL support. vpopmail 5.4.0 and 5.4.2 produce very similar output. Here's 5.4.0... $ ./configure --enable-roaming-users \ --enable-logging=p \ --enable-auth-module=mysql \ --enable-mysql-logging \ --enable-tcpserver-file=/var/vpopmail/etc/tcp.smtp \ --enable-valias - - - - SNIP - - - - - cd . /bin/sh ./config.status Makefile config.status: creating Makefile rm -f libvpopmail.a ar cru libvpopmail.a vpopmail.o md5.o bigdir.o vauth.o file_lock.o vpalias.o seek.o vlimits.o maildirquota.o cdb/*.o ranlib libvpopmail.a gcc -g -O2 -Wall -o vchkpw vchkpw.o md5.o hmac_md5.o libvpopmail.a -L/usr/local/mysql/lib -lmysqlclient -lz /usr/local/mysql/lib/libmysqlclient.a(password.o): In function `scramble': password.o(.text+0x1c8): undefined reference to `floor' password.o(.text+0x25d): undefined reference to `floor' /usr/local/mysql/lib/libmysqlclient.a(password.o): In function `check_scramble': password.o(.text+0x40a): undefined reference to `floor' password.o(.text+0x498): undefined reference to `floor' collect2: ld returned 1 exit status *** Error code 1 Stop in /var/src/mail/vpopmail-5.4.0 (line 424 of Makefile). *** Error code 1 Stop in /var/src/mail/vpopmail-5.4.0 (line 511 of Makefile). *** Error code 1 Stop in /var/src/mail/vpopmail-5.4.0 (line 335 of Makefile). - - - - - - - - - - Any and all help appreciated. Thanks, Alex
[vchkpw] vpopmail 5.4.0 make fails on OpenBSD 3.4, MySQL 4.0.16
Hello. I'm posting a fresh message because my previous one may have been absorbed into a previous thread -- my mistake. I'm attempting to get vpopmail set up with all the MySQL additions on a fully DJB-ified but otherwise out-of-the box install of OpenBSD 3.4 (GENERIC) on an Intel Pentium 4 machine. I'm using the OpenBSD distribution of MySQL (mysql-standard-4.0.16-unknown-openbsd3.4-i386), which seems to be the cause of the problem, as I can compile and install successfully without MySQL support. vpopmail 5.4.0 and 5.4.2 produce very similar output. Here's the end of the output from make with 5.4.0... - - - - - - gcc -g -O2 -Wall -o vchkpw vchkpw.o md5.o hmac_md5.o libvpopmail.a -L/usr/local/mysql/lib -lmysqlclient -lz /usr/local/mysql/lib/libmysqlclient.a(password.o): In function `scramble': password.o(.text+0x1c8): undefined reference to `floor' password.o(.text+0x25d): undefined reference to `floor' /usr/local/mysql/lib/libmysqlclient.a(password.o): In function `check_scramble': password.o(.text+0x40a): undefined reference to `floor' password.o(.text+0x498): undefined reference to `floor' collect2: ld returned 1 exit status *** Error code 1 Stop in /var/src/mail/vpopmail-5.4.0 (line 424 of Makefile). *** Error code 1 Stop in /var/src/mail/vpopmail-5.4.0 (line 511 of Makefile). *** Error code 1 Stop in /var/src/mail/vpopmail-5.4.0 (line 335 of Makefile). - - - - - - There was a suggestion that I might need to add -lm to the linker flags, but I'd hope that would be found without problem. From ldconfig -r... 7:-lm.1.0 = /usr/lib/libm.so.1.0 Any help much appreciated. Alex
[vchkpw] archive?
Just joined the list... Is there an archive somewhere? I googled but didn't see anything. I'm happy to search to see if my questions have already been answered if I can find where to search... Thanks, Alex [EMAIL PROTECTED]
[vchkpw] empty mysql tables / update vpopmail table directly?
Hi - Just found the archive, so disregard my previous question. Don't know how I could have overlooked it. Ok, I've just joined and my first question already labels me as a pinhead. I'll try to do better in future ;-) I have two questions regarding mysql support in vpopmail (currently running v5.5.0). 1. Is it ok to update the vpopmail table directly, such as to set a quota for an entire domain by e.g. update vpopmail set pw_shell='NOQUOTA' where pw_domain='foo.com', or are there side-effects of the vsetuserquota command that make it necessary? 2. Can you point me to some documentation of the operation of the various other tables in the vpopmail mysql schema and the way they relate to relaying, aliases, etc.? I tried to set up vpopmail with most of the mysql support options (except logging), but I notice that only the 'dir_control', 'lastauth', and 'vpopmail' tables contain data -- the others, 'ip_alias_map', 'limits', 'relay', 'valias' remain empty (I'd expect 'vlog' to be empty). I want to learn...! Thanks for any help, Alex