Ubuntu : Apache2 Set Port Number

Post by Goborijung at 2020-04-01 09:08:02 | ID: 455

> apache2 set port number
$ nano /etc/apache2/ports.conf

Ubuntu : Check Mysql Version

Post by Goborijung at 2020-03-28 12:34:16 | ID: 442

ตรวจสอบเวอร์ชั่น MySQL ด้วยคำสั่ง V
$ mysql -V

ค้นหาหมายเลขเวอร์ชัน
$ mysql -u root -p
SHOW VARIABLES like '%version%';

เลือก Version
SELECT VERSION();

ดูสถานะ
STATUS;

คำสั่ง Restart Mysql
$ service mysql restart

> ดู Mysql Status Running
$ service mysql status

> ตั้งค่า MySQL บน Ubuntu Server
$ sudo nano /etc/mysql/mysql.conf.d/mysqld.conf

หาบรรทัดที่เขียนว่า bind-address  = 127.0.0.1
เสร็จแล้วให้รีสตาร์ท mysql service ใหม่
$ sudo service mysql restart

Ubuntu : Check Ubuntu Version

Post by Goborijung at 2020-12-22 23:04:34 | ID: 931

lsb_release -a

Ubuntu : Hot to Re-Install PHP Version , php version , install php , enmode php version

Post by Goborijung at 2021-04-28 11:16:10 | ID: 1147

$ sudo apt purge libapache2-mod-php8.0 libapache2-mod-php
$ sudo apt-get install libapache2-mod-php8.0
$ sudo a2enmod php8.0
$ sudo service apache2 stop
$ sudo service apache2 start
$ sudo service apache2 restart

Ubuntu : How to Re-Install apache

Post by Goborijung at 2021-04-28 10:48:40 | ID: 1146

ทำการลบไฟล์กำหนดค่า apache2 อย่างสมบูรณ์
sudo apt-get purge apache2

ทำการติดตั้งใหม่ได้ตามปกติ
sudo apt-get install apache2

Ubuntu : How to fix : Can t connect to local MySQL server through socket /var/run/mysqld/mysqld.sock

Post by Goborijung at 2020-05-23 09:42:50 | ID: 565

https://www.youtube.com/watch?v=Ue6lPF10wC0

/* Apache Part */
Start Apache 2 Server
$ /etc/init.d/apache2 start

Restart Apache 2 Server
$ /etc/init.d/apache2 restart

Stop Apache 2 Server
$ /etc/init.d/apache2 stop

Check Apache 2 Status
$ systemctl status apache2.service

/* Mysql Part */
$ /etc/init.d/mysql start
$ /etc/init.d/mysql restart

> Test
mysql -u root -p

service mysql restart

Ubuntu : How to Install Driver for PHP for SQL Server on Ubuntu 16.04 : v1

Post by Goborijung at 2021-04-28 11:51:42 | ID: 1149

How to Install Driver for PHP for SQL Server on Ubuntu 16.04
Ref: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#ubuntu17

>> Installing on Ubuntu
Ubuntu versions 16.04, 18.04, and 20.04 are supported.

Step 1. Install PHP (Ubuntu)
sudo su
add-apt-repository ppa:ondrej/php -y
apt-get update
apt-get install php8.0 php8.0-dev php8.0-xml -y --allow-unauthenticated
*กรณี Error: Could not get lock /var/lib/dpkg/lock-frontend - open
ให้เข้าไปแก้ที่ Link นี้ : https://snappytux.com/how-to-fix-e-could-not-get-lock-var-lib-dpkg-lock-error-on-ubuntu/

Step 2. Install prerequisites (Ubuntu)
Ref: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

#Download appropriate package for the OS version
#Choose only ONE of the following, corresponding to your OS version

#Ubuntu 16.04
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

#Ubuntu 18.04
curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

#Ubuntu 20.04
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

#Ubuntu 20.10
curl https://packages.microsoft.com/config/ubuntu/20.10/prod.list > /etc/apt/sources.list.d/mssql-release.list

exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo apt-get install -y unixodbc-dev

Step 3. Install the PHP drivers for Microsoft SQL Server (Ubuntu)
sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
sudo su
printf "; priority=20
extension=sqlsrv.so
" > /etc/php/8.0/mods-available/sqlsrv.ini
printf "; priority=30
extension=pdo_sqlsrv.so
" > /etc/php/8.0/mods-available/pdo_sqlsrv.ini
exit
sudo phpenmod -v 8.0 sqlsrv pdo_sqlsrv
*Fix install pecl install sqlsrv is Error: https://github.com/microsoft/msphpsql/issues/1081

Step 4. Install Apache and configure driver loading (Ubuntu)
sudo su
apt-get install libapache2-mod-php8.0 apache2
a2dismod mpm_event
a2enmod mpm_prefork
a2enmod php8.0
exit

Step 5. Restart Apache and test the sample script (Ubuntu)
sudo service apache2 restart

Step 6. Testing Installation
Ref: https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#testing-your-installation
>> SQLSRV example
<?php
$serverName = "yourServername";
$connectionOptions = array(
    "database" => "yourDatabase",
    "uid" => "yourUsername",
    "pwd" => "yourPassword"
);

function exception_handler($exception) {
    echo "<h1>Failure</h1>";
    echo "Uncaught exception: " , $exception->getMessage();
    echo "<h1>PHP Info for troubleshooting</h1>";
    phpinfo();
}

set_exception_handler('exception_handler');

// Establishes the connection
$conn = sqlsrv_connect($serverName, $connectionOptions);
if ($conn === false) {
    die(formatErrors(sqlsrv_errors()));
}

// Select Query
$tsql = "SELECT @@Version AS SQL_VERSION";

// Executes the query
$stmt = sqlsrv_query($conn, $tsql);

// Error handling
if ($stmt === false) {
    die(formatErrors(sqlsrv_errors()));
}
?>

<h1> Success Results : </h1>

<?php
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    echo $row['SQL_VERSION'] . PHP_EOL;
}

sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);

function formatErrors($errors)
{
    // Display errors
    echo "<h1>SQL Error:</h1>";
    echo "Error information: <br/>";
    foreach ($errors as $error) {
        echo "SQLSTATE: ". $error['SQLSTATE'] . "<br/>";
        echo "Code: ". $error['code'] . "<br/>";
        echo "Message: ". $error['message'] . "<br/>";
    }
}
?>

// PDO_SQLSRV example
<?php
try {
    $serverName = "yourServername";
    $databaseName = "yourDatabase";
    $uid = "yourUsername";
    $pwd = "yourPassword";
    
    $conn = new PDO("sqlsrv:server = $serverName; Database = $databaseName;", $uid, $pwd);

    // Select Query
    $tsql = "SELECT @@Version AS SQL_VERSION";

    // Executes the query
    $stmt = $conn->query($tsql);
} catch (PDOException $exception1) {
    echo "<h1>Caught PDO exception:</h1>";
    echo $exception1->getMessage() . PHP_EOL;
    echo "<h1>PHP Info for troubleshooting</h1>";
    phpinfo();
}

?>

<h1> Success Results : </h1>

<?php
try {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        echo $row['SQL_VERSION'] . PHP_EOL;
    }
} catch (PDOException $exception2) {
    // Display errors
    echo "<h1>Caught PDO exception:</h1>";
    echo $exception2->getMessage() . PHP_EOL;
}

unset($stmt);
unset($conn);
?>

Ubuntu : How to Install the Microsoft ODBC Driver for SQL Server for Ubuntu 16.04 : v2

Post by Goborijung at 2021-04-28 11:50:16 | ID: 1148

1. Install the Microsoft ODBC Driver for SQL Server
sudo su  
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -  

# Download appropriate package for the OS version. Choose only ONE of the following, corresponding to your OS version  
# Ubuntu 16.04, change to 18.04 for bionic
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list  
exit 
sudo apt-get update 
sudo ACCEPT_EULA=Y apt-get install msodbcsql17 

# For unixODBC development headers 
sudo apt-get install unixodbc-dev mssql-tools

2. Install the Microsoft Drivers for PHP for SQL Server
sudo apt-get -y install php-pear php7.2-dev
sudo pecl install sqlsrv 
sudo pecl install pdo_sqlsrv

3. Load
ตรวจสอบให้แน่ใจว่าได้เพิ่มไฟล์ไดรเวอร์สองไฟล์ (sqlsrv.so และ pdo_sqlsrv.so) ไปยัง /usr/lib/php/20170718
(เส้นทางของคุณอาจแตกต่างออกไปเพียงตรวจสอบเส้นทางไลบรารีไดนามิก php ของคุณ)
sudo su 
echo "extension=sqlsrv.so" > /etc/php/8.0/mods-available/sqlsrv.ini
echo "extension=pdo_sqlsrv.so" > /etc/php/8.0/mods-available/pdo_sqlsrv.ini
exit

echo "extension=sqlsrv.so" > /etc/php/8.0/mods-available/sqlsrv.ini
echo "extension=pdo_sqlsrv.so" > /etc/php/8.0/mods-available/pdo_sqlsrv.ini

/*
คำสั่ง ln -s <file1> <file2> : ตัวอย่าง ln -s test1 test3 จะทำการสร้าง symbolic(สัญลักษณ์) link test3 ไปยัง test1
Ref : https://saixiii.com/ln-linux-command/
*/

# Enable sqlsrv extensions for apache2
ln -s /etc/php/8.0/mods-available/sqlsrv.ini /etc/php/8.0/apache2/conf.d/sqlsrv.ini
ln -s /etc/php/8.0/mods-available/pdo_sqlsrv.ini /etc/php/8.0/apache2/conf.d/pdo_sqlsrv.ini

# Enable sqlsrv extensions for CLI
ln -s /etc/php/8.0/mods-available/sqlsrv.ini /etc/php/8.0/cli/conf.d/sqlsrv.ini
ln -s /etc/php/8.0/mods-available/pdo_sqlsrv.ini /etc/php/8.0/cli/conf.d/pdo_sqlsrv.ini

หรือ

ln -s /etc/php/8.0/mods-available/sqlsrv.ini /etc/php/8.0/cli/conf.d/20-sqlsrv.ini
ln -s /etc/php/8.0/mods-available/pdo_sqlsrv.ini /etc/php/8.0/cli/conf.d/20-pdo_sqlsrv.ini

# Enable sqlsrv extensions for FPM
sudo ln -s /etc/php/8.0/mods-available/sqlsrv.ini /etc/php/8.0/fpm/conf.d/sqlsrv.ini
sudo ln -s /etc/php/8.0/mods-available/pdo_sqlsrv.ini /etc/php/8.0/fpm/conf.d/pdo_sqlsrv.ini

4. Test!
Test Connection to Database

Ubuntu : How to Remove Tor

Post by Goborijung at 2020-05-21 09:39:43 | ID: 560

>> Uninstall tor
To remove just tor package itself from Ubuntu 16.04 (Xenial Xerus) execute on terminal:

$ sudo apt-get remove tor

>> Uninstall tor and it's dependent packages
To remove the tor package and any other dependant package which are no longer needed from Ubuntu Xenial.

$ sudo apt-get autoremove tor

>> Purging tor
If you also want to delete configuration and/or data files of tor from Ubuntu Xenial then this will work:

$ sudo apt-get purge tor

>> To delete configuration and/or data files of tor and it's dependencies from Ubuntu Xenial then execute:

$ sudo apt-get autoremove --purge tor

Ubuntu : How to Use Sqlcmd connect to Remote Database

Post by Goborijung at 2021-04-26 16:22:13 | ID: 1142

How to Use Sqlcmd
------------------------------------------
1 ทดลองเชื่อมต่อ Remote Database
sqlcmd -S 172.16.0.28 -U sa
password:

2 Show all Database
select name from sys.databases
go

3 Use Database Name
use GSS_Test
go

4. Show all Tables
select name from sys.tables
go

5. Retrive Data From Table
select * From Carton
go