[rt-users] rt2-to-rt3 deletes the root user..

[mallah at trade-india.com]

>
>
>
> On Wed, Jul 16, 2003 at 09:08:00AM +0530, mallah at 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',
                        'Privileged' => '1',
                        'RealName' => 'Root',
                        'EmailAddress' => 'mallah_rajesh at 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/