On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Articles in this section

See more

How to fetch Plesk Action Log using the command line?

Avatar
Stefan Yakubov
Updated
Follow
Plesk for Windows Plesk for Linux kb: tools ABT: Group A

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Question

How to fetch Plesk Action Log using the command line?

Answer

Note: Vote for this feature in our Official Plesk UserVoice channel, as top-voted suggestions are likely to be included in future Plesk versions.

Configuration parameters of the Plesk Action Log are available on Tools & Settings > Action Log, where it is also possible to configure and download the action log for a selected time period.

Plesk saves the user actions in the internal action log stored in the Plesk database. It's possible to fetch the action log records directly from the database using the following steps:

Click on a section to expand

Plesk for Linux

  1. Connect to the server via SSH

  2. Download the script:

    # curl -L https://plesk.zendesk.com/hc/article_attachments/360017853154/action_log.zip -O

  3. Unpack the script:

    # unzip action_log.zip

  4. Execute the script:

    Note: The following command will return the Action Log records from 1st January 2020 to 30th January 2020 and the output will be saved in the file action_log. For more options run the script with the -h flag: plesk php ./action_log.php -h

    # plesk php ./action_log.php -f 01-01-2020 -t 30-01-2020 -o action_log

    If the following error is shown:

    CONFIG_TEXT: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 9437473 bytes) in action_log.php on line 327

    Run the command with custom memory_limit parameter, as an example:

    # plesk php -d memory_limit=512M ./action_log.php -f 01-01-2020 -t 30-01-2020 -o action_log

Plesk for Windows

  1. Connect to the server via RDP

  2. Start a command prompt as Administrator

  3. Switch to PowerShell:

    C:\> powershell

  4. Download the script:

    PS C:\> [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12; Invoke-WebRequest -URI https://plesk.zendesk.com/hc/article_attachments/360017853154/action_log.zip -OutFile action_log.zip

  5. Unpack the script:

    PS C:\> Add-Type -Assembly "System.IO.Compression.FileSystem"
    PS C:\> [System.IO.Compression.ZipFile]::ExtractToDirectory(($pwd).path + "\action_log.zip", ($pwd).path)

  6. Execute the script:

    Note: The following command is valid for PowerShell and CMD. It will return the Action Log records from 1st January 2020 to 30th January 2020 and the output will be saved in the file action_log. For more options run the script with the -h flag: plesk php ./action_log.php -h

    PS C:\> plesk php .\action_log.php -f 01-01-2020 -t 30-01-2020 -o action_log.txt

    If the following error is shown:

    CONFIG_TEXT: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 9437473 bytes) in action_log.php on line 327

    Run the command with custom memory_limit parameter, as an example:

    PS C:\> plesk php -d memory_limit=512M .\action_log.php -f 01-01-2020 -t 30-01-2020 -o action_log.txt

Comments

6 comments

Sort by Date Votes
  • Avatar
    Oxilion

    This article does not seem relevant to Plesk Onyx 17.8 anymore as the table format seems to have changed.

     

    $ action_log.sh
    ERROR 1054 (42S22) at line 1: Unknown column 'log_actions.action_id' in 'on clause'
    exit status 1

     

    There is no action_id table anymore.

    Would be nice to have a log viewer added to plesk cli via something like: plesk bin action_log

    Or just logging to a file in /var/log/plesk 

     

    Maybe this needs to be added to the uservoice pile of requests. :)

    0
    Comment actions Permalink
  • Avatar
    Gianluca

    Hello @Ivan, here the requested informations:

    Product version: Plesk Onyx 17.8.11 Update #18
        Update date: 2018/09/02 03:28
         Build date: 2018/08/24 12:47
         OS version: CentOS 7.5.1804

    mysql  Ver 15.1 Distrib 10.2.17-MariaDB, for Linux (x86_64) using readline 5.1

    0
    Comment actions Permalink
  • Avatar
    Gianluca

    The script file should be corrected, i receive the following error executing ./action_log.sh For Plesk version >= 17.8.11:

    [root@****** ~]# ./action_log.sh
    ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's interface preferences updated",' WHERE descr = 'client_preferences_update'' at line 1
    exit status 1

    0
    Comment actions Permalink
  • Avatar
    Alexandr Bashurov

    Hello @Gianluca,

    I have updated the script to work correctly with quotations in locale parameters.

    Please, try running it as per following commands:

    # curl -L https://plesk.zendesk.com/hc/article_attachments/360013148194/action_log.zip -O
    # unzip action_log.zip
    # php action_log.php
    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov (Edited )

    Hello @Gianluca,

    The error was not reproduced, see the output below. Please, let me know OS version and MariaDB version to reproduce the issue. Is Plesk version 17.8?

    # plesk -v
    Product version: Plesk Onyx 17.8.11 Update #18
    Update date: 2018/09/02 22:48
    Build date: 2018/08/24 17:47
    OS version: CentOS 7.5.1804

    # wget https://support.plesk.com/hc/en-us/article_attachments/360006831994/action_17_8.tar.gz && mv action_17_8.tar.gz action.tar.gz
    --2018-09-03 19:21:39-- https://support.plesk.com/hc/en-us/article_attachments/360006831994/action_17_8.tar.gz
    ...

     

    # tar -zvxf action.tar.gz
    action_log.sh
    # chmod +x action_log.sh
    # ./action_log.sh
    # ls action_log.txt
    action_log.txt

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @Oxilion

    Hello!

    Thank you for the feedback and the idea.

    I have created this feature suggestion.

    Plesk 17.8 is not released yet and some of the current articles do not support it. 

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles