How to install SQL Buddy on OpenSUSE 42.1

To install SQL Buddy on OpenSUSE 42.1

SQL Buddy is an open source web based tool was written in PHP language that intended to manage SQLite and MySQL administration via web browsers like Firefox, Chrome, Safari, Opera and IE+ (Internet Explorer). SQL buddy offers a well-designed interface with a comprehensive feature set for database administrators and programmers. This tutorial covers the installation procedure of SQL Buddy on OpenSUSE 42.1.

Installation procedure

Before beginning the installation procedure, move to Apache document by running the following command.

linuxhelp:~ # cd /srv/www/htdocs/

Now go to its official website and get the SQL Buddy package link for downloading it using wget command.

linuxhelp:/srv/www/htdocs # wget https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
--2017-09-28 10:17:29--  https://github.com/calvinlough/sqlbuddy/raw/gh-pages/sqlbuddy.zip
Resolving github.com (github.com)... 192.30.255.112, 192.30.255.113
Connecting to github.com (github.com)|192.30.255.112|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://raw.githubusercontent.com/calvinlough/sqlbuddy/gh-pages/sqlbuddy.zip [following]
--2017-09-28 10:17:30--  https://raw.githubusercontent.com/calvinlough/sqlbuddy/gh-pages/sqlbuddy.zip
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.8.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.8.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 385517 (376K) [application/zip]
Saving to: ‘ sqlbuddy.zip’ 
100%[=========================================================================================================================================================================> ] 385,517      335KB/s   in 1.1s   

2017-09-28 10:17:32 (335 KB/s) - ‘ sqlbuddy.zip’  saved [385517/385517]

Extract the downloaded package using unzip command.

linuxhelp:/srv/www/htdocs # unzip sqlbuddy.zip
Archive:  sqlbuddy.zip
   creating: sqlbuddy/
  inflating: sqlbuddy/ajaxcreatetable.php  
  inflating: sqlbuddy/ajaxfulltext.php  
  inflating: sqlbuddy/ajaximportfile.php  
  inflating: sqlbuddy/ajaxquery.php  
  inflating: sqlbuddy/ajaxsavecolumnedit.php  
  inflating: sqlbuddy/ajaxsaveedit.php  
  inflating: sqlbuddy/ajaxsaveuseredit.php  
  inflating: sqlbuddy/browse.php     
  inflating: sqlbuddy/config.php     
   creating: sqlbuddy/css/
.
.
.
.
inflating: sqlbuddy/themes/classic/images/corner-bl.png  
  inflating: sqlbuddy/themes/classic/images/corner-br.png  
  inflating: sqlbuddy/themes/classic/images/corner-tl.png  
  inflating: sqlbuddy/themes/classic/images/corner-tr.png  
  inflating: sqlbuddy/themes/classic/images/header.png  
  inflating: sqlbuddy/themes/classic/images/shading.png  
  inflating: sqlbuddy/users.php      

Provide the owner permission and file execution permission by executing the following set of commands.

linuxhelp:/srv/www/htdocs # chown -R wwwrun:www /srv/www/htdocs/sqlbuddy
linuxhelp:/srv/www/htdocs # chmod -R 777 /srv/www/htdocs/sqlbuddy

Restart the Apache service.

linuxhelp:/srv/www/htdocs/sqlbuddy # systemctl restart apache2

Switch over to the browser and enter http://your ip/sqlbuddy URL and hit enter. The login page of SQL Buddy appears on the screen.

Enter the required credentials and the admin page of SQL Buddy is shown.

The installation procedure of SQL Buddy on OpenSUSE 42.1 is done successfully.