Run eloquent query from another local virtual host with curl or api

[mirbaagheri]

• Laravel Version: 5.5
• PHP Version: 7.1
• Database Driver & Version:5.7.19

Description:

I have 2 virtual host in my wamp server under Windows 10(X64).

Virtual-host1 and Virtual-host2. virtual-host1 pointed to www/virtual1 and virtual-host2 pointed to www/virtual2

both virtual host running with Laravel 5.5.

Virtual-host1 have a configured database: virtualhost1_database Virtual-host2 does not have any database, default is: homestead

I defined a resource route in Virtual-host1: /users in the store function i use Eloquent and get user list from virtualhost1_database.

I try to get the list of users with Postman and it works fine: URL: virtual-host1/users Method: POST

Now I wanna send a Curl request from Virtual-host2 to Virtual-host1 to get the list of users.

curl_setopt_array($curl, array( CURLOPT_HEADER => true, CURLOPT_URL => 'http://virtual-host1/users\', CURLOPT_POST => 1, ));

But I have the following error: Access denied for user 'homestead'@'localhost' (using password: YES) (SQL: select * from users where active=1

That means virtual-host1 wanna get query from virtual-host2 database!

Can someone help me?

Steps To Reproduce:

[Dylan-DPC-zz]

I don't think this is a bug. You can seek help at the forums or the slack channel

[sisve]

Two sites on Apache on Windows requires cached configurations. It's a known but non-documented problem. Run php artisan config:cache on both sites.

#20207
#19990
#19454
#13906
#8191
vlucas/phpdotenv#219 (comment)

ONLY use env inside your config files, and then you MUST use the cache command to setup the config files. Then there are ZERO env issues in production.

vlucas/phpdotenv#76 (comment)

[mirbaagheri]

Thank you @sisve
Solved 👍