Debian Linux 安装firebird 数据库并基本设置

今天在QQ上,有网友问我能否将FIREBIRD数据库迁移到unix/Linux,并作优化。俺心想,这个数据库平时比较小众,不像ORACLE,DB2,MYSQL这些数据库那么普遍,就不妨研究一下,就想着在LINUX下安装一套FIREBIRD数据库。

下面为安装过程:

首先就想着在centos  安装,首先yum search firebird,发现centos没有收录firebrid数据库。

root@co1 ~]# yum search Firebird
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Warning: No matches found for: Firebird
No Matches found

那么,就只能从官网拉源代码包,准备编译安装。
[root@co1 ~]# which wget
/usr/bin/wget
[root@co1 ~]# pwd
/root
[root@co1 ~]# wget https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0.amd64.tar.gz

解压源代码,发现只有三个文件,并且有一个install.sh文件:

[root@co1 install]# cd Firebird/
[root@co1 Firebird]# ls
Firebird-3.0.4.33054-0.amd64.tar.gz
[root@co1 Firebird]# tar zxvf *.tar.gz
Firebird-3.0.4.33054-0.amd64/
Firebird-3.0.4.33054-0.amd64/install.sh
Firebird-3.0.4.33054-0.amd64/buildroot.tar.gz
Firebird-3.0.4.33054-0.amd64/manifest.txt
[root@co1 Firebird]# cd Firebird-3.0.4.33054-0.amd64
[root@co1 Firebird-3.0.4.33054-0.amd64]# ls
buildroot.tar.gz install.sh manifest.txt

安装firebird.如下:

[root@co1 Firebird-3.0.4.33054-0.amd64]# ./install.sh

阅读更多

在debian9.3下面安装与设置Oracle jdk1.8的最好方法

1、ssh  login到debian9 系统

2、切换到rott用户:sudo su-  OR  su –

3、下载oracle jdk1.8

###32 bit ###

# wget –no-check-certificate –no-cookies –header “Cookie: oraclelicense=accept-securebackup-cookie” http://download.oracle.com/otn-pub/java/jdk/8u152-b16/aa0333dd3019491ca4f6ddbe78cdb6d0/jdk-8u152-linux-i586.tar.gz

### 64 Bit ###

# wget –no-check-certificate –no-cookies –header “Cookie: oraclelicense=accept-securebackup-cookie” http://download.oracle.com/otn-pub/java/jdk/8u152-b16/aa0333dd3019491ca4f6ddbe78cdb6d0/jdk-8u152-linux-x64.tar.gz

4、解压jdk.tar.gz  文件并移到/usr/local/目录:

#tar -zxvf jdk-8u*-linux-*.tar.gz

#  mv jdk1.8.*/ /usr/local/

5、安装oracle jdk1.8

# update-alternatives –install /usr/bin/java java /usr/local/jdk1.8.*/bin/java 2

# update-alternatives –config java

阅读更多

Debian 9.x “stretch” 解决 /etc/rc.local 开机启动问题

Debian 9.x “stretch” 解决 /etc/rc.local 开机启动问题

由于某些软件并没有增加开启启动的服务,很多时候需要手工添加,一般我们都是推荐添加命令到 /etc/rc.local 文件,但是 Debian 9 默认不带 /etc/rc.local 文件,而 rc.local 服务却还是自带的

root@debian9 ~ # cat /lib/systemd/system/rc.local.service

#  This file is part of systemd.

#

#  systemd is free software; you can redistribute it and/or modify it

#  under the terms of the GNU Lesser General Public License as published by

#  the Free Software Foundation; either version 2.1 of the License, or

#  (at your option) any later version.

 

# This unit gets pulled automatically into multi-user.target by

# systemd-rc-local-generator if /etc/rc.local is executable.

[Unit]

Description=/etc/rc.local Compatibility

ConditionFileIsExecutable=/etc/rc.local

After=network.target

阅读更多

Debian9.3-安装 apache2 MariaDB10 PHP7 安装实录

root@debian:~# apt update
忽略:1 cdrom://[Debian GNU/Linux 9.3.0 _Stretch_ – Official amd64 xfce-CD Binary-1 20171209-12:11] stretch InRelease
错误:2 cdrom://[Debian GNU/Linux 9.3.0 _Stretch_ – Official amd64 xfce-CD Binary-1 20171209-12:11] stretch Release
请使用 apt-cdrom,通过它可以让 APT 识别该盘片。apt-get upgdate 不能被用来加入新的盘片。
忽略:3 http://mirrors.163.com/debian stretch InRelease
命中:4 http://security.debian.org/debian-security stretch/updates InRelease
命中:5 http://mirrors.163.com/debian stretch Release
正在读取软件包列表… 完成
E: 仓库 “cdrom://[Debian GNU/Linux 9.3.0 _Stretch_ – Official amd64 xfce-CD Binary-1 20171209-12:11] stretch Release” 没有 Release 文件。
N: 无法安全地用该源进行更新,所以默认禁用该源。
N: 参见 apt-secure(8) 手册以了解仓库创建和用户配置方面的细节。
root@debian:~# ping www.gznet.com
PING www.gznet.com (202.104.94.3) 56(84) bytes of data.
^C
— www.gznet.com ping statistics —
2 packets transmitted, 0 received, 100% packet loss, time 1023ms

root@debian:~# ping www.163.com
PING 163.xdwscache.ourglb0.com (125.90.206.143) 56(84) bytes of data.
64 bytes from 125.90.206.143 (125.90.206.143): icmp_seq=1 ttl=128 time=43.7 ms
64 bytes from 125.90.206.143 (125.90.206.143): icmp_seq=2 ttl=128 time=31.7 ms
^C
— 163.xdwscache.ourglb0.com ping statistics —
2 packets transmitted, 2 received, 0% packet loss, time 1005ms
rtt min/avg/max/mdev = 31.742/37.740/43.738/5.998 ms
root@debian:~# cd /etc/apt/sources.list.d/
root@debian:/etc/apt/sources.list.d# ls

root@debian:/etc/apt/sources.list.d# cd ..
root@debian:/etc/apt# ls
apt.conf.d listchanges.conf preferences.d sources.list sources.list~ sources.list.d trusted.gpg.d
root@debian:/etc/apt# cp sources.list sources.list.bak2018-02-12
root@debian:/etc/apt# more sources.list
#

阅读更多