1.apt-get install mariadb-server
2.Setup rights for user root or zabbix or similar
3.mysql
4.create DB zabbix with collate utf8_bin
5.create user zabbix with correct rights on zabbix DB
6.apt-get install zabbix-server-mysql zabbix-frontend-php php-mysql
7./etc/init.d/mysql restart
8.a2enconf zabbix-frontend-php
9.nano /etc/php/7.3/apache2/php.ini
10.setup date.timezone in php.ini (Europe/Rome)
11.systemctl reload apache2
12.systemctl restart apache2
13.nano /etc/mysql/mariadb.conf.d/50-server.cnf
14.innodb_log_file_size = 500M
15.innodb_log_buffer_size = 800M
16.innodb_strict_mode = 0
17.cd /usr/share/zabbix-server-mysql/
18.gunzip *.gz
19.mysql -uzabbix -p zabbix < schema.sql
20.mysql -uzabbix -p zabbix < images.sql
21.mysql -uzabbix -p zabbix < double.sql
22.mysql -uzabbix -p zabbix < data.sql
23.systemctl reload apache2
24.systemctl restart apache2
25.http://zabbix
26.apt-get install zabbix-agent
27.nano /etc/zabbix/zabbix_server.conf (DBPassword)
28.systemctl enable zabbix-server
29.reboot
Articoli nella categoria Server
How to install Zabbix 6.0 on Debian 12
Backup Sql Server Express
Scheduled Tasks:
Execute .bat file, from the folder, choose une day
.bat File:
sqlcmd -S .\SQLEXPRESS -E -Q “EXEC sp_BackupDatabases @backupLocation=’C:\where_to_put_bak_file\’, @databaseName=’db_name’, @backupType=’F'”
How To Repair Broken EFI Partition
Steps:
- Enter Windows Setup or Windows Recovery to get cmd (Command Prompt)
- Make sure that both your Windows Partition and EFI Partition are assigned a drive letter
- Use diskpart utility to assign a letter to the EFI Partition (i.e.: T:)
- Make sure you know which drive letter each partition is assigned
- When you’ve got both partitions ready with a drive letter use this command:
- C:\Windows\System32\bcdboot C:\Windows /s T:
- That will cause the EFI bootloader files to be copied from you Windows Partition onto your EFI partition which should get it working.
Printer Spool Temp Files Path
C:\Windows\System32\Spool\Printers
Stop spool service
delete all files
start spool service
How To Repair Broken EFI Partition
Assign both your Windows partition and your EFI partition a drive letter. The EFI partition by default is not assigned a drive letter, but you can use diskpart to assign a letter temporarily. Then make sure you know which drive letter each partition is assigned in the environment you’re using. When you’ve got both partitions assigned a drive letter and you know which partition has which drive letter, modify the example command below as needed. In the command below, the EFI partition is X: and the Windows partition is C. Change those as needed for your setup:
C:\Windows\System32\bcdboot C:\Windows /s X:
That will cause the EFI bootloader files from your Windows partition to be copied onto your EFI partition, which should get it working.
If it doesn’t work, try formatting your EFI partition as FAT32 just to erase it and start from scratch, then try running that command again. Again, that command is what Windows Setup runs when it first installs Windows in order to set up the EFI partition, so it should be able to get you a working EFI partition again.
Create Desktop Shortcuts via GPO
- User Conguration
- Preferences
- Windows Settings
- Shortcuts
- New -> Shortcut
- update
- name of the link ( myfolder\mylink )
- file system object
- Desktop
- \\mypath\mylink
How to setup a network interface on Debian 10
nano /etc/network/interfaces
allow-hotplug ens192
iface ens192 inet static
address 192.168.xx.yy
netmask 255.255.255.0
gateway 192.168.xx.yyy
dns-nameservers 192.168.xx.z 192.168.xx.w 192.168.xx.t
dns-search mydomain.mytld
Symbolic Link on Windows
c:> mklink /d c:\some\directory \\some_server\some_share
This will create a folder named c:\some\directory which will show the content of the share \\some_server\some_share.
This will work also with a remote disk with i.e. \\some_server\C$.
How to connect to Sql Server 2017 from php on debian 10
apt-get update
apt-get install unixodbc unixodbc-dev php-odbc php-cli
wget https://packages.microsoft.com/debian/10/prod/pool/main/m/msodbcsql17/msodbcsql17_17.4.1.1-1_amd64.deb
odbcinst -i -d -f /opt/microsoft/msodbcsql17/etc/odbcinst.ini
nano /etc/odbc.ini
[MySQLServerDB]
Description = Database SqlServerDB
Driver = ODBC Driver 17 for SQL Server
Server = server[,port]
Recent Comments