Reset the password for superlibrarian ?

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Reset the password for superlibrarian ?

Quỳnh Vũ Đỗ
Hello everyone,
Thanks to useful advice provided by the list community, I was able to
upgrade from Koha 3.18 to Koha 19.11.05

I could open the Staff login window. I am now faced with login in to Koha
as administrator to perform some maintenance tasks. I managed to found how
to get into a Koha shell and run the script
/usr/share/koha/bin/devel/create_superlibrarian.pl
With Usage:
    create_superlibrarian.pl --userid <userid> --password <password>
    --branchcode <branchcode> --categorycode <categorycode> --cardnumber
    <cardnumber>
So I tried with values without any quotes, with double quotes  and simple
quotes to always face the same error:

DBD::mysql::st execute failed: Duplicate entry 'BGH000001' for key
'cardnumber' [for Statement "INSERT INTO `borrowers` ( `borrowernumber`,
`branchcode`, `cardnumber`, `categorycode`, `dateenrolled`, `dateexpiry`,
`flags`, `password`, `privacy`, `surname`, `userid`) VALUES ( ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0=undef, 1='TLU', 2='BGH000001',
3='CB', 4='2020-05-16T14:29:34', 5='2021-05-16T14:29:34', 6='1', 7='!',
8=1, 9=undef, 10="2"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line
1834.

But as the superlibraian already exists, then I cannot insert an other one
- so the duplicate entry. What I would need is a simple UPDATE statement to
reset the password of the superlibrarian with userid thanglong with a
"newpassword"

Is it safe to enter the following command from a mysql shell
USE koha_library;
UPDATE `borrowers` SET `password` = PASSWORD("newpassord") WHERE
`userid`="thanglong";

I eventually tried it, but still was not able to log in.
Any hint on how to reset that password for the first row of the table
boowers?
Thanks for reading
Quynh

=================
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Reset the password for superlibrarian ?

Jonathan Druart
Hello Quynh,

Use the script misc/admin/set_password.pl

Regards,
Jonathan

Le sam. 16 mai 2020 à 09:47, Quỳnh Vũ Đỗ <[hidden email]> a écrit :

>
> Hello everyone,
> Thanks to useful advice provided by the list community, I was able to
> upgrade from Koha 3.18 to Koha 19.11.05
>
> I could open the Staff login window. I am now faced with login in to Koha
> as administrator to perform some maintenance tasks. I managed to found how
> to get into a Koha shell and run the script
> /usr/share/koha/bin/devel/create_superlibrarian.pl
> With Usage:
>     create_superlibrarian.pl --userid <userid> --password <password>
>     --branchcode <branchcode> --categorycode <categorycode> --cardnumber
>     <cardnumber>
> So I tried with values without any quotes, with double quotes  and simple
> quotes to always face the same error:
>
> DBD::mysql::st execute failed: Duplicate entry 'BGH000001' for key
> 'cardnumber' [for Statement "INSERT INTO `borrowers` ( `borrowernumber`,
> `branchcode`, `cardnumber`, `categorycode`, `dateenrolled`, `dateexpiry`,
> `flags`, `password`, `privacy`, `surname`, `userid`) VALUES ( ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0=undef, 1='TLU', 2='BGH000001',
> 3='CB', 4='2020-05-16T14:29:34', 5='2021-05-16T14:29:34', 6='1', 7='!',
> 8=1, 9=undef, 10="2"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line
> 1834.
>
> But as the superlibraian already exists, then I cannot insert an other one
> - so the duplicate entry. What I would need is a simple UPDATE statement to
> reset the password of the superlibrarian with userid thanglong with a
> "newpassword"
>
> Is it safe to enter the following command from a mysql shell
> USE koha_library;
> UPDATE `borrowers` SET `password` = PASSWORD("newpassord") WHERE
> `userid`="thanglong";
>
> I eventually tried it, but still was not able to log in.
> Any hint on how to reset that password for the first row of the table
> boowers?
> Thanks for reading
> Quynh
>
> =================
> M. Vũ Đỗ Quỳnh (Ph.D)
> Trường Đại học Thăng Long - Université de Thang Long - Thang Long
> University (Hanoi, Vietnam)
> Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
> internationale - Vice-Rector in charge of International Cooperation
> Web: http://thanglong.edu.vn/
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> [hidden email]
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Reset the password for superlibrarian ?

Quỳnh Vũ Đỗ
Hello Jonathan

Thanks for the info. I already solved my problem but I will try it as it's
good to know.
Best regards
Quynh


=================
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/


Vào Th 2, 18 thg 5, 2020 vào lúc 15:46 Jonathan Druart <
[hidden email]> đã viết:

> Hello Quynh,
>
> Use the script misc/admin/set_password.pl
>
> Regards,
> Jonathan
>
> Le sam. 16 mai 2020 à 09:47, Quỳnh Vũ Đỗ <[hidden email]> a
> écrit :
> >
> > Hello everyone,
> > Thanks to useful advice provided by the list community, I was able to
> > upgrade from Koha 3.18 to Koha 19.11.05
> >
> > I could open the Staff login window. I am now faced with login in to Koha
> > as administrator to perform some maintenance tasks. I managed to found
> how
> > to get into a Koha shell and run the script
> > /usr/share/koha/bin/devel/create_superlibrarian.pl
> > With Usage:
> >     create_superlibrarian.pl --userid <userid> --password <password>
> >     --branchcode <branchcode> --categorycode <categorycode> --cardnumber
> >     <cardnumber>
> > So I tried with values without any quotes, with double quotes  and simple
> > quotes to always face the same error:
> >
> > DBD::mysql::st execute failed: Duplicate entry 'BGH000001' for key
> > 'cardnumber' [for Statement "INSERT INTO `borrowers` ( `borrowernumber`,
> > `branchcode`, `cardnumber`, `categorycode`, `dateenrolled`, `dateexpiry`,
> > `flags`, `password`, `privacy`, `surname`, `userid`) VALUES ( ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0=undef, 1='TLU', 2='BGH000001',
> > 3='CB', 4='2020-05-16T14:29:34', 5='2021-05-16T14:29:34', 6='1', 7='!',
> > 8=1, 9=undef, 10="2"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line
> > 1834.
> >
> > But as the superlibraian already exists, then I cannot insert an other
> one
> > - so the duplicate entry. What I would need is a simple UPDATE statement
> to
> > reset the password of the superlibrarian with userid thanglong with a
> > "newpassword"
> >
> > Is it safe to enter the following command from a mysql shell
> > USE koha_library;
> > UPDATE `borrowers` SET `password` = PASSWORD("newpassord") WHERE
> > `userid`="thanglong";
> >
> > I eventually tried it, but still was not able to log in.
> > Any hint on how to reset that password for the first row of the table
> > boowers?
> > Thanks for reading
> > Quynh
> >
> > =================
> > M. Vũ Đỗ Quỳnh (Ph.D)
> > Trường Đại học Thăng Long - Université de Thang Long - Thang Long
> > University (Hanoi, Vietnam)
> > Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la
> coopération
> > internationale - Vice-Rector in charge of International Cooperation
> > Web: http://thanglong.edu.vn/
> > _______________________________________________
> >
> > Koha mailing list  http://koha-community.org
> > [hidden email]
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha