Navigation

    DDBB

    • Register
    • Login
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. admin
    3. Posts
    A
    • Profile
    • Following 0
    • Followers 0
    • Topics 38
    • Posts 40
    • Best 0
    • Groups 1

    Posts made by admin

    • 使用pagehelper控制分页数据条数

      在pom.xml里添加pagehelper插件

              <!-- pagehelper 插件-->
              <dependency>
                  <groupId>com.github.pagehelper</groupId>
                  <artifactId>pagehelper-spring-boot-starter</artifactId>
                  <version>1.2.13</version>
              </dependency>
      

      代码里在查询数据库操作前添加添加:
      一页3条数据

      PageHelper.startPage(1,3);
      
      posted in JAVA
      A
      admin
    • Azure Az-900认证 04——-考取AZ900所有知识点总结--获取证书!

      https://my.oschina.net/u/4332788/blog/4710842

      posted in Linux
      A
      admin
    • 使用Axios

      使用npm

      npm install axios --save
      

      使用yarn

      yarn add axios --save
      
      posted in JAVA
      A
      admin
    • IdeaIU添加vue高亮支持

      <方法1>安装vue.js

      File -> Settings -> Plugins ->

      <方法2>
      File Types: HTML 添加 *.vue类型

      File -> Settings -> Editor -> File Types -> HTML

      点Registered Patterns下的+,添加 *.vue

      posted in JAVA
      A
      admin
    • IdeaIU使用database插件连接mysql

      最右侧点击database

      加号新建连接

      使用console输入mysql命令

      输入下面命令

      drop table if exists `test`;
      create table `test` (
        `id` bigint not null comment 'id',
        `name` varchar(50) comment '名称',
        `password` varchar(50) comment '密码',
        primary key (`id`)
      ) engine=innodb default charset=utf8mb4 comment='测试';
      

      测试查询

      添加数据

      posted in JAVA
      A
      admin
    • Navicat 15远程连接mysql-新建数据库和表

      1.通过root用户,新建数据库

      2.添加用户

      3.添加权限


      4.新建表

      IDEA成功连接Database但不显示表怎么办?
      https://jingyan.baidu.com/article/e5c39bf592c7be78d6603374.html

      IDEA 使用mybatis插件Free Mybatis plugin
      https://www.jianshu.com/p/4f1c2600802c

      Docker查询MySQL版本号
      https://blog.csdn.net/qq_24641227/article/details/92569384

      Navicat15破解
      https://www.jianshu.com/p/aadf52aa6475

      posted in JAVA
      A
      admin
    • IdeaIU配置热部署

      1.首先在pom.xml里添加spring-boot-devtools

         <dependencies>
              <dependency>
                  <groupId>org.springframework.boot</groupId>
                  <artifactId>spring-boot-starter-web</artifactId>
              </dependency>
              #添加spring-boot-devtools
              <dependency>
                  <groupId>org.springframework.boot</groupId>
                  <artifactId>spring-boot-devtools</artifactId>
              </dependency>
      
              <dependency>
                  <groupId>org.springframework.boot</groupId>
                  <artifactId>spring-boot-starter-test</artifactId>
                  <scope>test</scope>
              </dependency>
          </dependencies>
      

      2.打开IdeaIU setting->complier

      3.在idea中 ,Shift+Ctrl+Alt+/,选择Registry

      如图勾选

      posted in JAVA
      A
      admin
    • IntelliJ IDEA 常用快捷键 之 Windows 版

      转自csdn
      https://blog.csdn.net/qq_35246620/article/details/53648746

      posted in JAVA
      A
      admin
    • JAVA安装,环境变量和HelloWorld和IdeaIU & GIT安装

      参考CSDN
      https://blog.csdn.net/tuxwig/article/details/113788287

      IdeaIU安装
      https://www.cnblogs.com/tangsujuan/p/14148404.html

      GIit安装
      https://www.cnblogs.com/hdlan/p/14395189.html

      IDEAIU Git登录404解决方法
      https://blog.csdn.net/PengZyi/article/details/113914880

      IntelliJ IDEA更改maven本地仓库位置
      https://www.jianshu.com/p/0aa04f3b3baa?utm_campaign=haruki

      【Git】ssh: connect to host github. com port 22: Connection timed out 的解决方案GIT
      https://blog.csdn.net/qq_42351033/article/details/104759709

      本地上传到git

      git remote add origin git@github.com:onezos/wiki.git
      git branch -M main
      git push -u origin main
      

      10分钟搭建自己的Git仓库
      https://zhuanlan.zhihu.com/p/108165153

      TO yaml
      https://toyaml.com/index.html

      posted in JAVA
      A
      admin
    • win10搭建nodejs开发环境

      Node.js下载地址:https://nodejs.org/en/
      默认安装后

      C:\Users\gdd93>node -v
      v14.15.4
      
      C:\Users\gdd93>npm -v
      6.14.10
      #安装cnpm
      C:\Users\gdd93>npm install -g cnpm --registry=https://registry.npm.taobao.org
      npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142
      npm WARN deprecated har-validator@5.1.5: this
      C:\Users\gdd93\AppData\Roaming\npm\cnpm -> C:\Users\gdd93\AppData\Roaming\npm\node_modules\cnpm\bin\cnpm
      + cnpm@6.1.1
      added 689 packages from 973 contributors in 46.455s
      
      #cnpm安装vue
      C:\Users\gdd93>cnpm install -g @vue/cli
      C:\Users\gdd93>vue --version
      @vue/cli 4.5.11
      
      C:\Users\gdd93>cnpm install -g @vue/cli-service-global
      
      #安装yarn
      C:\Users\gdd93>npm install -g yarn
      
      C:\Users\gdd93>yarn -v
      1.22.10
      
      #安装淘宝镜像源
      C:\Users\gdd93>yarn config set registry https://registry.npm.taobao.org/
      yarn config v1.22.10
      success Set "registry" to "https://registry.npm.taobao.org/".
      Done in 0.07s.
      
      #yarn安装vue
      C:\Users\gdd93>yarn global add @vue/cli
      

      安装node.js版本管理工具nvm
      下载地址:https://github.com/coreybutler/nvm-windows/releases
      安装完成后

      C:\Users\gdd93>nvm -v
      
      Running version 1.1.7.
      
      Usage:
      
        nvm arch                     : Show if node is running in 32 or 64 bit mode.
        nvm install <version> [arch] : The version can be a node.js version or "latest" for the latest stable version.
                                       Optionally specify whether to install the 32 or 64 bit version (defaults to system arch).
                                       Set [arch] to "all" to install 32 AND 64 bit versions.
                                       Add --insecure to the end of this command to bypass SSL validation of the remote download server.
        nvm list [available]         : List the node.js installations. Type "available" at the end to see what can be installed. Aliased as ls.
        nvm on                       : Enable node.js version management.
        nvm off                      : Disable node.js version management.
        nvm proxy [url]              : Set a proxy to use for downloads. Leave [url] blank to see the current proxy.
                                       Set [url] to "none" to remove the proxy.
        nvm node_mirror [url]        : Set the node mirror. Defaults to https://nodejs.org/dist/. Leave [url] blank to use default url.
        nvm npm_mirror [url]         : Set the npm mirror. Defaults to https://github.com/npm/cli/archive/. Leave [url] blank to default url.
        nvm uninstall <version>      : The version must be a specific version.
        nvm use [version] [arch]     : Switch to use the specified version. Optionally specify 32/64bit architecture.
                                       nvm use <arch> will continue using the selected version, but switch to 32/64 bit mode.
        nvm root [path]              : Set the directory where nvm should store different versions of node.js.
                                       If <path> is not set, the current root will be displayed.
        nvm version                  : Displays the current running version of nvm for Windows. Aliased as v.
      
      
      C:\Users\gdd93>nvm ls available
      
      |   CURRENT    |     LTS      |  OLD STABLE  | OLD UNSTABLE |
      |--------------|--------------|--------------|--------------|
      |   15.11.0    |   14.16.0    |   0.12.18    |   0.11.16    |
      |   15.10.0    |   14.15.5    |   0.12.17    |   0.11.15    |
      |    15.9.0    |   14.15.4    |   0.12.16    |   0.11.14    |
      |    15.8.0    |   14.15.3    |   0.12.15    |   0.11.13    |
      |    15.7.0    |   14.15.2    |   0.12.14    |   0.11.12    |
      |    15.6.0    |   14.15.1    |   0.12.13    |   0.11.11    |
      |    15.5.1    |   14.15.0    |   0.12.12    |   0.11.10    |
      |    15.5.0    |   12.21.0    |   0.12.11    |    0.11.9    |
      |    15.4.0    |   12.20.2    |   0.12.10    |    0.11.8    |
      |    15.3.0    |   12.20.1    |    0.12.9    |    0.11.7    |
      |    15.2.1    |   12.20.0    |    0.12.8    |    0.11.6    |
      |    15.2.0    |   12.19.1    |    0.12.7    |    0.11.5    |
      |    15.1.0    |   12.19.0    |    0.12.6    |    0.11.4    |
      |    15.0.1    |   12.18.4    |    0.12.5    |    0.11.3    |
      |    15.0.0    |   12.18.3    |    0.12.4    |    0.11.2    |
      |   14.14.0    |   12.18.2    |    0.12.3    |    0.11.1    |
      |   14.13.1    |   12.18.1    |    0.12.2    |    0.11.0    |
      |   14.13.0    |   12.18.0    |    0.12.1    |    0.9.12    |
      |   14.12.0    |   12.17.0    |    0.12.0    |    0.9.11    |
      |   14.11.0    |   12.16.3    |   0.10.48    |    0.9.10    |
      
      This is a partial list. For a complete list, visit https://nodejs.org/download/release
      
      C:\Users\gdd93>nvm install v10.16.0
      Downloading node.js version 10.16.0 (64-bit)...
      Complete
      Creating C:\Users\gdd93\AppData\Roaming\nvm\temp
      
      Downloading npm version 6.9.0... Complete
      Installing npm v6.9.0...
      
      Installation complete. If you want to use this version, type
      
      nvm use 10.16.0
      #查看当前系统安装的nodejs版本列表
      C:\Users\gdd93>nvm list
      
        * 14.15.4 (Currently using 64-bit executable)
          10.16.0
      #切换nodejs版本
      C:\Users\gdd93>nvm use v10.16.0
      Now using node v10.16.0 (64-bit)
      
      C:\Users\gdd93>node -v
      v10.16.0
      
      C:\Users\gdd93>npm -v
      6.9.0
      

      安装webpack和webpack-cli

      npm install webpack webpack-cli -D
      yarn add webpack webpack-cli -D
      

      Webpack安装和使用

      1.初始化项目
      npm init -y快速创建nodejs项目

      2.nvm,node,npm环境确认
      nvm install/use v14.15.4/node -v/npm -v

      3.两种webpack安装与三种使用方式
      npm install webpack webpack-cli -D/-g
      或yarn add webpack webpack-cli -D/yarn global add webpack webpack-cli
      npx webpack & node_modules/.bin/webpack & npm run

      posted in Linux
      A
      admin
    • docker安装mongo

      docker hub文档:https://hub.docker.com/_/mongo

      [root@VM-0-3-centos ~]# docker -v
      Docker version 20.10.5, build 55c4c88
      [root@VM-0-3-centos ~]# docker pull mongo
      Using default tag: latest
      latest: Pulling from library/mongo
      Digest: sha256:51f6fdbfc622d91e276ade7e6cf6491aa36ff2bd9b158dadb732f9e4a05f33ad
      Status: Image is up to date for mongo:latest
      docker.io/library/mongo:latest
      [root@VM-0-3-centos ~]# docker images
      REPOSITORY      TAG       IMAGE ID       CREATED         SIZE
      mongo           latest    bbfd3e575f12   3 days ago      449MB
      mysql           latest    8457e9155715   8 days ago      546MB
      hello-world     latest    bf756fb1ae65   14 months ago   13.3kB
      lw96/doclever   latest    bb305c190a83   2 years ago     940MB
      [root@VM-0-3-centos ~]# docker run -d --name some-mongo -p 10050:27017 mongo:4
      Unable to find image 'mongo:4' locally
      4: Pulling from library/mongo
      Digest: sha256:51f6fdbfc622d91e276ade7e6cf6491aa36ff2bd9b158dadb732f9e4a05f33ad
      Status: Downloaded newer image for mongo:4
      d1335239f99147b3078199b3c6a180cea138a2874eb4f781a9563b27b08a1179
      [root@VM-0-3-centos ~]# docker ps
      CONTAINER ID   IMAGE           COMMAND                  CREATED          STATUS          PORTS                      NAMES
      d1335239f991   mongo:4         "docker-entrypoint.s…"   40 seconds ago   Up 39 seconds   0.0.0.0:10050->27017/tcp   some-mongo
      697628e16761   lw96/doclever   "/entrypoint.sh"         10 hours ago     Up 10 hours     0.0.0.0:10040->10000/tcp   DOClever
      3d8cb248d6c3   mongo:latest    "docker-entrypoint.s…"   10 hours ago     Up 10 hours     27017/tcp                  mongodb
      [root@VM-0-3-centos ~]#
      
      

      ROBO 3T是mongo的图形话管理工具
      https://www.robomongo.org/

      posted in Linux
      A
      admin
    • docker安装mysql

      1.docker启动mysql
      方法:

      https://hub.docker.com/_/mysql
      

      找到命令并修改mysql名字和密码

      docker run --name one-mysql -e MYSQL_ROOT_PASSWORD=password -d mysql
      

      2.安装完成后查看

       docker ps
      CONTAINER ID   IMAGE     COMMAND                  CREATED         STATUS         PORTS                 NAMES
      cc4a81197502   mysql     "docker-entrypoint.s…"   6 seconds ago   Up 5 seconds   3306/tcp, 33060/tcp   one-mysql
      
      

      3.关闭mysql服务

       docker stop one-mysql
      

      4.查看是否关闭

       docker ps -a
      

      5.启动mysql

       docker start one-mysql
      

      6.持续打印mysql的log

       docker logs -f one-mysql
      

      7.移除mysql,需要先docker stop one-mysql

       docker rm one-mysql
      

      8.改变mysql运行端口

      docker run --name one-mysql -e MYSQL_ROOT_PASSWORD=password -p 28001:3306 -d mysql
      
      posted in Linux
      A
      admin
    • centos7上搭建自己的DOClever服务器

      DOClever开源地址:http://doclever.cn/controller/download/download.html
      docker安装方法: http://www.onezos.com/topic/26/centos中docker安装方法
      服务器:腾讯云

      [root@VM-0-3-centos /]# docker --version
      Docker version 20.10.5, build 55c4c88
      [root@VM-0-3-centos /]# docker-compose --version
      docker-compose version 1.28.5, build c4eb3a1f
      [root@VM-0-3-centos /]# cd /home
      [root@VM-0-3-centos home]# mkdir doclever
      [root@VM-0-3-centos home]# cd doclever/
      [root@VM-0-3-centos doclever]# vi docker-compose.yml
      version: "2"
      services:
        DOClever:
          image: lw96/doclever
          restart: always
          container_name: "DOClever"
          ports:
          - 10040:10000
          volumes:
          - /src/doclever/file:/root/DOClever/data/file
          - /src/doclever/img:/root/DOClever/data/img
          - /src/doclever/tmp:/root/DOClever/data/tmp
          environment:
          - DB_HOST=mongodb://mongo:27017/DOClever
          - PORT=10000
          links:
          - mongo:mongo
      
        mongo:
          image: mongo:latest
          restart: always
          container_name: "mongodb"
          volumes:
          - /src/doclever/db:/data/db
      
      

      启动服务:

      [root@VM-0-3-centos doclever]# docker-compose up -d
      ...
      Digest: sha256:546dd0fe158bb16f7a1ddd258783642def4254c3ebe00e974fb25e845d73398b
      Status: Downloaded newer image for lw96/doclever:latest
      Creating mongodb ... done
      Creating DOClever ... done
      

      使用docker ps 查看启动的doclever进程

      [root@VM-0-3-centos doclever]# docker ps | grep doclever
      697628e16761   lw96/doclever   "/entrypoint.sh"         2 minutes ago   Up 2 minutes   0.0.0.0:10040->10000/tcp   DOClever
      

      如果有防火墙:
      firewall-cmd --status查看防火墙是否开启
      firewall-cmd --list-all查看开放了哪些端口
      firewall-cmd --zone=public --add-port=10040/tcp --permanent添加放行端口
      firewall-cmd -reload重载防火墙
      firewall-cmd --list-all查看是否成功

      posted in Linux
      A
      admin
    • Centos中Docker安装方法
      1. 先删除旧的版本(如果没有可以跳过)
      $ sudo yum remove docker \
                        docker-client \
                        docker-client-latest \
                        docker-common \
                        docker-latest \
                        docker-latest-logrotate \
                        docker-logrotate \
                        docker-engine
      
      1. 安装必须的依赖:
      $ sudo yum install -y yum-utils \
       device-mapper-persistent-data \
       lvm2
      

      添加stable的Docker-ce的源:

      $ sudo yum-config-manager \
          --add-repo \
          https://download.docker.com/linux/centos/docker-ce.repo
      
      1. 安装docker-ce:
      $ sudo yum install docker-ce docker-ce-cli containerd.io
      
      1. 启动服务并测试一下:
      # 启动服务
      sudo systemctl start docker
      
      # 来一个Hello World吧
      sudo docker run hello-world
      Unable to find image 'hello-world:latest' locally
      latest: Pulling from library/hello-world
      1b930d010525: Pull complete
      Digest: sha256:2557e3c07ed1e38f26e389462d03ed943586f744621577a99efb77324b0fe535
      Status: Downloaded newer image for hello-world:latest
      
      Hello from Docker!
      This message shows that your installation appears to be working correctly.
      
      To generate this message, Docker took the following steps:
       1. The Docker client contacted the Docker daemon.
       2. The Docker daemon pulled the "hello-world" image from the Docker Hub.
          (amd64)
       3. The Docker daemon created a new container from that image which runs the
          executable that produces the output you are currently reading.
       4. The Docker daemon streamed that output to the Docker client, which sent it
          to your terminal.
      
      To try something more ambitious, you can run an Ubuntu container with:
       $ docker run -it ubuntu bash
      
      Share images, automate workflows, and more with a free Docker ID:
       https://hub.docker.com/
      
      For more examples and ideas, visit:
       https://docs.docker.com/get-started/
      

      如果看到上面的提示,说明Docker已经成功安装并运行了了。

      1. 关于升级&删除:
        升级:
      # 更新所有
      yum -y update
      
      # 更新指定
      yum -y update docker-ce docker-ce-cli containerd.io
      

      删除:

      sudo yum remove docker-ce
      
      # 删除文件系统
      sudo rm -rf /var/lib/docker
      

      6.Docker-compose集合命令
      Compose工具是一个批量工具,用于运行与管理多个docker容器。
      官方文档:https://docs.docker.com/compose/install/

      # 下载docker-compose
      sudo curl -L "https://github.com/docker/compose/releases/download/1.28.5/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
      
      # 国内镜像
      sudo curl -L https://get.daocloud.io/docker/compose/releases/download/1.28.5/docker-compose-`uname -s`-`uname -m` > /usr/local/bin/docker-compose
      
      # 给予执行权限
      sudo chmod +x /usr/local/bin/docker-compose
      
      # 测试命令
      $ docker-compose --version
      docker-compose version 1.28.5, build 1110ad01
      
      posted in Linux
      A
      admin
    • LINUX常用命令
      命令 解释
      lsb_release -a linux版本号
      uname -a 查看内核版本
      df -TH 查看 磁盘占用情况
      top linux的任务管理器
      ls 展示文件夹内容
      mkdir 创建目录
      touch 创建空文件
      vi 编辑文件,i插入,wq保存,q!不保存
      cat 查看文件
      echo 往文件里追加一条, 例: echo 'string' >> test.txt (两个箭头追加,一个箭头覆盖文件)
      rm -r 删除文件夹,加-rf是强制删除
      wget 下载文件
      tar zxvf 解压缩文件
      tar zcvf 压缩文件, 例: tar zcvf 文件名.tar.gz 目录
      ps -rf 查看进程,搜索某个进程可以加grep
      kill 中止进程,例: kill -9 pid
      service 查看服务,例:service sshd status/stop/restart
      systemctl centos查看服务,例:systemctl status firewalld.service
      netstat -anlp 查看占用端口,例:netstat -anlp | grep sshd
      vi /etc/ssh/sshd_config 找到22端口,改成高位如10022
      yum whatprovides semanage 反查哪个包里带有semanage这个命令
      yum install -y 安装软件包
      semanage port -a -t ssh_port_t -p tcp 10022 centos改变ddh端口生效
      semanage port -l | grep ssh 查看是否改变
      semanage port -d -t sshd_port_t -p tcp 22 删除多余端口
      posted in Linux
      A
      admin
    • 使用appnode是网站访问协议变成https
      安装Let's Encrypt

      进入APPNODE,在软件管家里找到Let's Encrypt,安装后创建帐户

      然后新建证书

      填入你的域名,开始创建。

      进入网站管理,选择你刚刚填入的网站。

      网站设置-->HTTPS-->选择手动配置并导入证书

      输入网址后自动变为https。

      posted in Linux
      A
      admin
    • CentOS + Mongodb安装NodeBB
      环境

      关闭 SELinux

      vim /etc/sysconfig/selinux
      

      找到 SELINUX 然后修改成 disabled .

      SELINUX = disabled
      

      安装APPNODE
      INSTALL_AGENT=1 INSTALL_APPS=sitemgr INIT_SWAPFILE=1 INSTALL_PKGS='nginx-stable,php56(zend-guard-loader),pureftpd,mysql56' bash -c "$(curl -sS http://dl.appnode.com/install.sh)"
      

      AppNode是 Linux 下的一款集群部署的可视化控制面板,一键安装,具体功能的体验。
      提供:
      可视化管理,提升运维效率
      快速安装,轻松升级
      轻便高效,节约系统资源
      将支持主流的 Linux 发行版本 (目前仅支持 CentOS)
      集中式设计,快速切换管理
      软件丰富,按需安装
      遵循通用规范,系统更原汁原味
      开放的 API 结构,便于扩展和整合
      AppNode 提供系统信息、软件管家、文件管理、服务管理、进程管理、防火墙管理、 用户管理等基本的
      Linux运维功能,通过可视化操作界面降低了 Linux 使用的门槛。

      进入APPNODE,在软件管家安装node.js

      同样安装PM2进程管理


      安装Redis

      Redis 是一个优秀的内存缓存应用,也是 NodeBB 的一个数据库选择。

      1. 搜索 “Redis”

      2. 一键安装
        然后启动,并勾选自启,守护。

        ​


      安装MongoDB

      NodeBB 推荐使用 MongoDB ,但APPNODE里面搜不到,所以需要通过终端来安装。

      vim /etc/yum.repos.d/mongodb-org-3.4.repo
      --------------------------------------------------------------
      [mongodb-org-3.4]  
      name=MongoDB Repository  
      baseurl=https://repo.mongodb.org/yum/redhat/$releasever/mongodb-org/3.4/x86_64/  
      gpgcheck=1  
      enabled=1  
      gpgkey=https://www.mongodb.org/static/pgp/server-3.4.asc
      

      安装

      yum -y install mongodb-org
      

      使用以下指令以启动 MongoDB 并设置开机自启。

      systemctl enable mongod
      systemctl start mongod
      

      配置MongoDB

      [root@li1877-76 ~]# mongo
      MongoDB shell version v3.4.13
      ....
      > use nodebb;
      switched to db nodebb
      > db.createUser( { user: "nodebb", pwd: "********", roles: [ { role: "readWrite", db: "nodebb" }, { role: "clusterMonitor", db: "admin" } ] } )
      Successfully added user: {
              "user" : "nodebb",
              "roles" : [
                      {
                              "role" : "readWrite",
                              "db" : "nodebb"
                      },
                      {
                              "role" : "clusterMonitor",
                              "db" : "admin"
                      }
              ]
      }
      > use admin
      switched to db admin
      > db.createUser( { user: "admin", pwd: "********", roles: [ { role: "readWriteAnyDatabase", db: "admin" }, { role: "userAdminAnyDatabase", db: "admin" } ] } )
      Successfully added user: {
              "user" : "admin",
              "roles" : [
                      {
                              "role" : "readWriteAnyDatabase",
                              "db" : "admin"
                      },
                      {
                              "role" : "userAdminAnyDatabase",
                              "db" : "admin"
                      }
              ]
      }
      > quit()
      [root@li1877-76 ~]# vi /etc/mongod.conf
      ------------------------
      security: 
        authorization: enabled
      ------------------------
      [root@li1877-76 ~]# service mongod restart
      Redirecting to /bin/systemctl restart mongod.service
      [root@li1877-76 ~]# mongo -u admin -p ******** --authenticationDatabase=admin
      MongoDB shell version v3.4.13
      connecting to: mongodb://127.0.0.1:27017
      MongoDB server version: 3.4.13
      > quit()
      

      打开 MongoDB 权限认证
      执行 vi /etc/mongod.conf ,找到 security: 这一行,取消注释并改为:

      security: 
        authorization: enabled
      

      获取nodebb

      首先重启一下服务器

      git clone -b v1.7.x https://github.com/NodeBB/NodeBB.git nodebb
      cd nodebb
      ./nodebb setup
      

      注意事项:

      1. URL used to access this NodeBB 这个问题填写域名http://www.xxx.com(别漏下 http前缀,域名末尾不加 / )
      2. 另外,NodeBB会默认监听本地端口 4567 ,我们后面还要使用 nginx 转发 80 端口的请求到4567 端口。
      3. 中间还有两次需要回答问题 Which database to use ,
        第一次是回答数据库程序名 mongo ,第二次回答所创建的数据库名 nodebb
      4. 这些回答都将被写入 NodeBB 的配置文件config.json,如果答错了可以随后手动修改

      nginx配置

      打开APPNODE


      PM2配置

      创建用PM2守护进程,并重启,nodebb已经成功上线!

      posted in Linux
      A
      admin
    • bwh1-使用ezhttp选择php5.2版本后无法使用phpmyadmin

      关于ezhttp就不多解释了,贴个link过去看看,很详细的。

      wget --no-check-certificate centos.bz/ezhttp.zip?time=$(date +%s) -O ezhttp.zip
      unzip ezhttp.zip
      cd ezhttp-master
      chmod +x start.sh
      ./start.sh
      

      ezhttp默认版本的phpmyadmin不支持php5.2,所以需要自己重新下载个低版本的。

      wget https://files.phpmyadmin.net/phpMyAdmin/4.0.10.19/phpMyAdmin-4.0.10.19-all-languages.tar.gz
      tar xzvf phpMyAdmin-4.0.10.19-all-languages.tar.gz
      mkdir -p /home/wwwroot/phpmyadmin
      cp -a phpMyAdmin-4.0.10.19-all-languages/*  /home/wwwroot/phpmyadmin
      sed -i '1aexit;' /home/wwwroot/phpmyadmin/version_check.php
      

      这样就可以访问了。

      posted in Linux
      A
      admin
    • CentOS6.5下安装MongoDB v3.05

      Linode的VPS准备在月底就终止续费了,所以尽可能多花时间在上面折腾。准备试着部署一下Nodeclub,看说明写的是

      线上跑的是 Node.js v4.4.0,MongoDB 是 v3.0.5,Redis 是 v3.0.3。

      Node.js系统上已经有了,就先开始安装MongoDB吧。

      [root@li1473-187 ~]# wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-rhel62-3.0.5.tgz
      [root@li1473-187 ~]# tar -zxvf mongodb-linux-x86_64-rhel62-3.0.5.tgz
      [root@li1473-187 ~]# mv mongodb-linux-x86_64-rhel62-3.0.5 mongodb
      [root@li1473-187 ~]# mv mongodb /usr/local/
      [root@li1473-187 ~]# cd /usr/local/mongodb
      [root@li1473-187 mongodb]# ls
      bin  GNU-AGPL-3.0  README  THIRD-PARTY-NOTICES
      [root@li1473-187 mongodb]# mkdir db
      [root@li1473-187 mongodb]# mkdir logs
      [root@li1473-187 mongodb]# cd bin
      [root@li1473-187 bin]# ls
      bsondump  mongod     mongoexport  mongoimport  mongoperf     mongos     mongotop
      mongo     mongodump  mongofiles   mongooplog   mongorestore  mongostat
      [root@li1473-187 bin]# vim mongodb.conf
      dbpath=/usr/local/mongodb/db
      logpath=/usr/local/mongodb/logs/mongodb.log
      port=27017
      fork=true
      nohttpinterface=true
      [root@li1473-187 bin]# /usr/local/mongodb/bin/mongod --config /usr/local/mongodb/bin/mongodb.conf
      about to fork child process, waiting until server is ready for connections.
      forked process: 26170
      child process started successfully, parent exiting
      

      MongoDB已经启动起来了。下面加入开机自动启动mongodb

      [root@li1473-187 bin]# vim /etc/rc.d/rc.local
      /usr/local/mongodb/bin/mongod --config /usr/local/mongodb/bin/mongodb.conf
      [root@li1473-187 bin]# ps -ef|grep mongo
      root     26170     1  0 15:30 ?        00:00:00 /usr/local/mongodb/bin/mongod --config /usr/local/mongodb/bin/mongodb.conf
      root     26794 21916  0 15:31 pts/3    00:00:00 grep mongo
      

      重启系统后进入MongoDB

      [root@li1473-187 ~]# /usr/local/mongodb/bin/mongo
      MongoDB shell version: 3.0.5
      connecting to: test
      Server has startup warnings:
      2017-02-15T15:46:30.303+0800 I CONTROL  [initandlisten] ** WARNING: You are running this process as the root user, which is not recommended.
      2017-02-15T15:46:30.303+0800 I CONTROL  [initandlisten]
      > show dbs
      local  0.078GB
      > exit
      bye
      [root@li1473-187 ~]#
      

      测试可用,OVER!

      posted in Linux
      A
      admin
    • CentOS6.5下Redis v3.03安装

      在CentOS6.5下安装Redis v3.03

      [root@li1473-187 ~]# wget http://download.redis.io/releases/redis-3.0.3.tar.gz
      [root@li1473-187 ~]# tar xzf redis-3.0.3.tar.gz
      [root@li1473-187 redis-3.0.3]# ls
      00-RELEASENOTES  CONTRIBUTING  deps     Makefile   README      runtest          runtest-sentinel  src    utils
      BUGS             COPYING       INSTALL  MANIFESTO  redis.conf  runtest-cluster  sentinel.conf     tests
      [root@li1473-187 redis-3.0.3]# make
      [root@li1473-187 redis-3.0.3]# cd src && make install
      
      Hint: It's a good idea to run 'make test' 😉
      
       INSTALL install
       INSTALL install
       INSTALL install
       INSTALL install
       INSTALL install
      [root@li1473-187 src]# make test
      You need tcl 8.5 or newer in order to run the Redis test
      make: *** [test] Error 1
      

      提示需要安装tcl8.5

      # wget http://downloads.sourceforge.net/tcl/tcl8.5.9-src.tar.gz
      # tar -zxvf tcl8.5.9-src.tar.gz
      # cd /tcl8.5.9-src/unix
      
      ./configure
      make
      make install
      

      再重新执行make test

      [root@li1473-187 src]# make test
      \o/ All tests passed without errors!
      
      Cleanup: may take some time... OK
      make[1]: Leaving directory '/root/redis-3.0.3/src'
      

      输入./src/redis-server启动 redis

      [root@li1473-187 redis-3.0.3]# ./src/redis-server
      11304:C 15 Feb 15:58:37.819 # Warning: no config file specified, using the default config. In order to specify a config file use ./src/redis-server /path/to/redis.conf
                      _._
                 _.-``__ ''-._
            _.-``    `.  `_.  ''-._           Redis 3.0.3 (00000000/0) 64 bit
        .-`` .-```.  ```\/    _.,_ ''-._
       (    '      ,       .-`  | `,    )     Running in standalone mode
       |`-._`-...-` __...-.``-._|'` _.-'|     Port: 6379
       |    `-._   `._    /     _.-'    |     PID: 11304
        `-._    `-._  `-./  _.-'    _.-'
       |`-._`-._    `-.__.-'    _.-'_.-'|
       |    `-._`-._        _.-'_.-'    |           http://redis.io
        `-._    `-._`-.__.-'_.-'    _.-'
       |`-._`-._    `-.__.-'    _.-'_.-'|
       |    `-._`-._        _.-'_.-'    |
        `-._    `-._`-.__.-'_.-'    _.-'
            `-._    `-.__.-'    _.-'
                `-._        _.-'
                    `-.__.-'
      

      打开另一个SSH,显示如下已经成功。

      [root@li1473-187 ~]# ./redis-3.0.3/src/redis-cli
      127.0.0.1:6379> set foo bar
      OK
      127.0.0.1:6379> get foo
      "bar"
      127.0.0.1:6379>
      

      修改 redis-3.0.3下配置文件

      [root@li1473-187 redis-3.0.3]# nano redis.conf
      找到 daemonize no 这项修改为 yes
      使服务端运行在后台
      新建 redis service脚本
      [root@li1473-187 redis-3.0.3]# touch /etc/rc.d/init.d/redis
      

      编辑/etc/rc.d/init.d/redis

      #!/bin/sh
      #chkconfig: 2345 86 14
      #description: Startup and shutdown script for Redis
      
      PROGDIR=/usr/redis #安装路径
      PROGNAME=redis-server
      DAEMON=$PROGDIR/$PROGNAME
      CONFIG=/usr/redis/redis.conf
      PIDFILE=/var/run/redis.pid
      DESC="redis daemon"
      SCRIPTNAME=/etc/rc.d/init.d/redis
      
      start()
      {
       if test -x $DAEMON
       then
       echo -e "Starting $DESC: $PROGNAME"
       if $DAEMON $CONFIG
       then
       echo -e "OK"
       else
       echo -e "failed"
       fi
       else
       echo -e "Couldn't find Redis Server ($DAEMON)"
       fi
      }
      
      stop()
      {
       if test -e $PIDFILE
       then
       echo -e "Stopping $DESC: $PROGNAME"
       if kill `cat $PIDFILE`
       then
       echo -e "OK"
       else
       echo -e "failed"
       fi
       else
       echo -e "No Redis Server ($DAEMON) running"
       fi
      }
      
      restart()
      {
       echo -e "Restarting $DESC: $PROGNAME"
       stop
       start
      }
      
      list()
      {
       ps aux | grep $PROGNAME
      }
      
      case $1 in
       start)
       start
       ;;
       stop)
       stop
       ;;
       restart)
       restart
       ;;
       list)
       list
       ;;
      
       *)
       echo "Usage: $SCRIPTNAME {start|stop|restart|list}" >&2
       exit 1
       ;;
      esac
      exit 0
      

      进入redis-3.0.3的src目录执行下面操作

      [root@li1473-187 src]# mkdir /usr/redis
      [root@li1473-187 src]# cp redis-server  /usr/redis
      [root@li1473-187 src]# cp redis-benchmark /usr/redis
      [root@li1473-187 src]# cp redis-cli  /usr/redis
      [root@li1473-187 src]# cp redis.conf  /usr/redis
      cp: cannot stat 'redis.conf': No such file or directory
      [root@li1473-187 src]# cd ..
      [root@li1473-187 redis-3.0.3]# ls
      00-RELEASENOTES  CONTRIBUTING  deps     Makefile   README      runtest          runtest-sentinel  src    utils
      BUGS             COPYING       INSTALL  MANIFESTO  redis.conf  runtest-cluster  sentinel.conf     tests
      [root@li1473-187 redis-3.0.3]# cp redis.conf /usr/redis
      [root@li1473-187 redis-3.0.3]#
      

      增加服务并设置开机启动。

      [root@li1473-187 rc.d]# chkconfig --add redis
      service redis does not support chkconfig
      [root@li1473-187 rc.d]# vim /etc/init.d/redis
      如果没加#chkconfig: 2345 86 14就会出现上面的错误。
      [root@li1473-187 rc.d]# chkconfig --add redis
      [root@li1473-187 rc.d]# chkconfig --level 2345 redis on
      [root@li1473-187 rc.d]# chkconfig --list redis
      redis           0:off   1:off   2:on    3:on    4:on    5:on    6:off
      [root@li1473-187 rc.d]#
      
      posted in Linux
      A
      admin