05.DB_Dev

1、容错以太网是PKS的控制网络，FTE不但提供了容错的特点，也提供了快速网络的相应，及工业以太网的控制应用的安全性。

FTE（Fault Tolerant Etherent）容错以太网，是冗余网络结构的单网，通过Honeywell的FTE驱动，及商用的网络设备实现的。

FTE网络包括冗余的交换机和电缆。

拓扑：双重并行树形网络在顶部接在一起。

2、交换机之间的级联线（cross link）构成单网。

商用的网络设备指交换机、双口单网卡或单口双网卡。

FTE网络通讯检测画面检测画面启动3、系统必须有控制器、服务器、操作站组成。

4、FTE网络包括冗余交换机和电缆。

树网：连接到A交换机上A口形成的网叫A网（Yellow tree）。

连接到B交换机上B口形成的网叫B网（Green tree）。

Localhost 接收数据节点。

FLEX操作站（F站）：过程数据及相关的报警和事件，还有其他数据信息，直接来自服务器；组态ES-F两种连接方法：固定连接方法（Static）：提供了特定ES-F的一种永久性专用连接。

轮替连接方法（Rotary）：提供了一种按需的连接，适用不需要全日制操作访问时。

Console操作站（C站）：过程数据及相关的报警和事件，直接来自于控制器；其他数据信息来自于服务器；Console Extension操作站（CE）：过程数据及相关的报警和事件，还有其他数据信息，全部信息都来自与C站。

7、一个C300控制器带有两个IOLINK，每个IOLINK最多支持40个IO卡件，而一个控制器最多支持64个IO卡件。

每套C300控制器最多支持64个IO Units（IOU）。

C300控制器必须与控制防火墙连接。

C300控制器主控制器FTE地址设定奇数，备用控制器地址为主控制器的地址+1。

Control Firewall（CF9）控制防火墙：在FTE网络中是成对出现的，8+1口，其中有一个专门的网线路口用于向上连接交换机，其余的8个网口可以连接控制器。

win7系统中安装金蝶KIS过程经过测试，win7下安装KIS完全可行，具体如下讲解。

一、系统要求1. 应该使用win7 32位的版本，本人用的是win7 32位旗舰版2. 安装SQL2005标准版二、SQL2005标准版的安装1. 下载SQL2005标准版和SQL 2005 SP3可以到[url=/]/[/url]上去下载，用迅雷可以全速下载2. 配置IIS到控制面板，打开IIS Features,点左边的加号，打开详细信息，我们勾上以下组件：1: Web Managerment Tools\IIS 6 Management Compatibility\IIS6 WMI Compatibility2: Web Managerment Tools\IIS 6 Management Compatibility\IIS6 Metabase and IIS 6 Configuration Compatibility3: World Wide Web Services\Application Development Features\4: World Wide Web Services\Common Http Features\Http Redirection5: World Wide Web Services\Security\Windows Authentication3. 安装标准版SQL Server 2005按照提示安装即可，安装过程中，勾选客户端选项，选择混合身份认证模式。

4. 安装SQL Server 2005 SP3最后一步设置系统帐号权限，需要先到任务管理器中关闭sqlserver 进程（注意有提示），然后到打开dos窗口之前的一步，又需要手动启动sqlserver服务。

5. 启用SQL Server Browser 服务单击“开始”，依次指向“程序”、“Microsoft SQL Server 2005”和“配置工具”，然后单击“SQL Server 外围应用配置器”。

linux⼀个读写锁的使⽤异常导致的故障环境信息：WARNING: kernel version inconsistency between vmlinux and dumpfileKERNEL: vmlinux-47.90DUMPFILE: vmcore [PARTIAL DUMP]CPUS: 32DATE: Wed Nov 1411:08:242018UPTIME: 05:08:36LOAD AVERAGE: 484.39, 481.11, 385.18TASKS: 5287NODENAME: ycby25-3kh_2RELEASE: 3.0.101-0.47.90-defaultVERSION: #1 SMP Wed Oct 1914:11:00 UTC 2016 (56c73f1)MACHINE: x86_64 (2600 Mhz)MEMORY: 255.6 GBPANIC: "[18477.566692] Kernel panic - not syncing: hung_task: blocked tasks"PID: 144COMMAND: "khungtaskd"TASK: ffff881fc096e080 [THREAD_INFO: ffff881fc0970000]CPU: 7STATE: TASK_RUNNING (PANIC)dmesg最后的log信息：[17013.334105] show_signal_msg: 30 callbacks suppressed[17013.334110] CMoniterThread[26144]: segfault at 0 ip 00007f13a100c699 sp 00007f138371fc30 error 6in libCommonUtilitiesLib.so[7f13a0fdd000+ 4d000][18477.566473] INFO: task dev_rdwriter:23683 blocked for more than 1200 seconds.[18477.566475] "echo 0 > /proc/sys/kernel/hung_task_timeout_secs" disables this message.[18477.566477] dev_rdwriter D 0000000000800000023683189680x00000000[18477.566479] ffff88173e599d70 0000000000000082 ffff88173e598010 0000000000010900[18477.566483] 000000000001090000000000000109000000000000010900 ffff88173e599fd8[18477.566486] ffff88173e599fd8 0000000000010900 ffff88173e5964c0 ffff881fc3378580[18477.566489] Call Trace:[18477.566499] [<ffffffff81467485>] rwsem_down_failed_common+0xb5/0x160[18477.566505] [<ffffffff81264d13>] call_rwsem_down_write_failed+0x13/0x20[18477.566509] [<ffffffff8146679c>] down_write+0x1c/0x20[18477.566541] [<ffffffffa05ddb6c>] xfs_ilock+0xec/0x100 [xfs][18477.566629] [<ffffffffa0604e47>] xfs_file_fallocate+0xc7/0x190 [xfs][18477.566665] [<ffffffff8115d629>] do_fallocate+0x129/0x130[18477.566669] [<ffffffff8115d676>] sys_fallocate+0x46/0x70[18477.566673] [<ffffffff8146f5f2>] system_call_fastpath+0x16/0x1b[18477.566690] [<00007f344662b010>] 0x7f344662b00f[18477.566692] Kernel panic - not syncing: hung_task: blocked tasks[18477.566698] Pid: 144, comm: khungtaskd Tainted: G ENX 3.0.101-0.47.90-default #1[18477.566701] Call Trace:[18477.566707] [<ffffffff81004b95>] dump_trace+0x75/0x300[18477.566712] [<ffffffff81464663>] dump_stack+0x69/0x6f[18477.566717] [<ffffffff8146471f>] panic+0xb6/0x224[18477.566722] [<ffffffff810c8731>] check_hung_uninterruptible_tasks+0x1e1/0x1f0[18477.566726] [<ffffffff810c8787>] watchdog+0x47/0x50[18477.566730] [<ffffffff810845f6>] kthread+0x96/0xa0[18477.566735] [<ffffffff81470764>] kernel_thread_helper+0x4/0x1023683 阻塞了很长时间，这个时间我们当时设置的是1200s。

【Python】pipinstallpycairo-U失败的问题升级pycairo，失败了$ pip install pycairo -UDefaulting to user installation because normal site-packages is not writeableLooking in indexes: https:///simple, https:///simpleRequirement already satisfied: pycairo in /usr/lib/python3/dist-packages (1.16.2)Collecting pycairoUsing cached https:///packages/bc/3f/64e6e066d163fbcf13213f9eeda0fc83376243335ea46a66cefd70d62e8f/pycairo-1.20.1.tar.gz (344 kB) Installing build dependencies ... doneGetting requirements to build wheel ... donePreparing metadata (pyproject.toml) ... doneBuilding wheels for collected packages: pycairoBuilding wheel for pycairo (pyproject.toml) ... errorERROR: Command errored out with exit status 1:command: /usr/bin/python3 /home/pi/.local/lib/python3.7/site-packages/pip/_vendor/pep517/in_process/_in_process.py build_wheel /tmp/tmpdx40huz4cwd: /tmp/pip-install-vbxqp8qw/pycairo_17a047a1a1314649a235068111ef22e5Complete output (15 lines):running bdist_wheelrunning buildrunning build_pycreating buildcreating build/lib.linux-aarch64-3.7creating build/lib.linux-aarch64-3.7/cairocopying cairo/__init__.py -> build/lib.linux-aarch64-3.7/cairocopying cairo/__init__.pyi -> build/lib.linux-aarch64-3.7/cairocopying cairo/py.typed -> build/lib.linux-aarch64-3.7/cairorunning build_extPackage cairo was not found in the pkg-config search path.Perhaps you should add the directory containing `cairo.pc'to the PKG_CONFIG_PATH environment variableNo package 'cairo' foundCommand '['pkg-config', '--print-errors', '--exists', 'cairo >= 1.15.10']' returned non-zero exit status 1.----------------------------------------ERROR: Failed building wheel for pycairoFailed to build pycairoERROR: Could not build wheels for pycairo, which is required to install pyproject.toml-based projects安装libcairo2-dev$ sudo apt-get install libcairo2-devReading package lists... DoneBuilding dependency treeReading state information... DoneThe following additional packages will be installed:libcairo-script-interpreter2 libfontconfig1-dev libice-dev libpixman-1-dev libpthread-stubs0-dev libsm-dev libx11-dev libxau-devlibxcb-render0-dev libxcb-shm0-dev libxcb1-dev libxdmcp-dev libxext-dev libxrender-dev x11proto-core-dev x11proto-dev x11proto-xext-devxorg-sgml-doctools xtrans-devSuggested packages:libcairo2-doc libice-doc libsm-doc libx11-doc libxcb-doc libxext-docThe following NEW packages will be installed:libcairo-script-interpreter2 libcairo2-dev libfontconfig1-dev libice-dev libpixman-1-dev libpthread-stubs0-dev libsm-dev libx11-devlibxau-dev libxcb-render0-dev libxcb-shm0-dev libxcb1-dev libxdmcp-dev libxext-dev libxrender-dev x11proto-core-dev x11proto-devx11proto-xext-dev xorg-sgml-doctools xtrans-dev0 upgraded, 20 newly installed, 0 to remove and 0 not upgraded.Need to get 4,177 kB of archives.After this operation, 13.0 MB of additional disk space will be used.Do you want to continue? [Y/n] yGet:1 /debian buster/main arm64 libfontconfig1-dev arm64 2.13.1-2 [964 kB]Get:2 /debian buster/main arm64 libcairo-script-interpreter2 arm64 1.16.0-4+rpt1 [157 kB]Get:3 /debian buster/main arm64 libpixman-1-dev arm64 0.36.0-1+rpt1 [455 kB]Get:4 /debian buster/main arm64 libcairo2-dev arm64 1.16.0-4+rpt1 [706 kB]Get:5 /debian buster/main arm64 xorg-sgml-doctools all 1:1.11-1 [21.9 kB]Get:6 /debian buster/main arm64 x11proto-dev all 2018.4-4 [251 kB]Get:7 /debian buster/main arm64 x11proto-core-dev all 2018.4-4 [3,128 B]Get:8 /debian buster/main arm64 libxau-dev arm64 1:1.0.8-1+b2 [22.8 kB]Get:9 /debian buster/main arm64 libxdmcp-dev arm64 1:1.1.2-3 [41.2 kB]Get:10 /debian buster/main arm64 xtrans-dev all 1.3.5-1 [100 kB]Get:11 /debian buster/main arm64 libpthread-stubs0-dev arm64 0.4-1 [5,336 B]Get:12 /debian buster/main arm64 libxcb1-dev arm64 1.13.1-2 [174 kB]Get:13 /debian buster/main arm64 libx11-dev arm64 2:1.6.7-1+deb10u2 [816 kB]Get:14 /debian buster/main arm64 libxrender-dev arm64 1:0.9.10-1 [38.8 kB]Get:15 /debian buster/main arm64 x11proto-xext-dev all 2018.4-4 [3,128 B]Get:16 /debian buster/main arm64 libxext-dev arm64 2:1.3.3-1+b2 [104 kB]Get:17 /debian buster/main arm64 libice-dev arm64 2:1.0.9-2 [62.0 kB]Get:18 /debian buster/main arm64 libsm-dev arm64 2:1.2.3-1 [37.4 kB]Get:19 /debian buster/main arm64 libxcb-render0-dev arm64 1.13.1-2 [113 kB]Get:20 /debian buster/main arm64 libxcb-shm0-dev arm64 1.13.1-2 [101 kB]Fetched 4,177 kB in 1min 40s (41.6 kB/s)Selecting previously unselected package libcairo-script-interpreter2:arm64.(Reading database ... 94619 files and directories currently installed.)Preparing to unpack .../00-libcairo-script-interpreter2_1.16.0-4+rpt1_arm64.deb ...Unpacking libcairo-script-interpreter2:arm64 (1.16.0-4+rpt1) ...Selecting previously unselected package libfontconfig1-dev:arm64.Preparing to unpack .../01-libfontconfig1-dev_2.13.1-2_arm64.deb ...Unpacking libfontconfig1-dev:arm64 (2.13.1-2) ...Selecting previously unselected package xorg-sgml-doctools.Preparing to unpack .../02-xorg-sgml-doctools_1%3a1.11-1_all.deb ...Unpacking xorg-sgml-doctools (1:1.11-1) ...Selecting previously unselected package x11proto-dev.Preparing to unpack .../03-x11proto-dev_2018.4-4_all.deb ...Unpacking x11proto-dev (2018.4-4) ...Selecting previously unselected package x11proto-core-dev.Preparing to unpack .../04-x11proto-core-dev_2018.4-4_all.deb ...Unpacking x11proto-core-dev (2018.4-4) ...Selecting previously unselected package libxau-dev:arm64.Preparing to unpack .../05-libxau-dev_1%3a1.0.8-1+b2_arm64.deb ...Unpacking libxau-dev:arm64 (1:1.0.8-1+b2) ...Selecting previously unselected package libxdmcp-dev:arm64.Preparing to unpack .../06-libxdmcp-dev_1%3a1.1.2-3_arm64.deb ...Unpacking libxdmcp-dev:arm64 (1:1.1.2-3) ...Selecting previously unselected package xtrans-dev.Preparing to unpack .../07-xtrans-dev_1.3.5-1_all.deb ...Unpacking xtrans-dev (1.3.5-1) ...Selecting previously unselected package libpthread-stubs0-dev:arm64.Preparing to unpack .../08-libpthread-stubs0-dev_0.4-1_arm64.deb ...Unpacking libpthread-stubs0-dev:arm64 (0.4-1) ...Selecting previously unselected package libxcb1-dev:arm64.Preparing to unpack .../09-libxcb1-dev_1.13.1-2_arm64.deb ...Unpacking libxcb1-dev:arm64 (1.13.1-2) ...Selecting previously unselected package libx11-dev:arm64.Preparing to unpack .../10-libx11-dev_2%3a1.6.7-1+deb10u2_arm64.deb ...Unpacking libx11-dev:arm64 (2:1.6.7-1+deb10u2) ...Selecting previously unselected package libxrender-dev:arm64.Preparing to unpack .../11-libxrender-dev_1%3a0.9.10-1_arm64.deb ...Unpacking libxrender-dev:arm64 (1:0.9.10-1) ...Selecting previously unselected package x11proto-xext-dev.Preparing to unpack .../12-x11proto-xext-dev_2018.4-4_all.deb ...Unpacking x11proto-xext-dev (2018.4-4) ...Selecting previously unselected package libxext-dev:arm64.Preparing to unpack .../13-libxext-dev_2%3a1.3.3-1+b2_arm64.deb ...Unpacking libxext-dev:arm64 (2:1.3.3-1+b2) ...Selecting previously unselected package libice-dev:arm64.Preparing to unpack .../14-libice-dev_2%3a1.0.9-2_arm64.deb ...Unpacking libice-dev:arm64 (2:1.0.9-2) ...Selecting previously unselected package libsm-dev:arm64.Preparing to unpack .../15-libsm-dev_2%3a1.2.3-1_arm64.deb ...Unpacking libsm-dev:arm64 (2:1.2.3-1) ...Selecting previously unselected package libpixman-1-dev:arm64.Preparing to unpack .../16-libpixman-1-dev_0.36.0-1+rpt1_arm64.deb ...Unpacking libpixman-1-dev:arm64 (0.36.0-1+rpt1) ...Selecting previously unselected package libxcb-render0-dev:arm64.Preparing to unpack .../17-libxcb-render0-dev_1.13.1-2_arm64.deb ...Unpacking libxcb-render0-dev:arm64 (1.13.1-2) ...Selecting previously unselected package libxcb-shm0-dev:arm64.Preparing to unpack .../18-libxcb-shm0-dev_1.13.1-2_arm64.deb ...Unpacking libxcb-shm0-dev:arm64 (1.13.1-2) ...Selecting previously unselected package libcairo2-dev:arm64.Preparing to unpack .../19-libcairo2-dev_1.16.0-4+rpt1_arm64.deb ...Unpacking libcairo2-dev:arm64 (1.16.0-4+rpt1) ...Setting up libcairo-script-interpreter2:arm64 (1.16.0-4+rpt1) ...Setting up libfontconfig1-dev:arm64 (2.13.1-2) ...Setting up libpixman-1-dev:arm64 (0.36.0-1+rpt1) ...Setting up libpthread-stubs0-dev:arm64 (0.4-1) ...Setting up xtrans-dev (1.3.5-1) ...Setting up xorg-sgml-doctools (1:1.11-1) ...Processing triggers for libc-bin (2.28-10+rpt2+rpi1) ...Processing triggers for man-db (2.8.5-2) ...Processing triggers for sgml-base (1.29) ...Setting up x11proto-dev (2018.4-4) ...Setting up libxau-dev:arm64 (1:1.0.8-1+b2) ...Setting up libice-dev:arm64 (2:1.0.9-2) ...Setting up libsm-dev:arm64 (2:1.2.3-1) ...Setting up libxdmcp-dev:arm64 (1:1.1.2-3) ...Setting up x11proto-core-dev (2018.4-4) ...Setting up x11proto-xext-dev (2018.4-4) ...Setting up libxcb1-dev:arm64 (1.13.1-2) ...Setting up libx11-dev:arm64 (2:1.6.7-1+deb10u2) ...Setting up libxcb-shm0-dev:arm64 (1.13.1-2) ...Setting up libxcb-render0-dev:arm64 (1.13.1-2) ...Setting up libxext-dev:arm64 (2:1.3.3-1+b2) ...Setting up libxrender-dev:arm64 (1:0.9.10-1) ...Setting up libcairo2-dev:arm64 (1.16.0-4+rpt1) ...重试升级pycairo，成功了$ pip install pycairo -UDefaulting to user installation because normal site-packages is not writeableLooking in indexes: https:///simple, https:///simpleRequirement already satisfied: pycairo in /usr/lib/python3/dist-packages (1.16.2)Collecting pycairoUsing cached https:///packages/bc/3f/64e6e066d163fbcf13213f9eeda0fc83376243335ea46a66cefd70d62e8f/pycairo-1.20.1.tar.gz (344 kB) Installing build dependencies ... doneGetting requirements to build wheel ... donePreparing metadata (pyproject.toml) ... doneBuilding wheels for collected packages: pycairoBuilding wheel for pycairo (pyproject.toml) ... doneCreated wheel for pycairo: filename=pycairo-1.20.1-cp37-cp37m-linux_aarch64.whl size=275219 sha256=0c4b0a21f1c8f2aa059678faf6c0e1c3e46ed0f727a1f8e4e96421fe554e98b1 Stored in directory: /home/pi/.cache/pip/wheels/05/3b/2b/3d2f418dab0cb8821d23beb32ee5275ec394c3d5e390ecfc57Successfully built pycairoInstalling collected packages: pycairoSuccessfully installed pycairo-1.20.1。

