search

snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
10.9k stars 3.15k forks source link

Database is created but still it shows "Unknown Database" #7691

Open abhijitrajkhowa27 opened 4 years ago

abhijitrajkhowa27 commented 4 years ago

Expected Behavior (or desired behavior if a feature request)

(what you expect to happen goes here)

The snipe-it Pre-Flight set-up page should appear.

Actual Behavior

(what actually happens goes here) Whoops, looks like something went wrong. Unknown database 'assetmanagement' (SQL: select * from information_schema.tables where table_schema = assetmanagement and table_name = users).

The database is created and I have cross-verified the credentials in .env file. I have checked the privilages for the user and it has all privilages.

image

image

image

However, the issue disappears if I replace the db name to an already pre-configured db and replace the username to root. With this setup I am able to see the Pre-flight screen, but not confident as I require a different db for my org.

image

image

Kindly help! I have tried all the troubleshooting that is possible.

Please confirm you have done the following before posting your bug report:

Provide answers to these questions:

(3/3) QueryExceptionSQLSTATE[HY000] [1049] Unknown database 'assetmanagement' (SQL: select * from information_schema.tables where table_schema = assetmanagement and table_name = users)

in Connection.php line 664 at Connection->runQueryCallback('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'), object(Closure))in Connection.php line 624 at Connection->run('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'), object(Closure))in Connection.php line 333 at Connection->select('select * from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'))in MySqlBuilder.php line 18 at MySqlBuilder->hasTable('users')in Facade.php line 221 at Facade::__callStatic('hasTable', array('users'))in Setting.php line 68 at Setting::setupCompleted()in CheckForSetup.php line 22 at CheckForSetup->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in TrustProxies.php line 57 at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in NosniffGuard.php line 17 at NosniffGuard->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ContentSecurityPolicyHeader.php line 18 at ContentSecurityPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ReferrerPolicyHeader.php line 17 at ReferrerPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in XssProtectHeader.php line 18 at XssProtectHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in FrameGuard.php line 17 at FrameGuard->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in StartSession.php line 63 at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForMaintenanceMode.php line 46 at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in HandlePreflight.php line 29 at HandlePreflight->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php line 102 at Pipeline->then(object(Closure))in Kernel.php line 151 at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116 at Kernel->handle(object(Request))in index.php line 58

(2/3) PDOExceptionSQLSTATE[HY000] [1049] Unknown database 'assetmanagement'

in PDOConnection.php line 31 at PDOConnection->construct('mysql:host=127.0.0.1;port=3306;dbname=assetmanagement', 'root', '', array(0, 2, 0, false, false))in Connector.php line 64 at Connector->createPdoConnection('mysql:host=127.0.0.1;port=3306;dbname=assetmanagement', 'root', '', array(0, 2, 0, false, false))in Connector.php line 43 at Connector->createConnection('mysql:host=127.0.0.1;port=3306;dbname=assetmanagement', array('driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'assetmanagement', 'username' => 'root', 'password' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => 'InnoDB', 'unix_socket' => '', 'dump' => array('dump_binary_path' => 'C:\wamp64\bin\mysql\mysql8.0.18\bin', 'use_single_transaction', 'timeout' => 300), 'options' => array(), 'name' => 'mysql'), array(0, 2, 0, false, false))in MySqlConnector.php line 24 at MySqlConnector->connect(array('driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'assetmanagement', 'username' => 'root', 'password' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => 'InnoDB', 'unix_socket' => '', 'dump' => array('dump_binary_path' => 'C:\wamp64\bin\mysql\mysql8.0.18\bin', 'use_single_transaction', 'timeout' => 300), 'options' => array(), 'name' => 'mysql'))in ConnectionFactory.php line 183 at ConnectionFactory->Illuminate\Database\Connectors{closure}() at call_user_func(object(Closure))in Connection.php line 915 at Connection->getPdo()in Connection.php line 940 at Connection->getReadPdo()in Connection.php line 399 at Connection->getPdoForSelect(true)in Connection.php line 325 at Connection->Illuminate\Database{closure}('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'))in Connection.php line 657 at Connection->runQueryCallback('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'), object(Closure))in Connection.php line 624 at Connection->run('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'), object(Closure))in Connection.php line 333 at Connection->select('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'))in MySqlBuilder.php line 18 at MySqlBuilder->hasTable('users')in Facade.php line 221 at Facade::callStatic('hasTable', array('users'))in Setting.php line 68 at Setting::setupCompleted()in CheckForSetup.php line 22 at CheckForSetup->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in TrustProxies.php line 57 at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in NosniffGuard.php line 17 at NosniffGuard->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ContentSecurityPolicyHeader.php line 18 at ContentSecurityPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ReferrerPolicyHeader.php line 17 at ReferrerPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in XssProtectHeader.php line 18 at XssProtectHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in FrameGuard.php line 17 at FrameGuard->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in StartSession.php line 63 at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForMaintenanceMode.php line 46 at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in HandlePreflight.php line 29 at HandlePreflight->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php line 102 at Pipeline->then(object(Closure))in Kernel.php line 151 at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116 at Kernel->handle(object(Request))in index.php line 58

