Hello,
I'm planning to install a new version of Roundcube to test it, but I want to leave the current version for all users while I'm testing the new one.
Is it possible, or will there be some problem with the mysql database ?
Thanks a lot in advance for any help
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
On Jul 16, 2009, at 12:00 PM, Denis BUCHER wrote:
Is it possible, or will there be some problem with the mysql
database ?
mysqldump the existing database, create a new database using a
different name, load the dumped data into the new database. Point the
testing RC instance at the " testing " database.
I always use a testing DB populated with data similar to my live
database for running testing instances against. Any project, not just
RC.
Hello,
chasd a écrit :
On Jul 16, 2009, at 12:00 PM, Denis BUCHER wrote:
Is it possible, or will there be some problem with the mysql
database ?mysqldump the existing database, create a new database using a
different name, load the dumped data into the new database. Point the
testing RC instance at the " testing " database.I always use a testing DB populated with data similar to my live
database for running testing instances against. Any project, not just
RC.
That's a good idea ! But what will happen if after having tested with my account I want to use the "old version" again ?
In fact I should ask : "What is stored in the RC mysql database" ? Because all data should be on the IMAP server, isn't it ?
Thanks a lot for your help :-)
Denis
List info: http://lists.roundcube.net/users/
Denis BUCHER wrote:
Hello,
chasd a écrit :
On Jul 16, 2009, at 12:00 PM, Denis BUCHER wrote:
Is it possible, or will there be some problem with the mysql
database ?mysqldump the existing database, create a new database using a
different name, load the dumped data into the new database. Point the
testing RC instance at the " testing " database.I always use a testing DB populated with data similar to my live
database for running testing instances against. Any project, not just
RC.That's a good idea ! But what will happen if after having tested with my account I want to use the "old version" again ?
In fact I should ask : "What is stored in the RC mysql database" ? Because all data should be on the IMAP server, isn't it ?
Thanks a lot for your help :-)
Denis
List info: http://lists.roundcube.net/users/
In a testing environment, it is commonly understood that you have a separate slice of the sets of components what you want to test.
in this example, you are testing a new version of roundcube, hosted on a separate port(or directory) of apache (or on a separate machine), a separate database instance in mysql. The imap backend stays the same, so you don't replicate that.
Since roundcube (on the user end) is similar to a mail client, it only stores an address book for users that use roundcubes address book, and possibly other user preferences. Since it does not store mail, once you are done testing, simply delete the web hosted instance, delete the database you made for the test, and clean up any links or user knowledge of the testing envorinoment. And have a nice day!
Josh K
List info: http://lists.roundcube.net/users/
Hello Joshua,
Joshua Kordani on the Road a écrit :
Is it possible, or will there be some problem with the mysql database ?
mysqldump the existing database, create a new database using a different name, load the dumped data into the new database. Point the testing RC instance at the " testing " database.
I always use a testing DB populated with data similar to my live database for running testing instances against. Any project, not just RC.
That's a good idea ! But what will happen if after having tested with my account I want to use the "old version" again ?
In fact I should ask : "What is stored in the RC mysql database" ? Because all data should be on the IMAP server, isn't it ?
In a testing environment, it is commonly understood that you have a separate slice of the sets of components what you want to test.
in this example, you are testing a new version of roundcube, hosted on a separate port(or directory) of apache (or on a separate machine), a separate database instance in mysql. The imap backend stays the same, so you don't replicate that.
Since roundcube (on the user end) is similar to a mail client, it only stores an address book for users that use roundcubes address book, and possibly other user preferences. Since it does not store mail, once you are done testing, simply delete the web hosted instance, delete the database you made for the test, and clean up any links or user knowledge of the testing envorinoment. And have a nice day!
Ok thanks a lot for your explanations, I was supposing most of it, but it's a lot better to have a confirmation with full details as you did, that's very nice... I hope it will also help others...
A last question :
My current version is roundcubemail-0.1.1 and I'm gonna install roundcubemail-0.2.2. Do you think I can keep the "old" mysql database, will 0.2.2 understand/be compatible with the old (0.1.1) database ? (Of course I will try, just to have your opinion)
Thanks a lot for your help
Have a nice (replace with whichever time of the day it is for you : evening/day/night) :-)
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
On Jul 16, 2009, at 1:04 PM, Joshua Kordani on the Road wrote:
The imap backend stays the same, so you don't replicate that.
If you were really concerned about the messages stored on the IMAP
server, you could duplicate that too.
That involves a lot more effort than what I described with the
database, and the risk to the data is pretty low, so for many people
it is more work than it is worth.
Someone that has all their messages accidentally deleted due to "
testing " might have a different opinion.
Not saying that's happened to me or anything . . .
As for if the databases are the same, do a diff of the SQL
initialization files from each of the RC versions to see if anything
in the schema changed.
chasd a écrit :
As for if the databases are the same, do a diff of the SQL
initialization files from each of the RC versions to see if anything
in the schema changed.
Yes and no, they could be the same as the schema, but the data contained could be different... Well anyway, I think the best is to test :-))
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
Denis BUCHER wrote:
chasd a écrit :
As for if the databases are the same, do a diff of the SQL
initialization files from each of the RC versions to see if anything
in the schema changed.Yes and no, they could be the same as the schema, but the data contained could be different... Well anyway, I think the best is to test :-))
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
Don't quote me, but I think upgrade instructions include a script to update an existing db. I am eventually looking to do my own upgrade from 0.1 to latest, and I think I saw that somewhere.
Good luck!
Feel free to post your findings ;-)
and its lunch time out here in gmt -6 _______________________________________________ List info: http://lists.roundcube.net/users/
Joshua Kordani on the Road a écrit :
As for if the databases are the same, do a diff of the SQL
initialization files from each of the RC versions to see if anything
in the schema changed.Yes and no, they could be the same as the schema, but the data contained could be different... Well anyway, I think the best is to test :-))
Don't quote me, but I think upgrade instructions include a script to update an existing db. I am eventually looking to do my own upgrade from 0.1 to latest, and I think I saw that somewhere.
Ok that's nice, I'll look for it...
Good luck! Feel free to post your findings ;-)
Yes of course, nothing is worse than finding questions without answers, I will try to post the results here :-)
and its lunch time out here in gmt -6
Here it's a little more than dinner time (GMT -1)
So have a nice afternoon :-)
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
Theres a file in the roundcube root directory called UPGRADING ...
On Thu, 16 Jul 2009 21:19:41 +0200, Denis BUCHER dbucherml@hsolutions.ch wrote:
Joshua Kordani on the Road a écrit :
As for if the databases are the same, do a diff of the SQL
initialization files from each of the RC versions to see if anything
in the schema changed.Yes and no, they could be the same as the schema, but the data
contained
could be different... Well anyway, I think the best is to test :-))
Don't quote me, but I think upgrade instructions include a script to update an existing db. I am eventually looking to do my own upgrade from 0.1 to latest, and I think I saw that somewhere.
Ok that's nice, I'll look for it...
Good luck! Feel free to post your findings ;-)
Yes of course, nothing is worse than finding questions without answers, I will try to post the results here :-)
and its lunch time out here in gmt -6
Here it's a little more than dinner time (GMT -1)
So have a nice afternoon :-)
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
List info: http://lists.roundcube.net/users/
Steve Perkins a écrit :
Theres a file in the roundcube root directory called UPGRADING ...
Yes I confirm everything is there and very clear, sorry for asking the obvious :-)
BTW there are even scripts to upgrade the files and script to update the database...
And thanks a lot for pointing it...
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
On Fri, Jul 17, 2009 at 1:38 AM, Denis BUCHER dbucherml@hsolutions.chwrote:
Steve Perkins a écrit :
Theres a file in the roundcube root directory called UPGRADING ...
Yes I confirm everything is there and very clear, sorry for asking the obvious :-)
BTW there are even scripts to upgrade the files and script to update the database...
And thanks a lot for pointing it...
Denis _______________________________________________ List info: http://lists.roundcube.net/users/
Hello all,
I had tried upgrading from 1.1beta to 2.2 some time back. I have a public production server with a few hundred accounts. 1.1 has a vulnerability and is prone to hacking. My site was hacked twice and then only I started investigating and found that it is my own blunder in not upgrading.
But the straight upgrade seems to have some problems. Somewhere along the line, the upgrade process flushes the message table, with the result your message list in the DB become null. I dont know what the implications are, so I just left it at that. I did not proceed. Agreed, the imap server will not be flushed, but I am unsure of the consequences. Since this is a production server, I did not want to take chances. Yes, I did sqldump and worked with a separate database etc.
If you pull this off, please let us know the problems that you face if any.
Regards
kmn
List info: http://lists.roundcube.net/users/
-
chasd -
Denis BUCHER -
Joshua Kordani on the Road -
kmnair -
Steve Perkins