admin password: unable to login

[aponzar]

Thanks for reaching out! We're happy to help resolve issues as quickly as possible.

Please use this template when creating a new issue. If you do not follow this template format, your issue may be closed without comment.

Before filing a new issue, please use the search bar at the top of the browser to search for similar issues. Also, please make sure you have read our documentation, which covers how to use Gophish.

What version of Gophish are you using?: 0.4.0

Brief description of the issue: Fresh installation and I am not able to login with admin/gophish

What are you expecting to see happen? : I expect to see the :3333 admin portal

What are you seeing happen? error: invalid username/password

If this question is related to email templates or landing pages not working as expected, please provide your template or landing page below:

Insert code here

Please provide any terminal output that may be relevant below: I attempted to run "sqlite3 gophish.db 'update users set hash="$2a$10$IYkPp0.QsM81lYYPrQx6W.U6oQGw7wMpozrKhKAHUBVL4mkm/EvAS" where username="admin";'" but receive the following: no such table: users

Insert output here

Please provide as many steps as you can to reproduce the problem:

• Step 1 - Attempt to login
• Step 2 -

[jordan-wright]

What do you see in the terminal when you start Gophish?

[aponzar]

Here is what I see in the terminal: [cid:image001.png@01D3DDAE.4E1B8230] Adam Ponzar | Service Director Computer St. Louis | 314.821.3237 aponzar@computerstlouis.com<mailto:aponzar@computerstlouis.com> Managed IT Services<http://www.computerstlouis.com/services/managed-it-services/> - Networks<http://www.computerstlouis.com/service/it-solutions/> - Cloud<http://www.computerstlouis.com/services/cloud-computing/> - VoIP<http://www.computerstlouis.com/services/voip-solutions/> From: Jordan Wright <notifications@github.com> Sent: Thursday, April 26, 2018 9:50 PM To: gophish/gophish <gophish@noreply.github.com> Cc: Adam C. Ponzar <APonzar@computerstlouis.com>; Author <author@noreply.github.com> Subject: Re: [gophish/gophish] admin password: unable to login (#1052) What do you see in the terminal when you start Gophish? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#1052 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/Ak-GzCxM1q-qBQqMCkCWxXV7T9Jb-rLcks5tsodugaJpZM4Tm7-t>.

[aponzar]

Is this permission related? I added in a user gophish per the setup guide I found here: https://medium.com/@immure/setting-up-gophish-on-aws-c2f2fd78b7e9 Adam Ponzar | Service Director Computer St. Louis | 314.821.3237 aponzar@computerstlouis.com<mailto:aponzar@computerstlouis.com> Managed IT Services<http://www.computerstlouis.com/services/managed-it-services/> - Networks<http://www.computerstlouis.com/service/it-solutions/> - Cloud<http://www.computerstlouis.com/services/cloud-computing/> - VoIP<http://www.computerstlouis.com/services/voip-solutions/> From: Adam C. Ponzar Sent: Thursday, April 26, 2018 10:31 PM To: 'gophish/gophish' <reply@reply.github.com>; gophish/gophish <gophish@noreply.github.com> Cc: Author <author@noreply.github.com> Subject: RE: [gophish/gophish] admin password: unable to login (#1052) Here is what I see in the terminal: [cid:image001.png@01D3DDAE.AEF3FD30] Adam Ponzar | Service Director Computer St. Louis | 314.821.3237 aponzar@computerstlouis.com<mailto:aponzar@computerstlouis.com> Managed IT Services<http://www.computerstlouis.com/services/managed-it-services/> - Networks<http://www.computerstlouis.com/service/it-solutions/> - Cloud<http://www.computerstlouis.com/services/cloud-computing/> - VoIP<http://www.computerstlouis.com/services/voip-solutions/> From: Jordan Wright <notifications@github.com<mailto:notifications@github.com>> Sent: Thursday, April 26, 2018 9:50 PM To: gophish/gophish <gophish@noreply.github.com<mailto:gophish@noreply.github.com>> Cc: Adam C. Ponzar <APonzar@computerstlouis.com<mailto:APonzar@computerstlouis.com>>; Author <author@noreply.github.com<mailto:author@noreply.github.com>> Subject: Re: [gophish/gophish] admin password: unable to login (#1052) What do you see in the terminal when you start Gophish? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#1052 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/Ak-GzCxM1q-qBQqMCkCWxXV7T9Jb-rLcks5tsodugaJpZM4Tm7-t>.

