Re: [rt-users] Issue with rt-serializer and rt-importer
On 4-9-2015 0:15, Simone Morandini wrote: > Hello list, > > I'm an RT newbie, and I'm having a problem trying to export/import my > RT database content. > I have a machine running RT 4.2.9 and I need to move the content onto > another machine, where I prepared a clean install of the latest RT > 4.2.12. > On the old box I ran "rt-validator --check" and then "rt-serializer". > I moved the content of the output directory onto the new box, where I > ran "rt-importer /path/to/dir", but I'm having problems. Why don't you use the export/import tools of the database of you choice? Or are you switching from ABC to mysql/mariadb? Regards, Joop
Re: [rt-users] Issue with rt-serializer and rt-importer
Hello Joop, On 4-9-2015 0:15, Simone Morandini wrote: Hello list, I'm an RT newbie, and I'm having a problem trying to export/import my RT database content. I have a machine running RT 4.2.9 and I need to move the content onto another machine, where I prepared a clean install of the latest RT 4.2.12. On the old box I ran "rt-validator --check" and then "rt-serializer". I moved the content of the output directory onto the new box, where I ran "rt-importer /path/to/dir", but I'm having problems. Why don't you use the export/import tools of the database of you choice? Or are you switching from ABC to mysql/mariadb? actually I'm running mysql on the old server as well, I just thought that the rt-* commands were more suited. And indeed, data is there: if I login as root I can see all the tickets/queues, etc. I just cannot see them if I login as a regular user. It seems some kind of "permission" issue, if it makes sense in the RT world. I actually do not know what to try in order to troubleshoot... Thanks, Simone.
Re: [rt-users] Issue with rt-serializer and rt-importer
Il 04/09/15 14:36, Joop ha scritto: On 4-9-2015 0:15, Simone Morandini wrote: Hello list, I'm an RT newbie, and I'm having a problem trying to export/import my RT database content. I have a machine running RT 4.2.9 and I need to move the content onto another machine, where I prepared a clean install of the latest RT 4.2.12. On the old box I ran "rt-validator --check" and then "rt-serializer". I moved the content of the output directory onto the new box, where I ran "rt-importer /path/to/dir", but I'm having problems. Why don't you use the export/import tools of the database of you choice? Or are you switching from ABC to mysql/mariadb? just for the records: exporting with mysqldump and then importing with mysql solved the issue. Thanks, Simone.
[rt-users] Issue with rt-serializer and rt-importer
Hello list, I'm an RT newbie, and I'm having a problem trying to export/import my RT database content. I have a machine running RT 4.2.9 and I need to move the content onto another machine, where I prepared a clean install of the latest RT 4.2.12. On the old box I ran "rt-validator --check" and then "rt-serializer". I moved the content of the output directory onto the new box, where I ran "rt-importer /path/to/dir", but I'm having problems. I can login with my personal username (before importing only the root user was defined), but I cannot see any content: no tickets, no queues. I can see all the "Saved searches" I had previously configured, but they are empty. If I try to open a new ticket, I get the error message "Queue could not be loaded." (none of them is displayed in the drop-down menu). Instead, if I login as root user, I can see everything correctly, and in fact, querying the database using mysql (MariaDB) CLI, the content is there: Tickets and Queues tables, for example, are populated with the correct content. What am I missing? Thanks in advance, Simone.