[vchkpw] vpopmail(mysql) squirrelmail - user change passwd?

2003-11-13 Thread jon kutassy
Hello List (again),

I've got vpopmail with mysql authentication and courier-imap and 
squirrelmail (thanks Michael Bowe), and I'm wondering the best/most eloquent 
way of allowing users to change their own passwords.

Is anybody doing this already?

I've looked at the squirrelmail plugin for change-mysql-passwd 
(http://www.squirrelmail.org/plugin_view.php?id=25) but that, as far as I 
can tell, is expecting all the logins/passes to be in one table.

mysql stores all the user/passes in seperate tables (one for each domain).

My first thought would be somehow to replicate all the various domain table 
user/passes into one table...

any thoughts?

regards

Jon

_
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile



Re: [vchkpw] TR : [vchkpw] [MySQL] error

2003-11-11 Thread jon kutassy


Perhaps the socket its trying is wrong?

If you try

# mysql -p
# password pass
mysql \s

it should confirm where your mysql is listening.. its sometimes 
/tmp/mysql.sock





-Message d'origine-
De : Tanen [mailto:[EMAIL PROTECTED]
Envoyé : mardi 11 novembre 2003 13:39
À : 'Gary'
Objet : RE : [vchkpw] [MySQL] error


Yes Mysql is running, i see the process on the ps ax

All work fine, i think ... PhPMyAdmin work correctly i can access to all my
database, it want meant MySQL is running correctly no ?
Someone have an idea plz ??

Thanks,

Tanen.



-Message d'origine-
De : Gary [mailto:[EMAIL PROTECTED]
Envoyé : mardi 11 novembre 2003 13:48
À : [EMAIL PROTECTED]
Objet : Re: [vchkpw] [MySQL] error




Hello,

I get a problem when i try to add my domain, with the vadddomain my.domain
my-pass


When the script try to be executed, i get this error message :



:~# /home/vpopmail/bin/vadddomain my.domain

Please enter password for postmaster:

enter password again:

could not connect to mysql update server Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock' (2) with database
could not connect to mysql update server Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock' (2)
vmysql: sql error[c]: MySQL server has gone away

vmysql: sql error[b]: MySQL server has gone away

vmysql: sql error[3]: MySQL server has gone away

vmysql: sql error[c]: MySQL server has gone away

vmysql: sql error[c]: MySQL server has gone away

vmysql: sql error[b]: MySQL server has gone away

vmysql: sql error[3]: MySQL server has gone away

vmysql: sql error[2]: MySQL server has gone away

Error: Unable to chdir to vpopmail/users directory

:~#



I’m on Debian Sarge (Woody upgraded).



Someone can tel me why i get this error and how to correct it plz ?



Best regards,

Tanen.



Looks like mysql died...double check to make sure mysql is running if not
start it up :)


Cheers,



Gary

_
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile



[vchkpw] Resolution: Re: [vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-11 Thread jon kutassy
Just for list completeness, upgrading from 5.2.1 to 5.3.29 cured my problem. 
Thanks all.

Another link to Michael Bowes documentation: (which is updating behind me as 
I work down the steps!)

http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm

- Original Message -
From: jon kutassy [EMAIL PROTECTED]
 Hello List,

 I've been following Michael Bowe's crib sheet on how to set up
 qmail+vpopmail+mysql+loads+loadsmore
:-)

 Im running vpopmail 5.2.1 .

You should not use vpopmail-5.2.1, it contains some nasty bugs that can
cause unreliable operation of courier-imap (especially if you compiled
courier with --with-authdaemon)
You could either go for vpopmail-5.2.2, or vpopmail-5.3.28

Once you have upgraded your vpopmail, you will also need to go and rebuild
your other add-on apps like qmailadmin and courier-imap, so that they can
link against the updated vpopmail code.
Michael.

_
Find a cheaper internet access deal - choose one to suit you. 
http://www.msn.co.uk/internetaccess




[vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-10 Thread jon kutassy
Hello List,

I've been following Michael Bowe's crib sheet on how to set up 
qmail+vpopmail+mysql+loads+loadsmore

I'm experiencing a problem with squirrelmail+courier-imap which the imap 
list suggested was down to libvpopmail..

The Problem:

Squirrelmail works fine as long as I'm the only one using it. When more than 
one connection is made, the Squirrelmail drops everyone back to the login 
prompt and no valid user-passwd combinations work.

Restarting courier-imap fixes this temporarily.

The courier-imap list said this was down to libvpopmail and that a very 
latest version of this should cure it.

Im running vpopmail 5.2.1 .

Does the vpopmail list agree that this is the case, and how do I repair it 
if you do. Do I need to re-install the whole vpopmail, ( I was looking at 
5.3.28) or can I just get this libvpopmail on its own?

I can't see that it should be this because Im using the same version as 
Michael Bowe was in his write-up.

Great write-up btw Michael.

Regards
Jon
_
MSN Messenger with backgrounds, emoticons and more. 
http://www.msnmessenger-download.com/tracking/cdp_customize




Re: [vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-10 Thread jon kutassy
Mine are set to 40 and 40, as per Michaels notes.. will try 512

At 09:00 AM 11/10/2003, jon kutassy wrote:
The Problem:

Squirrelmail works fine as long as I'm the only one using it. When more 
than one connection is made, the Squirrelmail drops everyone back to the 
login prompt and no valid user-passwd combinations work.

Restarting courier-imap fixes this temporarily.
in your courier-imap configuration (normally 
/usr/local/lib/courier-imap/etc/imapd)

what do you have the values set at for:

MAXDAEMONS=
MAXPERIP=
?

I set mine to 512 each. why? squirrelmail connects normally on localhost, 
127.0.0.1. which means a lot of concurrent connections to localhost. If you 
have a small value for those two variables, people will be locked out pretty 
quickly.

Paul Theodoropoulos
http://www.anastrophe.com
_
Find a cheaper internet access deal - choose one to suit you. 
http://www.msn.co.uk/internetaccess




Re: [vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-10 Thread jon kutassy
No, 512 doesnt make any difference, as soon as I open another browser and 
sign into a different account, the first one fails to the login screen.



Mine are set to 40 and 40, as per Michaels notes.. will try 512

At 09:00 AM 11/10/2003, jon kutassy wrote:
The Problem:

Squirrelmail works fine as long as I'm the only one using it. When more 
than one connection is made, the Squirrelmail drops everyone back to the 
login prompt and no valid user-passwd combinations work.

Restarting courier-imap fixes this temporarily.
in your courier-imap configuration (normally 
/usr/local/lib/courier-imap/etc/imapd)

what do you have the values set at for:

MAXDAEMONS=
MAXPERIP=
?

I set mine to 512 each. why? squirrelmail connects normally on localhost, 
127.0.0.1. which means a lot of concurrent connections to localhost. If you 
have a small value for those two variables, people will be locked out pretty 
quickly.

Paul Theodoropoulos
http://www.anastrophe.com
_
Find a cheaper internet access deal - choose one to suit you. 
http://www.msn.co.uk/internetaccess

_
Sign-up for a FREE BT Broadband connection today! 
http://www.msn.co.uk/specials/btbroadband




[vchkpw] mysql gone away. Please help a noob.

2003-08-19 Thread jon kutassy
I'd like to get vpopmail working with authenticating against mysql... I have 
a working version of mysql that Id rather not break:

Excuse me if I include too much info : Im not sure what is and isnt 
relevent:

mysql  Ver 12.21 Distrib 4.0.14, for pc-linux (i686)
Server version: 4.0.14-standard
Protocol version:   10
Connection: Localhost via UNIX socket
UNIX socket:/var/lib/mysql/mysql.sock
I compiled with ./configure --enable-mysql=y

when I run add domain I get:

Please enter password for postmaster:
enter password again:
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES) with database
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES)
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away

I have a database called vpopmail and a user vpopmail that has (I believe 
got access to this db).. but looking at this error message makes me 
wonder... does  Access denied for user:  mean that the database has been 
found just that its not allowing the user to authenticate?

Im lost..

Regards

Jon

_
Express yourself with cool emoticons - download MSN Messenger today! 
http://www.msn.co.uk/messenger




Re: [vchkpw] mysql gone away. Please help a noob.

2003-08-19 Thread jon kutassy
Thanks for the replies.

I've been following Michael  Bowe's excellent documentation on setting 
this up.

http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm (I hope he 
doesnt mind the link)

I took the windoze approach and restarted mysql, and its all working fine!!

Thanks everyone for your input!!

did you configure for your mysql user/password in vmysql.h?  if not, amend 
the entries and recompile.
also, did you create the tables or check that they were created?
did you allow mysql access from within mysql?
did you 'flush priviledges' to make the privs stick in mysql?

Good luck

jon kutassy wrote:

I'd like to get vpopmail working with authenticating against mysql... I 
have a working version of mysql that Id rather not break:

Excuse me if I include too much info : Im not sure what is and isnt 
relevent:

mysql  Ver 12.21 Distrib 4.0.14, for pc-linux (i686)
Server version: 4.0.14-standard
Protocol version:   10
Connection: Localhost via UNIX socket
UNIX socket:/var/lib/mysql/mysql.sock
I compiled with ./configure --enable-mysql=y

when I run add domain I get:

Please enter password for postmaster:
enter password again:
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES) with database
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES)
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away

I have a database called vpopmail and a user vpopmail that has (I believe 
got access to this db).. but looking at this error message makes me 
wonder... does  Access denied for user:  mean that the database has been 
found just that its not allowing the user to authenticate?

Im lost..

Regards

Jon

_
Express yourself with cool emoticons - download MSN Messenger today! 
http://www.msn.co.uk/messenger




v

_
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile



Re: [vchkpw] configure --enable-mysql=y error : help a noob please?

2003-08-17 Thread jon kutassy
Gents,  Im still trying to set up vpopmail with mysql. I followed Michael's 
exellent instructions below, which (after a re-install of mysql) worked, but 
I broke php/phpmyadmin in the progress.

Ive now got php back and working, but not vpopmail again!

I think its a socket issue, I believe vpopmail is expecting a socket in 
/tmp/mysql.sock:

My socket is here :

mysqladmin  Ver 8.40 Distrib 4.0.14, for pc-linux on i686

Server version  4.0.14-standard
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
How can I get vpopmail to look in the right place?

Regards

Jon

 Im trying to set up vpopmail +mysql + qmail on redhat 9

 I believe I've read the relevent docs, and searched the web :

 when i run ./configure --enable-mysql=y

 I get this error:

 configure: error: unable to find your inc dir, specify --enable-incdir
Hello

Maybe take a look at this guide I wrote :

A QUICK GUIDE TO VPOPMAIL WITH MYSQL
http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm
Michael.

_
Use MSN Messenger to send music and pics to your friends 
http://www.msn.co.uk/messenger




[vchkpw] configure --enable-mysql=y error : help a noob please?

2003-08-14 Thread jon kutassy
Im trying to set up vpopmail +mysql + qmail on redhat 9

I believe I've read the relevent docs, and searched the web :

when i run ./configure --enable-mysql=y

I get this error:

configure: error: unable to find your inc dir, specify --enable-incdir

Now I'd love to be able to do this, but Im not sure what one is...

Regards

Jon

_
Tired of 56k? Get a FREE BT Broadband connection 
http://www.msn.co.uk/specials/btbroadband