Access denied to database 'http'

I am getting the following errors when refreshing or switching pages inside my xwiki:

I am using Ubuntu 18.04.3 LTS
MySQL 5.7.28
xWiki 11.10
javas 1.8.0_231

2019-12-18 16:14:17,948 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:17,948 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:17,953 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:17,953 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:17,965 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:17,965 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:17,969 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:17,969 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:17,974 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:17,974 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:17,982 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:17,982 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:17,990 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:17,990 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,025 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,025 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,025 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,025 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,034 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,034 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,035 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,035 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,040 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,040 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,040 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,040 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,048 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,049 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,049 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,049 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,055 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,055 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,055 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,055 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,062 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,062 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,062 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,062 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,071 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,071 [mylocalxwikiserver:8080/xwiki/bin/ssx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:19,071 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:19,071 [mylocalxwikiserver:8080/xwiki/bin/jsx/XWiki/Notifications/Code/Macro/NotificationsMacro?language=de_DE&docVersion=1.1] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:20,396 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:20,396 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:20,409 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:20,409 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:20,411 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:20,411 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:20,414 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:20,414 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:20,421 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:20,421 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:20,424 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:20,424 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http' 
2019-12-18 16:14:20,429 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1044, SQLState: 42000 
2019-12-18 16:14:20,429 [mylocalxwikiserver:8080/xwiki/bin/view/EDV/Citrix/Citrix%20-%20Neighborhood%20-%20Einstellungen/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Access denied for user 'xwiki_user'@'localhost' to database 'http'

Now that I have granted access to such a database I get the following errors. Could anyone please help me?
Maybe there is a connection to the fact that the notification macro doesn’t work either.

2019-12-19 09:52:19,994 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1049, SQLState: 42000
2019-12-19 09:52:19,994 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown database 'http'
2019-12-19 09:52:20,000 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1049, SQLState: 42000
2019-12-19 09:52:20,000 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown database 'http'
2019-12-19 09:52:20,003 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1049, SQLState: 42000
2019-12-19 09:52:20,003 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown database 'http'
2019-12-19 09:52:20,009 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1049, SQLState: 42000
2019-12-19 09:52:20,010 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown database 'http'
2019-12-19 09:52:20,018 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1049, SQLState: 42000
2019-12-19 09:52:20,018 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown database 'http'
2019-12-19 09:52:20,024 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1049, SQLState: 42000
2019-12-19 09:52:20,025 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown database 'http'
2019-12-19 09:52:20,027 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1049, SQLState: 42000
2019-12-19 09:52:20,030 [mylocalwikiserver:8080/xwiki/bin/view/Main/XWikiNotificationsMacro.js] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown database 'http'

This is not a problem :slight_smile:

It just means that somewhere you’re putting a document reference to a subwiki named http in some markup content and it doesn’t exist.

You should paste your content here to get some help. But it’s not a problem.

That sounds good. Which content do you need to analyze this, since it is happening on each page I am browsing to, even if it is filled with no content?

Maybe you have created some panels or some UIX that are always displayed? Or you have a custom skin?

Maybe you’ve modified some Admin settings such as L&F > Presentation > HTTP META INFO?

The installation is a standard installation builded by the war-file. I didn’t change anything in the HTTP META INFO and used the recommended extensions only. I think the problem is inside the notifications-extension, because of the given informations. This is a UIX which is allways displayed in the upper menu. But I don’t know how to proof that.

Additionaly in every panel, like the users profile, I am getting the following information:

The “notifications” macro is not in the list of registered macros. Verify the spelling or contact your administrator.

I get the same errors in my log. Some processes want to write into a database called “http”, but i used the standard-deb-package xwiki-tomcat9-pgsql, so there is only a database called xwiki.

But i found out: I’ve changed the language to german (multilang-support off). If i change it back to english, the errors disappear. Back to german -> the errors will come back, too.

There are additional errors in syslogs (xwikidbversion does not exist, but it seems that all comes from the try to write into database http, e.g.: tomcat9[7809]: com.xpn.xwiki.store.migration.DataMigrationException: Unable to store new data version 1138000 into database http)

Please take a look at it - the errorlogs get full and the system is very slow because of this. Thanks!

The same on my site. My xwiki is in german language as well and I am now recognizing that the error occures since I have switched from english to german.

OK, sounds like a typo in one of the German translations files. In the meantime would be great to create an issue on https://jira.xwiki.org/browse/XWIKI explaining the step to reproduce it so that we debug it and find where exactly this is coming from.

Created https://jira.xwiki.org/browse/XWIKI-16939

Thanks !

Thanks for the quick fix of this issue. Now, when you know what the reason is: Can we safely work with the german version and just ignore the errors? Should we take care about something special?
Or should we wait for the next version (when will it be released) ?

Thanks,
Gerd

Definitely yes :slight_smile:

It’s just a bad syntax on one page. It won’t affect anything except filling your xwiki logs.

Yes, the only real consequence is a broken link on a panel on the right.

There is two possibilities if you are tired of all this log:

It’s planned today so it should not be long.

ok, thanks a lot for this information. I’ll wait for the next version :slight_smile: