My first response seems to have been lost so here it is again.
I can see that the db upgrade script was at lease partially successful.
Please check to make sure that you have a dbmail_clients table now using
mysql> select * from dbmail_clients;
+-------------+------------------------------------+
| client_idnr | client_name |
+-------------+------------------------------------+
| 0 | Client/Group/Department ID Not Set |
| 1 | DBMAIL Administrators |
+-------------+------------------------------------+
2 rows in set (0.00 sec)
It should return the above 2 rows. If that looks good, then I'm guessing
that is is going to be a password encryption problem. Please try
updating your bazy user to us a plaintext password and see if it lets
you in then. If so, then please set a user's password to "password"
using the same encryption as before and send me that hash just as it is
printed out using mysql so I can look at it and try to see what the
problem is. Your passwords may be missing the salt or be in some format
that I just wasn't able to reproduce, or your php doesn't have all the
encryption methods I have.
Let me know what you find.
I'm currently running on a FreeBSD 6.2-STABLE box with apache 2.2.4, php
5.2.1, mysql 5.1.16-beta, and dbmail-2.2.stable_branch all built from
source by hand.
My PHP was configured like
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-xsl'
'--with-xml' '--with-mysql' '--with-pgsql' '--with-imap'
'--with-imap-ssl' '--with-ldap' '--enable-ftp' '--with-gd'
'--with-jpeg-dir=/usr/local' '--with-zlib-dir=/usr/local'
'--enable-sockets' '--with-curl' '--with-openssl' '--enable-exif'
'--with-sqlite' '--enable-sqlite-utf8'
So nothing fancy there.
-Jon
Bazy wrote:
Hi Jonathan,
Thank you for this tool!
But... I have trouble installing it, I think I'm not understanding
something.
I did everything you said in the install of nvc and dbmail_admin, and
still I can't login as the user bazy or any other user.
I'm running FreeBSD 6.2, php5-5.2.3, apache-2.2.4_2. It's not a php
problem, phpmyadmin is running ok, dbmail-imap is running ok, my mail
server is ok.
Sorry for being stupid, but I just can't make it work... :( Thank you.
mysql> select * from dbmail_users;
+-----------+--------------------------------+----------------------------------+-------------+--------------+--------------+---------------+---------------+-----------------+---------------------+---------------+
| user_idnr | userid |
passwd | client_idnr | maxmail_size |
curmail_size | maxsieve_size | cursieve_size | encryption_type |
last_login | user_realname |
+-----------+--------------------------------+----------------------------------+-------------+--------------+--------------+---------------+---------------+-----------------+---------------------+---------------+
| 1 | [EMAIL PROTECTED]@__
| | 0 | 0
| 0 | 0 | 0 | md5 |
1979-11-03 22:05:58 | |
| 2 | anyone
| | 0 | 0
| 0 | 0 | 0 | md5 |
1979-11-03 22:05:58 | |
| 3 | __public__
| | 0 | 0
| 0 | 0 | 0 | md5 |
1979-11-03 22:05:58 | |
| 4 | bazy | XXXXXXXXXXXXXXXXX
| 1 | 0 | 825668074 | 0
| 0 | md5 | 2007-07-28 11:37:41 | |
+-----------+--------------------------------+----------------------------------+-------------+--------------+--------------+---------------+---------------+-----------------+---------------------+---------------+
And my config file looks like this:
// The path to the dbmail.conf
$ini_path="/usr/local/etc/dbmail.conf";
// The path to the dbmail executables - without the trailing slash.
$exec_path="/usr/local/sbin";
// The client number that the mailbox must be in to allow login.
// The default client_idnr on a user is 0, so we will make the first
client "1" the valid client list that can login to the tool.
$login_client="1";
// Default client number
$default_client="5";
// The encryption type to be used on passwords. Valid types are
plaintext, crypt, md5-hash, md5-digest, or md5-base64
$encryption_type="md5-hash";
// $encryption_type="";
// This is what will show on the interface. Set to whatever you want
to call your seperation of users.
$group_tag="Client/Group/Department";
// This tool works only in the database. LDAP modification is not
done. Changing quotas and group id's may not do anything at all.
// Set the next line to true to allow you to continue past the login
screen.
$skip_ldap_auth_warn=false;
Jonathan Feally wrote:
Greeting All,
I am pleased to announce the release of my own DBMail Admin tool for
DBMail 2.2.x. Yes - Its Free!
You can download it at my site
<http://www.netvulture.com/nvcapps.php>
http://www.netvulture.com/nvcapps.php - I have also added a link on
the Wiki so you can easily find it again later to get updates. Just
follow the INSTALL file inside the archive to get started. The rest
should be child's play.
While you are there, take my DBMail usage survey to become a
statistic and help DBMail developers better understand what the
people are doing with DBMail and what you would like to see.
DBMail Admin is currently for users of SQL based authentication, but
full LDAP support is being investigated.
All 3 database platforms are supported and should work provided your
PHP 5 has the appropriate DB support.
Current Features:
Store a real name against your userid's
Change mailbox passwords
View mailbox usage and set quotas
Manage local and external aliases
Divide users into groups, clients, departments, whatever you want
to call them as you set what is displayed on the screen
Create, Modify and Delete the groups, clients, etc.
Upcoming features (hopefully)
Manage folders for any user including #Public
Manage ACL's on folders
Work with LDAP attributes for group and quota settings.
Do dbmail-util runs on the fly
Possible features way down the road
Allow users to manage their sieve scripts
An integrated sieve script builder?
Questions, comments, suggestions, or what have you can be sent to me
at [EMAIL PROTECTED] - Patches to get things working in your
setup are always welcome.
While I have built this tool to be simple and use the dbmail-users
binary for any complex operations, use this tool at your own risk. I
am not responsible for anything that goes wrong.
Thanks and Enjoy
-Jon a.k.a. The NetVulture
------------------------------------------------------------------------
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
