Topic: Changing php.ini question

[rogerbodger]

I'm sure I must be making a quite basic mistake, but can't see what I'm doing wrong, hopefully someone can point out where I'm going wrong ....

I'm trying to install itop in an ibay (named itop) on my SME 8.0 server, but the installer is complaining that magic_quotes_gpc is set to On and needs to be set to Off.

I've created a templates-custom directory
mkdir -p /etc/e-smith/templates-custom/etc/php.ini
and copied the 40DataHandling file
cp /etc/e-smith/templates/etc/php.ini/40DataHandling /etc/e-smith/templates-custom/etc/php.ini
In 40DataHandling, I've added magic_quotes_gpc = Off, then expanded the template expand-template /etc/php.ini
I then modified the ibay signal-event ibay-modify itop (and I've even rebooted to be sure) but still the installer complains.

Any suggestions?

Thanks in advance,
Roger

[purvis]

From other web sources, I see methods to get the same results for special needs.
A global turn off is likely not your best option for the whole server.
There has been much discussion with this setting at the php developers.

[rogerbodger]

Thanks for your reply. I've also tried setting in .htaccess but again this makes no difference.

I've just run cat /etc/php.ini and that confirms magic_quotes_gpc is set to off, so I suspect I need to look more at the itop install code (however phpinfo tells me that it's set on  )

[janet]

rogerbodger

I've just run cat /etc/php.ini and that confirms magic_quotes_gpc is set to off, so I suspect I need to look more at the itop install code (however phpinfo tells me that it's set on  )

Is it in the [PHP] section of /etc/php.ini ?
Is there only one instance of
magic_quotes_gpc = ....

you may have
magic_quotes_gpc = On
and also
magic_quotes_gpc = Off
and one is overriding the other.

[janet]

rogerbodger

Actually that directive is deprecated in php 5.3.3
sme8 is running
rpm -q php
php-5.3.3-13.el5.sme.1

refer
http://php.net/manual/en/ini.list.php
magic_quotes_gpc    "1"    PHP_INI_PERDIR    PHP_INI_ALL in PHP <= 4.2.3. Deprecated in PHP 5.3.0. Removed in PHP 5.4.0.

[rogerbodger]

Actually that directive is deprecated in php 5.3.3

Thanks Mary, that would probably explain it.

[janet]

rogerbodger

....that would probably explain it.

Sure would.
So let us know here what you find out to do about it and workaround it etc.
It will be useful info for others.
Thanks

[mmccarn]

When playing with ioncube in 2011 I was able to disable magic quotes using:

Code: [Select]

mkdir -p /etc/e-smith/templates-custom/etc/php.ini
cd /etc/e-smith/templates-custom/etc/php.ini
echo 'magic_quotes_gpc = off' > 15ioncube
expand-template /etc/php.ini
sv t httpd-e-smith

I have several ibays that require that magic_quotes_gpc is off (and which came with their own .htaccess files).

The .htaccess files in those ibays contain a line saying:

Code: [Select]

php_flag magic_quotes_gpc          Off
But in order for .htaccess to make any difference in an ibay you need to 'AllowOverride' for the ibay:

Code: [Select]

db accounts setprop itop AllowOverride All
signal-event ibay-modify itop


[CharlieBrady]

Sure would.

Sure would not!

"Deprecated" means "please do not use". Does not mean "will not work".

[Stefano]

http://me.veekun.com/blog/2012/04/09/php-a-fractal-of-bad-design/   (Cit.)

[rogerbodger]

I have several ibays that require that magic_quotes_gpc is off (and which came with their own .htaccess files).

The .htaccess files in those ibays contain a line saying:

Code: [Select]

php_flag magic_quotes_gpc          Off
But in order for .htaccess to make any difference in an ibay you need to 'AllowOverride' for the ibay:

Code: [Select]

db accounts setprop itop AllowOverride All
signal-event ibay-modify itop


The AllowOverride has done the trick and the installer is now running - many thanks, I really appreciate your help.

[Bud]

Please guys can you help me.

I have a new SME 8.1 64Bit Server with all updates installed

I am trying to install ITOP V 2.03

I get to 40% installed then i receive this error:

*******************************************

Failed to issue SQL query: query = CREATE TABLE `priv_changeop` (`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `changeid` INT(11) NOT NULL, INDEX (`changeid`), `objclass` VARCHAR(255) NOT NULL, `objkey` VARCHAR(255) NOT NULL, `optype` VARCHAR(255) NOT NULL, INDEX (`optype`), INDEX `objclass_objkey` (`objclass`, `objkey`)) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_unicode_ci, mysql_error = Specified key was too long; max key length is 1000 bytes, mysql_errno = 1071

*******************************************

Any ideas what i must do with the MySQL Database ?

Any help greatly appreciated 

[Stefano]

Bud

this has nothing to do with SME..

you should search the reason/solution with Google, then try to apply it (likely via a custom fragment) to your SME

[Bud]

Stefano i understand.

However i need to start " InnoDB " as when i issue the following command in mysql " show engines; " i can see that InnoDB IS Disabled.

So you need to " Enable " InnoDB " and keep it enabled after a server reboot.

Please go to http://wiki.contribs.org/MySQL#Enable_InnoDB_engine

Or at the Shell enter the Following Command:

# db configuration setprop mysqld InnoDB enabled
# expand-template /etc/my.cnf
# sv t /service/mysqld

And there you go, ITOP can now be Installed

I know you guys are busy and am sorry for the noob questions. Thanks 

[Stefano]

The answer is wiki