Where is admin account located?

[dadimhome]

I have been trying to login to the panel for 4h i have serched web and reinstalled the panel multiple times but the admin credentials i put it does not work to login with.

[d00p]

INSERT INTO `panel_admins` SET `adminid` = 1, `loginname` = 'admin', `password` = 'SHA-256-HASH-OF-YOUR-PASSWORD', `name` = 'Siteadmin', `email` = 'admin@FROXLORHOSTNAME', `api_allowed` = 1, `customers` = -1, `customers_see_all` = 1, `caneditphpsettings` = 1, `domains` = -1, `domains_see_all` = 1, `change_serversettings` = 1, `diskspace` = -1024, `mysqls` = -1, `emails` = -1, `email_accounts` = -1, `email_forwarders` = -1, `email_quota` = -1, `ftps` = -1, `subdomains` = -1, `traffic` = -1048576;

 

[dadimhome]

i want to know where the accounts are located

 

[d00p]

Have you tried another browser? Possibly the session is being blocked. Or you somehow manage to change IP on every request so the session is invalid.

No idea how the "where is the account located" answer will help but: in froxlor's database in the table 'panel_admins'. Password is (default) SHA256 encrypted

[dadimhome]

There is nothing under panel_admins

[d00p]

Then there's something wrong with your installation. What OS? Which PHP Version? Which database server? Version?

[dadimhome]

Ubuntu 20.04, PHP 7.4.13, MariaDB

[dadimhome]

MariaDB version: 10.5.8+maria~focal

[dadimhome]

Can i make accounts from the command line in the ssh?

 

[d00p]

You can of course create an admin using SQL directly. It's not recommended though. I'd rather try to find out what went wrong with the install process. There should be some error messages somewhere, usually when an error occurs the installation is not completed successfully

[dadimhome]

there is no error messages, what do i do to make the account in the mysql? I have phpmyadmin

 

[dadimhome]

Still cant log in.

[d00p]

1 hour ago, d00p said:

Have you tried another browser? Possibly the session is being blocked. Or you somehow manage to change IP on every request so the session is invalid.

 

[dadimhome]

It found the account and gave me 
This account has been suspended because of too many login errors.
Please try again in 900 seconds.

[dadimhome]

I used this to get the sha for pass https://passwordsgenerator.net/sha256-hash-generator/

[d00p]

try this php script:

<?php
echo 'SHA-256: ' . crypt($argv[1], '$5$' . md5(uniqid(microtime(), 1)) . md5(uniqid(microtime(), 1))).PHP_EOL;

and call it with "php script.php PASSWORD" to generate the hash for PASSWORD

[dadimhome]

can  i remove the 15 min suspension?

[d00p]

set loginfail_count to 0

[dadimhome]

Where?

 

[d00p]

panel_admins of course for the entry you want to reset

[dadimhome]

Thanks for your help, i was able to login now.