[Koha] Need help in login to Koha

[Katrin Fischer]

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 at 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 at 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 at tuta.io <mailto:aaruswartz at 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 at lists.katipo.co.nz <mailto:Koha at 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 at orex.es <mailto:hagud at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha