Just need general help with setting up my server. Pterodactyl - Ubuntu 24.04 - Oracle VM.

I am going to have many questions, my first question is that ive followed this page https://pterodactyl.io/panel/1.0/getting_started.html#download-files I am trying to put in the command: CREATE USER 'pterodactyl'@'127.0.0.1' IDENTIFIED BY 'yourPassword'; And im getting back: CREATE: command not found ANy ideas on why thats happening, or what I missed in the earlier steps?
Getting Started | Pterodactyl
Pterodactyl is an open-source game server management panel built with PHP, React, and Go. Designed with security in mind, Pterodactyl runs all game servers in isolated Docker containers while exposing a beautiful and intuitive UI to end users.
52 Replies
Admincraft Meta
Admincraft Metaβ€’2mo ago
Thanks for asking your question!
Make sure to provide as much helpful information as possible such as logs/what you tried and what your exact issue is
Make sure to mark solved when issue is solved!!!
/close !close !solved !answered
Requested by da_milkman#0
SilentBot
SilentBotβ€’2mo ago
Are you typing that command in your sql console? After doing either mysql -u root -p or mariadb -u root -p, depending if you picked MariaDB or MySQL as your SQL server
π™ˆπ™„π™‡π™†π™Š
I tried both and they are both asking for a password, I cant type anything and if I jsut hit enter, it denys access I thought I was setting up mariaDB
SilentBot
SilentBotβ€’2mo ago
You've already attempted to run an install script on this machine, right?
SilentBot
SilentBotβ€’2mo ago
Likely it setup a database, with a password We don't know which database, nor what the password is, so that puts you in a unfortunate position
π™ˆπ™„π™‡π™†π™Š
OK, so what can I do to fix that?
SilentBot
SilentBotβ€’2mo ago
Either restarting the database in authless mode, so you can update the password for the default user Or starting from scratch and follow the steps on the guide 1 for 1, rather than trying to pickup from the failed install script (I'd recommend the latter)
π™ˆπ™„π™‡π™†π™Š
how does oen start from scratch, are you saying like create a completely new VM?
SilentBot
SilentBotβ€’2mo ago
Reinstall the OS, or recreate the VM, yeah
SilentBot
SilentBotβ€’2mo ago
You can continue from here, but realistically, if you don't know how things have been setup by the script It's mostly going to be figuring stuff out, rather than just setting it up
π™ˆπ™„π™‡π™†π™Š
Ok Rebuilt it all and it worked!
SilentBot
SilentBotβ€’2mo ago
:CHEERGIF:
π™ˆπ™„π™‡π™†π™Š
how do I find the .env encryption key to back up?
SilentBot
SilentBotβ€’2mo ago
it's in /var/www/pterodactyl/.env
SilentBot
SilentBotβ€’2mo ago
so just nano or cat it
π™ˆπ™„π™‡π™†π™Š
im just gonna pretend to understand! gonna go google some stuff so you dont have to explain it.
SilentBot
SilentBotβ€’2mo ago
nano /var/www/pterodactyl/.env or cat /var/www/pterodactyl/.env to see the contents and then copy the key
π™ˆπ™„π™‡π™†π™Š
cool πŸ˜… I don't see the key in there
SilentBot
SilentBotβ€’2mo ago
Should be APP_KEY
π™ˆπ™„π™‡π™†π™Š
just blank for me, ill try cat.
SilentBot
SilentBotβ€’2mo ago
it may be .env or .ENV I can't remember
π™ˆπ™„π™‡π™†π™Š
Ok, ill try some variations yep it was lowercase ok I got another q (sorry im getting cautious cause I dont want to restart eveything again) with php artisan p:environment:setup it asks for an email, should I put an email of mine in or am I supposed to do something differnt...
SilentBot
SilentBotβ€’2mo ago
So this is what would appear for password reset/server creation emails The next step will ask you to configure the provider by default it uses php's built in send mail function Which will go to spam if you don't own the domain and have the right spf records You can also just use a gmail address and gmail SMTP details
π™ˆπ™„π™‡π™†π™Š
Ok, are you saying that emails would be sent to this email? or from?
SilentBot
SilentBotβ€’2mo ago
from
π™ˆπ™„π™‡π™†π™Š
I see, so would this only matter if I was selling services? maybe im not understanding here... Like if I was setting up servers for others.
SilentBot
SilentBotβ€’2mo ago
It will still be used for password reset emails or emails when servers have finished being created+installed
π™ˆπ™„π™‡π™†π™Š
Oh wait, i think i understand, so in order for me to get emails about the server, I need to set up an email that those emails will come from. so in that case I should make a new gmail just for this?
SilentBot
SilentBotβ€’2mo ago
Would be easier to just use a "[email protected]" But you could create a gmail and use its SMTP details
π™ˆπ™„π™‡π™†π™Š
I do have a domain, but no email set up for it, is that an issue?
SilentBot
SilentBotβ€’2mo ago
No, because it will use PHP's built in mail function
π™ˆπ™„π™‡π™†π™Š
cool, so ill just do this!
czychuuu
czychuuuβ€’2mo ago
btw you can use mariadb -u root without a pass same for mysql
π™ˆπ™„π™‡π™†π™Š
oh ok, well I ended up completely restarting from scratch and that fixed it
czychuuu
czychuuuβ€’2mo ago
that also works
π™ˆπ™„π™‡π™†π™Š
but now I actually have a new problem: when i type php artisan migrate --seed --force I get two responses in red: SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'localhost' (using password: YES) (Connection: mysql, S QL: select table_name as name, (data_length + index_length) as size, table_comment as comment, engine as eng ine, table_collation as collation from information_schema.tables where table_schema = 'panel' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name) AND SQLSTATE[HY000] [1045] Access denied for user 'pterodactyl'@'localhost' (using password: YES)
czychuuu
czychuuuβ€’2mo ago
you entered a wrong pass to mysql
π™ˆπ™„π™‡π™†π™Š
I typed it right, but I didnt reply yes to the username, should I have done that?
czychuuu
czychuuuβ€’2mo ago
well i havent installed ptero for a long time so cant help here
π™ˆπ™„π™‡π™†π™Š
Aftewr going through php artisan p:environment:database It asked if i wanted to change mySQL password, when i typed yes, it gives me and option but It wont let me type anything ok
czychuuu
czychuuuβ€’2mo ago
instead of *** like on websites linux doesnt show anything but it is there
Arthurmeade12
Arthurmeade12β€’2mo ago
when you say it doesn't let you type anything, do you mean that you are prompted but whatever you type doesn't show up on screen?
π™ˆπ™„π™‡π™†π™Š
yes Oh wait I see
Arthurmeade12
Arthurmeade12β€’2mo ago
Because that's normal behavior. It's intended to block your password from being displayed Just type whatever you want for your password and then hit enter
π™ˆπ™„π™‡π™†π™Š
haha i have no clue wth is happening at this point, been workin gon this for horus 🫨 got it that fixed it!
Arthurmeade12
Arthurmeade12β€’2mo ago
glad I could helpπŸ‘
π™ˆπ™„π™‡π™†π™Š
for php artisan p:user:make should I use email I want to use for ptero account? or the previous php mail sending one
czychuuu
czychuuuβ€’2mo ago
if you not gonna use emails system just put anything
π™ˆπ™„π™‡π™†π™Š
no I already passed that, this is for making a user new problem: [ Error writing /etc/systemd/system/pteroq.service: Permission denied ] Nevermind fixed it.

Did you find this page helpful?