How to fetch Plesk Action Log using the command line

Follow

Comments

6 comments

  • 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. :)

  • 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. 

  • 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

  • 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

  • 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

  • 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

Please sign in to leave a comment.

Have more questions? Submit a request