Script must be into the Alert Script folder path. Default value is:
/etc/zabbix/alert.d
Let’s create our test.php file with execution permissions:
chmod a+x test.php
File must start with these lines:
#!/usr/bin/php
In Zabbix web interface make sure you set these values:
Get-ADUser -Filter * -SearchBase "DC=domain,DC=local" -Properties whenCreated | export-csv -Path c:\path\to\file.csv
https://www.tecmint.com/extend-and-reduce-lvms-in-linux/
File must start with declaration code and PHP start tag:
#!/usr/bin/php <?php
File must end with PHP end tag:
?>
In the middle you can put all PHP code you want and remember that parameters are passed via the variable:
$argv[]
insert
allow_writeable_chroot=YES
into:
/etc/vsftpd/vsftpd.conf
This is a secure solution for having a web server for many sites. With this you can specify which server user will be used for which site so apache will execute the code (mainly php) with that user preventing file system access to bad code.
On a fresh Debian 9 installation (with just SSH Server installed) let’s do:
apt-get install libapache2-mpm-itk libapache2-mod-php7.0
We’ll now enable that modules that could be useful and the one necessary:
a2enmod mpm_itk a2enmod rewrite
Now let’s configure a virtualhost:
cd /etc/apache2/sites-available touch my_website.conf nano my_website.conf
and put this inside the file (obviously you can change settings as you need):
<VirtualHost *:80>
ServerName my_website
ServerAdmin paolo@my_website
DocumentRoot /home/www/my_website/home/
<IfModule mpm_itk_module>
AssignUserId my_username my_usergroup
</IfModule>
<Directory /home/www/my_website/home/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
</Directory>
</VirtualHost>
Let’s activate my_website:
a2ensite my_website
At this point we need to create the user and the group we indicate into the file:
useradd -d /home/www/my_website -s /usr/sbin/nologin my_username
and the folders onto the path:
mkdir /home/www mkdir /home/www/my_website mkdir /home/www/my_website/home cd /home/www/my_website chown -R my_username:my_username home/
At this point we have a virtualhost that points to a folder path where apache will run scripts as my_username user.
Therefore it’s possibile to configure mysql o any other service to make this webserver richer of functions.
Connection String for quering an odbc AS400 database via powershell:
$query = "SELECT * FROM my_table"
$conn = New-Object System.Data.Odbc.OdbcConnection
$conn.ConnectionString = "Driver={iSeries Access ODBC Driver};System=my-as400-server;Uid=User;Pwd=Password;"
$conn.Open()
$cmd = New-Object System.Data.Odbc.OdbcCommand($query, $conn)
$cmd.CommandTimeout = 15
$ds = New-Object system.Data.DataSet
$da = New-Object system.Data.odbc.odbcDataAdapter($cmd)
[void]$da.fill($ds)
$conn.close()
$result = $ds.tables[0]
foreach ($Row in $ds.Tables[0].Rows) {
write-Output "$($Row.field1)"
write-Output "$($Row.field2)"
}
allow-hotplug ens192 iface ens192 inet static address 192.168.1.2 netmask 255.255.255.0 gateway 192.168.1.254 dns-nameservers 192.168.21.1 192.168.11.11 192.168.31.253 dns-search mydomain.mytld