vqadmin and mysql?

[Merle Reine]

I am trying to setup vqadmin via qmailrocks.org website.

I want everything to authenticate via mysql. I used the following
options when compiling:

*./configure --enable-cgibindir=/usr/local/apache/cgi-bin
-enable-htmldir=/usr/local/apache/htdocs -enable-mysql=y
*

*
*

However, when I try to run the app, I get the followin when adding a domain:

"*Database error
display_add_domain: Access denied for user 'my_user'@'localhost' (using
password: YES)"

*This is from the following URL:
http://mail.linspire.net/cgi-bin/vqadmin/vqadmin.cgi?nav=display_add_domain

1. Is mysql support even working? I see no mention of it in documentation.
a. I did find the reference to 'my_user' in vqadmin.cgi script but
see no way to modify it to valid mysql user name and database.
2. If not working, is it planned in the future?

Thanks for your help.
--
*

Merle Reine*
Network Engineer
Linspire, Inc.
Work: 858-587-6700 Ext. 244
Cell: 858-699-5202
www.linspire.com <http://www.linspire.com>
***@linspireinc.com <mailto:***@linspireinc.com>



<http://lindows.com/demosignature>
<http://linspire.com/reviews> Watch this Flash Demo
about Linspire <http://lindows.com/demosignature>





--

This message contains information which may be confidential and privileged. Unless you are the
addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone
the message or any information contained in the message. If you have received the message in error,
please advise the sender and delete the message. Thank you.

[Ken Jones]

Post by Merle Reine
I am trying to setup vqadmin via qmailrocks.org website.
I want everything to authenticate via mysql. I used the following
*./configure --enable-cgibindir=/usr/local/apache/cgi-bin
-enable-htmldir=/usr/local/apache/htdocs -enable-mysql=y

There is no mysql option for vqadmin.
vqadmin uses the vpopmail configuration.
So if you configure, make, make install vpopmail
with the mysql option. Then configure, make and make
install vqadmin. Then vqadmin will use vpopmail's libraries.

Hope that helps,
Ken Jones

Post by Merle Reine
*
*
*
"*Database error
password: YES)"
http://mail.linspire.net/cgi-bin/vqadmin/vqadmin.cgi?nav=display_add_domain
1. Is mysql support even working? I see no mention of it in
documentation. a. I did find the reference to 'my_user' in vqadmin.cgi
script but see no way to modify it to valid mysql user name and database.
2. If not working, is it planned in the future?
Thanks for your help.

[Merle Reine]

Thanks, I thought about that last night and that makes sense. Thanks
for you help. I do have version 2.3.6 of vqadmin and it shows mysql
option , FYI:

*[***@mail vqadmin-2.3.6]# ./configure --help*
`configure' configures this package to adapt to many kinds of systems.

Usage: ./configure [OPTION]... [VAR=VALUE]...

To assign environment variables (e.g., CC, CFLAGS...), specify them as
VAR=VALUE. See below for descriptions of some of the useful variables.

Defaults for the options are specified in brackets.

Configuration:
-h, --help display this help and exit
--help=short display options specific to this package
--help=recursive display the short help of all the included
packages
-V, --version display version information and exit
-q, --quiet, --silent do not print `checking...' messages
--cache-file=FILE cache test results in FILE [disabled]
-C, --config-cache alias for `--cache-file=config.cache'
-n, --no-create do not create output files
--srcdir=DIR find the sources in DIR [configure dir or `..']

Installation directories:
--prefix=PREFIX install architecture-independent files in PREFIX
[/usr/local]
--exec-prefix=EPREFIX install architecture-dependent files in EPREFIX
[PREFIX]

By default, `make install' will install all the files in
`/usr/local/bin', `/usr/local/lib' etc. You can specify
an installation prefix other than `/usr/local' using `--prefix',
for instance `--prefix=$HOME'.

For better control, use the options below.

Fine tuning of the installation directories:
--bindir=DIR user executables [EPREFIX/bin]
--sbindir=DIR system admin executables [EPREFIX/sbin]
--libexecdir=DIR program executables [EPREFIX/libexec]
--datadir=DIR read-only architecture-independent data
[PREFIX/share]
--sysconfdir=DIR read-only single-machine data [PREFIX/etc]
--sharedstatedir=DIR modifiable architecture-independent data
[PREFIX/com]
--localstatedir=DIR modifiable single-machine data [PREFIX/var]
--libdir=DIR object code libraries [EPREFIX/lib]
--includedir=DIR C header files [PREFIX/include]
--oldincludedir=DIR C header files for non-gcc [/usr/include]
--infodir=DIR info documentation [PREFIX/info]
--mandir=DIR man documentation [PREFIX/man]

Program names:
--program-prefix=PREFIX prepend PREFIX to installed program
names
--program-suffix=SUFFIX append SUFFIX to installed program
names
--program-transform-name=PROGRAM run sed PROGRAM on installed
program names

System types:
--build=BUILD configure for building on BUILD [guessed]
--host=HOST cross-compile to build programs to run on HOST [BUILD]

Optional Features:
--disable-FEATURE do not include FEATURE (same as
--enable-FEATURE=no)
--enable-FEATURE[=ARG] include FEATURE [ARG=yes]
--disable-dependency-tracking Speeds up one-time builds
--enable-dependency-tracking Do not reject slow dependency extractors
--enable-qmaildir=dir directory where qmail is installed.
--enable-vpopuser=vpopmail user vchkpw was installed as.
--enable-vpopgroup=vchkpw group vchkpw was installed as.
--enable-cgibindir={dir} HTTP server's cgi-bin directory.
*--enable-mysql=y|n Turn on mysql features (y) or off (n default).
*

Post by Ken Jones

Post by Merle Reine
I am trying to setup vqadmin via qmailrocks.org website.
I want everything to authenticate via mysql. I used the following
*./configure --enable-cgibindir=/usr/local/apache/cgi-bin
-enable-htmldir=/usr/local/apache/htdocs -enable-mysql=y

There is no mysql option for vqadmin.
vqadmin uses the vpopmail configuration.
So if you configure, make, make install vpopmail
with the mysql option. Then configure, make and make
install vqadmin. Then vqadmin will use vpopmail's libraries.
Hope that helps,
Ken Jones

Post by Merle Reine
*
*
*
"*Database error
password: YES)"
http://mail.linspire.net/cgi-bin/vqadmin/vqadmin.cgi?nav=display_add_domain
1. Is mysql support even working? I see no mention of it in
documentation. a. I did find the reference to 'my_user' in vqadmin.cgi
script but see no way to modify it to valid mysql user name and database.
2. If not working, is it planned in the future?
Thanks for your help.

--
*

Merle Reine*
Network Engineer
Linspire, Inc.
Work: 858-587-6700 Ext. 244
Cell: 858-699-5202
www.linspire.com <http://www.linspire.com>
***@linspireinc.com <mailto:***@linspireinc.com>



<http://lindows.com/demosignature>
<http://linspire.com/reviews> Watch this Flash Demo
about Linspire <http://lindows.com/demosignature>





--

This message contains information which may be confidential and privileged. Unless you are the
addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone
the message or any information contained in the message. If you have received the message in error,
please advise the sender and delete the message. Thank you.