Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

can't register a sysadmin account SQLSTATE[HY000][1130] error #493

Closed
padeyoung opened this issue Oct 6, 2017 · 16 comments
Closed

can't register a sysadmin account SQLSTATE[HY000][1130] error #493

padeyoung opened this issue Oct 6, 2017 · 16 comments

Comments

@padeyoung
Copy link

Description of the problem

DO NOT DELETE THE TEXT BELOW
BUT FILL THE REQUESTED INFOS!!!!!!

Informations

  • Elabftw version (visible in Sysadmin panel) : Not able to make a sysadmin account. Docker logs -f elabftw does show nginx in running state
  • Installation method (git, docker or zip archive) : Docker with apt-get and eLab with wget following the instructions on the "Docs >> Install on a GNU/Linux server
  • Operating system + version : Debian 8
  • Browser used (firefox/chrome) : firefox

For git/zip installation method:

  • PHP version:
  • MySQL version:
  • Webserver (apache/nginx) + version : do not have apache or nginx: answered install questions to reflect this.

The installation of Docker for Debian Jessie and elabftw went smoothly until the step for "register a sysadmin account:" the "Doc>>Install on a GNU/Linux server" Using chrome from a windows machine, using firefox from the server screen, using firefox from root (after sudo su) I get more or less the same failure
SQLSTATE[HY000][1130] Host 172.17.0.3 is not allowed to connect to this MySQL server. The address of the linux box is 209.140.209.210 (this was supplied during the Docker install)

@NicolasCARPi
Copy link
Contributor

Hello,

Yeah sometimes for a reason that I have not been able to identify, the mysql container is not properly working. I already had this error, it's kind of random. Remove all the running containers and try again:

elabctl stop
docker container prune
docker volume prune

BTW don't use firefox as root!!

@padeyoung
Copy link
Author

padeyoung commented Oct 6, 2017 via email

@NicolasCARPi
Copy link
Contributor

Please host the log file on pastebin.com, attachements are stripped by github.

@padeyoung
Copy link
Author

padeyoung commented Oct 6, 2017 via email

@padeyoung
Copy link
Author

padeyoung commented Oct 6, 2017 via email

@NicolasCARPi
Copy link
Contributor

Please paste the link here.

@padeyoung
Copy link
Author

padeyoung commented Oct 6, 2017 via email

@padeyoung
Copy link
Author

padeyoung commented Oct 6, 2017 via email

@NicolasCARPi
Copy link
Contributor

Ok I see you have an error with Docker:

ERROR: for mysql driver "aufs" failed to remove root filesystem for a424097a27fbc76390b46aff239b3a1ee204d92fa909872521ada109a64ef703: could not remove diff path for id 43bf779561b665c521278bbd37811d8aaad1e178b317e747eb899466fda8e7bc: error preparing atomic delete: rename /var/lib/docker/aufs/diff/43bf779561b665c521278bbd37811d8aaad1e178b317e747eb899466fda8e7bc /var/lib/docker/aufs/diff/43bf779561b665c521278bbd37811d8aaad1e178b317e747eb899466fda8e7bc-removing: device or resource busy

This explains why the container was not working. You might want to reboot. Make sure your system is fully updated, too. You might also want to read a few of those links:
https://www.google.fr/search?q=docker+aufs+failed+to+remove

Also you don't have to redownload the elabctl each time, just call elabctl install ;)

@padeyoung
Copy link
Author

padeyoung commented Oct 6, 2017 via email

@padeyoung
Copy link
Author

padeyoung commented Oct 9, 2017 via email

@NicolasCARPi
Copy link
Contributor

Well, you obviously have errors with aufs and docker. This has nothing to do with elabftw. Have a look at this issue: moby/moby#21704.

@padeyoung
Copy link
Author

padeyoung commented Oct 10, 2017 via email

@padeyoung
Copy link
Author

padeyoung commented Oct 10, 2017 via email

@NicolasCARPi
Copy link
Contributor

You can still install it without Docker you know: https://doc.elabftw.net/install-oldschool.html

Because in the end it's just a PHP + MySQL app like wordpress or mediawiki.

@NicolasCARPi
Copy link
Contributor

NicolasCARPi commented Oct 10, 2017

Can you point me to uninstall instructions?

elabctl uninstall

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants