![C09 Transaction Exposure[1]](https://imgs-1438308264.cos.ap-hongkong.myqcloud.com/1e9113539b89680203d825b9.webp)
progress数据库的配置与运⾏progress数据库的配置与运⾏1. 环境变量设置:在shell为tcsh的情况, 修改.tcshrc , 加⼊:setenv DLC /home/progress/dlcsetenv WRKDIR /home/progress/wrksetenv PROEXE $DLC/bin/_progressetenv PROMSGS $DLC/promsgssetenv PATH "……:$DLC/bin"2. Progress数据库的启动:progress安装后就已经有demo, sports,isports,sports2000,empty⼏个初始的数据库.[root@xfs dlc]# pwd/home/progress/dlc[root@xfs dlc]# proserve sportsPROGRESS PATCH Version 9.1C09 as of February 26, 200213:54:25 BROKER : You are not allowed to connect to a database in $DLC. (1379)13:54:25 BROKER : ** This process terminated with exit code 2. (8619)以上信息表明我们不能在环境变量$DLC指定的路径下直接执⾏proserve命令初始化和sports数据库的连接.[root@xfs dlc]# pwd/root/sports[root@xfs ~/sports]# ls /home/progress/dlc/sports.*/home/progress/dlc/sports.b1 /home/progress/dlc/sports.db/home/progress/dlc/sports.d1 /home/progress/dlc/sports.pl[root@xfs ~/sports]# ls /home/progress/dlc/sports_*/home/progress/dlc/sports_7.d1 /home/progress/dlc/sports_8.d1[root@xfs ~/sports]# cp /home/progress/dlc/sports.* ./[root@xfs ~/sports]# cp /home/progress/dlc/sports_* ./[root@xfs ~/sports]# lssports_7.d1 sports_8.d1 sports.b1 sports.d1 sports.db sports.plsports.*和sports_*等⽂件是sports数据库存储在磁盘上的所有必须的⽂件, 我们把它们⼀起copy到/root/sports/下⾯, 就等于将sports数据库复制⼀份到/root/sports下⾯了.[root@xfs ~/sports]# proserve sports -S 2000 -N tcpPROGRESS PATCH Version 9.1C09 as of February 26, 200218:00:01 BROKER 0: Multi-user session begin. (333)18:00:01 BROKER 0: Begin Physical Redo Phase at 0 . (5326)18:00:01 BROKER 0: Physical Redo Phase Completed at blk 0 off 167 upd 0. (7161)18:00:01 BROKER 0: Started for 2000 using tcp, pid 26815. (5644)-S 2000表⽰在端⼝2000上提供sports数据库的连接服务, -N tcp表⽰以tcp socket提供连接(或者选择udp), 如果不加上-S 2000, 则proserve sports虽然没有出错信息, 但并未能初始化sports数据库的连接服务.启动sports数据库的连接服务后,[root@xfs ~/sports]# netstat -a|grep 2000tcp 0 0 *:2000 *:* LISTEN[root@xfs ~/sports]# lssports_7.d1 sports.b1 sports.db sports.lic sports.plsports_8.d1 sports.d1 sports.lg sports.lk可以看到多了sports.lg , sports.lic, sports.lk 3个⽂件.[root@xfs ~/sports]# ps -ef | grep progressroot 25601 1 0 13:32 pts/0 00:00:00 /home/progress/dlc/bin/_mprosrv_mprosrv为监控和提供数据库连接服务的进程.3. SQLExplorer: 类似Oracle sql plus的⼯具[root@xfs ~/sports]# sqlexp -H localhost -S 2000 -db sportsPROGRESS PATCH Version 9.1C09 as of February 26, 2002Connecting user "root" to URL "jdbc:jdbcprogress:T:localhost:2000:sports" (8920)SQLExplorer>这样就进⼊了SQLExplorer的命令⾏界⾯, 可在其下执⾏SQL语句进⾏表的创建和管理等. 在本机上执⾏的情况–H localhost可以省去, 但-S 2000不能省, 必须指定为上⾯proserve sports的时侯所指定的端⼝, 才能正确连接到sports数据库上去.SQLExplorer命令⾏下输⼊SQL语句和命令时是⼤⼩写⽆关的, 但必须以”; “显式表明⼀个SQL语句的结束.Progress数据库安装好以后就有⼀个并且只有⼀个唯⼀的DBA, 其⽤户名为sysprogress, 并且以其他⽤户名调⽤sqlexp进⼊SQLExplorer的时侯都不具备创建或修改任何表和数据的权限. 上⾯sqlexp -H localhost -S 2000 -db sports 没有加-user 选项, 则SQLExplorer就认为使⽤sports数据库的⽤户名为unix⽤户即root, 我们接着执⾏create table命令的话可以看到⽤户root是不具备创建table的权限的:SQLExplorer>create table test(1> name varchar(20),2> age integer3> );=== SQL Exception 1 ===SQLState=HY000ErrorCode=-20057[JDBC Progress Driver]:No RESOURCE privileges (7574)所以我们必须⾸先以sysprogress⾝分登⼊SQLExplorer, 然后grant权限给⽤户root:[root@xfs ~/sports]# sqlexp -H localhost -S 2000 -user sysprogress -db sportsPROGRESS PATCH Version 9.1C09 as of February 26, 2002Connecting user "sysprogress" to URL "jdbc:jdbcprogress:T:localhost:2000:sports" (8920)QLExplorer>create table test(1> name varchar(20),2> age integer3> );=== SQL Exception 1 ===SQLState=HY000ErrorCode=-211015[JDBC Progress Driver]:Database object (table, view, index, trigger,procedure, or synonym) owned by "sysprogress" cannot be created, dropped, or altered. (7883) //sysprogress本⾝拥有的表,视图等是不可修改的, 因为sysprogress DBA相当于unix的超级⽤户, 为数据库安全起见不能对其修改.查看系统中所有的表: (相当于mysql的 show tables;命令)SQLExplorer>select * from sysprogress.systables;ID TBL CREATOR OWNER TBLTYPE SEGID HAS_PCNSTRS HAS_FCNSTRSHAS_CCNSTRS HAS_UCNSTRS TBL_STATUS RSSID----------- -------------------------------- -------------------------------- -------------------------------- ------- ----------- ----------- ----------- ----------- ----------- ---------- -----------2 Customer PUB PUB T 0 N N N N Y 51 Invoice PUB PUB T 0 N N N N Y 53 Item PUB PUB T 0 N N N N Y 58 Local-Default PUB PUB T 0 N N N N Y 54 Order PUB PUB T 0 N N N N Y 55 Order-Line PUB PUB T 0 N N N N Y 59 Ref-Call PUB PUB T 0 N N N N Y 56 Salesrep PUB PUB T 0 N N N N Y 57 State PUB PUB T 0 N N N N Y 532786 SYSATTACHTBLS SYSPROGRESS SYSPROGRESS V 0 N N NN 532807 SYSBIGINTSTAT SYSPROGRESS SYSPROGRESS V 0 N .....................................................查看某个表的字段结构:SQLExplorer>select * from sysprogress.syscolumns where tbl='test';ID COL TBL OWNER COLTYPE WIDTH SCALE NULLFLAGDFLT_VALUE CHARSET COLLATION----------- -------------------------------- -------------------------------- -------------------------------- ---------- ----------- ----------- -------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------- --------------------------------3 AGE TEST ROOT integer4 0Y iso8859-1 basic_S2 NAME TEST ROOT varchar 20 0Y iso8859-1 basic_SSQLExplorer>grant resource to root; //赋予权限给⽤户rootSQLExplorer>grant dba to root;SQLExplorer>commit;再⽤root⾝分登⼊:[root@xfs ~/sports]# sqlexp -H localhost -S 2000 -db sportsPROGRESS PATCH Version 9.1C09 as of February 26, 2002Connecting user "root" to URL "jdbc:jdbcprogress:T:localhost:2000:sports" (8920)SQLExplorer>create table test(1> name varchar(20),2> age integer3> );SQLExplorer>select * from sysprogress.systables;......200 TEST ROOT ROOT T 0 NSQLExplorer>select * from test;NAME AGE-------------------- -----------可以看到⽤户root现在有了权限创建表和修改数据.其他命令:查看帮助:SQLExplorer>@help;Available options include:@AutoCommit { true | false }@ColumnWidthLimit { 1...31995 }@ColumnWidthMinimum { 1...2048 }@ConnectTimeout { 1...300 }@Connect jdbc:jdbcprogress:T:localhost:<port>:<database>- or -@Connect jdbc:odbc:<data-source-name>@DisableWarnings { true | false }@Disconnect { true | false }@EchoAll { true | false }@EchoCmd { true | false }@EchoComments { true | false }@EchoSql { true | false }@FetchLimit { 1...32767 }@HasColumnLimit { true | false }@HasFetchLimit { true | false }@Help [ <option> [ <option>...]]@Logfile <logFilename>@Logging { true | false }@PageLimit { 1...32767 }@Pager { true | false }@ReportFormat { Standard | By Label }@Reset [ <option> [ <option>...]]@Run <runFilename>@Show [ <option> [ <option>...]]@SqlVerbose { true | false }@TransactionIsolation { Read Uncommitted | Read Committed | Repeatable Read | Serializable } - or -@TransactionIsolation { 0 | 1 | 2 | 3 };Ok: help. (8932)SQLExplorer>@show;Options values are:AutoCommit falseColumnWidthLimit 25ColumnWidthMinimum 1ConnectTimeout 180Connect jdbc:jdbcprogress:T:localhost:2000:sportsDisableWarnings trueDisconnect trueEchoAll falseEchoCmd falseEchoComments falseEchoSql falseFetchLimit 101HasColumnLimit falseHasFetchLimit trueLogfile /root/sports/SQLExplorerSession.logLogging falsePageLimit 22Pager falseReportFormat StandardSqlVerbose falseTransactionIsolation 1: Read Committed;Ok: show. (8932)4. 关闭⼀个数据库的连接服务[root@xfs ~/sports]# proshut sports1 Disconnect a User2 Unconditional Shutdown3 Emergency Shutdown (Kill All)x ExitEnter choice> 2Shutdown is executing. (1613)Shutdown complete. (1614)数据库连接服务关闭后我们便⽆法再⽤SQLExplorer去连接和访问它:[root@xfs ~/sports]# sqlexp -H localhost -S 2000 -db sportsPROGRESS PATCH Version 9.1C09 as of February 26, 2002Connecting user "root" to URL "jdbc:jdbcprogress:T:localhost:2000:sports" (8920)error in tcp bind 111Error: [JDBC Progress Driver]:Error in Network Daemon. (8933)See "/root/sports/sqlexp.log" and "/root/sports/SQLExplorer.exceptions" files for more information. (8950)5. ⽤JDBC访问Progress数据库的demodemo程序在$DLC/src/samples/sql92/下⾯的JdbcProgressTest.java, ⾸先要在.tcshrc⾥加⼊设置CLASSPATH: setenv CLASSPATH".:/home/progress/dlc/java/jdbc.zip", 然后javac编译成JdbcProgressTest.class, 然后⽤java JdbcProgressTest [jdbcURL] [username ] [password]的格式调⽤, 例如java JdbcProgressTest jdbc:JdbcProgress:T:localhost:2000:testdb root.WIN NT 32 Intel 9.1C19 9.1C 2002/03/08再进⼊download 91C19.exe的页⾯, 把91C19.exe download下来.运⾏91C19.exe, ⼀般缺省解压到c:\program files\progress⽬录,解压完毕后, 必须在windows的环境变量⾥加⼊⼀项DLC, 值为前⾯解压到的⽬录即c:\program files\progress, 在环境变量PATH的值中添加⼊%DLC%\bin; 使其成为PATH=”….;%DLC%\bin;”, 然后还需要在CLASSPATH中加⼊c:\program files\progress\java\progress.zip, 完成这些环境变量设置后再运⾏java JdbcProgressTest jdbc:JdbcProgress:T:192.168.1.3:2000:cms root, 可以看到已经能在Windows下运⾏JDBC程序访问另⼀台机器或本机上的Progress数据库了.。
国际金融的英语术语国际借贷：balanceofinternationalindebtedness[in’detidnis]国际投资状况：internationalinvestmentposition国际收支平衡表：balanceofpaymentstatements借方：debit贷方：credit经常账户：经常账户商品：商品资本帐户：capitalaccount金融帐户：financialaccount官方储备[ri'ze:v]外部融资：externalfinance内部融资：internalfinance调整政策：adjustment国际储备国际清偿能力：internationalliquidity特别提款权：特别提款权储备缓解措施：储备缓解货币互换协定：swapagreement货币的公开贬值：贬值；贬值；贬值；贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值；公开贬值外汇敞口：foreignexchangeexposure间接受险部分：indirectexposure交易风险：transactionexposure会计风险：accountingexposure经济风险：economicexposure转换风险：转换风险顺序：顺序清算风险：settlementrisk敞口头寸：exposureposition一般参加者：ordinaryparticipant市场活跃者：jobber市场领导者：市场领导者即期外汇头寸限额：spotforeignexchangepositionlimit同业拆放头寸限额：moneymarketpositionlimit掉期外汇交易限额：swappositionlimit外汇买卖限额：gappinglimit敞口头寸：openpositionlimit及时抵补：covered买入太多资金：卖出太多资金：空头止损点：减少损失延迟收款和付款方式：滞后提前收款和付款方式：领先余额法：匹配组匹配方式：付款多种货币组合法：portfolioapproachornesting保值措施：covertherisk保值条款：provisoclause完美平衡：完美匹配即期合同法：sportcontract远期合同法：forwardcontract贷款法：借款投资法：投资外汇处理日期：spotdate同业拆借利率：londointerbankofferedratelibor国库券：treasurybill银行承兑汇票：银行承兑汇票贴现市场：贴现市场：外汇市场外汇银行：appintedforeignexchangebankorauthorizedbank中央银行：centralbank欧洲商品市场：欧洲货币市场领先中心：PrimaryCenter簿记中心：bookingcenters集资中心：fundingcenters代收中心：collectioncenters票据发行工具：票据IsuanceFacilityNIF利率兑换：利率WAP货币掉期：货币掉期远期利率协定：forwardrateagreementfra。
黑客零起点实战篇手把手教你用“流光”我们用流光IV来扫描一段网址！点击探测－高级扫描工具！输入ip地址范围！起始地址/结束地址：需要扫描的IP地址范围。
▪目标系统：ALL-所有系统NT-NT／2000系统UNIX-UNIX系统，根据选择的不同下面的［检测项目］将会有不同设置。
▪获取主机名：获取主机的名称。
▪检测项目：选择需要扫描的项目，根据选择的不同表单会有所不同。
如图3所示你可以自己定义你的用户字典和密码字典。
∙猜解用户名字典：设置扫描中采用的用户字典，适用于POP3/FTP/IMAP/SQL/MYSQL。
∙猜解密码字典：设置扫描中采用的密码字典，适用于POP3/FTP/IMAP/SQL/MYSQL。
∙保存扫描报告：扫描的报告，采用HTML格式。
∙并发线程数目：默认80，可以根据情况增减，如果线程数目越大速度越快但是越容易误报和漏报。
∙网络选项：设置TCP参数大概需要20分钟左右扫描结束！太多就不贴了！总之我们得到了两个admin的帐号！mf和lyl密码都是空！我们点击开始运行－输入cmd单击确定我们在命令提示符下使用net use命令远程连接主机210.192.111.207 如下所示：这里端口78是自己改的！默认端口是99如下所示：我们已经成功登陆到主机210.192.111.207，权限是system 这个时候很多人都会问我该做什么呢！我们首先在名利提示符下输入：net name显示那台主机的名字在输入：ipconfig看看他的网络配置，有两块网卡一个是内部：192.168.1.4 一个是外部的：210.192.111.207输入：ver对方主机显示：C:\WINNT\system32>verMicrosoft Windows 2000 [Version 5.00.2195]C:\WINNT\system32>C:\WINNT\system32>net start已经启动以下 Windows 2000 服务:AlerterApplication ManagementCOM+ Event SystemComputer BrowserDHCP ClientDistributed File SystemDistributed Link Tracking ClientDistributed Link Tracking ServerDistributed Transaction CoordinatorDNS ClientEvent LogFile Replication ServiceFTP Publishing ServiceIIS Admin ServiceIndexing ServiceIntersite MessagingIPSEC Policy AgentKerberos Key Distribution CenterLogical Disk ManagerMessengerMicrosoft SearchMicrosoft SMTP ServiceMSSQLServerNet LogonNetwork ConnectionsNT LM Security Support ProviderPlug and PlayPrint SpoolerProtected StorageRemote Procedure Call (RPC)Remote Procedure Call (RPC) LocatorRemote Registry ServiceRemovable StorageRunAs ServiceSecurity Accounts ManagerServerSQLServerAgentSystem Event NotificationTask SchedulerTCP/IP NetBIOS Helper ServiceWindows Management Instrumentation Driver Extensions Windows TimeWorkstationWorld Wide Web Publishing Service许可协议登录服务命令成功完成。
