# Xibo 1.8.1 DB Details

**URL:** https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496
**Category:** Get Help
**Created:** [June 20, 2017, 10:12am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496 "2017-06-20T10:12:49Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![mca.gaurav85](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/mca.gaurav85/32/4445_2.png) [@mca.gaurav85](https://community.xibo.org.uk/u/mca.gaurav85)
#### Post date: [June 20, 2017, 10:12am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/1 "2017-06-20T10:12:49Z")

</div>

Hello,

We have configured the xibo 1.8.1 on Linux with docker. Now i want to see the database details of the CMS.  
Kindly suggest from where i can get these details like Database name, User name, Password.

---

<div class="post-metadata">

### Author: ![Peter](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/peter/32/8154_2.png) [@Peter](https://community.xibo.org.uk/u/Peter)
#### Post date: [June 20, 2017, 10:42am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/2 "2017-06-20T10:42:35Z")

</div>

I believe it’s like that:

Database User - cms  
Password - as set in the config.env  
Database name - cms

---

<div class="post-metadata">

### Author: ![mca.gaurav85](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/mca.gaurav85/32/4445_2.png) [@mca.gaurav85](https://community.xibo.org.uk/u/mca.gaurav85)
#### Post date: [June 20, 2017, 11:15am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/3 "2017-06-20T11:15:37Z")

</div>

its not working for us. Also we are not able to locate any php file in the folder structure.

---

<div class="post-metadata">

### Author: ![Peter](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/peter/32/8154_2.png) [@Peter](https://community.xibo.org.uk/u/Peter)
#### Post date: [June 20, 2017, 11:24am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/4 "2017-06-20T11:24:30Z")

</div>

What is not working and how are you trying to access mysql database please?

---

<div class="post-metadata">

### Author: ![mca.gaurav85](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/mca.gaurav85/32/4445_2.png) [@mca.gaurav85](https://community.xibo.org.uk/u/mca.gaurav85)
#### Post date: [June 20, 2017, 11:25am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/5 "2017-06-20T11:25:50Z")

</div>

> [@Peter](#):
>
> hat is not working and how are you trying to access mysql database please?

We are trying to access the Database through MySQL Workbench.

---

<div class="post-metadata">

### Author: ![mca.gaurav85](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/mca.gaurav85/32/4445_2.png) [@mca.gaurav85](https://community.xibo.org.uk/u/mca.gaurav85)
#### Post date: [June 22, 2017, 9:07am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/6 "2017-06-22T09:07:31Z")

</div>

Hello,

We are not able to locate any php files in the folder structure created through the xibo1.8.1 installation. can you please share the folder path where we can locate php files.

I think, Page name is not showing due to URL rewrite code. so i am not able to get the path of the page.

---

<div class="post-metadata">

### Author: ![alex](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/alex/32/5782_2.png) [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [June 22, 2017, 1:49pm UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/7 "2017-06-22T13:49:22Z")

</div>

The PHP files are inside the containers. They aren’t supposed to be modified directly. Folders are provided for custom middleware and custom themes which should provide all the customisation you need.

Similarly, MySQL runs inside it’s own container, and isn’t exposed to the host machine by default.

If you want to connect to it, there’s an article here which explains how you can do so:

> [@How can I run a SQL command when using a Docker Install?](https://community.xibo.org.uk/t/how-can-i-run-a-sql-command-when-using-a-docker-install/9946/1):
>
> While troubleshooting an issue you maybe asked to run a SQL statement on your database Docker container, or you may want to run a statement yourself for another purpose. To do either of these things there are two options. Using the command line Using the GUI called PhpMyAdmin Command Line Before you can run a statement inside the docker container you will need to find the container name. This can be done using the docker ps command. The resulting output will show a list of running docker con…

---

<div class="post-metadata">

### Author: ![mca.gaurav85](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/mca.gaurav85/32/4445_2.png) [@mca.gaurav85](https://community.xibo.org.uk/u/mca.gaurav85)
#### Post date: [June 22, 2017, 5:04pm UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/8 "2017-06-22T17:04:46Z")

</div>

Thanks Alex. We are trying to connect the cms database that resides in the docker through MySQL workbench. Through workbench we are able to connect the system databases however not able to connect the xibo 1.8.1 database (cms). We are using the cms in docker environment.

kindly suggest…

---

<div class="post-metadata">

### Author: ![alex](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/alex/32/5782_2.png) [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [June 22, 2017, 5:19pm UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/9 "2017-06-22T17:19:09Z")

</div>

The database runs in its own container as I explained in my last reply.

You cannot connect to it from the host machine in its default  
configuration.

You need to adjust the docker-compose file to expose the database server  
container port to the host, and then you could connect to it with  
workbench.

Note however making direct changes to the database means we cannot offer  
you support for your installation. All modifications should take place via  
the CMS Web interface or via the API.

---

<div class="post-metadata">

### Author: ![mca.gaurav85](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/mca.gaurav85/32/4445_2.png) [@mca.gaurav85](https://community.xibo.org.uk/u/mca.gaurav85)
#### Post date: [June 27, 2017, 8:24am UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/10 "2017-06-27T08:24:16Z")

</div>

Currently we are using xibo 1.7.9 on Linux server as Ubuntu 12.04 (x64). Kindly suggest if upgradation from xibo 1.7.9 to xibo 1.8.1 through docker is possible on this os.

---

<div class="post-metadata">

### Author: ![alex](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/alex/32/5782_2.png) [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [June 29, 2017, 2:35pm UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/11 "2017-06-29T14:35:51Z")

</div>

Ubuntu 12.04 ended support a few months ago now. It no longer receives security upgrades, so I would strongly suggest you upgrade to at least Ubuntu 14.04.

Since 12.04 is no longer updated, Docker don’t build packages for it. You may be able to find packages for Docker on Ubuntu 12.04, but I suspect the kernel supplied is also too old. I think you’re going to be fighting an uphill battle if you go down that path.

---

<div class="post-metadata">

### Author: ![system](https://community.xibo.org.uk/uploads/default/original/2X/a/a8759c2d8cc561474733895ac75beeb830f5d8ca.png) [@system](https://community.xibo.org.uk/u/system)
#### Post date: [March 4, 2020, 5:07pm UTC](https://community.xibo.org.uk/t/xibo-1-8-1-db-details/10496/12 "2020-03-04T17:07:55Z")

</div>


