Freesn: Unterschied zwischen den Versionen
Aus Vosp.info
V (Diskussion | Beiträge) |
V (Diskussion | Beiträge) (→Mysql einspielen) |
||
| Zeile 17: | Zeile 17: | ||
=== Mysql einspielen=== | === 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 ==== | ====Falls Datenbank erst gelöscht werden muss ==== | ||
SET FOREIGN_KEY_CHECKS=0; | SET FOREIGN_KEY_CHECKS=0; | ||
| Zeile 23: | Zeile 37: | ||
create database ncfreesn_nc; | create database ncfreesn_nc; | ||
\. MySql_InsertExampleFreesn.sql | \. MySql_InsertExampleFreesn.sql | ||
| − | |||
===Design === | ===Design === | ||
Version vom 15. Oktober 2015, 22:32 Uhr
Inhaltsverzeichnis
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
