New DBMail Admin web tool released!

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 | __!internal_delivery_user!__ 
> |                                  |           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.netv
ulture.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 vulturenetvulture.com - 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
>> DBmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>   
>



_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail