Leonard,
You need to be running a later release of MySQL. (I am useing 3.23.40 with no
problems)
Excerpt from the README.mysql
NOTE: make sure you are running the latest stable release of mysql.
If you have 3.22 installed, you will need to upgrade. The dir_control
table in vpopmail uses a "unique index (domain)" syntax which isn't
supported in the 3.22 releases. Thanks to Chris Scheller for
tracking this down.
Mark
Leonard Cooper wrote:
> Please excuse the terrible use of the engilsh language in my last mail, but
> it is 4am on a Sunday (Monday??!!) after a LONG weekend behind this
> console.....;)
>
> -----Original Message-----
> From: Leonard Cooper [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 20, 2001 4:43 AM
> To: [EMAIL PROTECTED]
> Subject: Vpopmail / MySql error - vadd*
>
> Hi All,
> Using vpopmail 4.9.10 and mysql 3.22.30 on Tru64 5.1A
> I was using cdb and it works fine, execpt I we now need to add 53000, yes,
> 53 thousand users. Cdb is no good for this ( I know, I tried!).
> I have Complies mysql and it seems fine, i guess.
> When running vadddomains or vadduser etc etc I get the following :
>
> # ./vadddomain test.com password
> could not create dir control table create table dir_control ( domain
> varchar(255) not null, cur_users int, level_cur int, l
> evel_max int, level_start0 int, level_start1 int, level_start2 int,
> level_end0 int, level_end1 int, level_end2 int, level_m
> od0 int, level_mod1 int, level_mod2 int, level_index0 int , level_index1
> int, level_index2 int, the_dir varchar(255), uniqu
> e index (domain) )
> could not replace dir control table 2 replace into dir_control ( domain,
> cur_users, level_cur, level_max, level_start0, lev
> el_start1, level_start2, level_end0, level_end1, level_end2, level_mod0,
> level_mod1, level_mod2, level_index0, level_index1
> , level_index2, the_dir ) values ( 'test.com', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,
> 0, 0, 0, 0, 0, '')
>
> Could someone please decipher...;)...and let me know?
> Have I missed something with mysql?
> I compiled vpopmail with the mysql "root" user and password.
> If you need moew info, tell my what and how to get it.
>
> thanks
> Leonard
