I've recently installed homestead and am definitely a beginner at this. With that said, I've installed Homestead as per the 5.2 tutorial, installed Laravel, and have begun to follow the tutorials. Everything has been going well until I get to the part where I am switching the database to sqlite3 and doing a migration. I have been stuck there. I'll explain the circumstances as detailed as possible.
I'm using Windows 8. I've installed homestead. homestead is installed in C:\Users\Joe. My Laravel folder is in C:\laravel\Sites The current site I'm working on is in C:\laravel\Sites\test\
I've modified the .env, DB_DATABASE to; "DB_DATABASE=storage/database.sqlite".
Inside the Homestead.yaml file, I've modified the database to storage/database.sqlite.
I've opened git bash inside C:\laravel\Sites\test I used the "touch storage/database.sqlite" command.
Joe@JOEALAI /C/laravel/Sites/test $ touch storage/database.sqlite $
Then I use the
php artisan migrate
command inside git bash and it tells me:
Joe@JOEALAI /C/laravel/Sites/test $ php artisan migrate Migrated: 2014_1012000000_create_users_table Migrated: 2014_10_12_100000_create_password_resets_table $
Therefore I know that it's being created. I've also checked the file inside the storage/ folder, and database.sqlite
Now, the next part is to type "sqlite3" into the same git bash that I just used to do that migration, and it says the following:
Joe@JOEALAI /C/laravel/Sites/test $ sqlite3 sh: sqlite3: command not found $
So what I've done next is gone into homestead and typed in sqlite3, and I actually get a response:
vagrant@homestead:~$ sqlite3
SQLite version 3.8.2 2013-12-06 14:53:30 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>
Next I've done what he said and types in .tables. It gives me the following:
sqlite> .tables sqlite>
Nothing happens.
Next I type in .databases and this is the response I get.
sqlite> .databases seq name file
0 main
sqlite>
so I hit ctrl+z, and then type in:
vagrant@homestead:~$ sqlite3 storage/database.sqlite
It then says:
SQLite version 3.8.2 2013-12-06 14:53:30 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>
I then type in: .tables and it says
Error: unable to open database "storage/database.sqlite": unable to open database file
I repeat the same thing with .databases
Same error.
What am I missing? I'm racking my brain on this. I've been stuck here for over an entire week. First I tried using WAMP, and I got the same problem except never had ANY response because I didn't have homestead installed. Now I have installed homestead and am using it, and it's still not working.
I thought maybe I had to do ALL of these commands within the vagrant box. I've gone into homestead vagrant box and tried to do a
php artisan migrate
command and it tells me
vagrant@homestead:~$ php artisan migrate Could not open input file: artisan vagrant@homestead:
Just for arguments sakes, I'll provide some of the data in my configuration files
DB_CONNECTION=sqlite DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=storage/database.sqlite DB_USERNAME=homestead DB_PASSWORD=secret
My Homestead.yaml file:
ip: "192.168.10.10" memory: 2048 cpus: 1 provider: virtualbox
authorize: ~/.ssh/id_rsa.pub
keys: - ~/.ssh/id_rsa
folders: - map: C:/laravel/Sites to: /home/vagrant/Sites
sites: - map: lol.app to: /home/vagrant/Sites/test/public
databases: - database
database.php
'default' => env('DB_CONNECTION', 'sqlite'),
'sqlite' => [ 'driver' => 'sqlite', 'database' => env('DB_DATABASE', database_path('database.sqlite')), 'prefix' => '', ],
If anyone can please help me figure out how to get this set up, I'd greatly appreciate it. If you need any more information I'd be happy to supply it.
Thank you!