1.下载安装文件通过svn下载源码#svn co https:///svnroot/opensips/trunk opensips_head2.基本安装需求库libmysqlclient-devmysql-client-5.1mysql-server-5.1bisonflexlibncurses5-dev3.安装#make#make all include_modules="db_mysql";#make install include_modules="db_mysql"安装成功的安装目录，默认为/usr/local/etc4.配置配置opensipsctlrc文件位置/usr/local/etc/opensips/opensipsctlrc，增加对数据库支持# $Id: opensipsctlrc 8289 2011-08-23 14:13:17Z razvancrainea $## The OpenSIPS configuration file for the control tools.## Here you can set variables used in the opensipsctl and opensipsdbctl setup# scripts. Per default all variables here are commented out, the control tools # will use their internal default values.## your SIP domain# SIP_DOMAIN=## chrooted directory# $CHROOT_DIR="/path/to/chrooted/directory"## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT,## by default none is loaded# If you want to setup a database with opensipsdbctl, you must at least specify # this parameter.DBENGINE=MYSQL## database hostDBHOST=localhost## database name (for ORACLE this is TNS name)DBNAME=opensips# database path used by dbtext or db_berkeleyDB_PATH="/usr/local/etc/opensips/dbtext"## database read/write userDBRWUSER=opensips## password for database read/write userDBRWPW="opensipsrw"## database super user (for ORACLE this is 'scheme-creator' user) DBROOTUSER="root"# user name columnUSERCOL="username"# SQL definitions# If you change this definitions here, then you must change them# in db/schema/entities.xml too.# FIXME# FOREVER="2020-05-28 21:32:15"# DEFAULT_ALIASES_EXPIRES=$FOREVER# DEFAULT_Q="1.0"# DEFAULT_CALLID="Default-Call-ID"# DEFAULT_CSEQ="13"# DEFAULT_LOCATION_EXPIRES=$FOREVER# Program to calculate a message-digest fingerprint# MD5="md5sum"# awk tool# AWK="awk"# grep tool# GREP="grep"# sed tool# SED="sed"# Describe what additional tables to install. Valid values for the variables# below are yes/no/ask. With ask (default) it will interactively ask the user# for an answer, while yes/no allow for automated, unassisted installs.## If to install tables for the modules in the EXTRA_MODULES variable.# INSTALL_EXTRA_TABLES=ask# If to install presence related tables.# INSTALL_PRESENCE_TABLES=ask# Define what module tables should be installed.# If you use the postgres database and want to change the installed tables,# then you must also adjust the STANDARD_TABLES or EXTRA_TABLES variable# accordingly in the opensipsdbctl.base script.# opensips standard modules# STANDARD_MODULES="standard acc domain group permissions registrar usrloc # msilo alias_db uri_db speeddial avpops auth_db pdt dialog # dispatcher dialplan drouting nathelper load_balancer"# opensips extra modules# EXTRA_MODULES="imc cpl siptrace domainpolicy carrierroute userblacklist b2b"## type of aliases used: DB - database aliases; UL - usrloc aliases## - default: none# ALIASES_TYPE="DB"## control engine: FIFO or UNIXSOCK## - default FIFO# CTLENGINE=xmlrpc## path to FIFO file# OSIPS_FIFO="/tmp/opensips_fifo"## MI_CONNECTOR control engine: FIFO, UNIXSOCK, UDP, XMLRPC# MI_CONNECTOR=FIFO:/tmp/opensips_fifo# MI_CONNECTOR=UNIXSOCK:/tmp/opensips.sock# MI_CONNECTOR=UDP:192.168.2.133:8000生成数据库脚本# opensipsdbctl createMySQL password for root:INFO: test server charsetINFO: creating database opensips ...INFO: Core OpenSIPS tables succesfully created.Install presence related tables? (y/n): yINFO: creating presence tables into opensips ...INFO: Presence tables succesfully created.Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist? (y/n): y INFO: creating extra tables into opensips ...INFO: Extra tables succesfully created.配置opensips.cfg文件位置/usr/local/etc/opensips更改监听网卡接口# $Id: opensips.cfg 8758 2012-02-29 11:59:26Z vladut-paiu $## OpenSIPS residential configuration script# byOpenSIPSSolutions<***************************>## This script was generated via "make menuconfig", from# the "Residential" scenario.# You can enable / disable more features / functionalities by# re-generating the scenario with different options.### Please refer to the Core CookBook at:# /Resources/DocsCookbooks# for a explanation of possible statements, functions and parameters.######## Global Parameters #########debug=3log_stderror=nolog_facility=LOG_LOCAL0fork=yeschildren=4/* uncomment the following lines to enable debugging */#debug=6#fork=no#log_stderror=yes/* uncomment the next line to enable the auto temporary blacklisting of not available destinations (default disabled) */#disable_dns_blacklist=no/* uncomment the next line to enable IPv6 lookup after IPv4 dns lookup failures (default disabled) */#dns_try_ipv6=yes/* comment the next line to enable the auto discovery of local aliases based on revers DNS on IPs */auto_aliases=no#listen=udp:127.0.0.1:5060 # CUSTOMIZE MElisten=udp:172.16.1.12:5060 # CUSTOMIZE MEdisable_tcp=yesdisable_tls=yes####### Modules Section #########set module pathmpath="/usr/local/lib/opensips/modules/"#### SIGNALING moduleloadmodule "signaling.so"#### StateLess moduleloadmodule "sl.so"#### Transaction Moduleloadmodule "tm.so"modparam("tm", "fr_timer", 5)modparam("tm", "fr_inv_timer", 30)modparam("tm", "restart_fr_on_each_reply", 0) modparam("tm", "onreply_avp_mode", 1)#### Record Route Moduleloadmodule "rr.so"/* do not append from tag to the RR (no need for this script) */ modparam("rr", "append_fromtag", 0)#### MAX ForWarD moduleloadmodule "maxfwd.so"#### SIP MSG OPerationS moduleloadmodule "sipmsgops.so"#### FIFO Management Interfaceloadmodule "mi_fifo.so"modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")#### URI moduleloadmodule "uri.so"modparam("uri", "use_uri_table", 0)#### USeR LOCation moduleloadmodule "usrloc.so"modparam("usrloc", "nat_bflag", 10)modparam("usrloc", "db_mode", 0)#### REGISTRAR moduleloadmodule "registrar.so"modparam("registrar", "tcp_persistent_flag", 7)/* uncomment the next line not to allow more than 10 contacts per AOR */ #modparam("registrar", "max_contacts", 10)54,1 18%#modparam("registrar", "max_contacts", 10)#### ACCounting moduleloadmodule "acc.so"/* what special events should be accounted ? */modparam("acc", "early_media", 0)modparam("acc", "report_cancels", 0)/* by default we do not adjust the direct of the sequential requests.if you enable this parameter, be sure the enable "append_fromtag"in "rr" module */modparam("acc", "detect_direction", 0)modparam("acc", "failed_transaction_flag", 3)/* account triggers (flags) */modparam("acc", "log_flag", 1)modparam("acc", "log_missed_flag", 2)####### Routing Logic ######### main request routing logicroute{if (!mf_process_maxfwd_header("10")) {sl_send_reply("483","Too Many Hops");exit;}if (has_totag()) {# sequential request withing a dialog should# take the path determined by record-routingif (loose_route()) {if (is_method("BYE")) {setflag(1); # do accounting ...setflag(3); # ... even if the transaction fails107,1 36%setflag(1); # do accounting ...setflag(3); # ... even if the transaction fails} else if (is_method("INVITE")) {# even if in most of the cases is useless, do RR for# re-INVITEs alos, as some buggy clients do change route set# during the dialog.record_route();}# route it out to whatever destination was set by loose_route()# in $du (destination URI).route(1);} else {if ( is_method("ACK") ) {if ( t_check_trans() ) {# non loose-route, but stateful ACK; must be an ACK after# a 487 or e.g. 404 from upstream servert_relay();exit;} else {# ACK without matching transaction -># ignore and discardexit;}}sl_send_reply("404","Not here");}exit;}# CANCEL processingif (is_method("CANCEL")){if (t_check_trans())t_relay();exit;}t_check_trans();if ( !(is_method("REGISTER") ) ) {if (from_uri==myself){} else {# if caller is not local, then called number must be localif (!uri==myself) {send_reply("403","Rely forbidden");exit;160,5-33 55%send_reply("403","Rely forbidden");exit;}}}# preloaded route checkingif (loose_route()) {xlog("L_ERR","Attempt to route with preloaded Route's [$fu/$tu/$ru/$ci]");if (!is_method("ACK"))sl_send_reply("403","Preload Route denied");exit;}# record routingif (!is_method("REGISTER|MESSAGE"))record_route();# account only INVITEsif (is_method("INVITE")) {setflag(1); # do accounting}if (!uri==myself) {append_hf("P-hint: outbound\r\n");route(1);}# requests for my domainif (is_method("PUBLISH|SUBSCRIBE")){sl_send_reply("503", "Service Unavailable");exit;}if (is_method("REGISTER")){if ( 0 ) setflag(7);if (!save("location"))sl_reply_error();exit;}if ($rU==NULL) {# request with no Username in RURI213,5-33 73%if ($rU==NULL) {# request with no Username in RURIsl_send_reply("484","Address Incomplete");exit;}# do lookup with method filteringif (!lookup("location","m")) {t_newtran();t_reply("404", "Not Found");exit;}# when routing via usrloc, log the missed calls alsosetflag(2);route(1);}route[1] {# for INVITEs enable some additional helper routesif (is_method("INVITE")) {t_on_branch("2");t_on_reply("2");t_on_failure("1");}if (!t_relay()) {send_reply("500","Internal Error");};exit;}branch_route[2] {xlog("new branch at $ru\n");}266,2-9 91%}onreply_route[2] {xlog("incoming reply\n");}failure_route[1] {if (t_was_cancelled()) {exit;}# uncomment the following lines if you want to block client# redirect based on 3xx replies.##if (t_check_status("3[0-9][0-9]")) {##t_reply("404","Not found");## exit;##}}启动和停止服务# opensipsctl startINFO: Starting OpenSIPS :INFO: started (pid: 28301)# opensipsctl stopINFO: Stopping OpenSIPS :INFO: stopped。

