Trouble setup mysql - authrization denied

[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.

[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.

[stuee]

yes phpmyadmin works with the details

[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

[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.

[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).

[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.

[Fraggboy]

You want to look for a Global Privileges checkbox.

Screen Shot 2017-09-30 at 7.31.20 AM.png (121.42 KiB) Viewed 24425 times

[stuee]

Everythings right with details.
Ive also tried using my wp database details and same problem?

[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

[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

[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.

[stuee]

fixed now.
I just wiped it all and uploaded a fresh install.
Put in same details and it worked? odd

[stuee]

thanks for everyones input

[dmgould]

Excellent news. Now things should be getting much easier for you.

[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!

[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!

[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?

[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!

[Jachym]

Was the config.php created on your server?

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