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


0 comments:

Post a Comment

top