Solon Zenetzis, Author at SBZ Systems

Convert tables from innodb to MyISAM – WordPress

This is a simple script for WordPress that converts all the tables from innodb to MyISAM. Some times this operation improves the speed of saving a page or post from admin panel.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

<?php

// DEVELOPED BY SBZ

// $host = 'localhost';

// $user = '';

// $password = '';

// $db = '';

require 'wp-config.php';

$host = DB_HOST;

$user = DB_USER;

$password = DB_PASSWORD;

$db = DB_NAME;

$link=mysqli_connect("$host", $user, $password) or die(mysqli_error($link));

mysqli_select_db($link,"$db") or die(mysqli_error($link));

$sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = '$db'

AND ENGINE = 'InnoDB'";

$rs = mysqli_query($link,$sql);

while($row = mysqli_fetch_array($rs))

{

$tbl = $row[0];

echo $tbl.' ';

$sql = "ALTER TABLE `$tbl` ENGINE=MyISAM";

mysqli_query($link,$sql);

}

?>

You can try it when it is very slow to save changes in a WordPress page or post.

Solon Zenetzis Last modified.: 06/05/2019 Free source (Delphi, PHP, Perl)

Programmatically selecting a TTreeView node by index – Delphi

Here’s an example that has will show you how to programmatically select a TTreeView node via index number

1

2

3

4

5

6

7

8

9

for i:=0 to TreeView1.Items.Count - 1 do begin

if TreeView1.Items[i].SelectedIndex = indexno then begin

TreeView1.Select(TreeView1.Items[i]);

TreeView1.SetFocus;

break;

end;

Solon Zenetzis Free source (Delphi, PHP, Perl)

Change varchar character set to UTF8 in Firebird database

Bellow is a firebird SQL script that will help you easily to change the character set of all varchar fields of a database.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

execute block

returns (fieldname char(1000),fieldlength int)

as

declare cur cursor for

(

select T1.RDB$FIELD_NAME, T1.RDB$FIELD_LENGTH

from RDB$FIELDS T1, RDB$RELATION_FIELDS T2

where T1.RDB$FIELD_TYPE = 37 and

T2.RDB$VIEW_CONTEXT is null and

T1.RDB$FIELD_NAME = T2.RDB$FIELD_SOURCE and

T1.RDB$CHARACTER_SET_ID<>4 and

not T2.RDB$RELATION_NAME like 'RDB$%' and

not T2.RDB$RELATION_NAME like 'MON$%'

);

begin

open cur;

while (1=1) do

begin

fetch cur into fieldname, fieldlength;

update RDB$FIELDS set

RDB$CHARACTER_SET_ID = 4,

RDB$FIELD_LENGTH = :fieldlength*4,

RDB$CHARACTER_LENGTH = :fieldlength

where RDB$FIELD_NAME = :fieldname;

if (row_count = 0) then leave;

suspend;

end

close cur;

end

Solon Zenetzis Last modified.: 07/04/2019 Databases issues and tips

Problem with opening call monitoring recording file, 404 File not found! (Elastix)

If each time you try to open monitor recordings on Elastix you receive the message 404 File not found!, this is a simple solution for the issue (worked for elastix-2.5.0-1): Go to

1	/var/www/html/modules/monitoring

and edit index.php On line 384 insert the line:

1	$namefile=str_replace(" ","+",$namefile);

so it will look like that:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

...

if (is_null($record) || !preg_match('/^[[:digit:]]+\.[[:digit:]]+$/', $record)) {

// Missing or invalid uniqueid

Header('HTTP/1.1 404 Not Found');

die("404 "._tr("no_file")." ");

}

// Check record is valid and points to an actual file

$namefile=str_replace(" ","+",$namefile);

$filebyUid = $pMonitoring->getAudioByUniqueId($record, $namefile);

if (is_null($filebyUid) || count($filebyUid) <= 0) {

// Uniqueid does not point to a record with specified file

Header('HTTP/1.1 404 Not Found');

die("404 "._tr("no_file")." ");

}

...

save it.

Solon Zenetzis Last modified.: 26/01/2019 Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Secure Issabel and Elastix PBX (asterisk)

Change default sip port from 5060 to something else for example 11333.

1 2	cd /etc/asterisk nano sip_general_custom.conf

add the following to the file:

1	bindport=5060

(Change 5060 to your new port).

1 2	amportal stop amportal start

Don’t forget to add the new port into Fail2Ban.

1 2	cd /etc/fail2ban nano jail.local

Define the new port on firewall Disable unused rules and add a one with the new port Reduce […]

Solon Zenetzis Last modified.: 10/12/2018 Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Wincor Nixdorf customer display setup

In order to set up the customer display of Wincor Nixdorf Ba63 and Ba64 models (BA64_Operating_Manual_english.pdf) follow these steps: 1. Install spos.exe (activate the option for RS232 device connector during EMDI installation). 2. Edit (with any notepad) the file sposbridge.ini (in EMDI installation folder) to look like the following (copy and paste):

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

[Display]

hexcommands_line2=$1b$5b$32$3b$30$31$48

hexcommands_line1=$1b$5b$31$3b$30$31$48

oem=0

datafolder=C:\Users\user\AppData\Local\Temp\

epson_mode=0

keyword_change=Change

keyword_total=Value

only_numbers=0

ad5=

ad4=

ad3=

ad2= * EMDI RESTAURANT *

ad1= * SBZ SYSTEMS *

maintext=Next Customer

currencychar=€

totaltitle=Total

charsperline=20

parity=Odd

stopbits=1

databits=8

BaudRate=9600

Port=COM1

Title=Display

3. User […]

Solon Zenetzis Last modified.: 02/05/2019 Installation / Uninstallation / Issues

Delete cache on TablePress plugin for WordPress

TablePress cache saved on database. So in order to delete it you have to execute:

1

2

3

4

delete FROM `wp_options`

where option_name like '_transient_tablepress_c%'

or option_name like '_transient_timeout_tablepress_c%'

Solon Zenetzis Web development

Easy ISPConfig installation on Ubuntu 18

After a successful ubuntu installation type the following:

1

2

3

4

5

6

7

apt-get update && apt-get -y upgrade

apt-get install -y unzip

cd /tmp

wget --no-check-certificate -O installer.tgz "https://github.com/servisys/ispconfig_setup/tarball/master"

tar zxvf installer.tgz

cd *ispconfig*

bash install.sh

Source: https://www.howtoforge.com/tutorial/ispconfig-automated-install-script/

Solon Zenetzis Linux general issues

Easy install Issabel PBX on Centos 7

After a successful centos installation type the following:

1

2

3

yum update

yum -y install wget

wget -O - http://repo.issabel.org/issabel4-netinstall.sh | bash

Source: https://forum.issabel.org/d/1145-install-in-a-vps

Solon Zenetzis Last modified.: 02/11/2018 Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Let’s Encrypt certificate installation problem (Issabel PBX)

If you try to install Let’s Encrypt certificate via Issabel web interface and it is failed you can installed from ssh.

1 2	cd \etc letsencrypt certonly --standalone -d sbz-tel.freeextra.com

If you get the message “Problem binding to port 80: Could not bind to IPv4 or IPv6.” try

1

2

3

4

service httpd stop

cd /etc

letsencrypt certonly --standalone -d yourdomain.com

service httpd start

After the certification creation via ssh, you can renew it easily via web interface.

Solon Zenetzis Asterisk (Issabel, FreePBX, Elastix, Trixbox)

Author: sbz