[Anthill-pro] Minimum mysql version requirements?

[Peter Steele]

I'll do this, thanks for the warning. We do not have Anthill tried into
LDAP so I assume this would avoid the problem you are describing.
Regardless, I'm not looking forward to this process--something *will* go
wrong...

-----Original Message-----
From: Ryan Smith [mailto:rws at urbancode.com] 
Sent: Friday, October 03, 2008 7:49 AM
To: Peter Steele
Cc: AnthillPro user and support list.
Subject: Re: [Anthill-pro] Minimum mysql version requirements?

Peter,

Unfortunately with Derby you do not get a accurate metric for the size 
of the database. The files always take up more space than the actual 
database, but it does sound large. The migration is not going to be 
extremely fast, probably will take several hours.

The only know issue with the migration is if certain system users and 
LDAP users have a database entry of "". The import tool (dbunit) can't 
tell a emtpy string from a null and tries to insert a null, which is not

allowed in the table.

Before the migration, you should connect to the derby database and check

if any SEC_USER entries have a empty or null entry for PASSWORD. If so, 
this value can be updated to:

pbe{T2rXUa16K1UqX7tbpFcsVsc66NJ7XM+e}


Ryan Smith

Peter Steele wrote:
> After a bit of work we managed to get our MySQL upgraded from 4.1.20
to
> 4.1.22, so now we can proceed with the next step of migrating the
> Anthill Derby DB to MySQL. I realize this isn't an easy question to
> answer, but how long can we expect the migration script to run? The
> derby data directory currently has 858596KB of information in it,
> according to du. My plan is to do a backup of the Derby DB and then
run
> the migration script. 
>
> Should we plan on backing up anything else? We could for example
backup
> the entire /opt/anthill/server directory, but this is huge and would
> take hours. If this is recommended though, we'll do it.
>
> Peter
>
> -----Original Message-----
> From: anthill-pro-bounces at lists.urbancode.com
> [mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Ryan
Smith
> Sent: Wednesday, October 01, 2008 8:39 AM
> To: AnthillPro user and support list.
> Subject: Re: [Anthill-pro] Minimum mysql version requirements?
>
> Peter,
>
> We have had it work with 4.1.22. We would recommend upgrading to MySQL
5
>
> if applicable. There are details on our site:
>
> http://www.anthillpro.com/html/products/anthillpro/installation.html
>
>
> Ryan Smith
>
> Peter Steele wrote:
>   
>> We want to migrate our Anthill derby database to mysql. The version
of
>>     
>
>   
>> mysql currently running on our Anthill server box is 4.1.20, which is

>> fairly old. Is this supported in the derby to mysql migration or do
we
>>     
>
>   
>> need a newer version of mysql?
>>
>>  
>>
>>
>>     
>
------------------------------------------------------------------------
>   
>> _______________________________________________
>> Anthill-pro mailing list
>> Anthill-pro at lists.urbancode.com
>> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>>   
>>     
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
>