cURL命令使⽤指南cURL是什么curl是Linux命令⾏⼯具，可以使⽤任何可⽀持的协议（如HTTP、FTP、IMAP、POP3、SCP、SFTP、SMTP、TFTP、TELNET、LDAP或FILE）在服务器之间传输数据。

在Linux下，curl是由libcurl 提供驱动封装的cli客户端，在libcurl驱动下，curl可以⼀次传输多个⽂件。

⽽PHP中的cURL函数，也是基于libcurl驱动的。

curl由libcurl⽀持所有与传输相关的特性cURL常⽤参数参数说明-i默认隐藏响应头，此选项打印响应头与-I/--head仅显⽰响应头-o将相应内容保存指定路径下-O将相应内容保存在当前⼯作⽬录下-C断点续传，在 crtl + c终端后，可以从中断后部分开始-v显⽰请求头与响应头-x使⽤代理-X指定请求⽅法，POST GET PUT DELETE等-d如GET/POST/PUT/DELETE 需要传的表单参数，如JSON格式-u username:password当使⽤ftp有⽤户名可以使⽤-u，ftp允许匿名⽤户访问可以忽略–-limit-rate 2000B限速-T/--upload-file <file>上传⼀个⽂件-c/--cookie-jar <file name>将cookie下载到⽂件内-k/--insecure允许执⾏不安全的ssl连接，即调过SSL检测--header 'Host: '使⽤请求头-L/--location接受服务端redirect的请求-F上传⼆进制⽂件下⾯整理了⼀些常⽤语法使⽤格式cURL使⽤案例限制下载速率curl --limit-rate 100K /yourfile.tar.gz -O使⽤代理访问curl --proxy yourproxy:port https://限速访问curl --limit-rate 1k存储cookie和使⽤cookie[root@VM-0-2-centos ~]# curl --cookie-jar cnncookies.txt https:///index.html -O -s -v* About to connect() to port 443 (#0)* Trying 14.215.177.39...* Connected to (14.215.177.39) port 443 (#0)* Initializing NSS with certpath: sql:/etc/pki/nssdb* CAfile: /etc/pki/tls/certs/ca-bundle.crtCApath: none* SSL connection using TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256* Server certificate:* subject: CN=,O="Beijing Baidu Netcom Science Technology Co., Ltd",OU=service operation department,L=beijing,ST=beijing,C=CN* start date: Apr 02 07:04:58 2020 GMT* expire date: Jul 26 05:31:02 2021 GMT* common name: * issuer: CN=GlobalSign Organization Validation CA - SHA256 - G2,O=GlobalSign nv-sa,C=BE> GET /index.html HTTP/1.1> User-Agent: curl/7.29.0> Host: > Accept: */*>< HTTP/1.1 200 OK< Accept-Ranges: bytes< Cache-Control: private, no-cache, no-store, proxy-revalidate, no-transform< Connection: keep-alive< Content-Length: 2443< Content-Type: text/html< Date: Wed, 26 May 2021 12:14:41 GMT< Etag: "58860402-98b"< Last-Modified: Mon, 23 Jan 2017 13:24:18 GMT< Pragma: no-cache< Server: bfe/1.0.8.18* Added cookie BDORZ="27315" for domain , path /, expire 1622117681< Set-Cookie: BDORZ=27315; max-age=86400; domain=; path=/<{ [data not shown]* Connection #0 to host left intact# Netscape HTTP Cookie File# http://curl.haxx.se/docs/http-cookies.html# This file was generated by libcurl! Edit at your own risk. TRUE / FALSE 1622117681 BDORZ 27315[root@VM-0-2-centos ~]# curl --cookie cnncookies.txt https:// -s -v -o /dev/null* About to connect() to port 443 (#0)* Trying 14.215.177.39...* Connected to (14.215.177.39) port 443 (#0)* Initializing NSS with certpath: sql:/etc/pki/nssdb* CAfile: /etc/pki/tls/certs/ca-bundle.crtCApath: none* SSL connection using TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256* Server certificate:* subject: CN=,O="Beijing Baidu Netcom Science Technology Co., Ltd",OU=service operation department,L=beijing,ST=beijing,C=CN * start date: Apr 02 07:04:58 2020 GMT* expire date: Jul 26 05:31:02 2021 GMT* common name: * issuer: CN=GlobalSign Organization Validation CA - SHA256 - G2,O=GlobalSign nv-sa,C=BE> GET / HTTP/1.1> User-Agent: curl/7.29.0> Host: > Accept: */*> Cookie: BDORZ=27315>< HTTP/1.1 200 OK< Accept-Ranges: bytes< Cache-Control: private, no-cache, no-store, proxy-revalidate, no-transform< Connection: keep-alive< Content-Length: 2443< Content-Type: text/html< Date: Wed, 26 May 2021 12:23:27 GMT< Etag: "58860402-98b"< Last-Modified: Mon, 23 Jan 2017 13:24:18 GMT< Pragma: no-cache< Server: bfe/1.0.8.18* Replaced cookie BDORZ="27315" for domain , path /, expire 1622118207< Set-Cookie: BDORZ=27315; max-age=86400; domain=; path=/ # 这⾥可以看到设置的cookie<{ [data not shown]* Connection #0 to host left intact使⽤代理curl -x socks5://127.0.0.1:10808 https://使⽤application/x-www-form-urlencoded表单类型这⾥使⽤的为application/x-www-form-urlencodedcurl -d "option=value&something=anothervalue" -X POST https://{hostname}/使⽤json格式作为bodycurl -H "Content-Type: application/json" -X POST https:/// \-d '{"option": "value","something": "anothervalue"}'使⽤curl 上传⽂件curl {host}/api/v1/upimg -F "file=@/Users/fungleo/Downloads/401.png" \-H "token: 222" \-v也可以指定MIME类型。

