h & d Z ddlZddlZddlmZ ddlmZ ddlmZm Z ddl
m Z ej e
Z ed Zded ee fd
Zd ej d ee fd Zd ee fd
Zd ee fdZdee d dfdZded ee fdZdeded dfdZd ee fdZ deded dfdZ d ee fdZ ded e fdZ dS )u
This program is free software: you can redistribute it and/or modify it under
the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License,
or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see .
Copyright © 2019 Cloud Linux Software Inc.
This software is also available under ImunifyAV commercial license,
see
N)Path)SqliteDatabase)WPSite
WordpressSite) PLUGIN_SLUGzD/var/lib/cloudlinux-app-version-detector/components_versions.sqlite3pathreturnc < t s;t dt t t S t
t d| d }d | D S )z
Get a list of WordPress sites that match the given path.
Args:
path: The path to search for WordPress sites.
Returns:
A list of WPSite objects that match the path.
-App detector database '%s' couldn't be found.ak
WITH latest_reports AS (
SELECT id, uid, domain
FROM report
WHERE id IN (
SELECT MAX(id)
FROM report
WHERE domain IS NOT NULL
AND domain != ''
GROUP BY dir
)
)
SELECT wp.real_path, lr.domain, lr.uid
FROM apps AS wp
INNER JOIN latest_reports AS lr
ON wp.report_id = lr.id
WHERE wp.title = 'wp_core'
AND wp.parent_id IS NULL
AND wp.real_path LIKE 'z %'
c
p g | ]3}t |d |d t |d 4S r )docrootdomainuidr int.0rows S/opt/imunify360/venv/lib/python3.11/site-packages/imav/wordpress/site_repository.py
z%get_sites_by_path..L I s1vc!f#c!f++>>> ) COMPONENTS_DB_PATHexistsloggererrorstrlistr execute_sqlfetchall)r cursors r get_sites_by_pathr% % s $ $ & & ; " # #
vv
.
/
/
;
; $ %)% F, ??$$ r user_infoc t r| ;t dt t t S | (t d t S t
t d| j d }d | D S )aq
Get a set of paths to WordPress sites belonging to a particular user. Paths are sorted by their length to make sure
that the main site is the last one in the list.
The data is pulled from the app-version-detector database.
Args:
user_info: The user info with ID to get sites for.
Returns:
A list of paths to WordPress sites.
Nr z'No user info provided for getting sitesz
WITH latest_reports AS (
SELECT MAX(id) as id
FROM report
WHERE uid = a]
GROUP BY dir
)
SELECT wp.real_path
FROM apps AS wp
INNER JOIN latest_reports AS lr
ON wp.report_id = lr.id
WHERE wp.title = 'wp_core'
AND wp.parent_id IS NULL
GROUP BY wp.real_path
ORDER BY length(wp.real_path) DESC
c g | ]
}|d S )r r s r r z&get_sites_for_user..| s 0 0 0sCF 0 0 0r )
r r r r r r! r r" pw_uidr# )r& r$ s r get_sites_for_userr+ R s $ $ & & )*; ; " # #
vv
5
vv
.
/
/
;
; ' - F$ 1 0foo / / 0 0 00r c b t s;t dt t t S t
t dt j dd d } d |
D S )z
Get a set of wp sites where imunify-security plugin is not installed.
The data is pulled from the app-version-detector database.
Returns:
A set of WPSite objects where the plugin is not installed.
r a
WITH latest_reports AS (
SELECT id, uid, domain
FROM report
WHERE id IN (
SELECT MAX(id)
FROM report
WHERE domain IS NOT NULL
AND domain != ''
GROUP BY dir
)
)
SELECT wp.real_path, lr.domain, lr.uid
FROM apps AS wp
INNER JOIN latest_reports AS lr
ON wp.report_id = lr.id
WHERE wp.title = 'wp_core'
AND wp.parent_id IS NULL
AND NOT EXISTS (
SELECT 1
FROM apps AS plugin
WHERE plugin.parent_id = wp.id
AND plugin.title = 'wp_plugin_-_z'
)
c
p h | ]3}t |d |d t |d 4S r
r r s r z+get_sites_without_plugin.. r r ) r r r r r setr r" r replacer# )r$ s r get_sites_without_pluginr3 s $ $ & & ; " # #
uu
.
/
/
;
; , 0;/B3/L/L- F6 ??$$ r c b t } d t j D }| |z
S )a
Get a set of WordPress sites where we need to install the plugin.
This is determined by finding sites that don't have the plugin installed
and are not already tracked in our database.
Returns:
A set of WPSite objects where the plugin needs to be installed.
c 6 h | ]}t j | S r) r from_wordpress_siter rs r r0 z'get_sites_to_install.. s0 *+"1%% r )r3 r select)sites_without_pluginexisting_sitess r get_sites_to_installr= sD 455 /. sH
+ <x <'+
r )r insert_manyexecute)r> s r insert_installed_sitesrG sP
giiiiir latest_versionc | s t d g S d t j t j t j | k D S )a
Get a list of WordPress sites that have outdated plugin versions.
Args:
latest_version: The latest available plugin version to compare against.
Returns:
A list of WPSite objects that have versions older than latest_version.
z8Cannot get outdated sites without a valid latest versionc 6 g | ]}t j | S r) r6 r8 s r r z&get_outdated_sites.. s3
"1%% r )r r r r: whererB is_nullrA )rH s r get_outdated_sitesrM s F
%''-- - 5 5 7 7 !^ 3
r rD timestampc t d| | t j | t j | j k dS )z
Mark a WordPress site as manually deleted in the database.
Args:
site: The WPSite object to mark as deleted
timestamp: The timestamp when the site was deleted
z:Mark site %s as manually deleted at %s (WP-Plugin removed))rB N)r infor updaterK r rF )rD rN s r mark_site_as_manually_deletedrR s\ KKD ;;; }$ 4 5 5 r c t } d t j t j D }| |z S )a
Get a set of WordPress sites that should be marked as manually deleted.
These are sites that are in our database but no longer have the plugin installed.
Returns:
set[WPSite]: A set of WordPress sites that should be marked as manually deleted
c 6 h | ]}t j | S r) r6 r8 s r r0 z8get_sites_to_mark_as_manually_deleted.. s3
"1%% r )r3 r r: rK rB rL )r;
sites_from_dbs r %get_sites_to_mark_as_manually_deletedrV sf 455 %''-- - 5 5 7 7
M - //r rA c t j | t j | j k dS )z
Update the version of a WordPress site in the database.
Args:
site: The WPSite object to update
version: The new version to set
)rA N)r rQ rK r rF )rD rA s r update_site_versionrX sA )))// -
giiiiir c d t j t j d D S )z
Get a list of WordPress sites that haven't been marked as manually deleted.
Returns:
A list of WPSite objects representing non-deleted sites.
c 6 g | ]}t j | S r) r6 rC s r r z*get_sites_to_uninstall..1 s3 "4(( r T)r r: rK rB rL r) r r get_sites_to_uninstallr[ * sP !(**00 - 5 5d ; ;
r c t j t j | j k S )z
Delete a WordPress site from the database.
Args:
site: The WPSite object to delete
Returns:
The number of rows affected by the delete operation
)r deleterK r rF )rD s r delete_siter^ 9 s5 }$ 4 5 5 r )!__doc__loggingpwdpathlibr peeweer imav.model.wordpressr r imav.wordpressr getLogger__name__r r r r! r%
struct_passwdr+ r1 r3 r= rG rM floatrR rV rX r[ r r^ r) r r rj s0 *
! ! ! ! ! ! 6 6 6 6 6 6 6 6 & & & & & & 8 $ $TJ
*C *DL * * * *Z*1#"3 *1S *1 *1 *1 *1Z.#f+ . . . .b
1c&k
1
1
1
1 #f+ $ 2s tF| 2 5 T (0s6{ 0 0 0 0.
f
s
t
V f r