Page 1 of 1

Trouble setup mysql - authrization denied

Posted: Fri Sep 29, 2017 10:24 am
by stuee
Hi all.,
Im struggling to get this working on my server.
I tried an existing database and got the error, then tried a new complete database and user and still the same.
Ive tried
localhost and also 127.0.0.1

not sure why it wont connect.
MYSQL is on the same server as this installation.

Re: Trouble setup mysql - authrization denied

Posted: Fri Sep 29, 2017 10:47 am
by Luc
Can you get access to your database with program phpMyAdmin with the same username and password you supplied in the main setup of meteotemplate?
Btw. localhost is ok for the server.

Re: Trouble setup mysql - authrization denied

Posted: Fri Sep 29, 2017 11:33 am
by stuee
yes phpmyadmin works with the details

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 1:20 am
by wxthomson
I am also having trouble entering a mysql in MT.

i can get to it through the hosts page and through phpMyAdmin but not from MT

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 1:26 am
by dmgould
Are you entering the exact database user name you setup and the password for that specific database? Then you can test the connection on your main setup page. The host should also give the exact address for the database.

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 4:42 am
by Luc
Could you check if your database user has the right privileges? It should have read and write access (may be more, I'll have to check).

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 9:18 am
by Jachym
There are usually 2 types of users, one has just read/write permissions and one can also create tables etc. You need the one with the full permissions.

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 2:32 pm
by Fraggboy
You want to look for a Global Privileges checkbox.
Screen Shot 2017-09-30 at 7.31.20 AM.png
Screen Shot 2017-09-30 at 7.31.20 AM.png (121.42 KiB) Viewed 24443 times

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 9:55 pm
by stuee
Everythings right with details.
Ive also tried using my wp database details and same problem?

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 10:29 pm
by stuee
This is my log file i just found. Seems TestMYSQL.php has an error line 5


[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1301
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: firstWeekday in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 2129
[29-Sep-2017 01:26:45 UTC] PHP Notice: Undefined variable: firstWeekday in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 2130
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1292
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: lang in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 1301
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: firstWeekday in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 2129
[29-Sep-2017 01:55:21 UTC] PHP Notice: Undefined variable: firstWeekday in /home13/cp891124/public_html/weather/meteo/install/setup.php on line 2130
[29-Sep-2017 06:37:06 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 06:38:33 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 06:39:01 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 06:39:12 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 06:43:16 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 06:50:47 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 07:07:07 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 12:32:20 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 12:32:30 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 12:32:39 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 12:32:59 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[29-Sep-2017 12:38:48 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/createConfig.php on line 35
[29-Sep-2017 22:39:31 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/createConfig.php on line 35

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 10:40 pm
by stuee
it looks like these are t he culprits and "USER" is the offender!

[30-Sep-2017 22:31:09 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/testMySQL.php on line 5
[30-Sep-2017 22:38:39 UTC] PHP Notice: Undefined index: user in /home13/cp891124/public_html/weather/meteo/install/createConfig.php on line 35

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 10:59 pm
by dmgould
Line 5 on testMySQL.php would mean the wrong MT user and return 'Unauthorized access' and then die when I look at my file. The file may have been changed some since I installed my MT. That would be a MT user problem not a database user problem and could cause you all kinds of issues.

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 11:37 pm
by stuee
fixed now.
I just wiped it all and uploaded a fresh install.
Put in same details and it worked? odd

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 11:37 pm
by stuee
thanks for everyones input :)

Re: Trouble setup mysql - authrization denied

Posted: Sat Sep 30, 2017 11:51 pm
by dmgould
Excellent news. Now things should be getting much easier for you.

Re: Trouble setup mysql - authrization denied

Posted: Sun Dec 03, 2017 5:20 pm
by MTQ
Hi,
I'm setting up MT for the first time. Now just with the setup.php...
And then trying to SAVE all the initial configuration it opens a new browser windows with the page "install/createConfig.php" and the text "Unauthorized access."

I've been re-writting all database credentials, server check, login with phpMyAdmin without any problem, etc.

I don't know anything else to do.

Anyone can help?
Thank you!

Re: Trouble setup mysql - authrization denied

Posted: Sun Dec 03, 2017 7:50 pm
by MTQ
Hi again,

I've tested with a simple php to connect and create a table inside this db and there is no problem at all...
I've changed several times the Username and Pass for that table, and it does not work with anyone.

Thank you!

Re: Trouble setup mysql - authrization denied

Posted: Sun Dec 03, 2017 8:45 pm
by Jachym
If you have the setup opened it should ALWAYS log you in. If it does not (shows unauthorized) it means your server is not properly handling sessions. This is something to check. Are you using external hosting or yours? Is it a free webhosting?

Re: Trouble setup mysql - authrization denied

Posted: Sun Dec 03, 2017 8:52 pm
by MTQ
Hi,

Is an external hosting where I've my domain and website.
Is there anything I can check about session handling?

I've been able to check the database and save the configuration. But event is saved and when I com back to the config all my config is there, if I open /template on my browser it shows the default template without even my station name, it just says "Meteotemplate".

Thank you!

Re: Trouble setup mysql - authrization denied

Posted: Sun Dec 03, 2017 8:55 pm
by Jachym
Was the config.php created on your server?

If yes, then it shows Meteotemplate because you didnt change the header title