测井曲线代码大全测井曲线(含解释结果)代码大全测井符号英文名称中文名称Rt true formation resistivity. 地层真电阻率Rxo flushed zone formation resistivity 冲洗带地层电阻率Ild deep investigate induction log 深探测感应测井Ilm medium investigate induction log 中探测感应测井Ils shallow investigate induction log 浅探测感应测井Rd deep investigate double lateral resistivity log 深双侧向电阻率测井Rs shallow investigate double lateral resistivity log 浅双侧向电阻率测井RMLL micro lateral resistivity log 微侧向电阻率测井CON induction log 感应测井AC acoustic 声波时差DEN density 密度CN neutron 中子GR natural gamma ray 自然伽马SP spontaneous potential 自然电位CAL borehole diameter 井径K potassium 钾TH thorium 钍U uranium 铀KTH gamma ray without uranium 无铀伽马NGR neutron gamma ray 中子伽马---------------------------------------------------POR 孔隙度 NEWSANDPORW 含水孔隙度 NEWSANDPORF 冲洗带含水孔隙度 NEWSANDPORT 总孔隙度 NEWSANDPORX 流体孔隙度 NEWSANDPORH 油气重量 NEWSANDBULK 出砂指数 NEWSANDPERM 渗透率 NEWSANDSW 含水饱和度 NEWSANDSH 泥质含量 NEWSANDCALO 井径差值 NEWSANDCL 粘土含量 NEWSANDDHY 残余烃密度 NEWSANDSXO 冲洗带含水饱和度 NEWSANDDA 第一判别向量的判别函数 NEWSANDDB 第二判别向量的判别函数 NEWSAND DAB 综合判别函数 NEWSANDCI 煤层标志 NEWSANDCARB 煤的含量 NEWSANDTEMP 地层温度 NEWSANDQ 评价泥质砂岩油气层产能的参数 NEWSAND PI 评价泥质砂岩油气层产能的参数 NEWSAND SH 泥质体积CLASS SW 总含水饱和度CLASS POR 有效孔隙度CLASS PORG 气指数CLASS CHR 阳离子交换能力与含氢量的比值CLASS CL 粘土体积CLASS PORW 含水孔隙度CLASS PORF 冲洗带饱含泥浆孔隙度CLASS CALC 井径差值CLASS DHYC 烃密度CLASS PERM 绝对渗透率CLASS PIH 油气有效渗透率CLASS PIW 水的有效渗透率CLASS CLD 分散粘土体积CLASS CLL 层状粘土体积CLASS CLS 结构粘土体积CLASS EPOR 有效孔隙度CLASS ESW 有效含水饱和度CLASS TPI 钍钾乘积指数CLASS POTV １００％粘土中钾的体积CLASS CEC 阳离子交换能力CLASS QV 阳离子交换容量CLASS BW 粘土中的束缚水含量CLASS EPRW 含水有效孔隙度CLASS UPOR 总孔隙度，UPOR=EPOR+BW CLASS HI 干粘土骨架的含氢指数CLASS BWCL 粘土束缚水含量CLASS TMON 蒙脱石含量CLASS TILL 伊利石含量CLASS TCHK 绿泥石和高岭石含量CLASS VSH 泥质体积CLASS VSW 总含水饱和度CLASS VPOR 有效孔隙度CLASS VPOG 气指数CLASS VCHR 阳离子交换能力与含氢量的比值CLASS VCL 粘土体积CLASS VPOW 含水孔隙度CLASS VPOF 冲洗带饱含泥浆孔隙度CLASS VCAC 井径差值CLASS VDHY 烃密度CLASS VPEM 绝对渗透率CLASS VPIH 油气有效渗透率CLASS VPIW 水的有效渗透率CLASS VCLD 分散粘土体积CLASS VCLL 层状粘土体积CLASS VCLS 结构粘土体积CLASS VEPO 有效孔隙度CLASS VESW 有效含水饱和度CLASS VTPI 钍钾乘积指数CLASS VPOV １００％粘土中钾的体积CLASS VCEC 阳离子交换能力CLASS VQV 阳离子交换容量CLASS VBW 粘土中的束缚水含量CLASS VEPR 含水有效孔隙度CLASS VUPO 总孔隙度CLASS VHI 干粘土骨架的含氢指数CLASS VBWC 粘土束缚水含量CLASS VTMO 蒙脱石含量CLASS VTIL 伊利石含量CLASS VTCH 绿泥石和高岭石含量CLASS QW 井筒水流量 PLIQT 井筒总流量 PLISK 射孔井段 PLIPQW 单层产水量 PLIPQT 单层产液量 PLIWEQ 相对吸水量 ZRPMPEQ 相对吸水强度 ZRPMPOR 孔隙度 PRCOPORW 含水孔隙度 PRCOPORF 冲洗带含水孔隙度 PRCOPORT 总孔隙度 PRCOPORX 流体孔隙度 PRCOPORH 油气重量 PRCOBULK 出砂指数 PRCOHF 累计烃米数 PRCOPF 累计孔隙米数 PRCOPERM 渗透率 PRCOSW 含水饱和度 PRCOSH 泥质含量 PRCOCALO 井径差值 PRCOCL 粘土含量 PRCODHY 残余烃密度 PRCOSXO 冲洗带含水饱和度 PRCOSWIR 束缚水饱和度 PRCOPERW 水的有效渗透率 PRCOPERO 油的有效渗透率 PRCOKRW 水的相对渗透率 PRCOKRO 油的相对渗透率 PRCOFW 产水率 PRCOSHSI 泥质与粉砂含量 PRCOSXOF 199＊SXO PRCOSWCO 含水饱和度 PRCOWCI 产水率 PRCOWOR 水油比 PRCOCCCO 经过PORT校正后的C／O值 PRCO CCSC 经过PORT校正后的SI／CA值 PRCO CCCS 经过PORT校正后的CA／SI值 PRCO DCO 油水层C／O差值 PRCOXIWA 水线视截距 PRCOCOWA 视水线值 PRCOCONM 视油线值 PRCOCPRW 产水率（C／O计算） PRCOCOAL 煤层 CRAOTHR 重矿物的百分比含量 CRASALT 盐岩的百分比含量 CRASAND 砂岩的百分比含量 CRALIME 石灰岩的百分比含量 CRADOLM 白云岩的百分比含量 CRAANHY 硬石膏的百分比含量 CRAANDE 安山岩的百分比含量 CRABASD 中性侵入岩百分比含量 CRADIAB 辉长岩的百分比含量 CRACONG 角砾岩的百分比含量 CRATUFF 凝灰岩的百分比含量 CRAGRAV 中砾岩的百分比含量 CRABASA 玄武岩的百分比含量 CRA________________________________________________________________ __________代码名称A1R1 T1R1声波幅度A1R2 T1R2声波幅度A2R1 T2R1声波幅度A2R2 T2R2声波幅度AAC 声波附加值AAVG 第一扇区平均值AC 声波时差AF10 阵列感应电阻率AF20 阵列感应电阻率AF30 阵列感应电阻率AF60 阵列感应电阻率AF90 阵列感应电阻率AFRT 阵列感应电阻率AFRX 阵列感应电阻率AIMP 声阻抗AIPD 密度孔隙度AIPN 中子孔隙度AMAV声幅AMAX 最大声幅AMIN 最小声幅AMP1 第一扇区的声幅值AMP2 第二扇区的声幅值 AMP3 第三扇区的声幅值AMP4 第四扇区的声幅值AMP5 第五扇区的声幅值AMP6 第六扇区的声幅值 AMVG 平均声幅 AO10 阵列感应电阻率AO20 阵列感应电阻率AO30 阵列感应电阻率AO60 阵列感应电阻率AO90 阵列感应电阻率AOFF 截止值AORT 阵列感应电阻率AORX 阵列感应电阻率APLC 补偿中子AR10 方位电阻率AR11 方位电阻率AR12 方位电阻率ARO1 方位电阻率ARO2 方位电阻率ARO3 方位电阻率ARO4 方位电阻率ARO5 方位电阻率ARO6 方位电阻率ARO7 方位电阻率ARO8 方位电阻率ARO9 方位电阻率AT10 阵列感应电阻率AT20 阵列感应电阻率AT30 阵列感应电阻率AT60 阵列感应电阻率AT90 阵列感应电阻率ATAV 平均衰减率ATC1 声波衰减率ATC2 声波衰减率ATC3 声波衰减率ATC4 声波衰减率ATC5 声波衰减率ATC6 声波衰减率ATMN 最小衰减率ATRT 阵列感应电阻率ATRX 阵列感应电阻率AZ 1号极板方位 AZ1 1号极板方位 AZI 1号极板方位AZIM 井斜方位BGF 远探头背景计数率BGN 近探头背景计数率BHTA 声波传播时间数据BHTT 声波幅度数据BLKC 块数BS 钻头直径BTNS 极板原始数据C1 井径 C2 井径 C3 井径 CAL 井径 CAL1 井径 CAL2 井径 CALI 井径 CALS 井径CASI 钙硅比CBL 声波幅度CCL 磁性定位CEMC 水泥图CGR 自然伽马CI 总能谱比CMFF 核磁共振自由流体体积CMRP 核磁共振有效孔隙度CN 补偿中子 CNL 补偿中子CO 碳氧比CON1 感应电导率COND 感应电导率CORR 密度校正值D2EC 200兆赫兹介电常数D4EC 47兆赫兹介电常数DAZ 井斜方位DCNT 数据计数DEN 补偿密度DEN_1 岩性密度DEPTH 测量深度DEV 井斜DEVI 井斜DFL 数字聚焦电阻率DIA1 井径 DIA2 井径 DIA3 井径DIFF 核磁差谱DIP1 地层倾角微电导率曲线1 DIP1_1 极板倾角曲线DIP2 地层倾角微电导率曲线2 DIP2_1 极板倾角曲线DIP3 地层倾角微电导率曲线3 DIP3_1 极板倾角曲线DIP4 地层倾角微电导率曲线4 DIP4_1 极板倾角曲线DIP5 极板倾角曲线 DIP6 极板倾角曲线DRH 密度校正值DRHO 密度校正值DT 声波时差DT1 下偶极横波时差DT2 上偶极横波时差DT4P 纵横波方式单极纵波时差DT4S 纵横波方式单极横波时差DTL 声波时差DTST 斯通利波时差ECHO 回波串ECHOQM 回波串ETIMD 时间FAMP 泥浆幅度FAR 远探头地层计数率FCC 地层校正FDBI 泥浆探测器增益FDEN 流体密度FGAT 泥浆探测器门限FLOW 流量FPLC 补偿中子FTIM 泥浆传播时间GAZF Z轴加速度数据GG01 屏蔽增益GG02 屏蔽增益GG03 屏蔽增益GG04 屏蔽增益GG05 屏蔽增益GG06 屏蔽增益GR 自然伽马GR2 同位素示踪伽马HAZI 井斜方位HDRS 深感应电阻率HFK 钾HMRS 中感应电阻率HSGR 无铀伽马HTHO 钍HUD 持水率HURA 铀IDPH 深感应电阻率IMPH 中感应电阻率K 钾KCMR 核磁共振渗透率KTH 无铀伽马LCAL 井径LDL 岩性密度LLD 深侧向电阻率LLD3 深三侧向电阻率LLD7 深七侧向电阻率LLHR 高分辨率侧向电阻率LLS 浅侧向电阻率LLS3 浅三侧向电阻率LLS7 浅七侧向电阻率M1R10 高分辨率阵列感应电阻率M1R120 高分辨率阵列感应电阻率M1R20 高分辨率阵列感应电阻率M1R30 高分辨率阵列感应电阻率M1R60 高分辨率阵列感应电阻率M1R90 高分辨率阵列感应电阻率M2R10 高分辨率阵列感应电阻率M2R120 高分辨率阵列感应电阻率M2R20 高分辨率阵列感应电阻率M2R30 高分辨率阵列感应电阻率M2R60 高分辨率阵列感应电阻率M2R90 高分辨率阵列感应电阻率M4R10 高分辨率阵列感应电阻率M4R120 高分辨率阵列感应电阻率M4R20 高分辨率阵列感应电阻率M4R30 高分辨率阵列感应电阻率M4R60 高分辨率阵列感应电阻率M4R90 高分辨率阵列感应电阻率MBVI 核磁共振束缚流体体积MBVM 核磁共振自由流体体积MCBW 核磁共振粘土束缚水ML1 微电位电阻率ML2 微梯度电阻率MPHE 核磁共振有效孔隙度MPHS 核磁共振总孔隙度MPRM 核磁共振渗透率MSFL 微球型聚焦电阻率NCNT 磁北极计数NEAR 近探头地层计数率NGR 中子伽马NPHI 补偿中子P01 第1组分孔隙度P02 第2组分孔隙度P03 第3组分孔隙度P04 第4组分孔隙度P05 第5组分孔隙度P06 第6组分孔隙度P07 第7组分孔隙度P08 第8组分孔隙度P09 第9组分孔隙度P10 第10组分孔隙度P11 第11组分孔隙度P12 第12组分孔隙度P1AZ 1号极板方位P1AZ_1 2号极板方位P1BTN 极板原始数据P2BTN 极板原始数据P2HS 200兆赫兹相位角P3BTN 极板原始数据P4BTN 极板原始数据P4HS 47兆赫兹相位角P5BTN 极板原始数据P6BTN 极板原始数据PAD1 1号极板电阻率曲线PAD2 2号极板电阻率曲线PAD3 3号极板电阻率曲线PAD4 4号极板电阻率曲线PAD5 5号极板电阻率曲线PAD6 6号极板电阻率曲线PADG 极板增益PD6G 屏蔽电压PE 光电吸收截面指数PEF 光电吸收截面指数PEFL 光电吸收截面指数PERM-IND 核磁共振渗透率POTA 钾PPOR 核磁T2谱 PPORB 核磁T2谱 PPORC 核磁T2谱PR 泊松比PRESSURE 压力 QA 加速计质量 QB 磁力计质量 QRTT 反射波采集质量 R04 0.4米电位电阻率 R045 0.45米电位电阻率 R05 0.5米电位电阻率 R1 1米底部梯度电阻率 R25 2.5米底部梯度电阻率 R4 4米底部梯度电阻率 R4AT200兆赫兹幅度比 R4AT_1 47兆赫兹幅度比 R4SL 200兆赫兹电阻率 R4SL_1 47兆赫兹电阻率 R6 6米底部梯度电阻率 R8 8米底部梯度电阻率 RAD1 井径（极板半径） RAD2 井径（极板半径） RAD3 井径（极板半径）RAD4 井径（极板半径）RAD5 井径（极板半径）RAD6 井径（极板半径） RADS 井径（极板半径） RATI 地层比值 RB 相对方位RB_1 相对方位角 RBOF 相对方位 RD 深侧向电阻率 RFOC 八侧向电阻率 RHOB 岩性密度 RHOM 岩性密度 RILD 深感应电阻率 RILM 中感应电阻率 RLML 微梯度电阻率 RM 钻井液电阻率 RMLL 微侧向电阻率RMSF 微球型聚焦电阻率RNML 微电位电阻率ROT 相对方位RPRX 邻近侧向电阻率 RS 浅侧向电阻率 SDBI 特征值增益 SFL 球型聚焦电阻率 SFLU 球型聚焦电阻率 SGAT 采样时间 SGR 无铀伽马 SICA 硅钙比SIG 井周成像特征值SIGC 俘获截面SIGC2 示踪俘获截面SMOD 横波模量 SNL 井壁中子 SNUM 特征值数量 SP 自然电位 SPER 特征值周期 T2 核磁T2谱 T2-BIN-A 核磁共振区间孔隙度T2-BIN-B 核磁共振区间孔隙度 T2-BIN-PR 核磁共振区间孔隙度 T2GM T2分布对数平均值T2LM T2分布对数平均值TEMP 井温TH 钍THOR 钍TKRA 钍钾比TPOR 核磁共振总孔隙度 TRIG 模式标志 TS 横波时差 TT1 上发射上接受的传播时间 TT2 上发射下接受的传播时间 TT3 下发射上接受的传播时间 TT4 下发射下接受的传播时间 TURA 钍铀比 U 铀 UKRA 铀钾比 URAN 铀 VAMP 扇区水泥图 VDL 声波变密度 VMVM 核磁共振自由流体体积 VPVS 纵横波速度比 WAV1 第一扇区的波列 WAV2 第二扇区的波列 WAV3 第三扇区的波列 WAV4 第四扇区的波列 WAV5 第五扇区的波列 WAV6 第六扇区的波列 WAVE 变密度图 WF 全波列波形 ZCORR 密度校正值——————————————————————————————————————————————————————————————————————————测井项目及曲线名称2.5米梯度m2.25a0.5 r25梯度电极m2.25a0.5b r25自然电位 sp井径 cal微电极a0.025m0.025n-a0.05m ml1、ml2井温 temp声波时差 ac感应测井 cond自然伽码 gr声波幅度 cbl0.4米a0.4m2.25n r040.4米a0.4m2.35n r040.5米b2.25a0.5 r054米a3.75m0.5n r44米m3.75a0.5b r40.45米m0.4a0.1b r045rt深侧向电阻率 rtrxo浅侧向电阻率 rxo中子伽码 ngrden密度 dencnl井壁中子cnlrxo1微球形聚焦电阻率 rxo1伽马－伽马 gr流体电阻率 rt微测向 rmll七测向 lld7、lls7中感应 rilm深感应 rild八测向 rfoc井斜 dev方位角 azim激发电位人工电位补偿声波 bhc声波衰减率 atc常用测井曲线名称测井符号英文名称中文名称rt true formation resistivity. 地层真电阻率rxo flushed zone formation resistivity 冲洗带地层电阻率ild deep investigate induction log 深探测感应测井ilm medium investigate induction log 中探测感应测井ils shallow investigate induction log 浅探测感应测井rd deep investigate double lateral resistivity log 深双侧向电阻率测井rs shallow investigate double lateral resistivity log 浅双侧向电阻率测井rmll micro lateral resistivity log 微侧向电阻率测井con induction log 感应测井ac acoustic 声波时差den density 密度cn neutron 中子gr natural gamma ray 自然伽马sp spontaneous potential 自然电位cal borehole diameter 井径k potassium 钾th thorium 钍u uranium 铀kth gamma ray without uranium 无铀伽马ngr neutron gamma ray 中子伽马5700系列的测井项目及曲线名称star imager 微电阻率扫描成像cbil 井周声波成像mac 多极阵列声波成像mril 核磁共振成像tbrt 薄层电阻率dac 阵列声波dvrt 数字垂直测井hdip 六臂倾角mphi 核磁共振有效孔隙度mbvm 可动流体体积mbvi 束缚流体体积mperm 核磁共振渗透率echoes 标准回波数据t2 dist t2分布数据tpor 总孔隙度bhta声波幅度bhtt 声波返回时间image dip 图像的倾角comp amp 纵波幅度shear amp 横波幅度comp attn 纵波衰减shear attn 横波衰减radoutr 井眼的椭圆度dev 井斜测井基础看好灰机~ 2009-11-21 00:08 阅读60 评论3字号：大大中中小小孔隙度：岩石孔隙体积与岩石总体积之比。

DB2安装本文以DB2 v8.2版本为例讲解DB2 安装初始界面（图一）双击DB2安装光盘中的setup.exe文件会出现如上图一显示的安装初始界面，选择安装产品。

这里我们选择安装DB2 UDB企业服务器版，下一步接下来出现欢迎使用“DB2 安装”向导界面点击下一步出现上图的许可证协议界面，选择我接受许可证协议中的全部条款，点击下一步（当然你也可以不接受，点击下一步退出本软件的安装）选择安装类型提供三种安装类型，这边我直接点击下一步，继续软件的安装。

选择下一步可以选择安装在那个分区，并指定安装的目录，然后选择下一步为DB2 管理服务器设置用户信息，如果不是域环境，域可以留空，为默认用户db2admin设定一个密码。

选择下一步默认，下一步出现如下界面点击下一步继续下一步继续如果目前没有此实例的管理联系人，可以选择将任务延迟到完成安装后进行，然后选择下一步出现下图所示的安装信息的汇总。

点击安装。

耐心等待几分钟来完成DB2的安装。

点击完成，至此DB2数据库的安装过程就结束。

DB2的管理1.、创建数据库打开DB2的控制中心开始→程序→IBM DB2→一般管理工具→控制中心或者点击桌面右下角的绿色小图标，选择DB2控制中心…下图为DB2控制中心管理界面点击所有数据库选择创建新的数据库后出现如下界面指定创建的数据库名，缺省驱动器，下一步默认，下一步下一步继续，直到完成至此，数据库test就创建完成。

如何在新建的test库创建表及表中插入数据还是通过控制中心，点击所有数据库，会显示刚才创建的test库，双击库名展开，点击表，同样在界面的右侧下方，选择创建新的表下一步选择添加，在创建的表test，添加一列这里我填写的是test，然后点应用，确定。

关闭添加列界面，重新回到刚才界面，点下一步继续，表空间，键，维，约束可以是默认，出现下面界面，点击完成。

通过上面的操作，我们创建了一个名为test的库，并且往这个库创建了一个名为test的表，表插入一列，列名为test。

--查询→‎S QLCM‎D模式，可‎以执行操作‎系统命令‎!!if ‎n ot e‎x ist ‎E:\ba‎c kup ‎M D E:‎\Back‎u p--‎目标文件命‎名不规范‎B acku‎p Dat‎a base‎Nort‎h wind‎C STo‎disk‎='E:\‎B acku‎p\aaa‎'--完‎整备份，命‎名规范B‎a ckup‎Data‎b ase ‎N orth‎w indC‎STo ‎d isk=‎'E:\B‎a ckup‎\Nort‎h wind‎C S-20‎10081‎5-F.b‎a k' -‎-差异备份‎Back‎u p Da‎t abas‎e Nor‎t hwin‎d CST‎o dis‎k='E:‎\Back‎u p\No‎r thwi‎n dCS-‎20100‎815-D‎.bak'‎With‎Diff‎e rent‎i al-‎-事务日志‎备份,数据‎库不能是简‎单恢复模式‎--默认‎截断日志‎B acku‎p Log‎Nort‎h wind‎C STo‎disk‎='E:\‎B acku‎p\Nor‎t hwin‎d CS-2‎01008‎15-L.‎b ak' ‎--查看数‎据库的文件‎和文件组‎E xec ‎s p_he‎l pdb ‎N orth‎w indC‎S--备‎份数据文件‎Back‎u p Da‎t abas‎e Nor‎t hwin‎d CS F‎i le='‎N orth‎w indC‎S' To‎disk‎='E:\‎B acku‎p\Nor‎t hwin‎d CS-2‎01008‎15-Fi‎l e.ba‎k' --‎备份文件组‎Back‎u p Da‎t abas‎e Nor‎t hwin‎d CS F‎i leGr‎o up='‎P rima‎r y' T‎o dis‎k='E:‎\Back‎u p\No‎r thwi‎n dCS-‎20100‎815-F‎G.bak‎' --仅‎复制备份，‎不影响现有‎的备份序列‎Back‎u p Da‎t abas‎e Nor‎t hwin‎d CST‎o dis‎k='E:‎\Back‎u p\No‎r thwi‎n dCS-‎20100‎815-C‎.bak'‎With‎Copy‎_only‎--事务‎日志备份,‎但是不截断‎日志Ba‎c kup ‎L og N‎o rthw‎i ndCS‎To d‎i sk='‎E:\Ba‎c kup\‎N orth‎w indC‎S-201‎00815‎-L.ba‎k' Wi‎t h No‎_Trun‎c ate‎--千万不‎要物理删除‎日志文件‎--立即截‎断日志不保‎留,SQL‎2008不‎支持Ba‎c kup ‎L og N‎o rthw‎i ndCS‎With‎No_l‎o gBa‎c kup ‎L og N‎o rthw‎i ndCS‎With‎Trun‎c ate_‎O nly‎--SQL‎2008‎替代实现‎的截断日志‎方法Al‎t er D‎a taba‎s e No‎r thwi‎n dCS ‎S‎e t Re‎c over‎y Sim‎p leD‎b cc S‎h rink‎F ile(‎N orth‎w indC‎S_log‎)Alt‎e r Da‎t abas‎e Nor‎t hwin‎d CS‎Se‎t Rec‎o very‎Full‎--一个‎文件可以存‎放多次备份‎，默认是追‎加Bac‎k up D‎a taba‎s e No‎r thwi‎n dCS‎T o di‎s k='E‎:\Bac‎k up\N‎o rthw‎i ndCS‎-2010‎0815-‎F.bak‎'--覆‎盖现有的备‎份目标文件‎Back‎u p Da‎t abas‎e Nor‎t hwin‎d CST‎o dis‎k='E:‎\Back‎u p\No‎r thwi‎n dCS-‎20100‎815-F‎.bak'‎With‎Init‎--分割‎备份到多个‎目标文件‎B acku‎p Dat‎a base‎Nort‎h wind‎C STo‎disk‎='E:\‎B acku‎p\Nor‎t hwin‎d CS-2‎01008‎15-Pa‎r t1.b‎a k'‎, di‎s k='E‎:\Bac‎k up\N‎o rthw‎i ndCS‎-2010‎0815-‎P art2‎.bak'‎--镜像‎备份到多个‎目标文件，‎S QL20‎05以后支‎持Bac‎k up D‎a taba‎s e No‎r thwi‎n dCS‎T o di‎s k='E‎:\Bac‎k up\N‎o rthw‎i ndCS‎-2010‎0815-‎M1.ba‎k'Mi‎r ror ‎T O di‎s k='E‎:\Bac‎k up\N‎o rthw‎i ndCS‎-2010‎0815-‎M2.ba‎k' WI‎T H FO‎R MAT‎--尾部‎日志备份,‎备份完成之‎后数据库不‎再提供服务‎Back‎u p Lo‎g Nor‎t hwin‎d CST‎o dis‎k='E:‎\Back‎u p\No‎r thwi‎n dCS-‎20100‎815-T‎a il.b‎a k'W‎i th N‎o Reco‎v ery‎--恢复数‎据库的可用‎Rest‎o re D‎a taba‎s e No‎r thwi‎n dCS ‎W ith ‎R ecov‎e ry‎--如何执‎行相同的语‎句每天生成‎一个备份文‎件Dec‎l are ‎@Path‎varc‎h ar(3‎000)‎S et @‎P ath=‎'E:\B‎a ckup‎\Nort‎h wind‎C S-'‎+ ‎C onve‎r t(va‎r char‎,Getd‎a te()‎,112)‎+'-F‎.bak'‎Back‎u p Da‎t abas‎e Nor‎t hwin‎d CST‎o dis‎k=@Pa‎t h‎--如何‎启用XP_‎C mdsh‎e ll 存‎储过程-‎-查看SQ‎L实例当前‎的配置E‎x ec s‎p_con‎f igur‎e--‎开启高级配‎置选项的显‎示Exe‎c sp_‎c onfi‎g ure ‎'show‎adva‎n ced ‎o ptio‎n s',1‎--让配‎置立即生效‎Reco‎n figu‎r e Wi‎t h Ov‎e rrid‎e--查‎看SQL实‎例当前的配‎置Exe‎c sp_‎c onfi‎g ure ‎--启动‎X P_Cm‎d shel‎lExe‎c sp_‎c onfi‎g ure ‎'xp_c‎m dshe‎l l',1‎--让配‎置立即生效‎Reco‎n figu‎r e Wi‎t h Ov‎e rrid‎e-‎-如何实现‎直接备份到‎异地（其他‎服务器）‎--1.备‎份到远程服‎务器，使用‎同名同密码‎账号写入‎B acku‎p Dat‎a base‎Nort‎h wind‎C STo‎disk‎='\\‎192.1‎68.1.‎22\Ba‎c kup\‎N orth‎w indC‎S_fy.‎b ak'‎--2.‎备份到远程‎服务器，执‎行写入的用‎户名和密码‎Exec‎Xp_c‎m dshe‎l l‎'Net ‎U se \‎\192.‎168.1‎.164\‎B acku‎p /US‎E R:SQ‎L Serv‎i ce p‎a sswo‎r d' B‎a ckup‎Data‎b ase ‎N orth‎w indC‎STo‎disk‎='\\‎192.1‎68.1.‎164\B‎a ckup‎\Nort‎h wind‎C S_Fy‎.bak'‎-‎-创建备份‎设备US‎E [ma‎s ter]‎GO-‎-创建逻辑‎设备，映射‎到一个文件‎EXEC‎mast‎e r.db‎o.sp_‎a ddum‎p devi‎c e‎@devt‎y pe =‎N'di‎s k', ‎@log‎i caln‎a me =‎N'Lo‎c alDE‎V',‎@phys‎i caln‎a me =‎N'E:‎\Back‎u p\Lo‎c alDE‎V.bak‎'GO‎--备份到‎设备Ba‎c kup ‎D atab‎a se N‎o rthw‎i ndCS‎T‎o Loc‎a lDEV‎‎。