Categories
Mastering Development

Mysql Port 3308 is not getting connected with 127.0.0.1:8000 laravel 6* in wamp 3.2

This is my .env file with required changes APP_NAME=Laravel APP_ENV=local APP_KEY=base64:NReElKvDMYvjmIci0h3E9fsvWssYhz0Ld/jeuqWNlCc= APP_DEBUG=true APP_URL=http://localhost LOG_CHANNEL=stack DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3308 DB_DATABASE=studmgmt DB_USERNAME=root DB_PASSWORD= BROADCAST_DRIVER=log CACHE_DRIVER=file QUEUE_CONNECTION=sync SESSION_DRIVER=file SESSION_LIFETIME=120 REDIS_HOST=127.0.0.1 REDIS_PASSWORD=null REDIS_PORT=6379 MAIL_MAILER=smtp MAIL_HOST=smtp.mailtrap.io MAIL_PORT=2525 MAIL_USERNAME=null MAIL_PASSWORD=null MAIL_ENCRYPTION=null MAIL_FROM_ADDRESS=null MAIL_FROM_NAME=”${APP_NAME}” AWS_ACCESS_KEY_ID= AWS_SECRET_ACCESS_KEY= AWS_DEFAULT_REGION=us-east-1 AWS_BUCKET= PUSHER_APP_ID= PUSHER_APP_KEY= PUSHER_APP_SECRET= PUSHER_APP_CLUSTER=mt1 MIX_PUSHER_APP_KEY=”${PUSHER_APP_KEY}” MIX_PUSHER_APP_CLUSTER=”${PUSHER_APP_CLUSTER}” This is my database.php file <?php use Illuminate\Support\Str; return […]

Categories
Mastering Development

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘laravel.users’ doesn’t exist

I want to use the login implemented by default by laravel. My database isn’t called “laravel” and I don’t want to call it in that way, is there a way to do that and still make it work? By default it asks for the “laravel” database which of course doesn’t exist cause I called my […]

Categories
Development

Laravel not fetching result from mongodb

I have a json file called “University.json” which contains only one row of records. {“University”: [{“fees”: “$200”}, {“month”: “June”}]} Now I have used mongo import to insert the above *.json file into MongoDb. mongoimport –db university –collection finance –file University.json My Mongo database/collection values are : university/finance To show the values on view blade from […]

Categories
Database Development Laravel

New version of Laravel project using old versions database

I’m trying to make an API using Laravel, but I’ve run in to a problem. I’ve started a second version of the project, but even though I’ve changed the database to a second version database, it’s still trying to take from the first versions database. Version 1 database is APITest, version 2 database is APITest2 […]

Categories
Database Development Laravel

hello guys am new to laravel testing and am getting no test execute i am using laravel 6.0 i have created database.sqlite if anybody has a clue please

this is my config/database will be if i can get prompt reply ‘connections’ => [ ‘sqlite’ => [ ‘driver’ => ‘sqlite’, ‘url’ => env(‘DATABASE_URL’), ‘database’ => env(‘DB_DATABASE’, database_path(‘database.sqlite’)), ‘prefix’ => ”, ‘foreign_key_constraints’ => env(‘DB_FOREIGN_KEYS’, true), ] …this is the phpunit.ml….. <testsuite name=”Feature”> <directory suffix=”Test.php”>./tests/Feature</directory> </testsuite> </testsuites> <filter> <whitelist processUncoveredFilesFromWhitelist=”true”> <directory suffix=”.php”>./app</directory> </whitelist> </filter> <php> <server […]

Categories
Development Drivers Laravel MySQL

I’m trying to use laravel and I keep getting PDO exception error since it cant find my driver [duplicate]

This question already has an answer here: Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL) 10 answers I’m trying to connect my database to laravel and nothing seems to work. !https://imgur.com/cbPWU20 no matter what i always get the PDO exception error I already removed the semicolons for extension=php_pdo_pgsql.dll and extension=php_pgsql.dll, […]

Categories
Database Development Laravel

Laravel connect database to another server by SSH [duplicate]

This question already has an answer here: Connect to a MySQL server over SSH in PHP 6 answers I have connected to the server successfully ssh -i ~/.ssh/BaltimoreCyberTrustRoot.crt.pem user@16.17.131.26 How to config my app Laravel to connect database to another server? ‘mysql’ => [ ‘driver’ => ‘mysql’, ‘url’ => env(‘DATABASE_URL’), ‘host’ => env(‘DB_HOST’, ‘127.0.0.1’), ‘port’ […]