Freesn

Aus Vosp.info
Version vom 15. Oktober 2015, 22:32 Uhr von V (Diskussion | Beiträge) (Mysql einspielen)
Wechseln zu:Navigation, Suche

freeSN

Software

unter Debian Jessie
apt-get install apache2 php5 mysql-server-5.5 php5-mysql php5-gd php-pear php5-xsl git phpunit php5-curl

pear install --alldeps XML_Parser
pear install --alldeps XML_RSS
pear install --alldeps channel://pear.php.net/HTML_Common2
ln -s /usr/share/php /var/www
ln -s /usr/share/php/XML/ /usr/share/php5/
ln -s /usr/share/php/PEAR /usr/share/php5/
ln -s /usr/share/php/PEAR5.php /usr/share/php5/
ln -s /usr/share/php/PEAR.php /usr/share/php5/


Mysql einspielen

cd /var/www/freeSN/include/System/sql


Vorbereiten

create database ncfreesn_nc
GRANT ALL PRIVILEGES ON ncfreesn_nc.* TO nc IDENTIFIED BY 'xxxxxxxxxx';
UPDATE `mysql`.`db` SET `Host` = 'localhost', `Select_priv` = 'Y', `Insert_priv` = 'Y', `Update_priv` = 'Y', `Delete_priv` = 'Y', `Create_priv` = 'Y', `Drop_priv` = 'Y', `Create_view_priv` = 'Y', `Show_view_priv` = 'Y', `Create_routine_priv` = 'Y', `Alter_routine_priv` = 'Y', `Execute_priv` = 'Y' WHERE CONVERT( `Db` USING utf8 ) = 'ncfreesn_nc' AND `User`= 'nc' LIMIT 1 ;
UPDATE `mysql`.`db` SET `Host` = 'localhost', `Select_priv` = 'Y', `Insert_priv` = 'Y', `Update_priv` = 'Y', `Delete_priv` = 'Y', `Create_priv` = 'Y' WHERE CONVERT( `Db` USING utf8 ) = 'ncfreesn_sn_srequest' AND `User`= 'nc' LIMIT 1 ;
 update mysql.user set Host='localhost' where User='nc';
FLUSH PRIVILEGES;

Falls Datenbank erst gelöscht werden muss

SET FOREIGN_KEY_CHECKS=0; 
drop database ncfreesn_nc;

Beispieldaten

create database ncfreesn_nc;
\. MySql_InsertExampleFreesn.sql

Design

zB.:
$OLDDESGNDIR=mensch.coop
$NEWDESGNDIR=netz.coop
Neues Design:
cp ./include/Forest/$OLDDESGNDIR ./include/Forest/$NEWDESGNDIR 
Find/Replace $OLDDESGNDIR with $NEWDESGNDIR in all Files under $NEWDESGNDIR
cp ./include/System/xsl/$OLDDESGNDIR ./include/System/xsl/$NEWDESGNDIR