search

nickfox / GpsTracker

Google Map Gps Cell Phone Tracker
https://www.websmithing.com/gps-tracker
MIT License
796 stars 581 forks source link

Can't access database #104

Open Helen300 opened 5 years ago

Helen300 commented 5 years ago

Hello, I'm a beginner programmer trying to set up the MySQL database with the php server, but I'm having trouble accessing the database. Whenever I go to http://localhost:8080/gpstracker/php/updatelocation.php

I get this error and I'm not sure how to debug this.

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'gpstracker_user'@'localhost' (using password: YES) in /opt/lampp/htdocs/gpstracker/php/dbconnect.php:24 Stack trace: #0 /opt/lampp/htdocs/gpstracker/php/dbconnect.php(24): PDO->__construct('mysql:host=loca...', 'gpstracker_user', 'gpstracker') #1 /opt/lampp/htdocs/gpstracker/php/updatelocation.php(2): include('/opt/lampp/htdo...') #2 {main} thrown in /opt/lampp/htdocs/gpstracker/php/dbconnect.php on line 24

coose2018 commented 4 years ago

I'm curious does it function yet?

brentfraser commented 4 years ago

I think Nick considers this project to be archived and he may not be monitoring it anymore, but I'll try to help.

The obvious question is can you access your database using the user name and password stored in dbconnect.php?

coose2018 commented 4 years ago

I didnt know I had a password anymore I haven't been there in so long and came across that project. I had to see if it was complete

On Mon., Jan. 27, 2020, 9:23 a.m. Brent Fraser, notifications@github.com wrote:

I think Nick considers this project to be archived and he may not be monitoring it anymore, but I'll try to help.

The obvious question is can you access your database using the user name and password stored in dbconnect.php?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/nickfox/GpsTracker/issues/104?email_source=notifications&email_token=AL7BMGGSFYI3JTXALCQ7OWLQ73U7LA5CNFSM4HZA23UKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJ7VQYY#issuecomment-578771043, or unsubscribe https://github.com/notifications/unsubscribe-auth/AL7BMGEFWCNDPMUTEC7KOPTQ73U7LANCNFSM4HZA23UA .

brentfraser commented 4 years ago

I'm confused. Does the "gpstracker_user" in your MySQL database have a password? Did you follow the instructions on https://www.websmithing.com/2014/01/20/quick-start-guide-for-gpstracker-3/ ?

coose2018 commented 4 years ago

Not that I'm aware of u mean the zip I grabbed I thought it was either finished or close to it. I think maybe i should bring it back i wasnt aware of a password that's not cool i can i opened it and well whatever it said was a good thing but it's one part to the bigger picture. I'm sorry dude

On Mon., Jan. 27, 2020, 1:28 p.m. Brent Fraser, notifications@github.com wrote:

I'm confused. Does the "gpstracker_user" in your MySQL database have a password? Did you follow the instructions on https://www.websmithing.com/2014/01/20/quick-start-guide-for-gpstracker-3/ ?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/nickfox/GpsTracker/issues/104?email_source=notifications&email_token=AL7BMGFCJAVMMZH3C2VEXHLQ74RTTA5CNFSM4HZA23UKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKARVUQ#issuecomment-578886354, or unsubscribe https://github.com/notifications/unsubscribe-auth/AL7BMGC7MM62H6M4LPZMIMLQ74RTTANCNFSM4HZA23UA .

coose2018 commented 4 years ago

Yes I followed the instructions but dont recall a password am I getting someone in trouble here I hope not I just got a zip file that I figured wasnt complete

On Mon., Jan. 27, 2020, 9:23 a.m. Brent Fraser, notifications@github.com wrote:

I think Nick considers this project to be archived and he may not be monitoring it anymore, but I'll try to help.

The obvious question is can you access your database using the user name and password stored in dbconnect.php?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/nickfox/GpsTracker/issues/104?email_source=notifications&email_token=AL7BMGGSFYI3JTXALCQ7OWLQ73U7LA5CNFSM4HZA23UKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJ7VQYY#issuecomment-578771043, or unsubscribe https://github.com/notifications/unsubscribe-auth/AL7BMGEFWCNDPMUTEC7KOPTQ73U7LANCNFSM4HZA23UA .

brentfraser commented 4 years ago

The zip file is fine. There are two parts to GPSTracker: one is the mobile phone app (you can install it from the Play Store). The other is the server code. You install it on your server by unzipping the zip file and configuring it by modifying the dbconnect.php file to point to your server.

The Quick Start Guide says you must create a username and password for your MySQL database. Did you do that?

coose2018 commented 4 years ago

No I didnt get the second part we so it does work why are u not doing this or do u have top secret going on lol

On Mon., Jan. 27, 2020, 2:08 p.m. Brent Fraser, notifications@github.com wrote:

The zip file is fine. There are two parts to GPSTracker: one is the mobile phone app (you can install it from the Play Store). The other is the server code. You install it on your server by unzipping the zip file and configuring it by modifying the dbconnect.php file to point to your server.

The Quick Start Guide says you must create a username and password for your MySQL database. Did you do that?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/nickfox/GpsTracker/issues/104?email_source=notifications&email_token=AL7BMGBMROMVT3GZZ3HOYITQ74WLVA5CNFSM4HZA23UKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKAV3XY#issuecomment-578903519, or unsubscribe https://github.com/notifications/unsubscribe-auth/AL7BMGGFJ6HCY75YDSF6YSTQ74WLVANCNFSM4HZA23UA .

coose2018 commented 4 years ago

So does it work or is that up to me to figure out the instructions are there all of it

On Mon., Jan. 27, 2020, 4:50 p.m. Daves not Here man, < wilsonmarcus290@gmail.com> wrote:

No I didnt get the second part we so it does work why are u not doing this or do u have top secret going on lol

On Mon., Jan. 27, 2020, 2:08 p.m. Brent Fraser, notifications@github.com wrote:

The zip file is fine. There are two parts to GPSTracker: one is the mobile phone app (you can install it from the Play Store). The other is the server code. You install it on your server by unzipping the zip file and configuring it by modifying the dbconnect.php file to point to your server.

The Quick Start Guide says you must create a username and password for your MySQL database. Did you do that?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/nickfox/GpsTracker/issues/104?email_source=notifications&email_token=AL7BMGBMROMVT3GZZ3HOYITQ74WLVA5CNFSM4HZA23UKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKAV3XY#issuecomment-578903519, or unsubscribe https://github.com/notifications/unsubscribe-auth/AL7BMGGFJ6HCY75YDSF6YSTQ74WLVANCNFSM4HZA23UA .

brentfraser commented 4 years ago

It works fine if you follow the instructions to set up your server.

coose2018 commented 4 years ago

Ok thank u very much that's to cool I appreciate all your help

On Tue., Jan. 28, 2020, 2:55 p.m. Brent Fraser, notifications@github.com wrote:

It works fine if you follow the instructions to set up your server.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/nickfox/GpsTracker/issues/104?email_source=notifications&email_token=AL7BMGDUXK2VUKPXXFQFCMLRACEU5A5CNFSM4HZA23UKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKEVSEA#issuecomment-579426576, or unsubscribe https://github.com/notifications/unsubscribe-auth/AL7BMGEURIEFVGFQYYJN3Y3RACEU5ANCNFSM4HZA23UA .