Invalid username/password with web installer - original installation
Hi all, I'm planning to use Koha 19.05 to set up a library management system for a small library collection, as an independent project to make searching for resources easier for the small group of users. On a computer running Ubuntu I've followed the basic instructions to download Koha and the supporting software such as Apache2 and Perl. All this seems to have gone well. When I get to the Koha 19.05 web installer on Firefox I'm not getting anywhere with the username and password. I've tried *koha_kohadev* and *password* based on the Koha Manual 19.05 documentation, plus *koha_<libraryname> *and the password retrieved through the terminal command *sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo*, as according to Open School Solutions' installation guide. Whatever I do I seem to come up with this message above the web installer: *Error: Invalid username or password* In my research I've learned that Koha 19.05 doesn't permit logging in with the database user and creating a superlibrarian patron is recommended. I've attempted to follow the steps at https://lists.katipo.co.nz/public/koha/2018-May/050688.html but am getting a series of DBI connect failures in the terminal. I don't have library codes or category codes set up (haven't cracked the web installer yet) so maybe this has something to do with it?
From the kohageek blog ( http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line....) I get a different response after loading the environmental variables and attempting to create the superlibrarian: *Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module)* and then an explanation of what @INC contains.
Any ideas? Any help would be much appreciated. Cheers, Matthew Sampson
Hello Matthew, What installation instructions have you followed? is it the package based installation method here : https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages . By the way, if web installer never happened you cannot create admin user using the methods in the link you provided, as the db structure was not created yet. So you have to focus on getting mysql username/password first : sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo NOTE THAT library in that command is the instance name and so you should change it to your instance name. you mentioned in your message that you tried user (koha_kohadev ) so it look like your instance name is kohadev so that command should be like this : sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/kohadev /koha-conf.xml;echo This should output the password for mysql for your instance. and the usrer is koha_kohadev if you are not sure what was the instance name you can figure that out by running : sudo koha-list I hope that helps, Best regards. Karam. On Thu, Aug 29, 2019 at 6:57 AM Matthew Sampson <matthew.b.sampson@gmail.com> wrote:
Hi all,
I'm planning to use Koha 19.05 to set up a library management system for a small library collection, as an independent project to make searching for resources easier for the small group of users.
On a computer running Ubuntu I've followed the basic instructions to download Koha and the supporting software such as Apache2 and Perl. All this seems to have gone well.
When I get to the Koha 19.05 web installer on Firefox I'm not getting anywhere with the username and password. I've tried *koha_kohadev* and *password* based on the Koha Manual 19.05 documentation, plus *koha_<libraryname> *and the password retrieved through the terminal command *sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo*, as according to Open School Solutions' installation guide.
Whatever I do I seem to come up with this message above the web installer: *Error: Invalid username or password*
In my research I've learned that Koha 19.05 doesn't permit logging in with the database user and creating a superlibrarian patron is recommended. I've attempted to follow the steps at https://lists.katipo.co.nz/public/koha/2018-May/050688.html but am getting a series of DBI connect failures in the terminal. I don't have library codes or category codes set up (haven't cracked the web installer yet) so maybe this has something to do with it?
From the kohageek blog (
http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.... ) I get a different response after loading the environmental variables and attempting to create the superlibrarian: *Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module)* and then an explanation of what @INC contains.
Any ideas? Any help would be much appreciated.
Cheers,
Matthew Sampson _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
Hi Karam, Hey, thanks for writing back. I discovered the solution after playing with another respondent's recommendations—I had created two instances in my relatively uninformed setup (discovered them through sudo koha-list) and the one I was not aware of worked first time. Many thanks—I would have worked it out from your support if I hadn't cracked it already. Cheers, Matthew On Thu, 29 Aug 2019 at 15:13, Karam Qubsi <karamqubsi@gmail.com> wrote:
Hello Matthew,
What installation instructions have you followed? is it the package based installation method here : https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages .
By the way, if web installer never happened you cannot create admin user using the methods in the link you provided, as the db structure was not created yet.
So you have to focus on getting mysql username/password first :
sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo
NOTE THAT library in that command is the instance name and so you should change it to your instance name. you mentioned in your message that you tried user (koha_kohadev ) so it look like your instance name is kohadev so that command should be like this :
sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/kohadev /koha-conf.xml;echo
This should output the password for mysql for your instance. and the usrer is koha_kohadev
if you are not sure what was the instance name you can figure that out by running : sudo koha-list
I hope that helps,
Best regards. Karam.
On Thu, Aug 29, 2019 at 6:57 AM Matthew Sampson < matthew.b.sampson@gmail.com> wrote:
Hi all,
I'm planning to use Koha 19.05 to set up a library management system for a small library collection, as an independent project to make searching for resources easier for the small group of users.
On a computer running Ubuntu I've followed the basic instructions to download Koha and the supporting software such as Apache2 and Perl. All this seems to have gone well.
When I get to the Koha 19.05 web installer on Firefox I'm not getting anywhere with the username and password. I've tried *koha_kohadev* and *password* based on the Koha Manual 19.05 documentation, plus *koha_<libraryname> *and the password retrieved through the terminal command *sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo*, as according to Open School Solutions' installation guide.
Whatever I do I seem to come up with this message above the web installer: *Error: Invalid username or password*
In my research I've learned that Koha 19.05 doesn't permit logging in with the database user and creating a superlibrarian patron is recommended. I've attempted to follow the steps at https://lists.katipo.co.nz/public/koha/2018-May/050688.html but am getting a series of DBI connect failures in the terminal. I don't have library codes or category codes set up (haven't cracked the web installer yet) so maybe this has something to do with it?
From the kohageek blog (
http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.... ) I get a different response after loading the environmental variables and attempting to create the superlibrarian: *Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module)* and then an explanation of what @INC contains.
Any ideas? Any help would be much appreciated.
Cheers,
Matthew Sampson _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
Hi For accessing web installer you should get the username and password from koha-conf.xml, there is a section tagged nysql... you can also get the password via sudo koha-passwd <<instance>> username koha_<<instance>> El jue., 29 ago. 2019 a las 0:57, Matthew Sampson (< matthew.b.sampson@gmail.com>) escribió:
Hi all,
I'm planning to use Koha 19.05 to set up a library management system for a small library collection, as an independent project to make searching for resources easier for the small group of users.
On a computer running Ubuntu I've followed the basic instructions to download Koha and the supporting software such as Apache2 and Perl. All this seems to have gone well.
When I get to the Koha 19.05 web installer on Firefox I'm not getting anywhere with the username and password. I've tried *koha_kohadev* and *password* based on the Koha Manual 19.05 documentation, plus *koha_<libraryname> *and the password retrieved through the terminal command *sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo*, as according to Open School Solutions' installation guide.
Whatever I do I seem to come up with this message above the web installer: *Error: Invalid username or password*
In my research I've learned that Koha 19.05 doesn't permit logging in with the database user and creating a superlibrarian patron is recommended. I've attempted to follow the steps at https://lists.katipo.co.nz/public/koha/2018-May/050688.html but am getting a series of DBI connect failures in the terminal. I don't have library codes or category codes set up (haven't cracked the web installer yet) so maybe this has something to do with it?
From the kohageek blog (
http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.... ) I get a different response after loading the environmental variables and attempting to create the superlibrarian: *Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module)* and then an explanation of what @INC contains.
Any ideas? Any help would be much appreciated.
Cheers,
Matthew Sampson _______________________________________________ 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.
Hi Hugo, Thanks for writing back. I've had my problem solved. Those commands are really quick though and much better than the roundabout code I've been using. Many thanks! Matthew On Thu, 29 Aug 2019 at 18:18, Hugo Agud <hagud@orex.es> wrote:
Hi
For accessing web installer you should get the username and password from koha-conf.xml, there is a section tagged nysql...
you can also get the password via sudo koha-passwd <<instance>>
username koha_<<instance>>
El jue., 29 ago. 2019 a las 0:57, Matthew Sampson (< matthew.b.sampson@gmail.com>) escribió:
Hi all,
I'm planning to use Koha 19.05 to set up a library management system for a small library collection, as an independent project to make searching for resources easier for the small group of users.
On a computer running Ubuntu I've followed the basic instructions to download Koha and the supporting software such as Apache2 and Perl. All this seems to have gone well.
When I get to the Koha 19.05 web installer on Firefox I'm not getting anywhere with the username and password. I've tried *koha_kohadev* and *password* based on the Koha Manual 19.05 documentation, plus *koha_<libraryname> *and the password retrieved through the terminal command *sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo*, as according to Open School Solutions' installation guide.
Whatever I do I seem to come up with this message above the web installer: *Error: Invalid username or password*
In my research I've learned that Koha 19.05 doesn't permit logging in with the database user and creating a superlibrarian patron is recommended. I've attempted to follow the steps at https://lists.katipo.co.nz/public/koha/2018-May/050688.html but am getting a series of DBI connect failures in the terminal. I don't have library codes or category codes set up (haven't cracked the web installer yet) so maybe this has something to do with it?
From the kohageek blog (
http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.... ) I get a different response after loading the environmental variables and attempting to create the superlibrarian: *Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module)* and then an explanation of what @INC contains.
Any ideas? Any help would be much appreciated.
Cheers,
Matthew Sampson _______________________________________________ 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.
participants (3)
-
Hugo Agud -
Karam Qubsi -
Matthew Sampson