[jordan-wright]

Hey there! I'm afraid it looks like the image didn't upload correctly. Could you give it another shot (or upload it to something like imgur) and we can take a look?

[aponzar]

Sorry about that, here you go: https://i.imgur.com/XUM9FqW.png When I run systemctl status gophish, It notes: unable to open database file. Adam Ponzar | Service Director Computer St. Louis | 314.821.3237 aponzar@computerstlouis.com<mailto:aponzar@computerstlouis.com> Managed IT Services<http://www.computerstlouis.com/services/managed-it-services/> - Networks<http://www.computerstlouis.com/service/it-solutions/> - Cloud<http://www.computerstlouis.com/services/cloud-computing/> - VoIP<http://www.computerstlouis.com/services/voip-solutions/> From: Jordan Wright <notifications@github.com> Sent: Monday, April 30, 2018 8:12 PM To: gophish/gophish <gophish@noreply.github.com> Cc: Adam C. Ponzar <APonzar@computerstlouis.com>; Author <author@noreply.github.com> Subject: Re: [gophish/gophish] admin password: unable to login (#1052) Hey there! I'm afraid it looks like the image didn't upload correctly. Could you give it another shot (or upload it to something like imgur) and we can take a look? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#1052 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/Ak-GzKOrc-MJ0rKHFGcOwTPnuAsJk6rZks5tt7ZPgaJpZM4Tm7-t>.

[aponzar]

https://i.imgur.com/zwxdpth.png One more with a little more detail. Adam Ponzar | Service Director Computer St. Louis | 314.821.3237 aponzar@computerstlouis.com<mailto:aponzar@computerstlouis.com> Managed IT Services<http://www.computerstlouis.com/services/managed-it-services/> - Networks<http://www.computerstlouis.com/service/it-solutions/> - Cloud<http://www.computerstlouis.com/services/cloud-computing/> - VoIP<http://www.computerstlouis.com/services/voip-solutions/> From: Jordan Wright <notifications@github.com> Sent: Monday, April 30, 2018 8:12 PM To: gophish/gophish <gophish@noreply.github.com> Cc: Adam C. Ponzar <APonzar@computerstlouis.com>; Author <author@noreply.github.com> Subject: Re: [gophish/gophish] admin password: unable to login (#1052) Hey there! I'm afraid it looks like the image didn't upload correctly. Could you give it another shot (or upload it to something like imgur) and we can take a look? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#1052 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/Ak-GzKOrc-MJ0rKHFGcOwTPnuAsJk6rZks5tt7ZPgaJpZM4Tm7-t>.

[jordan-wright]

Hmm... it seems that the connection to the database isn't staying open. I'm not sure if that's related to Gophish being run as a service or not.

Are you using MySQL or SQLite? It's possible that if you're using MySQL that there is some kind of connection failure happening, so I'd verify that the db url you're using is correct (credentials, port, ip, etc.).

[jordan-wright]

Since there hasn't been any updates to this issue in a while, I'm going to go ahead and close it out. @aponzar let us know if you are still running into issues and we can continue troubleshooting.

Thanks again for getting in touch!

[aponzar]

Thanks you. I ended up just reloading and it was fine. Adam Ponzar Computer St. Louis Service Director 314.821.3237 sent from a very tiny keyboard ;-) On Sat, Jun 9, 2018 at 2:26 PM -0500, "Jordan Wright" <notifications@github.com<mailto:notifications@github.com>> wrote: Since there hasn't been any updates to this issue in a while, I'm going to go ahead and close it out. @aponzar<https://github.com/aponzar> let us know if you are still running into issues and we can continue troubleshooting. Thanks again for getting in touch! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#1052 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/Ak-GzFfTSUBgph4ETFChebR9Ztb_tGJFks5t7CF3gaJpZM4Tm7-t>.