Ams - Historique des versions

Admin : /* PHP 5.4 Apache Spec */

2012-10-28T17:42:13Z

PHP 5.4 Apache Spec

← Version précédente		Version du 28 octobre 2012 à 17:42
Ligne 97 :		Ligne 97 :


−	a2enmod rewrite	+	a2enmod rewrite ssl
	service apache2 restart		service apache2 restart

Admin : /* Frontaux */

2012-10-25T10:54:35Z

Frontaux

← Version précédente		Version du 25 octobre 2012 à 10:54
Ligne 80 :		Ligne 80 :
	apt-get upgrade		apt-get upgrade
	apt-get install openvpn		apt-get install openvpn
−	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached php5-memcached syslog-ng	+	apt-get install htop tree nfs-client postfix openntpd htop php5 php5-mysql python-soappy python keepalived memcached php5-memcached syslog-ng
	lvcreate -L 50G -nwww vg		lvcreate -L 50G -nwww vg
	mkfs.ext3 /dev/mapper/vg-www		mkfs.ext3 /dev/mapper/vg-www

Admin : /* Frontaux */

2012-10-25T10:13:09Z

Frontaux

← Version précédente		Version du 25 octobre 2012 à 10:13
Ligne 80 :		Ligne 80 :
	apt-get upgrade		apt-get upgrade
	apt-get install openvpn		apt-get install openvpn
−	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached syslog-ng	+	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached php5-memcached syslog-ng
	lvcreate -L 50G -nwww vg		lvcreate -L 50G -nwww vg
	mkfs.ext3 /dev/mapper/vg-www		mkfs.ext3 /dev/mapper/vg-www

Admin : /* Frontaux */

2012-10-23T20:01:29Z

Frontaux

← Version précédente		Version du 23 octobre 2012 à 20:01
Ligne 80 :		Ligne 80 :
	apt-get upgrade		apt-get upgrade
	apt-get install openvpn		apt-get install openvpn
−	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached	+	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached syslog-ng
	lvcreate -L 50G -nwww vg		lvcreate -L 50G -nwww vg
	mkfs.ext3 /dev/mapper/vg-www		mkfs.ext3 /dev/mapper/vg-www

Admin : /* Frontaux */

2012-10-23T19:46:15Z

Frontaux

← Version précédente		Version du 23 octobre 2012 à 19:46
Ligne 78 :		Ligne 78 :

	apt-get update		apt-get update
		+	apt-get upgrade
	apt-get install openvpn		apt-get install openvpn
	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached		apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached

Admin : /* Frontaux */

2012-10-23T19:39:28Z

Frontaux

← Version précédente		Version du 23 octobre 2012 à 19:39
Ligne 79 :		Ligne 79 :
	apt-get update		apt-get update
	apt-get install openvpn		apt-get install openvpn
−	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived ~~memcached~~ memcached	+	apt-get install htop tree nfs-client openntpd htop php5 php5-mysql python-soappy python keepalived memcached
	lvcreate -L 50G -nwww vg		lvcreate -L 50G -nwww vg
	mkfs.ext3 /dev/mapper/vg-www		mkfs.ext3 /dev/mapper/vg-www

Admin : /* injection DB */

2012-10-22T05:23:38Z

injection DB

← Version précédente		Version du 22 octobre 2012 à 05:23
Ligne 127 :		Ligne 127 :
	MySQL a répondu: Documentation		MySQL a répondu: Documentation
	#1452 - Cannot add or update a child row: a foreign key constraint fails (`allmyski`.<result 2 when explaining filename '#sql-d72_72'>, CONSTRAINT `fk_ams_user_data_ams_city1` FOREIGN KEY (`uda_cty_id`) REFERENCES `ams_city` (`cty_id`) ON DELETE NO ACTION ON UPDATE )		#1452 - Cannot add or update a child row: a foreign key constraint fails (`allmyski`.<result 2 when explaining filename '#sql-d72_72'>, CONSTRAINT `fk_ams_user_data_ams_city1` FOREIGN KEY (`uda_cty_id`) REFERENCES `ams_city` (`cty_id`) ON DELETE NO ACTION ON UPDATE )
		+
		+
		+	==== Le PHP qd on met en 'production' ====
		+
		+	Oct 22 07:21:42 10.8.1.16 skivoiturage_error: [Mon Oct 22 07:21:42 2012] [error] [client 82.227.229.68] PHP Fatal error: Uncaught exception 'Zend_Config_Exception' with message 'Section 'production' cannot be found in /var/www/skiVoiturage/application/configs/eventManager.ini' in /var/www/skiLibraries/Zend/Config/Ini.php:151\nStack trace:\n#0 /var/www/skiLibraries/Zend/Application.php(386): Zend_Config_Ini->__construct('/var/www/skiVoi...', 'production')\n#1 /var/www/skiLibraries/Zend/Application.php(130): Zend_Application->_loadConfig('/var/www/skiVoi...')\n#2 /var/www/skiLibraries/Zend/Application.php(92): Zend_Application->setOptions(Array)\n#3 /var/www/skiVoiturage/public/index.php(33): Zend_Application->__construct('production', Array)\n#4 {main}\n thrown in /var/www/skiLibraries/Zend/Config/Ini.php on line 151
		+	Oct 22 07:21:42 10.8.1.12 skivoiturage_error: [Mon Oct 22 07:21:42 2012] [error] [client 82.227.229.68] PHP Warning: require_once(Zend/Application.php): failed to open stream: No such file or directory in /var/www/skiVoiturage/public/index.php on line 19
		+	Oct 22 07:21:42 10.8.1.12 skivoiturage_error: [Mon Oct 22 07:21:42 2012] [error] [client 82.227.229.68] PHP Fatal error: require_once(): Failed opening required 'Zend/Application.php' (include_path='/var/www/skiVoiturage/libraries::.:/usr/share/php:/usr/share/pear') in /var/www/skiVoiturage/public/index.php on line 19

	=== bench ===		=== bench ===

