Setup does not create database Xampp

Self-Hosted | v5
1

I setup Ninja with Xampp and the setup checks worked but after setting up user in loops back to the start of setup. No tables were created in database. V5 PHP 8.1

2

[2023-03-12 03:53:13] production.INFO: The command “mysql --user=”${:LARAVEL_LOAD_USER}" --password=“${:LARAVEL_LOAD_PASSWORD}” --host=“${:LARAVEL_LOAD_HOST}” --port=“${:LARAVEL_LOAD_PORT}” --database=“${:LARAVEL_LOAD_DATABASE}” < “${:LARAVEL_LOAD_PATH}”" failed.

Exit Code: 1(General error)

Working directory: F:\Xampp\htdocs\public

Output:

Error Output:

‘mysql’ is not recognized as an internal or external command,
operable program or batch file.

It looks like mysql is the problem. Xampp uses Mariadb.
Does anyone know where and how to change the path so it looks for Mariadb instead of mysql?

3

Hi,

@david can you please advise?

4

mysql / mariadb are interchangeable, most like you don’t have the mysql client installed.

you may also want to try running

php artisan migrate

after this has been installed and you’ll see the actual error.

5

Not sure how to run php artisan migrate in windows.

6

I ran php artisan migrate and it gave me the same error I sent in my first post.

[2023-03-12 18:00:20] production.INFO: The command “mysql --user=”${:LARAVEL_LOAD_USER}" --password=“${:LARAVEL_LOAD_PASSWORD}” --host=“${:LARAVEL_LOAD_HOST}” --port=“${:LARAVEL_LOAD_PORT}” --database=“${:LARAVEL_LOAD_DATABASE}” < “${:LARAVEL_LOAD_PATH}”" failed.

Exit Code: 1(General error)

Working directory: F:\Xampp\htdocs\public

Output:

Error Output:

‘mysql’ is not recognized as an internal or external command,
operable program or batch file.

[2023-03-12 18:28:04] production.INFO: account table not found

7

Ok I ran php artisan migrate:fresh --seed and the database populated.
What is the login?

8

localhost/public/setup & login both give me 404 errors.

9

Can I manually add username & password?

10

@wesch3

run this:

php artisan ninja:create-account --email=your@email.com --password=supasecret
11

Login still failed, no credentials on file.
I get an error on login but I can force login at bottom of page.
This does not seem like normal login.

12

Since I forced migration I assume the database tables are correct.
The setup was successful except at the end setting up user, it reverted back to start.
I am using localhost/login, I assume that is correct.
Something is wrong with the login because it doesn’t come up on the right screen.
Login seems like a minor issue.
Should I delete database and start over?

13

David-

I deleted DB and started over.
Setup ran the first time.
Login url=localhost/#/
I guess that is normal.
Anyway thanks for the help.