-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Going to IP/firefly-iii/public gives an Apache not found error #858
Comments
I think your database has been initialized before, so it can't remove the tables since they're already there. Perhaps a previous attempt only left half the tables. You could use a database manager such as phpmyadmin and clear out all the tables from the firefly database, then run the command again. To remove the questions, run it like this:
|
So I deleted the database and created a new one with the same name and the command you proposed. But still I can only see "not found" under firefly.halnet.cloud/firefly-iii/public... |
It says not found, have you checked this part of the guide, under Apache 2? https://firefly-iii.github.io/using-installing.html That might fix it. |
That's not a problem. Is mod_rewrite enabled?
Restart Apache afterwards. |
In case you still need help, here's a short tutorial: go to your firefly-iii public folder and run 'pwd'
copy the result into your apache2 sites-enabled default file. Mine is
restart apache |
Change the www-root to firefly-iii/public. Is index.php in the DirectoryIndex config entry? |
@TheGammelgalopper there are a few reasons why you would get that 404:
did you run these? make sure you update the commands to reflect your path
|
The .htaccess file must be readable by www-data (your apache daemon user) and mod-rewrite must be enabled, which by previous posts, is enabled |
if you ran the previous commands, there should not be any permission issues... If I may ask, do you have anything extremely private on your server? you could provide me some access, I could check everything for you |
I guess that would probably be the best... |
I'm putting my son to bed right now, give me a few minutes |
No worries, I am setting up the environment |
send me an email at [Dear NSA: I just removed it because I love my privacy] with your teamviewer id |
So that problem is solved! Thx to @gavu who was the best help! However a new problem occured...
|
DocumentRoot was set to The Now apache runs as expected, however... the above error occurred. I thought it would be because of a '/' character in his SMTP password, which I changed to a wrong one just to see if it changes anything, but no |
I'll have to look into it, but it's a sign not everything is working correctly yet. I had it too in a dev-environment but it was gone before I could look into it. Unfortunately, it won't be until Sunday or later next week that I can check it out. |
Thanks for looking into this! Somehow I just get all the errors... I tried a fresh install on Ubuntu 17.04 instead of on 16.04 and kind of got through the installation... in Connection.php (line 647) at Connection->runQueryCallback('select `id`, `name`, `data` from `configuration` where `name` = ? and `configuration`.`deleted_at` is null limit 1', array('is_demo_site'), object(Closure))in Connection.php (line 607) at Connection->run('select `id`, `name`, `data` from `configuration` where `name` = ? and `configuration`.`deleted_at` is null limit 1', array('is_demo_site'), object(Closure))in Connection.php (line 326) at Connection->select('select `id`, `name`, `data` from `configuration` where `name` = ? and `configuration`.`deleted_at` is null limit 1', array('is_demo_site'), true)in Builder.php (line 1705) at Builder->runSelect()in Builder.php (line 1690) at Builder->get(array('id', 'name', 'data'))in Builder.php (line 462) at Builder->getModels(array('id', 'name', 'data'))in Builder.php (line 446) at Builder->get(array('id', 'name', 'data'))in BuildsQueries.php (line 75) at Builder->first(array('id', 'name', 'data'))in FireflyConfig.php (line 57) at FireflyConfig->get('is_demo_site', false)in Facade.php (line 221) at Facade::__callStatic('get', array('is_demo_site', false))in Controller.php (line 60) at Controller->__construct()in HomeController.php (line 44) at HomeController->__construct() at ReflectionClass->newInstanceArgs(array())in Container.php (line 762) at Container->build('FireflyIII\\Http\\Controllers\\HomeController')in Container.php (line 608) at Container->resolve('FireflyIII\\Http\\Controllers\\HomeController')in Container.php (line 575) at Container->make('FireflyIII\\Http\\Controllers\\HomeController')in Application.php (line 728) at Application->make('FireflyIII\\Http\\Controllers\\HomeController')in Route.php (line 217) at Route->getController()in Route.php (line 747) at Route->controllerMiddleware()in Route.php (line 708) at Route->gatherMiddleware()in Router.php (line 585) at Router->gatherRouteMiddleware(object(Route))in Router.php (line 565) at Router->runRouteWithinStack(object(Route), object(Request))in Router.php (line 533) at Router->dispatchToRoute(object(Request))in Router.php (line 511) at Router->dispatch(object(Request))in Kernel.php (line 176) at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))in Pipeline.php (line 30) at Pipeline->Illuminate\Routing\{closure}(object(Request))in CheckForMaintenanceMode.php (line 46) at CheckForMaintenanceMode->handle(object(Request), object(Closure))in Pipeline.php (line 148) 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 57)
|
Try a |
You can't have gotten this far without php-mysql. The database migrations would have failed. |
True... |
Yeah that's the thing... |
wut a magical reboot fixed it.... :D I will still keep the 16.04 installation. So if @JC5 wants to have a look at that problem he can. But the priority to this just changed to very low as the 17.04 installation works fine. Thank you all for helping me with this! It is truly awesome software! |
Glad to hear everything works again. Let me know if you run into issues! @gavu, thanks for helping him out! 👍 |
Hey guys,
I really want to use this programm, but I just can't figure it out...
I am now sitting here and finished after 2 hours but can't get it to show up...
I followed the installation guide and have a working LAMP stack.
php -i says this:
`
phpinfo()
PHP Version => 7.1.9-1+ubuntu16.04.1+deb.sury.org+1
System => Linux firefly 4.4.0-87-generic #110-Ubuntu SMP Tue Jul 18 12:55:35 UTC 2017 x86_64
Build Date => Sep 2 2017 05:56:43
`
composer -v
Composer version 1.5.2 2017-09-11 16:59:25
My .env file:
`APP_ENV=production
APP_DEBUG=true
APP_FORCE_SSL=false
APP_FORCE_ROOT=firefly.halnet.cloud
APP_KEY=base64:zhugMsHeZtjl1WETzyKDyYQw02vWtHKG4fVK03WJu0o=
APP_LOG=daily
APP_LOG_LEVEL=debug
APP_URL=http://localhost
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=firefly
DB_USERNAME=firefly
DB_PASSWORD=firefly
BROADCAST_DRIVER=log
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
COOKIE_PATH="/"
COOKIE_DOMAIN=
COOKIE_SECURE=false
REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379
MAIL_DRIVER=smtp
MAIL_HOST=imap.gmail.com
MAIL_PORT=993
MAIL_FROM=xyz@gmail.com
MAIL_USERNAME=xyz@gmail.com
MAIL_PASSWORD=xyz'spassword
MAIL_ENCRYPTION=true
SEND_REGISTRATION_MAIL=true
SEND_ERROR_MESSAGE=true
SHOW_INCOMPLETE_TRANSLATIONS=false
CACHE_PREFIX=firefly
EXCHANGE_RATE_SERVICE=fixerio
GOOGLE_MAPS_API_KEY=
ANALYTICS_ID=
SITE_OWNER=xyz@gmail.com
USE_ENCRYPTION=true
PUSHER_KEY=
PUSHER_SECRET=
PUSHER_APP_ID=
DEMO_USERNAME=
DEMO_PASSWORD=
`
And then lastly, this command (sudo php artisan migrate:refresh --seed) gives me this:
`**************************************
Do you really wish to run this command? (yes/no) [no]:
going through everything with yes results in this:
**************************************Do you really wish to run this command? (yes/no) [no]:
Do you really wish to run this command? (yes/no) [no]:
[Illuminate\Database\QueryException]
SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constr
aint fails (SQL: drop table
users
)[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constr
aint fails
[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constr
aint fails
`
I have no clue what is going on, this seems to be some kind of database error, but I have no idea what to do. I just wanted to install a programm and not get a degree in computer science...
For today that's it, I am going to sleep, see you in the morning.
I hope somebody is able to help me!
The text was updated successfully, but these errors were encountered: