Little Star Blog

路在脚下，心向远方

使用unix-socket解耦

vim receive.sh #!/bin/bash SOCKET="/var/run/ha_state.sock" [ -e "$SOCKET" ] && rm -f "$SOCKET" # 移除旧 socket 文件 socat - UNIX-LISTEN:$SOCKET,fork | while read line; do echo "收到 socket 消息: $line" done vim send.sh echo 'hello' | socat - UNIX-CONNECT:/var/run/lxgme.sock 先启动 receive.sh sudo bash receive.sh 再去启动 send.sh sudo bash receive.sh 返回内容如下

Posted by "lxg" on Tuesday, April 15, 2025

Mariadb+Keppalived互为主备

假设现在有两台服务器，需要搭建Mariadb高可用性集群，一台为主数据库（Master），另一台为从数据库（Slave）。服务器信息如下：服

Posted by "lxg" on Saturday, April 12, 2025

ubuntu终端如何设置固定ip

以Ubuntu 24.04为例第一步、编辑网络接口信息 vim /etc/netplan/01-network-manager-all.yaml 复制如下内容到 01-network-manager-all.yaml 文件中 network: version: 2 renderer: networkd ethernets: ens33: dhcp4: false addresses: [192.168.31.91/24] optional: true routes: - to: default via: 192.168.31.2 nameservers: addresses: [223.5.5.5, 8.8.4.4] ens33.ad

Posted by "lxg" on Saturday, April 12, 2025

OMV如何通过ISCSI挂载磁盘

扫描所有可用的 iSCSI 目标 iscsiadm --mode discovery --type sendtargets --portal <IP地址> 返回如下 192.168.6.130:3260,1 iqn.2024-12.local.openmediavault:pistorage 192.168.6.130:3260,1 iqn.2024-12.local.openmediavault:raid0 登录到目标设备 iscsiadm --mode node --targetname <targetname> --portal <IP地址>:<端口&g

Posted by "lxg" on Thursday, December 26, 2024

Ubuntu如何挂载磁盘

假设现在服务器已经安装了一块硬盘设备，并且被系统设备到，设备名 /dev/sdb，现在需要将此硬盘挂载到本机的/mnt目录。第一步找到硬盘设备

Posted by "lxg" on Friday, November 29, 2024

Ubuntu安装nfs

第一步安装相关软件包 sudo apt-get install nfs-kernel-server # 安装 NFS服务器端 sudo apt-get install nfs-common # 安装 NFS客户端第二步创建需要被共享的目录 mkdir /mnt chomod -R 777 /mnt 第三步创建需要被共享的目录添

Posted by "lxg" on Friday, November 29, 2024

PostgreSQL 用户管理

创建用户修改用户密码删除用户

Posted by "lxg" on Thursday, August 22, 2024

OpengaussDB

创建数据库 CREATE DATABASE collector WITH ENCODING 'utf8'

Posted by "lxg" on Wednesday, August 21, 2024

sybase

表操作创建表 create table dbo.table_name ( column_name int) 删除表 drop table table_name 删除数据 delete from table_name

Posted by "lxg" on Wednesday, August 21, 2024

sybase

登录数据库 /sybase/isql -S DKSYBASE -U sa -P password 用户操作创建用户 create login xxx with password wewewew@2323 修改用户密码 alter login xxx with password 'password' modify password 'wewewWWD#$ew@23233'

Posted by "lxg" on Wednesday, August 21, 2024

sybase

docker安装 https://hub.docker.com/r/chernov/sybase docker run -d -t -p 5000:5000 -e "SYBASE_USER=guest" -h dksybase --name sybase157 chernov/sybase:latest docker exec -t sybase157 /bin/bash /sybase/isql -i"/opt/sybase/ASE-15_0/scripts/installpubs2" 分页显示设置返回条数不限制 SET ROWCOUNT 0 返回4条 SET ROWCOUNT 4 显示前4条内容 SELECT TOP 4 t.* from table_name t 查看设备

Posted by "lxg" on Wednesday, August 21, 2024

sybase 审计操作

打开审计攻击查看当前审计状态 sp_configure 'auditing' 打开审计第一步、先初始化审计设备 disk init name = "auditdev", physname = "/opt/sybase/data/c2d0s4", size = "100M" disk init name = "auditlogdev", physname = "/opt/sybase/data/c2d0s5", size = "200M" create database sybsecurity on auditdev log on auditlogdev 第二步、执行审计

Posted by "lxg" on Wednesday, August 21, 2024

PostgreSQL 审计操作

查看插件 select name from pg_available_extensions; 查看pgaudit设置 select name,setting from pg_settings where name ~ 'pgaudit'; set pgaudit.log = 'write, ddl'; set pgaudit.log_relation = on; pgaudit.log 可选项如下参数值描述 none 这是原定设置值。不记录任何数据库更改。 all 记录

Posted by "lxg" on Sunday, August 18, 2024

宁芝84 ec ble说明书

相关驱动 23年6月编程固件说明校验软件包说明书

Posted by "lxg" on Saturday, August 17, 2024

SQL Server 常用命令

常用操作修改SA账号的密码（基于sql） ALTER LOGIN [sa] WITH PASSWORD=N'newpassword' 以上均只供测试环境调试使用，线上谨慎使用。

Posted by "lxg" on Monday, August 12, 2024

google下载一直loading怎么办

如果你是小米用户已经具备了连接google play的能力，能访问play 但是下载一直loading。尝试以下下方式解决。下载应用中关闭迅雷引

Posted by "lxg" on Thursday, August 8, 2024

Mysql Database 常用命令

主从问题 show slave status查看同步出现异常使用skip 跳过一定数量的事务，先让他同步起来，后面再数据修复 SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;

Posted by "lxg" on Monday, August 5, 2024

Mysql Database 常用命令

常用命令登陆数据库登陆远程地址为xx端口为3307用户为root mysql -u root -h xx -p -P 3307 用户权限相关查看用户相关配置 ALTER USER 'root'@'%' IDENTIFIED BY 'new_password'; 修改密码 set password for root@localhost = password('123');

Posted by "lxg" on Monday, August 5, 2024

Oracle Database 审计操作

安装oracle https://hub.docker.com/r/dragonbest520/oracle-xe-10g 查询是否开启审计 show parameter audit; 使用ssh登陆 ssh root@localhost -p 49160 password: admin 开启审计 alter system set audit_sys_operations=TRUE scope=spfile; alter system set audit_trail=DB scope=spfile; alter system set audit_trail=db,extended scope=spfile; 查看审计结果 select username 用户,action_

Posted by "lxg" on Monday, August 5, 2024

Oracle Database 常用命令

常用操作用户相关创建表空间以新用户重启数据库实例 shutdown immediate; startup mount; alter database open; 创建表空间 CREATE TABLESPACE lxg DATAFILE 'F:\tablespace\demo' size 800M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 创建索引表空间 CREATE TABLESPACE lxg_index DATAFILE 'F:\tablespace\demo' size 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT

Posted by "lxg" on Monday, August 5, 2024