[DOCKER] Pydio


Recommended Posts

In the mySQL container; I have created a username and database.

 

My mySQL docker is running with the following xml:

 


....
....
</Description>
  <Registry>https://registry.hub.docker.com/_/mysql/</Registry>
  <Repository>mysql</Repository>
  <BindTime>true</BindTime>
  <Privileged>false</Privileged>
  <Environment>
    <Variable>
      <Name>MYSQL_ROOT_PASSWORD</Name>
      <Value>(A chosen root password)</Value>
    </Variable>
    <Variable>
      <Name>MYSQL_DATABASE</Name>
      <Value>d_mysql</Value>
    </Variable>
    <Variable>
      <Name>MYSQL_USER</Name>
      <Value>d_mysql_user</Value>
    </Variable>
    <Variable>
      <Name>MYSQL_PASSWORD</Name>
      <Value>(Some Password)</Value>
    </Variable>
  </Environment>
...
...

 

I've also created the user d_mysql in unraid itself...

 

 

When you said 'database', did you mean I needed to explicitly create a table in the database first?

 

i'm not familiar with that container, what ip address are you using in the pydio setup interface to connect with it ?

 

I thought it would be as simple as using localhost or 127.0.0.1 with the port number appended (3306); since both docker images are running on the unraid server.

 

Link to comment
  • Replies 61
  • Created
  • Last Reply

Top Posters In This Topic

In the mySQL container; I have created a username and database.

 

My mySQL docker is running with the following xml:

 


....
....
</Description>
  <Registry>https://registry.hub.docker.com/_/mysql/</Registry>
  <Repository>mysql</Repository>
  <BindTime>true</BindTime>
  <Privileged>false</Privileged>
  <Environment>
    <Variable>
      <Name>MYSQL_ROOT_PASSWORD</Name>
      <Value>(A chosen root password)</Value>
    </Variable>
    <Variable>
      <Name>MYSQL_DATABASE</Name>
      <Value>d_mysql</Value>
    </Variable>
    <Variable>
      <Name>MYSQL_USER</Name>
      <Value>d_mysql_user</Value>
    </Variable>
    <Variable>
      <Name>MYSQL_PASSWORD</Name>
      <Value>(Some Password)</Value>
    </Variable>
  </Environment>
...
...

 

I've also created the user d_mysql in unraid itself...

 

 

When you said 'database', did you mean I needed to explicitly create a table in the database first?

 

i'm not familiar with that container, what ip address are you using in the pydio setup interface to connect with it ?

 

I thought it would be as simple as using localhost or 127.0.0.1 with the port number appended (3306); since both docker images are running on the unraid server.

 

nope, you have to use the unraid server's IP.

 

localhost to a container is anything within that SPECIFIC container only.

Link to comment

The LAN IP should be ok right? We don't need to port forward and use the WAN IP (or what the Inet sees from the router, correct?)

 

If so; I'm getting this error. It is strange because I can connect to the DB with the same credentials via my Windows PC with MySQL Workbench.

 

Not sure where Pydio is getting that IP from though (see attachment):

connection_issue.jpg.a1401dfa7affec38f3b4ed9badc1e0d0.jpg

Link to comment

Also if it helps; this is what I found on official mysql site; they are the ones providing this official mysql docker image:

 

Source (https://registry.hub.docker.com/_/mysql/)

Connect to MySQL from an application in another Docker container

 

This image exposes the standard MySQL port (3306), so container linking makes the MySQL instance available to other application containers. Start your application container like this in order to link it to the MySQL container:

 

docker run --name some-app --link some-mysql:mysql -d app-that-uses-mysql

Link to comment

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE USER 'pydio' IDENTIFIED BY 'pydio';
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> create database pydio;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> GRANT ALL ON *.* TO 'pydio';
Query OK, 0 rows affected (0.00 sec)

 

0GWizQK.png

Link to comment
  • 2 months later...
  • 3 months later...

i have this installed and working great, and i access it from the web and the mobile app with no problems. However, i can't seem to perform actions of my files and folders if they were created by another docker, for example - stuff downloaded by Transmission and placed in the Downloads/Complete folder.

If i create a folder manually from a windows share i am able to do everything to it, but folders created by Transmission have the move/rename/delete buttons grayed out.

 

I never played with permissions on my server, and all my dockers are installed using the default settings.

Any suggestions?

 

Thanks

Link to comment
  • 10 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.