1,977
edits
Changes
m
Import interlang links (links to translated versions of this page in other languages) from Multi Language Manager table.
Line 1:
Line 1:
+And with that we end this tutorial.+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<!-- BEGIN origin interlang links -->
+<!-- You can edit this section but do NOT remove these comments
+ Links below will be automatically replicated on translated pages by PolyglotBot -->
+[[es:Cloud_con_Redhat_OpenShift_Flex]]
+<!-- END interlang links -->
+
[[Category:Admin]]
[[Category:Admin]]
+[[Category:Admin_en]]
[[Category:Cloud]]
[[Category:Cloud]]
{{TemplateDocUser}}
{{TemplateDocUser}}
Line 29:
Line 36:
'''How Do Gears Work?'''<br />
'''How Do Gears Work?'''<br />
−Let's look at an example Drupal-based app running on OpenShift. We can estimate the needs and costs of the app at different stages.
+Let's look at an example Drupal-based app running on OpenShift. We can estimate the needs of the app at different stages.
*15 pages/second
*15 pages/second
Line 38:
Line 45:
As we see, a free plan, it may be sufficient for a small or medium company.
As we see, a free plan, it may be sufficient for a small or medium company.
+
For larger companies, you can switch to the next plan.
For larger companies, you can switch to the next plan.
+
In OpenShift, we have two possibilities, to launch Dolibarr.
In OpenShift, we have two possibilities, to launch Dolibarr.
−1 -. As developers, it gives us the ability to extend or create your own modules.<br />
+1 -. To extend or create your own modules.<br />
−2 -. As entrepreneurs, it gives us the opportunity to put into production our Dolibarr.
+2 -. To put in production our Dolibarr.
Line 149:
Line 158:
Hands to work.
Hands to work.
−We need a SSH / FTP client like WinSCP and PuTTY.
+We need a SSH / FTP client like [http://sourceforge.net/projects/winscp WinSCP] and PuTTY.
We download and install.
We download and install.
Line 419:
Line 428:
As a final step, we will see the connection from a local client database, to our remote MySQL.
As a final step, we will see the connection from a local client database, to our remote MySQL.
−For this example I will use HeidiSQL, which serves both MySQL or PostgreSQL database and is Free.
+For this example I will use [http://sourceforge.net/projects/heidisql HeidiSQL], which serves both MySQL or PostgreSQL database and is Free.
Open HeidiSQL.
Open HeidiSQL.
Line 437:
Line 446:
[[File:Settings_heidisql.JPG|500px]]
[[File:Settings_heidisql.JPG|500px]]
−We fill the fields with the credentials of the database, select the database, click in Save and click in Open to test the connection.
+We obtain the hostname and port of MySQL to connect to Dolibarr database. Top image 33.
+Fill the fields with the credentials of the database, select the database, click in Save and click in Open to test the connection.
Image 43<br />
Image 43<br />
[[File:HeidiSQL_has_established_connection.JPG|500px]]
[[File:HeidiSQL_has_established_connection.JPG|500px]]
−== Addendum ==
== Addendum ==
−=== Connection to MySQL gear ===
+=== Connection to MySQL Gear ===
+You remember when we obtained the hostname and port of MySQL to connect to Dolibarr database. Top image 33.
+Image 44<br />
+[[File:WinSCP_connect_MySQL_Gear.JPG|500px]]
+The first part of the Hostname: is also the Username:
+5364c670e0b8cd09f500036d-sdme.rhcloud.com click in Advanced and verify that everything be as the image 18.
+Click in Save and click in Login.
+With open WinSCP, go to the Options menu --> preferences --> Integration --> Applications as shown in the image below.
+In the PuTTY/terminal client path: field select the path where we have the putty.exe and mark the three checkboxes.
+Image 45<br />
+[[File:Preferences_winscp_run_putty.JPG|500px]]
+Each time you start in with WinSCP session also will start session in PuTTY. As seen in the image below.
+Image 46<br />
+[[File:Initialize_session_winscp_with_putty.JPG|500px]]
+Having PuTTY open and connected to the same session, allow us to execute command line statements to stop or start the MySQL server or Gear.
+Note -. Also in the remote part of WinSCP, we can navigate to folders as
+/var/lib/openshift/5364c670e0b8cd09f500036d/mysql/data/startdolibarr where this physically our database or we can go to /var/lib/openshift/5364c670e0b8cd09f500036d/app-root/logs to see MySQL logs.
+If we write help in the PuTTY window, will show some important commands.
+Among the common commands are:
+ctl_app<br />
+Control your application (MySQL)
+*ctl_app start
+*ctl_app stop
+*ctl_app restart
+*ctl_app status
+ctl_all<br />
+Similar to ctl_app but we can control the whole Gear.
+*ctl_all start
+*ctl_all stop
+*ctl_all restart
+*ctl_all status
+Cited here www.openshift.com/developers/remote-access where we find most useful commands.
+And with that we end this tutorial.