[rt-users] Sqlite to MySQL migration with a 4.0.5 deployment
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
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 about datatypes and schemas are very close, so I think pretty much any SQLite - mysql converter will just work. Use the following steps: 1) install RT 4.0.5 on mysql 2) make sure it works 3) delete everything from mysql tables 4) use answers from [1] to dump tables as sql with inserts only 5) insert data mysql -u root rt4 dump.sql 6) test, adjust, repeat I think this will work, may be with tiny quircks. Thanks… Tim -- Best regards, Ruslan.
[rt-users] SQLite error on new 3.8.8 Install
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 compact local database would be the easiest way to evaluate RT before finding it a home on one of our primary database servers. Yes, I did pass --with-db-type=SQLite into ./configure All of the generated defaults in the RT_Config.pm have been left alone, and I haven't overridden any of the database* properties in RT_SiteConfig.pm, I'm trying to remain as vanilla as possible in this first go around. Set($DatabaseType , 'SQLite'); Set($DatabaseHost , 'localhost'); Set($DatabaseRTHost , 'localhost'); Set($DatabasePort , ''); Set($DatabaseUser , 'rt_user'); Set($DatabasePassword , 'rt_pass'); Set($DatabaseName , 'rt3'); Set($DatabaseRequireSSL , undef); Set($SenderMustExistInExternalDatabase , undef); I have set $rtname, $Organization, $Timezone, $OwnerEmail, $WebDomain, and $WebPath, and finally decided to enable DevelMode in order to try to find better error messages. I overcame a mod_perl problem already, but am now met with some sort of a SQLite error; All of the background database queries appear to be failing with an identical error message: DBD::SQLite::db prepare failed: not an error at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 469. RT::Handle=HASH(0x2ac800384380) couldn't prepare the query 'SELECT * FROM Users WHERE lower(Name) = ?'not an error Many of those queries fail when Apache restarts, and it continues to fail each time I attempt to log in. At first, the only problem I had was being unable to log in with the initial default login, which really threw me for a loop. I just received an Authentication Failed error on the web site on log in. After diving a lot deeper, I found out that all queries to the database are failing. This is everything that I can think is pertinent; (1) Again, I haven't changed any of the RT_Config database properties. (2) The database exists at /opt/rt3/var/rt3 (3) Running the query manually via the command line sqlite3 utility works, and I see the information about the root user. (4) It goes without saying that I did indeed make initialize-database. The only error I received during that was the note about setting RTAddressRegexp, I'll set that after I can actually start working with RT. Apache: 2.2.3 Using mod_perl2 DBD::SQLite 1.29 RT 3.8.8 You can see from the error message I'm using Perl 5.8.8 (on CentOS 5.4). I don't quite know how I would trace the requests to see if it's attempting to open the database in the expected location, which is my last idea but I'm out of ways to figure it out. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 speed. A commit takes at least two full drive rotations, so for a 7200rpm drive you can only do 60 transactions per second. Not terribly scalable :) I am in a small shop (12 people tops). If we end up having 60 tickets per minute, I would be happily amazed and glad to upgrade to mysql or something else. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 ;) If you leave synchronous writes on, you're limited on transaction speed. A commit takes at least two full drive rotations, so for a 7200rpm drive you can only do 60 transactions per second. Not terribly scalable :) I am in a small shop (12 people tops). If we end up having 60 tickets per minute, I would be happily amazed and glad to upgrade to mysql or something else. No, really, don't do that. We haven't tested RT 3.x on SQLite in a production environment. That's not a supported configuration. I have no idea how badly it might hurt you. Jesse Vincent (RT's Architect) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 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 at least two full drive rotations, so for a 7200rpm drive you can only do 60 transactions per second. Not terribly scalable :) I am in a small shop (12 people tops). If we end up having 60 tickets per minute, I would be happily amazed and glad to upgrade to mysql or something else. No, really, don't do that. We haven't tested RT 3.x on SQLite in a production environment. That's not a supported configuration. I have no idea how badly it might hurt you. 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. mk ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 perhaps have xen snapshots on or something? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 Phone: 807.766.7331 Email: mike.john...@normed.ca Technology assistance: email nosmhelpd...@normed.ca Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat holidays: Off campus toll free 1-800-461-8777, option 8, or locally either (705)-662-7120 or (807)-766-7500 Jesse Vincent je...@bestpractical.com 23/09/2009 11:24 am 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 perhaps have xen snapshots on or something? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com ( http://wiki.bestpractical.com/ ) Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ( http://rtbook.bestpractical.com/ ) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] sqlite
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 used it? If so, what are your experiences? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 outdated docs), it is not ready for prime time just yet. So, has anyone used it? If so, what are your experiences? SQLite is primarily intended for development and testing environments. It's not well-suited to a multi-user production environement for RT. Best, Jesse ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 Mail, Safari, Firefox, Google Gears, and the Skype client. But it certainly isn't robust enough for the enterprise side of things. Google Gears on SQLite sure, but Google itself? Skype client yes, but Skype servers? Not gonna happen. -- -- Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 applications. It's used by a lot of such things such as Apple Mail, Safari, Firefox, Google Gears, and the Skype client. But it certainly isn't robust enough for the enterprise side of things. Google Gears on SQLite sure, but Google itself? Skype client yes, but Skype servers? Not gonna happen. RT is very slow when using sqlite. I've installed rt3.6 from debian with sqlite and after about 300 tickets, I was forced to go through a painful process of migrating data to mysql. With mysql rt is about 10 times faster. mk ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 applications. It's used by a lot of such things such as Apple Mail, Safari, Firefox, Google Gears, and the Skype client. But it certainly isn't robust enough for the enterprise side of things. Google Gears on SQLite sure, but Google itself? Skype client yes, but Skype servers? Not gonna happen. 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 ;) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] sqlite
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 at least two full drive rotations, so for a 7200rpm drive you can only do 60 transactions per second. Not terribly scalable :) -- -- Tom Lahti BIT Statement LLC (425)251-0833 x 117 http://www.bitstatement.net/ -- ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] SQLite, RT 3.6.1
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: table Attachement already exists. I seems as if there were some kind of loop in script execution. Could you help me to resolve this problem please ? Pozdrowienia Mariusz ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] SQLite, RT 3.6.1
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 execution. Could you help me to resolve this problem please ? Pozdrowienia Mariusz ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com