MySQL/PHP issue.

WLS-ITGuy

Actually, you might have more than one php.ini file. Create info.php file with this content:
<?php phpinfo(); ?>
and visit it in web browser. See what memory limits it shows and where could additional configs be located.

http://i.imgur.com/Z9Ltyp0.png[/img]

http://i.imgur.com/blBpUgw.png[/img]

marcinozga

So limit is set to 2G, is the conversion script still refusing to run?

WLS-ITGuy

@marcinozga

Yes. If I CD to /var/www/moodle/ and run 'php admin/cli/mysql_compressed_rows.php --list' I get PHP Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 49152 bytes) in var/www/moodle/admin/cli/mysql_compressed_rows.php on line 152

scottalanmiller

Just to be sure.... you aren't out of memory, right?

marcinozga

Oh, that's a cli script, I thought you were calling it with browser. Try this:

php -d memory_limit=2048M admin/cli/mysql_compressed_rows.php --list

WLS-ITGuy

@marcinozga said in MySQL/PHP issue.:

php -d memory_limit=2048M admin/cli/mysql_compressed_rows.php --list

That all worked! And now I am on to the next part of the upgrade!

marcinozga

Just to clarify, -d option allows you to override any php settings.

WLS-ITGuy

@marcinozga said in MySQL/PHP issue.:

Just to clarify, -d option allows you to override any php settings.

OK. So why would php.ini show that it is allowing 2G but not actually allow 2G?

marcinozga

php-cli has its config file elsewhere, I'm not sure where. When you check it through web, it's shows what's in php.ini.

WLS-ITGuy

@marcinozga
Gotcha! Thanks for the help!

marcinozga

Run

php --ini

and see what it returns.

WLS-ITGuy

@marcinozga Gives me a list of files pulled from /etc/php5/cli/

marcinozga

@WLS-ITGuy line Loaded Configuration File: will give you config location.
See what the memory limit is set there.

WLS-ITGuy

@marcinozga said in MySQL/PHP issue.:

@WLS-ITGuy line Loaded Configuration File: will give you config location.

Yup. Got it. Changed the memory_limit there and was able to run the script without using -d.

dafyre

@WLS-ITGuy said in MySQL/PHP issue.:

@marcinozga

Yes. If I CD to /var/www/moodle/ and run 'php admin/cli/mysql_compressed_rows.php --list' I get PHP Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 49152 bytes) in var/www/moodle/admin/cli/mysql_compressed_rows.php on line 152

Run that same php info.php file from the CLI... and search for the php.ini file that way...

php info.php|grep -i "php.ini"

And see what file(s) it spits out.

Edit: Dang... Day late, $1 short.