[Koha] Need help in login to Koha

Wed Oct 9 22:32:30 NZDT 2019

Hi

you just need to login to mysql and execute

select * from branches;
select * from categories;

and you will see then

El mié., 9 oct. 2019 a las 11:30, <aaruswartz at tuta.io> escribió:

> Hi Katrin Fischer,
> Thanks for the suggestions. I now tried to create a super librarian
> account using the create_superlibrarian.pl  under koha-shell.
>
> using the below command:
> create_superlibrarian.pl --userid library --password password -branchcode
> MAIN --categorycode LIS --cardumber -25
> I am getting the below error.
> "Invalid parameter passed, categorycode=15 does not exist."
>
> I exactly don't remember the CategoryCode and BranchCode that used
> previously
>
> Hence unable to create superlibrarian accont.
>
> Thank you.
>
> Oct 8, 2019, 02:09 by katrin.fischer.83 at web.de:
>
> > 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
> >>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>

-- 

*Hugo Agud - Orex Digital *

*www.orex.es <http://www.orex.es>*

<http://www.orex.es/>    [image: www.orex.es/koha] <http://www.orex.es/koha>
   [image: www.orex.es/vufind] <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 · 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.