netz98 / n98-magerun Goto Github PK

Add an option do install a bunch of or all available magento versions with the same user settings and autogenerated data base names.

We should be able to specifiy a database name prefix so the table names are generated like

"magento_test_ce-1_7_0_2"

XML values should be wrapped in CDATA to prevent parse errors e.g.

<host><![CDATA[localhost]]></host>
<unix_socket><![CDATA[/tmp/mysqld1.sock]]></unix_socket>

Adding an admin user via commandline would be great. Additional parameters would be needed:

-username <usename> -email <email> -password <password> [-firstname <firstname=Admin>] [-lastname <lastname=User>]

I did this for another script before and will add this to n98-magerun soon.

We have three different wordings for the same thing.

Actually it makes sense to have a different wording for the Magento Connect functionality (currently: extension / package) and the local modules (currently module)

But maybe we should full reword extension to package ?

extension:download Download magento-connect package
extension:list List magento connection extensions
dev:module:create Creates an registers new magento module.

sys:check command should check if db user can do all related things like LOCK TABLES etc.
We need to specify which permissions are needed.

Check index_process table and calculate the last index runtimes.

This information could also be included in the reindex actions to give an estimate on how long the index ran before.

sys:urls:list [--add-categories] [--add-products] [--add-cmspages] [--add-all] [stores] [linetemplate]

Examples:

• Create a list of product urls only
  ./n98-magerun.phar system:urls:list --add-products 4
• Create a list of all products, categories and cms pages of store 4 and 5 separating host and path (e.g. to feed a jmeter csv sampler)
  ./n98-magerun.phar system:urls:list --add-all 4,5 '{host},{path}' > urls.csv

The "linetemplate" can contain all parts "parse_url" return wrapped in '{}'. '{url}' always maps the complete url and is set by default

Not sure if this is bug, probably rather a specific issue. But here is background: on OSX built in PHP doesn't have mcrypt included which is one of Magento requirements. Thus solutions like http://php-osx.liip.ch/ are common to be used, but the tool is using /usr/bin/php when installing Magento using install command thus it doesn't succeed

.. brings strange output:

$ n98-magerun.phar config:get base
base => 

~/dev/testshop$ n98-magerun.phar admin:user:cha Username
PHP Fatal error: Call to a member function ask() on a non-object in phar:///usr/bin/n98-magerun.phar/src/N98/Magento/Command/Admin/User/ChangePasswordCommand.php on line 46

Hey,

It will be great if there will be possibility to change url for stores (web/unsecure/baseurl). It is very handy in continous integration

It would be nice if we could update an extension like:

n98-magerun extension:update KEY

When executing n98-magerun.phar cache:clear full_page there is message in console "full_page cache cleared" however in backend cache management page this cache type is still marked as Invalidated.

Can you reproduce this? Could be something with my instance if not

What do empty entries mean?

+-----------------------------------------+------+----+----+----+----+
| Job | m | h | D | M | WD |
+-----------------------------------------+------+----+----+----+----+
| currency_rates_update | | | | | |
+-----------------------------------------+------+----+----+----+----+

They don't run at all?

Maybe there could be a notice for that as it is not clear on the first look.

| #currency_rates_update | | | | | |

would be a nice way to display disabled crons.

The parameter "session save" should give several options to choose from.

Would be helpful to clean out orders and quotes

Password entry should be starred out. This may require a password-confirm prompt. Ref https://github.com/Seldaek/hidden-input for details on Symfony2 Console hidden-input field

Maybe we could use a syntax like

"n98-magerun.phar database:dump -"

or

"n98-magerun.phar database:dump --stdout"

See also: http://stackoverflow.com/questions/12789085/common-syntax-to-specific-stdout-as-output-file

I want to publish CMS pages and activate / deactivate banners by a schedule.

The following commands would be handy, so I can add n98-magerun to the cron tab.

cms:page:publish
cms:banner:activate
cms:banner:deactivate
cms:banner:toggle

For the activate and deactive functionality we actually could make a more generic command that can activate / deactivate all kinds of magento objects.

What do you think?

I would try to provide some pull request.

