where some-mysql is the name you want to assign to your container, my-secret-pw is the password to be set for the MySQL root user and tag is the tag specifying the MySQL version you want. Starting a MySQL instance is simple: $ docker run -name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag With its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications, covering the entire range from personal projects and websites, via e-commerce and information services, all the way to high profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more.įor more information and related downloads for MySQL Server and other MySQL products, please visit How to use this image Start a mysql server instance MySQL is the world's most popular open source database. Official-images repo's library/mysql file ( history) Official-images PRs with label library/mysql Repo-info repo's repos/mysql/ directory ( history) Supported tags and respective Dockerfile links Not sure what to do from here as I am pretty new to the whole Docker thing, and Xwiki as well.The Docker Community Forums, the Docker Community Slack, or Stack Overflow The xwiki container can resolve the DB server (I can see connection attempts in the Mariadb logs). The database parameters above are those needed to connect to the external DB server. mnt/data/xwiki/solr/data:/opt/solr/server/solr mnt/data/xwiki/solr:/docker-entrypoint-initdb.d The docker-compose.yml I used in Portainer stack deployment is: version: '2' I tried passing several ENV variables to the xwiki container (such as “TZ=America/Toronto”, “server.Timezone=America/Toronto”, etc…) and re-deploying the container, nothing worked. The MariaDB server is already configured with America/Toronto (and only xwiki complains about this so I know this is not an issue on the DB server). In the XWiki file inside the JDBC URL string as in jdbc:mysql://localhost:3306/myschema?serverTimezone=UTC.In the XWiki file in the property (e.g.According to the Xwiki MySQL Installation page: It seems that there is a mis-configuration regarding timezone for mariadb. Note The full stack trace of the root cause is available in the server logs. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.Ĭom.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'EDT' is unrecognized or represents more than one time zone. : The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.) : Cannot create PoolableConnectionFactory (The server time zone value 'EDT' is unrecognized or represents more than one time zone. There is an error in the Hibernate configuration file, please review it. ServiceException: Unable to create requested service Query statement = Ĭom.: Error number 3202 in 3: Exception while reading document : Exception while translating XWQL query to the language. WikiManagerException: Failed to locate XWiki.XWikiServerClass document for wiki alias : Failed to locate wiki descriptor for alias : : Error number 11007 in 0: Failed to extract Entity Resource Reference from URL Ĭom.: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL Message : Error number 11007 in 0: Failed to extract Entity Resource Reference from URL ĭescription The server encountered an unexpected condition that prevented it from fulfilling the request. The xwiki and solr containers were installed successfully, but when I try to access the XWiki web page it loads for a few seconds, then I get the following errors (truncated with only the Java error messages): HTTP Status 500 – Internal Server Error I followed the instructions of “ ” and used Portainer to deploy the “stack” with the exception of not including the “db” block which installs the MariaDB/MySQL container… (see docker-compose.yml below). I wish to use an external MariaDB server running on the same network as the VPS and not deploy a Mariadb/mysql container for performance reasons… I have decided to use Docker to install XWiki on a new VPS running Rocky Linux 8 (Centos 8 replacement).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |