20 Nov 2019 - TVDB Scraper v3.2.0 is now available which reinstates scraping. TVDB are still in the process of fixing a number of bugs so there may still be further breakages. See this post. 2901570 (post)

host not allowed connect with mariadb
#1
After setting up a new syn box i have troubles making database om mariadb on my syno
I get either this fault: unable to open database (Host xxx.xxx.x.xxx is not allowed to connect on this MariaDb server)
or user eric is not allowed .........
I've setup mariadb  5 and 10 same probs on both
Made user eric with pw advanced settings.xml same user and pw
made no db with name eric
How do i go from here?
Had it runnuing on my previous testbos with xpenology
Reply
#2
Did you grant the MySQL user the correct privs to be able to read/write to the database you're trying to create/use?

There are some more details on the wiki (MySQL (wiki)) which may help, although it's a little beyond Kodi itself hence the advanced/experimental tags.
|Banned add-ons (wiki) Forum rules (wiki)|VPN policy (wiki)|First time user (wiki)|FAQs (wiki) Troubleshooting (wiki)|Add-ons (wiki)|Free content (wiki)|Debug Log (wiki)|

My Blog Posts
Reply
#3
(2019-11-09, 09:52)DarrenHill Wrote: YDid you grant the MySQL user the correct privs to be able to read/write to the database you're trying to create/use?

There are some more details on the wiki (MySQL (wiki)) which may help, although it's a little beyond Kodi itself hence the advanced/experimental tags.

Yes i did give the user all privs to read and write with grant all
Reply
#4
(2019-11-09, 11:16)ikkeenjij36 Wrote: Yes i did give the user all privs to read and write with grant all

If you log into the mariadb server as that user and then do show grants; what does the output say ?

It should be something like this
MariaDB [(none)]> show grants;
+--------------------------------------------------------------------------------------------------------------+
| Grants for [email protected]%                                                                                            |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)


Sounds like you may have only granted privileges for that user on the local machine, instead of network wide.
Learning Linux the hard way !!
Reply
#5
(2019-11-09, 11:32)black_eagle Wrote:
(2019-11-09, 11:16)ikkeenjij36 Wrote: Yes i did give the user all privs to read and write with grant all

If you log into the mariadb server as that user and then do show grants; what does the output say ?

It should be something like this
MariaDB [(none)]> show grants;
+--------------------------------------------------------------------------------------------------------------+
| Grants for [email protected]%                                                                                            |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)


Sounds like you may have only granted privileges for that user on the local machine, instead of network wide.  

How do i do that?
by ssh or in the phpadmin ?
i made it on localhost ,or should i make it on any host? with %?
removed mariadb5 and 10 on syno
reinstalled mariadb 10
made a user eric grant all on %
now it connects to the maria db but it cant make a db on it now?
Reply
#6
(2019-11-09, 12:14)ikkeenjij36 Wrote: it cant make a db on it now?

What does the Kodi logfile say ? See Debug Log (wiki) for details on how to find and upload it somewhere.
Learning Linux the hard way !!
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
host not allowed connect with mariadb00