Can there be an option to download an extension from magento connect only without installing it?

n98-magerun just displays no message at all when starting it.

Why is that?

Could there be at least an error message?

We have various issues with permissions of var/cache and so on files.

It might help to prevent running magerun as root user.

What do you think?

Not sure how best to describe this but

1. The errors="0" and failures="0" are both incorrect.
2. Loaded Class is incorrect

<?xml version="1.0" encoding="UTF-8"?>
<testsuites>
    <testsuite name="n98-magerun: dev:module:rewrite:conflicts" timestamp="2012-10-17T12:47:18+0000"
                         time="0.25371217727661" tests="1" failures="1">
        <testcase errors="0" failures="0" name="Magento Rewrite Conflict Test" classname="ConflictsCommand">
            <failure type="MagentoRewriteConflictException">Rewrite conflict: Type blocks | Class: adminhtml/sales_order_grid,
                Rewrites: AW_Deliverydate_Block_Adminhtml_Sales_Order_Grid,
                Screenpages_RedPrairie_Adminhtml_Block_Sales_Order_Grid, Screenpages_EuroStop_Block_OrderGrid | Loaded class:
                Mage_Adminhtml_Model_Sales_Order_Grid
            </failure>
        </testcase>
    </testsuite>
</testsuites>

When calling cache:flush I get:

PHP Fatal error: require(): Failed opening required 'Enterprise/PageCache/Model/Cache.php' (include_path='XXXXXX') in /....../Magento/Autoload.php on line 118

