Algorithms, Design, Code and more: Php

Saturday, September 28, 2024

Sexy Polling Reloaded Extension (Plugin) on J4 with MySql 8

For anyone installing the plugin SexyPolling 4.1.7 on a Joomla 4.3.4 with a MySql 8.0 db on an Ubuntu system there may be issues with default value for Text fields. More specifically error in setting default value for country, city, etc TEXT fields:

    "BLOB, TEXT, GEOMETRY or JSON column 'country' can't have a default value"

1) There is a solution for MySql 8.0 to set DEFAULT values for TEXT fields. The CREATE statement for table `#_sexy_votes` needs to be changed to:

         // Modify the sexypolling plugin CREATE TABLE script:
            CREATE TABLE `#_sexy_votes` (
              `id_vote` int(10) unsigned NOT NULL AUTO_INCREMENT,
                  ....
              `country` text NOT NULL DEFAULT (_utf8mb4'Unknown'),
              `city` text NOT NULL DEFAULT (_utf8mb4'Unknown'),
              `region` text NOT NULL DEFAULT (_utf8mb4'Unknown'),
              `countrycode` text NOT NULL DEFAULT (_utf8mb4'Unknown'),
              PRIMARY KEY (`id_vote`),
                  .....
            ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

Further, in order for the CREATE table changes to take effect & not get dropped/ altered, a few of the plugin's installer scripts needs to be modified. The installation then needs to be done from a folder (or a modified zip file) in which the modified plugin installer scripts are present (instead of the downloaded joomla_plugin_sexypolling_reloaded_v4.1.7.zip file), as explained next.

2) Installation of plugin from /tmp folder

2.1) Unzip the downloaded joomla_plugin_sexypolling_reloaded_v4.1.7.zip file to the site /tmp folder as mentioned in the site configuration.php file (e.g. /var/www/html/<site_name>/tmp). Give the folder proper read/write permissions.

2.2) Change CREATE TABLE `#_sexy_votes` command in /tmp/com_sexypolling/admin/install/sql/install.sql:

Set the DEFAULT value for country, city, region, countrycode to "DEFAULT (_utf8mb4'Unknown')" as mentioned above.

2.3) Remove ALTER TABLE `#_sexy_votes` command from /tmp/com_sexypolling/scriptfile.php.

Put an invalid condition check on line 235 of the script to stop ALTER TABLE for `#_sexy_votes` to run:

$alterSexyVotes=false;

if($alterSexyVotes && is_array($columns_titles)) {

...

2.4) Finally, install:

Option A: Install from modified com_sexypolling folder: Install the extension from the folder /tmp/com_sexypolling from the J! "Admin" > "System" > "Install Extensions" > "Install from Folder" page.

Option B: Zip & Install modified com_sexypolling folder: Another option could be to manually zip the folder with the modifications (/tmp/com_sexypolling) & install using this zip file from the standard J! "Admin" > "System" > "Install Extensions" > "Upload Package File" page.

Friday, May 3, 2013

Php Script To Display Process, Vmstat, Disk Usage, Syslog Of A Linux Server Via A Browser

A Php script that executes some standard shell programs for monitoring resource utilization & processes on a given Linux box. The script directs the output to a web-browser.

Apache web-server should be installed on the server. To run copy the script to the DocumentRoot (/var/www/html). Appropriate execute rights (-rw-x) need to be given to the apache user (which runs this script, but is not the owner) to execute this Php file & to be able to access /var/log/syslog.

Save this file as: showHealth.php in the /var/www/html folder:

<html>
<body>
<script type="text/javascript">

</script>
<div id="outermost">
<div id="mcdetails">
Showing stats from:

<?php
echo shell_exec("ip addr show | grep 'inet' | tail -1");
?>
<br/><br/>Server Date is:
<?php
echo shell_exec("date");
?>
<br/><br/>
</div>
<a href="#" onclick="toggle('vmstat');">-------Vmstat----------</a><br/><br/>
<div id="vmstat" style="display:none">
<?php
$output = shell_exec("vmstat| sed 's/$/<br\/>/g'| sed 's/ /./g'");
echo $output;
?>
</div>
<br/><a href="#" onclick="toggle('df');">-------df -m----------</a><br/><br/>
<div id="df" style="display:none">
<?php
$output = shell_exec("df -m | sed 's/$/<br\/>/g'| sed 's/ /./g'");
echo $output;
?>
</div>
<br/><a href="#" onclick="toggle('ps');">-------ps aux----------</a><br/><br/>
<div id="ps" style="display:none">
<?php
$output = shell_exec("ps aux | sed 's/$/<br\/><br\/>/g'| sed 's/ /./g'");
//$output = shell_exec('ls -l');
echo $output;
?>
</div>
<br/><a href="#" onclick="toggle('syslogdiv');">-------syslog----------</a><br/><br/>

<div id="syslogdiv" style="display:none">
<?php
$output = shell_exec("tail -200 /var/log/syslog | sed 's/$/<br\/>/g' ");
//$output = shell_exec('ls -l');
echo $output;
?>
</div>
</div>
</body>
</html>