Hello, all In our latest exchange, on June 6, 2019, at 9:00 AM, Héctor González wrote:
Not so grand! This means the user it is trying to create to grant database privileges is already there, and it won´t continue. You should first make sure everything is clean of your previous attempts, or it will not proceed.
You should check mysql, and drop the user and the database if they exist before running that command again.
koha-remove can help you remove a previous installation attempt.
Sorry but this did not help. I typed in the terminal $ sudo koha-remove mylibrary The report was ERROR 1133 (28000) at line 1: Can’t find any matching row in the user table Any other suggestions? Hope all are well and all is well. — Charles. Charles Kelley PSC 704 Box 1029 APO AP 96338 011-81-80-4714-5490 [JPN cell] mnogojazyk@aol.com cmkelleymls@gmail.com www.linkedin.com/in/cmkelleymls Meeting Your Information Needs. Virtually.
On Jun 5, 2019, at 11:02 PM, Charles Kelley <cmkelleymls@gmail.com> wrote:
Hello, all
In our latest exchange, on June 6, 2019, at 9:00 AM, Héctor González wrote:
Not so grand! This means the user it is trying to create to grant database privileges is already there, and it won´t continue. You should first make sure everything is clean of your previous attempts, or it will not proceed.
You should check mysql, and drop the user and the database if they exist before running that command again.
koha-remove can help you remove a previous installation attempt.
Sorry but this did not help. I typed in the terminal
$ sudo koha-remove mylibrary
The report was
ERROR 1133 (28000) at line 1: Can’t find any matching row in the user table
Any other suggestions?
Try sudo koha-remove --keep-mysql mylibrary so it doesn´t try to remove the mysql part, then check mysql, and see if the database is there or not. If it is there, drop it, and then start again. The message indicates that the mysql user koha creates is not there, so this part is already done, and should be skipped. The original message your system showed was about the linux user, which should also be deleted to proceed. Your koha looks like it is in a half installed state, so you need to try and make it clean again. You could also change the name of the library configuration, but the old files would be left there. If this is just a development server, the fastest route might be to do: sudo koha-create --create-db myotherlibrary
Hope all are well and all is well.
— Charles.
Charles Kelley PSC 704 Box 1029 APO AP 96338
011-81-80-4714-5490 [JPN cell]
mnogojazyk@aol.com cmkelleymls@gmail.com
www.linkedin.com/in/cmkelleymls Meeting Your Information Needs. Virtually.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Héctor González cacho@genac.org
On Jun 5, 2019, at 11:02 PM, Charles Kelley <cmkelleymls@gmail.com> wrote:
$ sudo koha-remove mylibrary
The report was
ERROR 1133 (28000) at line 1: Can’t find any matching row in the user table
Any other suggestions?
I recently had to do this again for an upgrade, and found this exact error. It means the mysql user koha_mylibrary exists, but does not have a password assigned, so it can´t be found and erased properly. you can add a password (it doesn´t matter which you use, it will be removed with koha-remove mylibrary), from mysql, with: grant all on koha_mylibrary.* to koha_mylibrary@localhost identified with 'thispasswordwillberemovedbykoha-remove'; then koha-remove should be able to work.
Hope all are well and all is well.
— Charles.
Charles Kelley PSC 704 Box 1029 APO AP 96338
011-81-80-4714-5490 [JPN cell]
mnogojazyk@aol.com <mailto:mnogojazyk@aol.com> cmkelleymls@gmail.com <mailto:cmkelleymls@gmail.com>
www.linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.
-- Héctor González cacho@genac.org
participants (2)
-
Charles Kelley -
Hector Gonzalez