In FlushCommand:execute we have an is_callable(array('\Enterprise_PageCache_Model_Cache', 'getCacheInstance') . class_exists also does not work.

I actually do not understand why this is working in Magento 1. I guess because the autoloader is different.

Should we simple check

AbstractMagentoCommand->_magentoEnterprise instead?

What do you think?

https://gist.github.com/2715268

$ n98-magerun.phar config:get *country_id*
+----------------------------+----------+----------+----+
| Path                       | Scope    | Scope-ID | V  |
+----------------------------+----------+----------+----+
| shipping/origin/country_id | websites |    72    | DE |
+----------------------------+----------+----------+----+

$ n98-magerun.phar mysql
mysql> select * from core_config_data where path like "%country_id%";
+-----------+----------+----------+----------------------------+-------+
| config_id | scope    | scope_id | path                       | value |
+-----------+----------+----------+----------------------------+-------+
|       635 | default  |        0 | shipping/origin/country_id | NULL  |
|       730 | websites |        1 | shipping/origin/country_id | DE    |
|       748 | websites |        4 | shipping/origin/country_id | GB    |
[ many rows removed ]
|      6709 | websites |       72 | shipping/origin/country_id | DE    |
+-----------+----------+----------+----------------------------+-------+
18 rows in set (0.00 sec)

Because of the aliases on level 1, the whole commands are repeated. Example:

database
  database:console                 Opens mysql client by database config from local.xml
  database:dump                    Dumps database with mysqldump cli client according to informations from local.xml
  database:info                    Dumps database informations
db
  db:console                       Opens mysql client by database config from local.xml
  db:dump                          Dumps database with mysqldump cli client according to informations from local.xml
  db:info                          Dumps database informations

Is it possible do display it like this?

database (alias: db)
  database:console                 Opens mysql client by database config from local.xml
  database:dump                    Dumps database with mysqldump cli client according to informations from local.xml
  database:info                    Dumps database informations

With log support it will be possible to add the results to i.e. a jenkins server.
So a build process can check if there are rewrite conflicts.

If I call

n98-magerun.phar config:dump,

If I combine it with less:

n98-magerun.phar config:dump|less

The XML is formated - why is that?

The sales_order_status* tables contain important reference data, not transactional data. These should not be cleaned.

A bash autocomplete integration for the parameters would be nice.

If I am not in a Magento folder, a PHP warning along with the stack trace is print.

PHP Warning:  require_once(/app/Mage.php): failed to open stream: No such file or directory in phar:///usr/local/bin/n98-magerun.phar/src/N98/Magento/Command/AbstractMagentoCommand.php on line 21

Also there is the correct message "Magento folder could not be detected" so the warning just should be omitted.

Can you add a switch that displays tabluar information in a more simple format, such as tab separated or something like that?

This would be great for

• copy & pasting stuff to other places such as mails
• post-processing info with shell tools

The option also should removed colored output and headline.

The sales group ignores data in the sales_flat_order_* tables which means that sales_flat_order itself is not ignored.

- id: sales
    description: Sales data (orders, invoices, creditmemos etc)
    tables: sales_order_* sales_flat_order_* sales_flat_creditmemo_* sales_flat_invoice_* sales_flat_quote sales_recurring_* sales_refunded_* sales_payment_*

Insert the command "database:console" that calls the mysql command with the database configuration to quickly open a database console.

Magento installer has problems with PHP 5.4.
It stops installation with "PHP Extensions “0” must be loaded".

A possible fix for installer is here: http://www.magentocommerce.com/boards/viewthread/284882/#t411655

We should detect if someone is using PHP 5.4 and patch magento installer with magerun.

When enabling template hints or inline translation, the setting might not take effect because a developer IP restriction is set

• show warning
• add an option to reset the IP

Lots of issues can be caused when the var folder is different when running magerun on the console from the one that the webserver uses.

We could implement a check if the var dir is set to /tmp/magento because this might not be the desired place in most of the cases.

Implement

n98-magerun.phar cache:clean full_page,block_html

to clear multiple caches.

Currently I think also no error message is shown if invalid cache codes are supplied

Could apply to other commands to run them on multiple targets

Somewhere between versions 1.24.1-1.24.2 the tool got broken and outputting just an error:

/usr/local/bin/n98-magerun.phar: line 1: ?php: No such file or directory
/usr/local/bin/n98-magerun.phar: line 3: =: command not found
/usr/local/bin/n98-magerun.phar: line 5: syntax error near unexpected token `('
/usr/local/bin/n98-magerun.phar: line 5: `$application = new N98\Magento\Application($autoloader);'

use this code to check if there are contradictions in the total order definition

amenk/magento2@2946655

Example:

-action set -path <path> -value <value> [-scope <scope=default>] [-scopeId <scopeId=0>]
-action get -path <path> [-storeId <storeId>]

I've done this for another tool and can contribute this to n98-magerun

Windows 7 running IIS (not by choice at all) and PHP-CGI 5.3.8 returns the following response when running

php-cgi.exe n98-magerun.phar

with any commands. PHP directory is on the Windows path.

Status: 500 Internal Server Error
Content-type: text/html

With php.exe nothing happens; no errors no output. IE:

php.exe n98-magerun.phar database:info

returns nothing.

Allow for reindexing multiple indices by entering a comma-seperated list of menu-choices e.g. 1,2,3

A function like in https://github.com/amenk/SelfScripts/blob/master/mysql-stripped-dump might be handy to exclude big tables and only dump their structure. There could be a pre-defined set of usually un-needed tables and the possibility to user define some.

Hi,

I know the install feature is experimental, but here is an issue I faced during installation of Magento 1.7.0.2

Install sample data? [y]: 
  - Installing sample-data-1.6.1.0 (1.6.1.0)
    Downloading: 100%         

Importing .//magento_sample_data_for_1.6.1.0.sql

but no sample data available after successful installation. Then I installed it from command line:
mysql -u root -p magento-ce1702 < magento_sample_data_for_1.6.1.0.sql
and got error: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'catalog_product_entity_group_price' already exists

didn't have time to look closer, probably sample data installation error wasn't handled

Thanks,
Alex

Sometimes it would be nice/necessary if you could specify the database table prefix during the installation of Magento.

Implement an option --set modulecode=versionnumber to force a version number to be set before executiong applyAllUpdates. This can be helpfull to re-run setup scripts for debugging.

Hi,

just tried the tools on my dev box, and getting a warning "Magento folder could not be detected" for a perfectly valid Magento installation. Anyway I could help to debug the issue?

Thank you

app/etc/local.xml can specify a value for unix_socket, however this value is not used by the Magerun CLI db: tools. Following error is returned:

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect