OpenVPN System Based On User/Password Authentication with mysql & Day Control (lib-pam mysql) - Debian

OpenVPN System Based On User/Password Authentication with mysql &Day Control (lib-pam mysql) - Debian System detail: - OpenVPN Server, MySQL Server, IP = 1.1.1.1 - lib-pam MySQL - 1 user - many connections I. Install MySQL Server for User/Pass Authentication 1. Install MySQL Server apt-get install mysql-server 2. Log in MySQL as root mysql -uroot -p 3. Create the database 'openvpn' CREATE DATABASE openvpn; 4. Create a MySQL user with username 'USERNAME' and password 'PASSWORD' GRANT ALL ON openvpn.* TO 'USERNAME'@"%" IDENTIFIED BY 'PASSWORD'; 5. Log out root user exit; 6. Log in MySQL as new user 'USERNAME' mysql -uUSERNAME -pPASSWORD 7. Switch database USE openvpn; 8. Create user,...

Read more »

OpenVPN System Based On User/Password Authentication with mysql & Day Control (shell script)- Debian

OpenVPN System Based On User/Password Authentication with mysql &Day Control (shell script) - Debian System detail: - OpenVPN Server, IP = 1.1.1.1 - MySQL Server, IP = 2.2.2.2 - Shell script (Customize) - 1 user - many connections I. Install MySQL Server for User/Pass Authentication, IP = 2.2.2.2 1. Install MySQL Server apt-get install mysql-server 2. Log in MySQL as root mysql -uroot -p 3. Create the database 'openvpn' CREATE DATABASE openvpn; 4. Create a MySQL user with username 'USERNAME' and password 'PASSWORD' GRANT ALL ON openvpn.* TO 'USERNAME'@"%" IDENTIFIED BY 'PASSWORD'; 5. Log out root user exit; 6. Log in MySQL as new user 'USERNAME' mysql -uUSERNAME -pPASSWORD 7. Switch database ...

Read more »

MySQL update update more than one table

MySQL update update more than one table In a MySQL update statement you can update more than one table like this UPDATE tableA A JOIN tableB B ON A.ID = B.ID SET B.status = '1', B.status = '1' WHERE A.ID = 'ID' Or UPDATE C JOIN tableB B ON B.ID = C.ID JOIN tableA A ON A.ID = B.ID SET C.status = '1', A.status = '1' WHERE A.ID = '1' OR A.ID = '2' OR A.ID = '3...

Read more »

SQL query : count and result in MySQL

SQL query : count and result one query in MySQL Table: banks bank_id bank_name bank_abbrev 1 Bangkok BBL 2 Kasikornthai KBANK 3 Siam Commercial SCB 4 Krungthai KTB 5 Krungsri BAY SQL query: SELECT b.*, t.total FROM banks b LEFT JOIN ( SELECT count(*) AS total FROM banks ) AS t ON b.bank_id != -1 LIMIT 0, 3 Query results: bank_id bank_name bank_abbrev total 1 Bangkok BBL 5 2 Kasikornthai KBANK 5 3 Siam Commercial SCB 5 ...

Read more »

VirtualHost on Linux

VirtualHost on Linux Create file : /etc/apache2/sites-available/project <VirtualHost *:80> ServerAdmin admin@project ServerName project.dev DocumentRoot /home/Workspace/project <Directory /home/Workspace/project/> Options Indexes FollowSymLinks AllowOverride All Order allow,deny allow from all </Directory> ErrorLog "|/usr/sbin/rotatelogs /home/log/apache_logs/project/error.log.%Y-%m-%d-%H_%M_%S 86400" CustomLog "|/usr/sbin/rotatelogs /home/log/apache_logs/project/access.log.%Y-%m-%d-%H_%M_%S 86400" combined </VirtualHost> Make link ln -s /etc/apache2/sites-available/project /etc/apache2/sites-enabled/. Insert to file /etc/hosts 127.0.0.1 project.dev Create dir for log mkdir /home/log/apache_logs/project Restart Apache /etc/init.d/apache2...

Read more »

.htacceess: Invalid command 'RewriteEngine'

.htacceess: Invalid command 'RewriteEngine' You haven't loaded mod_rewrite. (as a superuser) a2enmod rewrite apache2ctl restar...

Read more »

sudoers command in root user

sudoers command in root user file : /etc/sudoers user_group ALL=(ALL) NOPASSWD: /usr/local/bin/command.sh #Cmnd_Alias COMMAND_USER = /usr/local/bin/command.sh #user_group ALL=(ALL) NOPASSWD: COMMAND_USE...

Read more »

ASP.NET Error The conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value.

ASP.NET Error The conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value. Can fix: userQuizDataSource.InsertParameters.Add( "DateTimeComplete", TypeCode.DateTime, DateTime.Now.ToString() )...

Read more »

ReadFile Encoding UTF-8 - java

ReadFile Encoding UTF-8 - java import java.io.BufferedReader; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStreamReader; public class ReadUTF8Data { private static final String FILE_ENCODE = "UTF-8"; public static void main(String[] args) { String data = null; BufferedReader dataIns = null; String file = ""; try { dataIns = new BufferedReader(new InputStreamReader( new FileInputStream(file), FILE_ENCODE)); while ((data = dataIns.readLine()) != null) { System.out.println("Line 1 :" + data); } dataIns.close(); dataIns = null; } catch (IOException e) { e.printStackTrace(); } } ...

Read more »