This requires Apache Mysql stack - here making use of bitnami wamp stack
Installing 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 - which will return the following error/page
http://127.0.0.1:81/webzashtest2
\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