Showing posts with label bitnami. Show all posts
Showing posts with label bitnami. Show all posts
This requires Apache Mysql stack - here making use of bitnami wamp stack 

  •  Copy webzash-v2.8.zip in the htdoc folder
C:\Bitnami\wampstack-7.2.22-0\apache2\htdocs

  • Extract the zip file which will have the folder name cakephp-2.10.14
    Rename it as webzashtest2(its your prerogative)
  • In the web browser access the locally hosted site  -
    http://127.0.0.1:81/webzashtest2
    
    which will return the following error/page
\app\Plugin\Webzash\Config\bootstrap.php (line 337)

'Missing master sqlite database file. Please check your setup.'

Webzash
 Errors
Missing Database Connection

Error: A Database connection using "Sqlite" was missing or unable to connect.
The database server returned this error: Selected driver is not enabled

Error: Sqlite driver is NOT enabled

Notice: If you want to customize this error message, create app\View\Errors\missing_connection.ctp



  • Here master scheme database is not present/configured in the mysql database.
Log in phpmyadmin page


Create database webzashtest2db

Import MasterSchema.MySQL.sql to populate webzashtest2db
MasterSchema.MySQL.sql is present in
C:\Bitnami\wampstack-7.2.22-0\apache2\htdocs\webzashtest2\app\Plugin\Webzash\Config






Edit MasterConfig.php
C:\Bitnami\wampstack-7.2.22-0\apache2\htdocs\webzashtest2\app\Plugin\Webzash\Config
and database.php
C:\Bitnami\wampstack-7.2.22-0\apache2\htdocs\webzashtest2\app\Config
with
$ diff -uNr MasterConfig.php ../../../../../webzashtest2/app/Plugin/Webzash/Config/MasterConfig.php > patchfile
--- MasterConfig.php 2019-01-15 18:22:28.000000000 +1100
+++ ../../../../../webzashtest2/app/Plugin/Webzash/Config/MasterConfig.php 2019-10-14 21:08:17.892756900 +1100
@@ -55,8 +55,13 @@
  * $wz['settings'] = ''; // Optional parameter
  */
 
-$wz['datasource'] = 'Database/Sqlite';
-$wz['database'] = $root_path . 'Database/' . 'webzash.sqlite';
+$wz['datasource'] = 'Database/Mysql';
+/*$wz['database'] = $root_path . 'Database/' . 'webzash.sqlite';*/
+$wz['database'] = 'webzashtest2db';
+$wz['host'] = '127.0.0.1';
+$wz['port'] = '3307';
+$wz['login'] = 'root';
+$wz['password'] = 'r12348';
 $wz['prefix'] = '';
 $wz['encoding'] = 'utf8';
 $wz['persistent'] = false;

and
$ diff -uNr database.php ../../../webzashtest2/app/Config/database.php > patchfile
--- database.php 2017-07-23 05:06:53.000000000 +1000
+++ ../../../webzashtest2/app/Config/database.php 2019-10-14 21:06:18.293559900 +1100
@@ -69,10 +69,11 @@
  public $default = array(
   'datasource' => 'Database/Mysql',
   'persistent' => false,
-  'host' => 'localhost',
-  'login' => 'user',
-  'password' => 'password',
-  'database' => 'database_name',
+  'host' => '127.0.0.1',
+  'port' => '3307',
+  'login' => 'root',
+  'password' => 'r12348',
+  'database' => 'webzashtest2db',
   'prefix' => '',
   //'encoding' => 'utf8',
  );

This will lead to the login page


It's a straight forward task(screenshot included) even with antivirus @ bg.

It supports various framework, intend to make use of Cakephp (MVC approach)

Remeber the MySQL root pwd
Remember the ports for Apache web server and MySQL(how to get that info using manager-windows.exe, see below)






Launch the WAMP stack - 127.0.0.1:81/index.html
phpmyadmin(web interface) module will alow easy access to MySQL - 127.0.0.1:81/phpmyadmin




One can access the graphical manager tool to start/stop/restart and know port info of the services
It's in the installation dir



top