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

eve_universe.sql imports empty data based on directions in current readme #68

Open
nicat23 opened this issue Aug 11, 2023 · 0 comments
Open
Labels
documentation Improvements or additions to documentation
Milestone

Comments

@nicat23
Copy link

nicat23 commented Aug 11, 2023

I worked for a while trying to get this up and running. I was able to successfully launch and setup pathfinder, however after creating the eve_universe database as per the instructions in the install documents, I was unable to log in via SSO - it would give a database error indicating that the table couldn't be updated due to it not existing. Looking further into the logs and viewing the database tables it was indeed blank. I checked the contents of eve_universe.sql.zip and it was empty. When I looked at the install logs, running

docker-compose exec pfdb /bin/sh -c "unzip -p eve_universe.sql.zip | mysql -u root -p$MYSQL_ROOT_PASSWORD eve_universe"; from step 4 resulted in a single output message: unzip: short read

This is how I discovered the zip was empty or malformed. In order to correctly import the data into the container, I had to run the following:

sudo wget https://github.com/exodus4d/pathfinder/raw/master/export/sql/eve_universe.sql.zip
sudo unzip eve_universe.sql.zip
sudo docker cp eve_universe.sql "$(sudo docker-compose ps | grep pfdb | awk '{ print $1}'):/eve_universe.sql"
sudo docker-compose exec pfdb sh -c 'exec mysql -uroot -p"$MYSQL_ROOT_PASSWORD" eve_universe < /eve_universe.sql'
sudo rm eve_universe.sql*

modified from the steps I was able to find from https://github.com/KryptedGaming/pathfinder-docker/blob/master/README.md#importing-static-database to match the container name in this instance. After completing the above I was able to finish the setup and log in without failure. You may need to update or amend your install directions! :) Thanks!

@TyrHeimdalEVE TyrHeimdalEVE added the documentation Improvements or additions to documentation label Sep 7, 2023
@TyrHeimdalEVE TyrHeimdalEVE added this to the v2.3.0 milestone Sep 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation
Projects
None yet
Development

No branches or pull requests

2 participants