[rt-users] Sqlite to MySQL migration with a 4.0.5 deployment

2013-01-24 Thread Tim Pozar
I see mail how to move from SQLite to MySQL with 3.x versions of RT. I expect that this may be different with 4.0.x versions. Anyone have a pointer on how to do this? I am currently running version 4.0.5. Thanks… Tim

Re: [rt-users] Sqlite to MySQL migration with a 4.0.5 deployment

2013-01-24 Thread Ruslan Zakirov
On Fri, Jan 25, 2013 at 1:46 AM, Tim Pozar po...@lns.com wrote: I see mail how to move from SQLite to MySQL with 3.x versions of RT. I expect that this may be different with 4.0.x versions. Anyone have a pointer on how to do this? I am currently running version 4.0.5. SQLite is so liberal

[rt-users] SQLite error on new 3.8.8 Install

2010-06-22 Thread Jason Salaz
Hey folks, I'm running into an issue that's kind of bewildering me. I'm installing RT 3.8.8 for the first time, and I think I've done about everything needed per the ManualInstallation wiki page (and the Manual Apache Setup page following). I'm using SQLite as initial test, figuring that a

Re: [rt-users] sqlite

2009-09-23 Thread Mauricio Tavares
Tom Lahti wrote: Sorry. What I meant to say is RT's SQLite support - I _love_ SQLite for all sorts of applications. multi-user apps with SQLite are totally doable -- you just need to be careful with write concurrency ;) If you leave synchronous writes on, you're limited on transaction

Re: [rt-users] sqlite

2009-09-23 Thread Jesse Vincent
On Wed, Sep 23, 2009 at 10:29:03AM -0400, Mauricio Tavares wrote: Tom Lahti wrote: Sorry. What I meant to say is RT's SQLite support - I _love_ SQLite for all sorts of applications. multi-user apps with SQLite are totally doable -- you just need to be careful with write concurrency ;)

Re: [rt-users] sqlite

2009-09-23 Thread Martin Kraus
On Wed, Sep 23, 2009 at 10:50:40AM -0400, Jesse Vincent wrote: On Wed, Sep 23, 2009 at 10:29:03AM -0400, Mauricio Tavares wrote: Tom Lahti wrote: Sorry. What I meant to say is RT's SQLite support - I _love_ SQLite for all sorts of applications. multi-user apps with SQLite are

Re: [rt-users] sqlite

2009-09-23 Thread Jesse Vincent
with 300 tickets on a machine running on xen, it's been unusable. took about 15 seconds just to show a ticket. the problem was disk io. underlying disk space was a hardware raid1 on SAS disks. now with mysql, it takes about 2 seconds to show a ticket. That still sounds really high. Do you

Re: [rt-users] sqlite

2009-09-23 Thread Mike Johnson
Is it swap drive io?? I've had this happen when RT tries to process a large attachment... see if the mailbox it's pulling from has an email with a large attachment in it. Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1

[rt-users] sqlite

2009-09-22 Thread Mauricio Tavares
I've asked this in the channel but could use more than one sentence: what is the current status of using sqlite as the db for RT? Where I work at they like sqlite a lot but from what I have read so far (could be outdated docs), it is not ready for prime time just yet. So, has anyone

Re: [rt-users] sqlite

2009-09-22 Thread Jesse Vincent
On Tue, Sep 22, 2009 at 01:21:35PM -0400, Mauricio Tavares wrote: I've asked this in the channel but could use more than one sentence: what is the current status of using sqlite as the db for RT? Where I work at they like sqlite a lot but from what I have read so far (could be

Re: [rt-users] sqlite

2009-09-22 Thread Tom Lahti
SQLite is primarily intended for development and testing environments. It's not well-suited to a multi-user production environement for RT. Actually, I think SQLite's mission is to provide a lightweight database for individual use applications. It's used by a lot of such things such as Apple

Re: [rt-users] sqlite

2009-09-22 Thread Martin Kraus
On Tue, Sep 22, 2009 at 11:40:03AM -0700, Tom Lahti wrote: SQLite is primarily intended for development and testing environments. It's not well-suited to a multi-user production environement for RT. Actually, I think SQLite's mission is to provide a lightweight database for individual use

Re: [rt-users] sqlite

2009-09-22 Thread Jesse Vincent
On Tue, Sep 22, 2009 at 11:40:03AM -0700, Tom Lahti wrote: SQLite is primarily intended for development and testing environments. It's not well-suited to a multi-user production environement for RT. Actually, I think SQLite's mission is to provide a lightweight database for individual

Re: [rt-users] sqlite

2009-09-22 Thread Tom Lahti
Sorry. What I meant to say is RT's SQLite support - I _love_ SQLite for all sorts of applications. multi-user apps with SQLite are totally doable -- you just need to be careful with write concurrency ;) If you leave synchronous writes on, you're limited on transaction speed. A commit takes

Re: [rt-users] SQLite, RT 3.6.1

2007-03-21 Thread Ruslan Zakirov
SQLite backend exist there for development only. On 3/19/07, Mariusz Stakowski [EMAIL PROTECTED] wrote: Hello List, I a m trying to install SQLite with RT 3.6.1 but I can't initialize database. When trying to do this I get the following error:

[rt-users] SQLite, RT 3.6.1

2007-03-19 Thread Mariusz Stakowski
Hello List, I a m trying to install SQLite with RT 3.6.1 but I can't initialize database. When trying to do this I get the following error: table Attachement already exists. I seems as if there were some kind of loop in script