The epubster from digitalpublishingtoolkit

database.sql

Hi there,

I don't seem to be able to find the full database schema ... or should it self create.

Cheers,

Michael

Installation documentation

I'm trying to get it to run on a vintage CentOS 6.5 / ISPConfig / Ajenti server.

I've cloned both the cakephp and epubster into a private folder that cannot be accessed by the web server first.

Assembly

Then I'd copy CakePHP to the public facing folder that Apache listens on with PHP FastCGI. Usually it works.

cp ~/cakephp/app/ ~/../web/

Afterwards the lib

cp ~/cakephp/lib ~/../web/

plus epubster

cp -f ~/epubster/ ~/../web/

Don't remember the right syntax right now; used mc. Only represented as reference.

Database setup

After the files had been in place, they could be tampered with.

First, obviously, was

cp Config/database.php.default Config/database.php

and editing it to meet the local settings. Uncommenting the encoding would just meet the case.

Loading the schema was implicit by following

$ mysql -u db_user -pDB_PASS

and then got that stuff inside

mysql> use db;
mysql> source database.sql;
mysql> quit;

The errors

[Sun Feb 08 01:40:41 2015] [warn] [client ::1] mod_fcgid: stderr: PHP Warning:  include(): open_basedir restriction in effect. File(/var/www/clients/client4/web50/lib/Cake/bootstrap.php) is 
not within the allowed path(s): (/var/www/clients/client4/web50/web:/var/www/clients/client4/web50/private:/var/www/clients/client4/web50/tmp:/var/www/epub.allmende.io/web:/srv/www/epub.allm
ende.io/web:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin) in /var/www/clients/client4/web50/web/webroot/index.php on line 98
[Sun Feb 08 01:40:41 2015] [warn] [client ::1] mod_fcgid: stderr: PHP Warning:  include(/var/www/clients/client4/web50/lib/Cake/bootstrap.php): failed to open stream: Operation not permitted
 in /var/www/clients/client4/web50/web/webroot/index.php on line 98
[Sun Feb 08 01:40:41 2015] [warn] [client ::1] mod_fcgid: stderr: PHP Warning:  include(): Failed opening '/var/www/clients/client4/web50/lib/Cake/bootstrap.php' for inclusion (include_path=
'.:/usr/share/pear:/usr/share/php') in /var/www/clients/client4/web50/web/webroot/index.php on line 98
[Sun Feb 08 01:40:41 2015] [warn] [client ::1] mod_fcgid: stderr: PHP Fatal error:  CakePHP core could not be found. Check the value of CAKE_CORE_INCLUDE_PATH in APP/webroot/index.php. It sh
ould point to the directory containing your /cake core directory and your /vendors root directory. in /var/www/clients/client4/web50/web/webroot/index.php on line 103

wherefore I adapted define('CAKE_CORE_INCLUDE_PATH', ROOT . DS . 'web' . DS . 'lib'); in index.php

Then I added

                date_default_timezone_set('Europe/Berlin');

                if (!is_numeric($this->settings['duration'])) {
                        $this->settings['duration'] = strtotime($this->settings['duration']) - time();
                }
                return true;

to CacheEngine.php and weird time errors disappeared.

[Sun Feb 08 02:40:32 2015] [warn] [client ::1] mod_fcgid: stderr: PHP Warning:  strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead in /var/www/clients/client4/web50/web/lib/Cake/Cache/CacheEngine.php on line 60

Finally a PHP application is presenting its "frontend" errors.

Notice (1024): Please change the value of 'Security.salt' in APP/Config/core.php to a salt value specific to your application. [APP/lib/Cake/Utility/Debugger.php, line 846]
Notice (1024): Please change the value of 'Security.cipherSeed' in APP/Config/core.php to a numeric (digits only) seed value specific to your application. [APP/lib/Cake/Utility/Debugger.php, line 850]

So I got a security.salt and .cypherSeed and can now go on to create the first user.

Should I update the docs and create a PR from my fork?

Demo

This looks interesting!
Is there a demo available somewhere?

digitalpublishingtoolkit / epubster Goto Github PK

epubster's People

Contributors

Stargazers

Watchers

Forkers

epubster's Issues

database.sql

Installation documentation

Assembly

Database setup

The errors

Demo

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent