Changes between Version 5 and Version 6 of InstallationGuidelines/PythonAnywhere

Timestamp:

08/05/19 05:24:30 (5 years ago)

Author:

rommelsotto

Comment:

--

InstallationGuidelines/PythonAnywhere

@@ -23 +23 @@
 15. You can now navigate to other tabs(or do other things) and the bash console will keep running as a separate thread. In order to kill the current console you can go to "Console" tab and kill the desired bash console from the list.
 
-'''Creating MySQL Database'''
+'''Creating Database'''
+
+[[BR]]
+MySQL
 1. In your pythonanywhere account go to Databases Tab
 2. Go to MySQL Tab
 3. Set the password for you MySQL connection then proceed
-3. In the Create Database portion enter the database name that you want, then click create.
-4 The details of you database will be shown once you have successfully created it.
+4. In the Create Database portion enter the database name that you want, then click create.
+5. The details of you database will be shown once you have successfully created it.
    Database host address : ''username.mysql.pythonanywhere-services.com''[[BR]]
    Database name : username$databasename
 
+[[BR]]
+Postgres (you would need to pay for this service)
+1. go to Database tab, then postgres
+2. create password for super
+3. go to postgres console
+4. Create Database
+        CREATE DATABASE name_of_database;
+        CREATE USER username WITH PASSWORD password
+
+
 '''Connecting your Database to Eden'''
+
+[[BR]]
+MySQL
 1. Proceed to the File Tab and navigate to your ''000_config.py'' file. if you didn't change the name in the setup it will be in /home/username/web2py/applications/eden/models
 2. Uncomment and edit the following lines[[BR]]settings.database.db_type = "mysql"[[BR]]settings.database.host = "''username.mysql.pythonanywhere-services.com''"[[BR]]settings.database.database = "''username$databasename''"[[BR]]settings.database.username = "''your pythonanywhere username''"[[BR]]settings.database.password = "''MySQL password you created''"
@@ -38 +54 @@
 4. Go back to your dashboard and proceed to Web Tab
 5. Click Reload and then proceed to accessing your Eden Site
+
+[[BR]]
+Postgres
+1. Proceed to the File Tab and navigate to your 000_config.py file. if you didn't change the name in the setup it will be in /home/username/web2py/applications/eden/models
+2.Uncomment and edit the following lines
+  settings.database.db_type = "postgres"
+  [[BR]]settings.database.host = "username-autonumber.postgres.pythonanywhere-services.com"
+  [[BR]]settings.database.username = "your database username"
+  [[BR]]settings.database.password = "password you created"
+3. Save it.
+4. Go back to your dashboard and proceed to Web Tab
+5. Click Reload and then proceed to accessing your Eden Site