[vchkpw] vpopmail 5.4.0 make fails on OpenBSD 3.4, MySQL 4.0.16

2004-02-24 Thread ax
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

2004-02-24 Thread ax
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?

2005-03-28 Thread ax
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?

2005-03-28 Thread ax
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