9 Oct
2019
9 Oct
'19
11:32 a.m.
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@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@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@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 > >> > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@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@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.