Hi Aaru, I assume you used a database dump for importing your old data? In this case the superlibrarian user created by the script will have been overwritten and you will have to create it again using the script. The database user from koha-conf.xml will only work for the web installer in newer versions of Koha and won't allow you to get into the staff interface. A superlibrarian account is required for that. Hope this helps, Katrin On 07.10.19 08:07, aaruswartz@tuta.io wrote:
Dear Hugo Agud, I have went through the create_superlibrarian.pl file and couldn't find anything related to koha version. Hence I created a virtualBox Debian image and installed Koha 19.05 , MySQL 15.1 and MariaDB 10.4.8. I could now log into Koha with the username and password in the /etc/koha/sites/library/koha-conf.xml.
But once I import all the data from the old database to the new one, I am not able to login to Koha. Thanks Regards Aaru_Swartz
Sep 30, 2019, 10:29 by hagud@orex.es:
Good morning
Depending on the koha's version you'are not able to login via user and password from SQL, please take a look on > See the script misc/devel/> create_superlibrarian.pl <http://create_superlibrarian.pl>> . (remember to sudo koha-shell <<instance>> before run it
kindest regards
El lun., 30 sept. 2019 a las 6:47, <> aaruswartz@tuta.io <mailto:aaruswartz@tuta.io>> > escribió:
Dear Team Koha, Thanks for accepting my request to join the mail-list.
Our office library uses Koha for a long time now. Librarian has forgotten the user name and password. I am the System Admin and have reset the Koha admin user password in the /etc/koha/sites/library/koha-conf.xml and in MySQL. I am able to login to the database via both PHPMyAdmin and MySQL CLI. But unable to login to the Koha site at >> http://IPaddress:8000 <http://IPaddress:8000>>> <>> http://IPaddress:8000 <http://IPaddress:8000>>> >.
The login page displays this below message. "Error: Invalid username or password" message is being displayed. "
OS : Debian GNU/Linux 8.11 (jessie) Koha : koha 18.11.03 MySQL: mysql 5.5.62 PHPmyadmin : phpmyadmin 4:4.2.12
Please let me know what is causing the problem and if any fix. Thank you.
Aaru_Swartz _______________________________________________ Koha mailing list >> http://koha-community.org <http://koha-community.org>
Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>
--
Hugo Agud - Orex Digital
www.orex.es <http://www.orex.es>
<http://www.orex.es/> <http://www.orex.es/koha>> <http://www.orex.es/vufind>> >
Director
Passeig Comte Vilardaga, 118 3-3 08980 -Sant Feliu de Llobregat - Tel: 933 856 138 > hagud@orex.es <mailto:hagud@orex.es>> · > http://www.orex.es/ <http://www.orex.es/>
No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha