// Get the user id for a user-name.
Select (user_idnr) from users where (userid = 'john');
user_id_var = GetSelectResult();
// Get maximum mail box size allow for a specific user.
select (maxmail_size) from users where (user_idnr = user_id_var);
maxmailbox_size = GetSelectResult();
// Sum the byt
DM> Assume you have a connection context with the dbmail database.
DM> 1. Query the users table to get the quota value in maxmail_size for a
DM> specific user and store the user_idnr around in a variable for use in
DM> the next step.
DM> 2. Query the messageblk table where messageblk_idnr = user_id
>
> How to count up the quota information for the user through IMAP
commands
> or MySQL?
>
A high level procedure for database only to calculate quota:
Assume you have a connection context with the dbmail database.
1. Query the users table to get the quota value in maxmail_size for a
specific u
> currently there is no support for the IMAP QUOTA extension;
Are you planning to develop it? And when?
> you can check user quota by using
> dbmail-adduser s
> or write a little c program using the db_get_quotum_used() etc.
> functions.
But how to do it through MySQL? I don't want to enable cg
Could you re-compile with debug on? (add -ggdb to the CFLAGS in the
makefile). Then run the program and see where it crashes.
regards roel
Chris Nolan heeft op dinsdag, 14 jan 2003 om 13:12 (Europe/Amsterdam)
het volgende geschreven:
Hi all,
I've tried this myself but I always manage to ge
Hi,
currently there is no support for the IMAP QUOTA extension; you can
check user quota by using
dbmail-adduser s
or write a little c program using the db_get_quotum_used() etc.
functions.
regards roel
Igor Olemskoi heeft op dinsdag, 14 jan 2003 om 12:32 (Europe/Amsterdam)
het volgend
Hi chris,
the daemons need to be started as root, otherwise it is not allowed to
bind to a port <1024. The daemons however drop their privileges after
the network setup running effectively as user nobody.
regards roel
Chris Nolan heeft op dinsdag, 14 jan 2003 om 13:09 (Europe/Amsterdam)
het
Hi again all.
I was thinking (all run in terror!). Considering MySQL has a "read-only"
table type that supports compression, would it make sense to offer the
option of archiving a whole bunch of messages into a seperate table?
I've heard that PostgreSQL has something similar.
It might allow
Hi all,
I've tried this myself but I always manage to get a SIGSEGV whenever I
call the appropriate functions. I need to follow this process:
1. See if a folder exists.
1a. If it doesn't, create it.
2. Insert a whole bunch of messages into that folder.
1a I can easily accomplish. As for 1 and
Hi everyone!
Regarding those IMAP folder problems, I also found that I couldn't get
DBMail to work on the standard IMAP port unless I made the daemons run
as root. Sound right or am I just openning up far too many security
holes without need?
Chris
Greetings,
How to count up the quota information for the user through IMAP commands
or MySQL?
Best regards,
Igor.
Hi philip,
well it seems the growing has stoppen - the database has grown from 7.5
to 8.7 Gb in a few days but has been stable since. Thanks for your help
- i'll be sure to contact you if it starts growing again ;)
regards roel
Philip Warner heeft op dinsdag, 14 jan 2003 om 06:29 (Europe/Am
At 09:30 AM 13/01/2003 +0100, Roel Rozendaal - IC&S wrote:
here are the logs of two days of vacuuming - hope it can help!
Can you let me know which file(s) are growing? It looks from these logs
like the messageblks toast table grew slightly at the start of the day,
then remained the same size
13 matches
Mail list logo