Admin : /* injection DB = */

2012-10-22T05:21:25Z

injection DB =

← Version précédente		Version du 22 octobre 2012 à 05:21
Ligne 113 :		Ligne 113 :

	=== Mise en place de SkiVoiturage ===		=== Mise en place de SkiVoiturage ===
−	=== injection DB ====	+	==== injection DB ====

	Erreur		Erreur
Ligne 126 :		Ligne 126 :

	MySQL a répondu: Documentation		MySQL a répondu: Documentation
−	#1452 - Cannot add or update a child row: a foreign key constraint fails (`allmyski`.<result 2 when explaining filename '#sql-d72_72'>, CONSTRAINT `fk_ams_user_data_ams_city1` FOREIGN KEY (`uda_cty_id`) REFERENCES `ams_city` (`cty_id`) ON DELETE NO ACTION ON UPDATE )	+	#1452 - Cannot add or update a child row: a foreign key constraint fails (`allmyski`.<result 2 when explaining filename '#sql-d72_72'>, CONSTRAINT `fk_ams_user_data_ams_city1` FOREIGN KEY (`uda_cty_id`) REFERENCES `ams_city` (`cty_id`) ON DELETE NO ACTION ON UPDATE )
−		+
−		+
−		+
−		+

	=== bench ===		=== bench ===

Admin : /* bench */

2012-10-22T05:21:14Z

bench

← Version précédente		Version du 22 octobre 2012 à 05:21
Ligne 111 :		Ligne 111 :
	- virtual_server 87.98.251.179 80 {		- virtual_server 87.98.251.179 80 {
	+ virtual_server fwmark 1 {		+ virtual_server fwmark 1 {
		+
		+	=== Mise en place de SkiVoiturage ===
		+	=== injection DB ====
		+
		+	Erreur
		+
		+	Requête SQL:
		+
		+	--
		+	-- Contraintes pour la table `ams_user_data`
		+	--
		+	ALTER TABLE `ams_user_data` ADD CONSTRAINT `ams_user_data_ibfk_2` FOREIGN KEY ( `uda_usr_id` ) REFERENCES `ams_user` ( `usr_id` ) ON DELETE CASCADE ON UPDATE NO ACTION ,
		+	ADD CONSTRAINT `fk_ams_user_data_ams_city1` FOREIGN KEY ( `uda_cty_id` ) REFERENCES `ams_city` ( `cty_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION ;
		+
		+	MySQL a répondu: Documentation
		+	#1452 - Cannot add or update a child row: a foreign key constraint fails (`allmyski`.<result 2 when explaining filename '#sql-d72_72'>, CONSTRAINT `fk_ams_user_data_ams_city1` FOREIGN KEY (`uda_cty_id`) REFERENCES `ams_city` (`cty_id`) ON DELETE NO ACTION ON UPDATE )
		+
		+
		+
		+

	=== bench ===		=== bench ===

Admin : /* PHP 5.4 */

2012-10-22T05:00:22Z

PHP 5.4

← Version précédente		Version du 22 octobre 2012 à 05:00
Ligne 89 :		Ligne 89 :
	mount /var/www/shared		mount /var/www/shared

−	=== PHP 5.4 ===	+	=== PHP 5.4 Apache Spec ===
	apt-get install python-software-properties		apt-get install python-software-properties
	add-apt-repository ppa:ondrej/php5		add-apt-repository ppa:ondrej/php5
Ligne 99 :		Ligne 99 :
	service apache2 restart		service apache2 restart

−	~~ajout de l'ip FailOver~~	+	=== Keepalived Spécifiques ===
−	~~#vim /etc/network/interfaces~~	+
−	~~auto eth0:0~~	+	chmod +x /etc/keepalived/front01.failover.py
−	~~iface eth0:0 inet static~~	+	chmod +x /etc/keepalived/front02.failover.py
−	~~address 87.98.251.179~~	+
−	~~netmask 255.255.255.255~~	+
−	~~broadcast 87.98.251.179~~	+
−		+
−	chmod +x /etc/~~ha.d~~/front01.failover.py	+
−	chmod +x /etc/~~ha.d~~/front02.failover.py	+
−	~~chmod +x /etc/ha.d/resource.d/IPaddrFO~~	+
−		+
−	~~commiter toute la partie HaProxy y compris.~~	+
−	~~/etc/default/haproxy~~	+
−		+
−	~~/usr/lib/ocf/resource.d/heartbeat/IPaddrFO~~	+
−		+
−		+
	ifconfig tunl0 ${VIP_HTTPS} netmask 255.255.255.255 broadcast ${VIP_HTTPS}		ifconfig tunl0 ${VIP_HTTPS} netmask 255.255.255.255 broadcast ${VIP_HTTPS}
	ifconfig tunl0 87.98.251.179 netmask 255.255.255.255 broadcast 87.98.251.179		ifconfig tunl0 87.98.251.179 netmask 255.255.255.255 broadcast 87.98.251.179