id: dcde4c48343943d082a783aefaffd6fd
parent_id: 
item_type: 1
item_id: beb1786eb2ac4ab5a4883754b842751f
item_updated_time: 1764345590996
title_diff: "[{\"diffs\":[[1,\"jharkinsvtiger-docker\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":21}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>jharkins/vtiger-docker</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"20475\\\"></a>\\\r\\\n<h1>jharkins/vtiger-docker</h1>\\\r\\\n\\\r\\\n<div><span>\\\n  <div>\\\n<div><br/></div><div style=\\\"font-size: 16px; display:block; min-width: 100%;\\\"> <div style=\\\"background-color:transparent;font:inherit;vertical-align:baseline;\\\"><div style=\\\"background-color:transparent;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;font-size:16px;line-height:1.5em;color:rgb(31, 9, 9);text-align:left;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;z-index:200;padding-left:2em;padding-right:2em;margin-left:auto;margin-right:auto;position:relative;width:36em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;position:relative;margin-left:-25px;margin-right:25px;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;position:relative;padding-top:0px;padding-bottom:9em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;position:relative;margin-bottom:0px;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:0px;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:0px;\\\"><h1 style=\\\"border:0px;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;text-align:left;font-size:35px;font-weight:normal;line-height:35px;margin-bottom:20px;padding:0px;margin:0px;\\\">Vtiger CRM Docker</h1><div style=\\\"padding:0px;border:0px;font:inherit;vertical-align:baseline;position:relative;height:1em;line-height:1;text-align:center;padding-top:1.5em;padding-bottom:1.5em;margin:0px;margin-bottom:0px;\\\"><div style=\\\"padding:0px;border:0px;font:inherit;vertical-align:baseline;position:absolute;left:-4em;top:50%;z-index:10;width:100%;padding-left:4em;padding-right:4em;height:0.1em;opacity:0.5;background:-webkit-linear-gradient(0deg, rgb(243, 242, 238) 1%, rgb(31, 9, 9) 50%, rgb(243, 242, 238) 99%);margin:0px;margin-bottom:0px;\\\"><span style=\\\"font:inherit;position:absolute;left:-4em;top:50%;z-index:10;width:100%;padding-left:4em;padding-right:4em;height:0.1em;margin:0px;opacity:0.5;background:-webkit-linear-gradient(0deg, rgb(243, 242, 238) 1%, rgb(31, 9, 9) 50%, rgb(243, 242, 238) 99%);\\\"></span></div></div></div><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;\\\">\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">A Vtiger Docker setup - includes Out-of-the-box LAMP image (PHP+MySQL). Based on\\\nthe tutum-docker-lamp project <a href=\\\"https://index.docker.io/u/tutum/lamp/\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;color:rgb(6, 85, 136);text-decoration:none;\\\" target=\\\"_blank\\\">https://index.docker.io/u/tutum/lamp/</a></p>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">Uses the convention of <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">lamp/vtiger</code> for image name.</p>\\\n<h2 style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;text-align:left;font-weight:bold;font-size:30px;line-height:35px;margin-top:35px;margin-bottom:1.5em;\\\">Usage</h2>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">To create the image <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">lamp/vtiger</code>, execute the following command on the tutum-docker-lamp folder:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">docker build -t lamp/vtiger .\\\n</code></pre>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">You can now push your new image to the registry:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">docker push lamp/vtiger\\\n</code></pre>\\\n<h2 style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;text-align:left;font-weight:bold;font-size:30px;line-height:35px;margin-top:35px;margin-bottom:1.5em;\\\">Running your LAMP docker image</h2>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">Start your image binding the external ports 80 and 3306 in all interfaces to your container:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">docker run -d -p 80:80 -p 3306:3306 lamp/vtiger\\\ndocker run -d -p &lt;host port&gt;:&lt;container port&gt; -p &lt;host port&gt;:&lt;container port&gt;  lamp/vtiger\\\n</code></pre>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">Test your deployment by using a web browser: <a href=\\\"http://localhost/\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;color:rgb(6, 85, 136);text-decoration:none;\\\" target=\\\"_blank\\\">http://localhost</a>:/</p>\\\n<h2 style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;text-align:left;font-weight:bold;font-size:30px;line-height:35px;margin-top:35px;margin-bottom:1.5em;\\\">Connecting to the bundled MySQL server from within the container</h2>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">The bundled MySQL server has a <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">root</code> user with no password for local connections.\\\nSimply connect from your PHP code with this user:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">&lt;?php\\\n$mysql = new mysqli(&quot;localhost&quot;, &quot;root&quot;);\\\necho &quot;MySQL Server info: &quot;.$mysql-&gt;host_info;\\\n?&gt;\\\n</code></pre>\\\n<h2 style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;text-align:left;font-weight:bold;font-size:30px;line-height:35px;margin-top:35px;margin-bottom:1.5em;\\\">Connecting to the bundled MySQL server from outside the container</h2>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">The first time that you run your container, a new user <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">admin</code> with all privileges\\\nwill be created in MySQL with a random password. To get the password, check the logs\\\nof the container by running:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">docker logs $CONTAINER_ID\\\n</code></pre>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">You will see an output like the following:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">========================================================================\\\nYou can now connect to this MySQL Server using:\\\n\\\n    mysql -uadmin -p47nnf4FweaKu -h&lt;host&gt; -P&lt;port&gt;\\\n\\\nPlease remember to change the above password as soon as possible!\\\nMySQL user 'root' has no password but only allows local connections\\\n========================================================================\\\n</code></pre>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">In this case, <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">47nnf4FweaKu</code> is the password allocated to the <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">admin</code> user.</p>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">You can then connect to MySQL:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\"> mysql -uadmin -p47nnf4FweaKu\\\n</code></pre>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">Remember that the <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">root</code> user does not allow connections from outside the container -\\\nyou should use this <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">admin</code> user instead!</p>\\\n<h2 style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;text-align:left;font-weight:bold;font-size:30px;line-height:35px;margin-top:35px;margin-bottom:1.5em;\\\">Setting a specific password for the MySQL server admin account</h2>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">If you want to use a preset password instead of a random generated one, you can\\\nset the environment variable <code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;font-size:0.875em;line-height:1.71429em;\\\">MYSQL_PASS</code> to your specific password when running the container:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">docker run -d -p 80:80 -p 3306:3306 -e MYSQL_PASS=&quot;mypass&quot; tutum/lamp\\\n</code></pre>\\\n<p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">You can now test your new admin password:</p>\\\n<pre style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;background-color:rgb(243, 242, 238);font-family:Inconsolata;width:auto;font-size:0.875em;line-height:1.71429em;\\\"><code style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;font-family:Inconsolata;line-height:1.71429em;font-size:1.15em;\\\">mysql -uadmin -p&quot;mypass&quot;\\\n</code></pre>\\\n</div>\\\n      \\\n  </div></div></div><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;position:absolute;top:-1000px;left:-1000px;\\\">Measure</div><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;position:absolute;top:-1000px;left:-1000px;line-height:1;margin-bottom:0px;\\\">Measure</div></div></div></div></div></div></div></div>\\\n</div>\\\n</span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":13467}]"
metadata_diff: {"new":{"id":"beb1786eb2ac4ab5a4883754b842751f","parent_id":"f67288c3a0be4374b5d532b5dcc3aabc","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764348827247,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T21:04:03.106Z
created_time: 2025-11-28T21:04:03.106Z
type_: 13