Rt2-to-rt3 deletes the root user

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

Does rt 3.0.4 works with postgresql 7.3.x ?
i was forced to use Pgsql 7.2.x with Rt 2.0.x
i hope it works this time.

Regds.

Mallah.

Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/

I’m using RT3.0.4 with PG7.3.3

LER–On Wednesday, July 16, 2003 09:08:00 +0530 mallah@trade-india.com wrote:

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

Does rt 3.0.4 works with postgresql 7.3.x ?
i was forced to use Pgsql 7.2.x with Rt 2.0.x
i hope it works this time.

Regds.

Mallah.


Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

You didn’t have a “root” superuser in your RT2 instance? Just use your
existing RT2 superuser to create a new ‘root’ account.

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

I’m using RT3.0.4 with PG7.3.3

Hmmm ,

rt2-to-rt3 is then providing a golden chance for the MySQL + RT 2.0.x
usersto migrate to PgSQL 7.3.3/7.4dev + RT 3.0.4 , becoz the export - import
code is cooly DB independent :slight_smile:

changing DBs within RT 2.0.x or 3.0.x is not that easy .

regds
mallah.

LER

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

Does rt 3.0.4 works with postgresql 7.3.x ?
i was forced to use Pgsql 7.2.x with Rt 2.0.x
i hope it works this time.

Regds.

Mallah.


Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

You didn’t have a “root” superuser in your RT2 instance?

Yep !
{
‘Comments’ => ‘SuperUser’,
‘Privileged’ => ‘1’,
‘RealName’ => ‘Root’,
‘EmailAddress’ => ‘mallah_rajesh@yahoo.com’,
‘Creator’ => ‘1’,
‘Gecos’ => ‘root’,
‘Signature’ => ‘Root.’,
‘LastUpdatedBy’ => ‘3’,
‘Password’ => ‘kqL1xZtDh2SL.’,
‘Created’ => ‘2001-11-20 13:49:46+00’,
‘id’ => ‘3’,
‘LastUpdated’ => ‘2002-12-02 08:27:53+00’,
‘Name’ => ‘root’
},

Just use your

existing RT2 superuser to create a new ‘root’ account.

there is not root user in users table in the rt3 database.

in dumpfile-to-rt-3.0

if ($import_users) {
print “Importing users\n”;
my $users = $VAR1->{‘User’};
$RT::Handle->SimpleQuery(“DELETE FROM Users where Name=‘root’”);

foreach my $user ( @{$users} ) {
  print "u";
    encode_hashref($user);
    import_user($user);
}
    print "\n";

}

regds
mallah.


http://www.bestpractical.com/rt – Trouble Ticketing. Free.

Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

You didn’t have a “root” superuser in your RT2 instance?

Yep !
{
‘Comments’ => ‘SuperUser’,
‘Password’ => ‘kqL1xZtDh2SL.’,

you might want to make sure you change that password now.

                    'id' => '3',
                    'Name' => 'root'
               },

Just use your

existing RT2 superuser to create a new ‘root’ account.

there is not root user in users table in the rt3 database.

in dumpfile-to-rt-3.0

That removes it from your RT3 database before importing your RT2
database. If you really don’t have a root user any more, then your
upgrade may have failed.

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

I’m using RT3.0.4 with PG7.3.3

Hmmm ,

rt2-to-rt3 is then providing a golden chance for the MySQL + RT 2.0.x
usersto migrate to PgSQL 7.3.3/7.4dev + RT 3.0.4 , becoz the export -
import code is cooly DB independent :slight_smile:
Just remember to set the sequences after the import (see my message to the
list about 2-3 months ago).

Jesse,
Any chance of the script(s) being updated soon for that for Pg?

changing DBs within RT 2.0.x or 3.0.x is not that easy .
Hehe.

regds
mallah.

LER

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

Does rt 3.0.4 works with postgresql 7.3.x ?
i was forced to use Pgsql 7.2.x with Rt 2.0.x
i hope it works this time.

Regds.

Mallah.


Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm


Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Just remember to set the sequences after the import (see my message to the
list about 2-3 months ago).

Jesse,
Any chance of the script(s) being updated soon for that for Pg?

A patch would be greatly appreciated.

Jesse

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

database. If you really don’t have a root user any more, then your
upgrade may have failed.

Hmmm… Thats scary,

Please tell me what am i supposed to do then?

i redescribe the situation:

existing version: 2.0.15 user root exists which some non trivial password.

rt2-to-dumpfile dumps the metadata and tickets (27000 of them)

dumpfile-to-rt3 code is not restoring the ‘root’ user and looks
like explicity deleting it. [ is it really so ? ]

Regds
Mallah.On Wednesday 16 Jul 2003 9:52 am, Jesse Vincent wrote:

On Wed, Jul 16, 2003 at 09:47:46AM +0530, mallah@trade-india.com wrote:

How Do we recreate the root user on rt3 which gets deleted by the
rt2-to-rt3 conversion script.

You didn’t have a “root” superuser in your RT2 instance?

Yep !
{
‘Comments’ => ‘SuperUser’,
‘Password’ => ‘kqL1xZtDh2SL.’,

you might want to make sure you change that password now.

                    'id' => '3',
                    'Name' => 'root'
               },

Just use your

existing RT2 superuser to create a new ‘root’ account.

there is not root user in users table in the rt3 database.

in dumpfile-to-rt-3.0

That removes it from your RT3 database before importing your RT2
database. If you really don’t have a root user any more, then your
upgrade may have failed.

Please tell me what am i supposed to do then?

You might want to look through the database or turn on logging during an
import to see if you can detect a point at which it’s failing to insert
your RT2 root user.

dumpfile-to-rt3 code is not restoring the ‘root’ user and looks
like explicity deleting it. [ is it really so ? ]

Again, it’s deleting the automatically created RT3 root user before
importing your RT2 database. You might want to consider instrumenting
the import tool to see what it’s doing.

Regds
Mallah.

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

Jessie Thanks Very much,
I will study the problem in detail and post
the results.

Regds
Mallah.On Thursday 17 Jul 2003 2:03 am, Jesse Vincent wrote:

On Wed, Jul 16, 2003 at 12:59:51PM +0530, Rajesh Kumar Mallah wrote:

Please tell me what am i supposed to do then?

You might want to look through the database or turn on logging during an
import to see if you can detect a point at which it’s failing to insert
your RT2 root user.

dumpfile-to-rt3 code is not restoring the ‘root’ user and looks
like explicity deleting it. [ is it really so ? ]

Again, it’s deleting the automatically created RT3 root user before
importing your RT2 database. You might want to consider instrumenting
the import tool to see what it’s doing.

Regds
Mallah.