(1/3) PDOExceptionSQLSTATE[HY000] [1049] Unknown database 'assetmanagement'

in PDOConnection.php line 27 at PDO->construct('mysql:host=127.0.0.1;port=3306;dbname=assetmanagement', 'root', '', array(0, 2, 0, false, false))in PDOConnection.php line 27 at PDOConnection->construct('mysql:host=127.0.0.1;port=3306;dbname=assetmanagement', 'root', '', array(0, 2, 0, false, false))in Connector.php line 64 at Connector->createPdoConnection('mysql:host=127.0.0.1;port=3306;dbname=assetmanagement', 'root', '', array(0, 2, 0, false, false))in Connector.php line 43 at Connector->createConnection('mysql:host=127.0.0.1;port=3306;dbname=assetmanagement', array('driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'assetmanagement', 'username' => 'root', 'password' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => 'InnoDB', 'unix_socket' => '', 'dump' => array('dump_binary_path' => 'C:\wamp64\bin\mysql\mysql8.0.18\bin', 'use_single_transaction', 'timeout' => 300), 'options' => array(), 'name' => 'mysql'), array(0, 2, 0, false, false))in MySqlConnector.php line 24 at MySqlConnector->connect(array('driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => 'assetmanagement', 'username' => 'root', 'password' => '', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => 'InnoDB', 'unix_socket' => '', 'dump' => array('dump_binary_path' => 'C:\wamp64\bin\mysql\mysql8.0.18\bin', 'use_single_transaction', 'timeout' => 300), 'options' => array(), 'name' => 'mysql'))in ConnectionFactory.php line 183 at ConnectionFactory->Illuminate\Database\Connectors{closure}() at call_user_func(object(Closure))in Connection.php line 915 at Connection->getPdo()in Connection.php line 940 at Connection->getReadPdo()in Connection.php line 399 at Connection->getPdoForSelect(true)in Connection.php line 325 at Connection->Illuminate\Database{closure}('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'))in Connection.php line 657 at Connection->runQueryCallback('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'), object(Closure))in Connection.php line 624 at Connection->run('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'), object(Closure))in Connection.php line 333 at Connection->select('select from information_schema.tables where table_schema = ? and table_name = ?', array('assetmanagement', 'users'))in MySqlBuilder.php line 18 at MySqlBuilder->hasTable('users')in Facade.php line 221 at Facade::__callStatic('hasTable', array('users'))in Setting.php line 68 at Setting::setupCompleted()in CheckForSetup.php line 22 at CheckForSetup->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in TrustProxies.php line 57 at TrustProxies->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in NosniffGuard.php line 17 at NosniffGuard->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ContentSecurityPolicyHeader.php line 18 at ContentSecurityPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ReferrerPolicyHeader.php line 17 at ReferrerPolicyHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in XssProtectHeader.php line 18 at XssProtectHeader->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in FrameGuard.php line 17 at FrameGuard->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in StartSession.php line 63 at StartSession->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in CheckForMaintenanceMode.php line 46 at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in HandlePreflight.php line 29 at HandlePreflight->handle(object(Request), object(Closure))in Pipeline.php line 149 at Pipeline->Illuminate\Pipeline{closure}(object(Request))in Pipeline.php line 53 at Pipeline->Illuminate\Routing{closure}(object(Request))in Pipeline.php line 102 at Pipeline->then(object(Closure))in Kernel.php line 151 at Kernel->sendRequestThroughRouter(object(Request))in Kernel.php line 116 at Kernel->handle(object(Request))in index.php line 58

Please do not post an issue without answering the related questions above. If you have opened a different issue and already answered these questions, answer them again, once for every ticket. It will be next to impossible for us to help you.

https://snipe-it.readme.io/docs/getting-help

stale[bot] commented 4 years ago

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

abhijitrajkhowa27 commented 4 years ago

This is still relevant. Any input on this will be highly appreciated. @snipe

stale[bot] commented 4 years ago

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

GzaGator commented 4 years ago

I am having the same issue. Snipe-IT will not see my created users or my created databases, but if I put in root and a preconfigured db it will go to the preflight page. Otherwise I get the unknown database error.

stale[bot] commented 4 years ago

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

abhijitrajkhowa27 commented 4 years ago

This is still relevant

stale[bot] commented 4 years ago

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

abhishekshingadiya commented 4 years ago

I get this issue too I created DB but not working with 

try
{

    $dbh = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
}
catch (PDOException $e)
{
    exit("Error: " . $e->getMessage());
}
stale[bot] commented 4 years ago

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

abhijitrajkhowa27 commented 4 years ago

yes

stale[bot] commented 4 years ago

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

horlakay commented 3 years ago

pymysql would not see my database in wamp