mono 数据库

Re阿里云centos6.532位如何安装asp.net环境？（nginxMYSQL已安装） 补充：centos6.5 32位，用的是阿里云linux_setup_1.4.1一键WEB环境。 ------------------------- 回2楼ivmmff的帖子 非常感谢，我先试验下看看。 ------------------------- Re阿里云centos6.532位如何安装asp.net环境？（nginxMYSQL已安装） 非常感谢安装指导，我用centos6.5 32位镜像，根据您的提示，详细安装过程如下： 一、更新系统运行以下命令，更新系统软件包：yum -y update二、 安装编译Mono时需要的软件运行以下命令，安装必需的软件包和库：yum -y install gcc gcc-c++ bison pkgconfig glib2-devel gettext make libpng-devel libjpeg-devel libtiff-devel libexif-devel giflib-devel libX11-devel freetype-devel fontconfig-devel  cairo-devel三、编译安装libgdipluslibgdiplus是安装Mono需要的GDI+兼容API库，运行以下命令，编译安装libgdiplus-3.12：mkdir /root/Downloadscd /root/Downloadswget http://download.mono-project.com/sources/libgdiplus/libgdiplus-3.12.tar.gztar -xvzf libgdiplus-3.12.tar.gzcd libgdiplus-3.12./configure --prefix=/usr/localmake && make install四、编译安装Mono运行以下命令，从源码编译安装4.0.3.19Mono：cd /root/Downloadswget http://download.mono-project.com/sources/mono/mono-4.0.3.19.tar.bz2tar -jxvf mono-4.0.3.19.tar.bz2cd mono-4.0.3./autogen.sh./configure --prefix=/usrsed -i 's/define HAVE_LOCALCHARSET_H 1/define HAVE_LOCALCHARSET_H 0/g' eglib/config.hmake && make installldconfig输入 mono -V 如有mono版本信息,则安装成功。五、编译安装Jexus运行以下命令，从源码编译安装Jexus-5.6.3：cd /root/Downloadswget http://jaist.dl.sourceforge.net/project/jexus-webserver/jexus-5.6.3.tar.gztar -zvxf jexus-5.6.3.tar.gzcd jexus-5.6.3./install /usr/local/jexus六、测试通过以下命令可以启动/停止/重启Jexus服务：/usr/local/jexus/jws start/usr/local/jexus/jws stop/usr/local/jexus/jws restart通过以下命令可以启动/停止/重启指定网站：/usr/local/jexus/jws start <siteName>/usr/local/jexus/jws stop <siteName>/usr/local/jexus/jws restart <siteName> 现在http://wap.dzbfsj.com/info打开，测试正常，但不知道怎样才能在运行ASP.NET网站的同时，运行php呢？ ------------------------- Re阿里云centos6.532位如何安装asp.net环境？（nginxMYSQL已安装） 用不了现成的aspx源码。。。这真不是一般人能弄成的。 http://wap.dzbfsj.com/index.aspx ------------------------- Re阿里云centos6.532位如何安装asp.net环境？（nginxMYSQL已安装） 不支持ACCES数据库，实用性不大。 ------------------------- 回22楼买醉的帖子 mdbtools网上找不到任何有用的教程啊，都是非常古老的。 ------------------------- 回 24楼(买醉) 的帖子 谢谢提醒，有空我再试试，反正另一个ECS就是不停地折腾做试验的。

Re:回12楼买醉的帖子 引用第14楼风中的过于2015-07-29 21:57发表的 回12楼买醉的帖子 : 高手，能否提示下centos6.5 下的asp.net安装要点？非常需要这个 依赖： yum -y install autogen glib2-devel libtiff libtiff-devel libjpeg libjpeg-devel giflib giflib-devel libpng libpng-devel libX11 libX11-devel freetype freetype-devel fontconfig fontconfig-devel libexif libexif-devel gcc-c++ gettext unzip libgdiplus gtk2-sharp pango cairo pixman zip glib bzip2 bzip2-devel curl-devel gtk2-devel boost-devel libtool libtool-devel git 安装需要的软件，mono官方都有下的 安装命令： tar -zxvf libgdiplus-3.12.tar.gzcd libgdiplus-3.12./configure --prefix=/usrmake && make installcd ..tar -jxvf mono-4.0.3.19.tar.bz2cd mono-4.0.3./autogen.sh./configure --prefix=/usr sed -i 's/define HAVE_LOCALCHARSET_H 1/define HAVE_LOCALCHARSET_H 0/g' eglib/config.hmake && make installcd ..export PKG_CONFIG_PATH=/usr/lib/pkgconfig:/usr/local/lib/pkgconfig:/usr/lib64/pkgconfig:/usr/share/pkgconfiggit clone https://github.com/mono/xsp.gitcd xsp./autogen.sh./configure --prefix=/usrmake && make installcd .. 启动命令： fastcgi-mono-server4 /applications=/:/wwwroot/htdocs/www/ /socket=tcp:127.0.0.1:9001 /printlog=true  2>&1 > /dev/null &或者用fastcgi-mono-server4 /applications=/:/wwwroot/htdocs/www/ /socket=unix:/tmp/mono.sock /printlog=true  2>&1 > /dev/null & 加入启动项（或者写启动脚本也行）： cat >> /etc/rc.local << EOFfastcgi-mono-server4 /applications=/:/wwwroot/htdocs/www/ /socket=unix:/tmp/mono.sock /printlog=true  2>&1 > /dev/null &EOF 如果是centos7 还需要给rc.local执行权限 chmod +x /etc/rc.d/rc.local 至于怎么整合nginx你用tcp或者unix都行，和php一样的加上就行了，看启动命令 /wwwroot/htdocs/www/ 为我的站点目录，换成你的，还有就是文件权限要是nginx的运行用户权限 如果你有多个.net站 建议你别装xsp和nginx,直接使用Jexus作为web server,Jexus也可以跑php等fcgi接口的环境，比如php / cgi  / python 等环境，也有反向代理功能可以整合jsp等环境 xsp只能跑单一的.net站点 ------------------------- Re:Re阿里云centos6.532位如何安装asp.net环境？（nginxMYSQL已安装） 引用第21楼秋日的私语于2015-07-30 16:07发表的 Re阿里云centos6.532位如何安装asp.net环境？（nginxMYSQL已安装） : 不支持ACCES数据库，实用性不大。 [url=http://bbs.aliyun.com/job.php?action=topost&tid=252259&pid=681098][/url] 谁告诉你不linux就不支持access数据库了，下结论前先在网络上搜索一下，给你个提示 mdbtools 至于jexus怎么支持php，这个要看你用什么方式运行php了，如果是tcp方式就在jexus的配置文件里加一行如：fastcgi.add=php|tcp:127.0.0.1:9000 如果是unix方式启动的php就加一行如：fastcgi.add=php|socket:/tmp/php-cgi.sock ------------------------- Re:回22楼买醉的帖子 引用第23楼秋日的私语于2015-07-30 18:57发表的 回22楼买醉的帖子 : mdbtools网上找不到任何有用的教程啊，都是非常古老的。 access也很古老 mdbtools其实很简单的，自己搭建个本地环境，试几次就知道了，至于程序的新版，网上有下的，你要是找不到我也没办法

wav文件头包含了wav文件大小，采样率，数据位，声道等信息，如果你去噪不改变这些，就不需要扩展，只要将紧随其后的音频数据处理即可，处理后的数据还是保存成wav格式，将之前的头信息(或者修改后）写在新文件的的文件头即可。wav数据处理有很多现成的库，比如libsample等。######太感谢了，一语中的！###### 代码里面只处理了采样率，这是不够的。还需要看数据位(通常是8bit,16bit)和声道(MONO或STEREO)。 另外有些WAV文件不是标准的44字节文件头，需要注意下。

Re这样的配置应该怎么升级？ 1核 1G 2M足以，我的一个wp博客 每天也在2000-8000IP左右，另外还装了java和mono 主要看你怎么优化了，如果静态文件 等等多，可以使用varnish做前端，如果动态PHP多，可以使用varnish做php缓存，如果操作数据库量大，可以用memcached 用所谓的面板，灵活性和扩展性太差了，其实在linux架构方面想用好还是学着自己去编译

centos可以安装asp环境，关键是楼主你会用不 ------------------------- 回 5楼(秋日的私语) 的帖子 linux虽然不能支持mssql数据库，但是可以支持Access数据库，安装了mdbtools就可以在linux下支持Access数据库了 我当然知道linux下的asp不是asp.net linux下 asp.net是mono环境 asp则是IASP环境 关键linux下的asp还是asp.net与win下的iis支持的有很大的不同，包括组件，路径 等等都不一样，没有现成的站点程序可以用 我以前在linux下跑过k6论坛，但是要修改很多东西 ------------------------- 回 7楼(秋日的私语) 的帖子 想在centos下安装asp 1.安装jdk 也就是java环境 2.安装IASP 2.1（iasp需要jdk） 3.安装mdbtools 4.安装apache 2.0.64(再高的版本iasp就不支持了) 5.整合apache到nginx 部分代码，主要是让apache支持iasp的 tar zxvf iasp21.tar.gzmv iasp21 /usr/local/webserver/cd /usr/local/webserver/iasp21chmod +x connector.sh stop-server.sh start-server.sh start-admin.sh stop-admin.sh cd /usr/local/webserver/iasp21/bin/apache/source/2.0//usr/local/webserver/apache/bin/apxs -i -c *.c 启动 cat >>  /etc/rc.local << EOF/usr/local/webserver/apache/bin/apachectl start &/usr/local/webserver/iasp21/start-server.sh > /dev/null 2>&1 &EOF /usr/local/webserver/iasp21/start-server.sh > /dev/null 2>&1 &/usr/local/webserver/apache/bin/apachectl start &

" <entry<span style=""font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;line-height:15.399999618530273px;background-color:#FFFFFF;""> key-ref="dbAuthHandler"<span style=""font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;line-height:15.399999618530273px;background-color:#FFFFFF;""> value-ref="primaryPrincipalResolver"<span style=""font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;font-size:14px;line-height:15.399999618530273px;background-color:#FFFFFF;""> /> 改成 <entry key-ref="primaryAuthenticationHandler" value-ref="dbAuthHandler" /> ######回复 @kylePen : 抱歉,看差了..感觉应该是primaryPrincipalResolver对应的bean注入的问题.######感谢回答。但是key-ref后的值是验证处理器，而value-ref后是用户信息处理器，所以说dbAuthHandler还是应该放前面的。###### 我跟你一样的配置，但我启动的时候报错了 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'authenticationManager' defined in ServletContext resource [/WEB-INF/deployerConfigContext.xml]: Unsatisfied dependency expressed through constructor argument with index 0 of type [java.util.Map]: Could not convert constructor argument value of type [java.util.LinkedHashMap] to required type [java.util.Map]: Failed to convert value of type 'java.util.LinkedHashMap' to required type 'java.util.Map'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [org.jasig.cas.authentication.AcceptUsersAuthenticationHandler] to required type [org.jasig.cas.authentication.principal.PrincipalResolver]: no matching editors or conversion strategy found 我不知道是什么原因，你能够把你的所有配置文件贴出来？谢谢 ######我现在也出现了跟你同样的问题。请问你是怎么解决的？ ######我已经解决了######能给一份解决后详细的 配置文件出来看看吗？？ 无解中######楼主能给一份解决后详细的 配置文件出来看看吗？？ 期待重 我也是遇到 无解中 ###### <entry key-ref="proxyAuthenticationHandler" value-ref="proxyPrincipalResolver" /> 把这行删除掉，就可以用数据库密码验证了 ###### 我刚测试成功，JDK8 Tomcat8 <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:c="http://www.springframework.org/schema/c" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util" xmlns:sec="http://www.springframework.org/schema/security" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd        http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-3.2.xsd        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd"> <!-- 原始密码配置 <bean id="authenticationManager" class="org.jasig.cas.authentication.PolicyBasedAuthenticationManager">  <constructor-arg> <map> <entry key-ref="proxyAuthenticationHandler" value-ref="proxyPrincipalResolver"  /> <entry key-ref="primaryAuthenticationHandler" value-ref="primaryPrincipalResolver"  /> </map> </constructor-arg> <property name="authenticationPolicy"> <bean  class="org.jasig.cas.authentication.AnyAuthenticationPolicy" /> </property>  </bean> <bean id="primaryAuthenticationHandler" class="org.jasig.cas.authentication.AcceptUsersAuthenticationHandler">  <property name="users"> <map> <entry key="admin" value="admin" /> </map>  </property> </bean> --> <bean id="proxyAuthenticationHandler" class="org.jasig.cas.authentication.handler.support.HttpBasedServiceCredentialsAuthenticationHandler" p:httpClient-ref="httpClient" /> <bean id="authenticationManager" class="org.jasig.cas.authentication.PolicyBasedAuthenticationManager"> <constructor-arg> <map> <!-- <entry key-ref="proxyAuthenticationHandler" value-ref="proxyPrincipalResolver" /> --> <entry key-ref="dbAuthHandler" value-ref="primaryPrincipalResolver" /> </map> </constructor-arg> <property name="authenticationPolicy"> <bean class="org.jasig.cas.authentication.AnyAuthenticationPolicy" /> </property> </bean> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" p:driverClass="com.mysql.jdbc.Driver" p:jdbcUrl="jdbc:mysql://192.168.0.110:3306/jufeng?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull" p:user="root" p:password="123456" /> <!-- 密码加密方式 --> <bean id="passwordEncoder" class="org.jasig.cas.authentication.handler.DefaultPasswordEncoder" c:encodingAlgorithm="SHA1" p:characterEncoding="UTF-8" /> <bean id="dbAuthHandler" class="org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler" p:dataSource-ref="dataSource" p:sql="SELECT PASSWORD FROM JF_USER WHERE USER_NAME=? AND STATUS=0" /> <!-- p:passwordEncoder-ref="passwordEncoder" --><!-- 暂时不使用密码加密 --> <bean id="proxyPrincipalResolver" class="org.jasig.cas.authentication.principal.BasicPrincipalResolver" /> <bean id="primaryPrincipalResolver" class="org.jasig.cas.authentication.principal.PersonDirectoryPrincipalResolver"> <property name="attributeRepository" ref="attributeRepository" /> </bean> <bean id="attributeRepository" class="org.jasig.services.persondir.support.StubPersonAttributeDao" p:backingMap-ref="attrRepoBackingMap" /> <util:map id="attrRepoBackingMap"> <entry key="uid" value="uid" /> <entry key="eduPersonAffiliation" value="eduPersonAffiliation" /> <entry key="groupMembership" value="groupMembership" /> </util:map> <bean id="serviceRegistryDao" class="org.jasig.cas.services.InMemoryServiceRegistryDaoImpl" p:registeredServices-ref="registeredServicesList" /> <util:list id="registeredServicesList"> <bean class="org.jasig.cas.services.RegexRegisteredService" p:id="0" p:name="HTTP and IMAP" p:description="Allows HTTP(S) and IMAP(S) protocols" p:serviceId="^(https?|imaps?)://.*" p:evaluationOrder="10000001" /> </util:list> <bean id="auditTrailManager" class="com.github.inspektr.audit.support.Slf4jLoggingAuditTrailManager" /> <bean id="healthCheckMonitor" class="org.jasig.cas.monitor.HealthCheckMonitor" p:monitors-ref="monitorsList" /> <util:list id="monitorsList"> <bean class="org.jasig.cas.monitor.MemoryMonitor" p:freeMemoryWarnThreshold="10" /> <bean class="org.jasig.cas.monitor.SessionMonitor" p:ticketRegistry-ref="ticketRegistry" p:serviceTicketCountWarnThreshold="5000" p:sessionCountWarnThreshold="100000" /> </util:list> </beans> ######原来是MySQL Connector没安装######你好，我遇到一个问题在cas这块？我部署了也是cas4.0版本，我有2个系统，webapp1,webapp2,我先登录webapp1系统，然后通过里面某一个功能点击进入webapp2中，然后在退出webapp1中，换一个用户登录，然后在跳到webapp2中，发现用户还是上一旧用户登录的。而且我手动访问cas服务端logout，但是我刷新webapp1，发现还能继续访问？请问这是什么问题？ 我的系统里面加入了： <filter> <filter-name>CAS Single Sign Out Filter</filter-name> <filter-class>org.jasig.cas.client.session.SingleSignOutFilter</filter-class> </filter> <filter-mapping> <filter-name>CAS Single Sign Out Filter</filter-name> <url-pattern>*</url-pattern> </filter-mapping> <listener> <listener-class>org.jasig.cas.client.session.SingleSignOutHttpSessionListener</listener-class> </listener> ######p:passwordEncoder-ref="passwordEncoder"去掉这句，数据库里面的password没进行加密，所以不要加这个，如果数据库中的密码也加密了再加上这句。默认，发送请求时，cas会对password进行你定义的那种方式加密。所以验证时select去除的password和加密后的不是一样的 " 

为了提升用户在云服务器上的软件安装效率，减少下载和安装软件的成本，操作系统为SUSE的用户可通过 YaST 快速安装软件。本文对此进行简要说明。 SUSE 默认使用 zypper 安装软件时提示 denied 的解决办法 SUSE 因为是企业级发行版，对于安全和隐私要求高，所以官方是不允许直接通过 mirrors.aliyun.com 公网访问源的，而必须通过 mirrors.aliyuncs.com 1、将 /etc/zypp/repos.d/SLES11-SP3.repo和/etc/zypp/repos.d/SLES11-SP3-Updates.repo 里面的为公网的 mirrors.aliyun.com 的 enable 和 autofresh 设置为 0 ，只使用 aliyuncs.com 内网源。 $ vi /etc/zypp/repos.d/SLES11-SP3.repo [SLES11-SP3-0] name=SLES11-SP3-0 enabled=0 autorefresh=0 baseurl=http://mirrors.aliyun.com/SLES/SLES11-SP3/sle-11-x86_64/ type=NONE keeppackages=0 [SLES11-SP3-1] name=SLES11-SP3-1 enabled=1 autorefresh=1 baseurl=http://mirrors.aliyuncs.com/SLES/SLES11-SP3/sle-11-x86_64/ type=yast2 keeppackages=0 ~ $ vi /etc/zypp/repos.d/SLES11-SP3-Updates.repo [SLES11-SP3-Updates] type=rpm-md [SLES11-SP3-Updates-0] name=SLES11-SP3-Updates enabled=0 autorefresh=0 baseurl=http://mirrors.aliyun.com/SLES/SLES11-SP3-Updates/sle-11-x86_64/ type=rpm-md [SLES11-SP3-Updates-1] name=SLES11-SP3-Updates enabled=1 autorefresh=1 baseurl=http://mirrors.aliyuncs.com/SLES/SLES11-SP3-Updates/sle-11-x86_64/ type=rpm-md ~ 2、zypper refresh $ zypper refresh 软件源“SLES11-SP3”是最新的。 软件源“SLES11-SP3-Updates”是最新的。 所有安装源均已刷新。   zypper 在线安装的使用方法 1、可以通过 zypper sl 列出软件源 iZ23i4t4jvzZ:~ # zypper sl # | 别名 | 名称 | 已启用 | 刷新 | 类型 --+--------------------+--------------------+--------+------+------- 1 | SLES11-SP3 | SLES11-SP3 | 是 | 是 | yast2 2 | SLES11-SP3-Updates | SLES11-SP3-Updates | 是 | 是 | rpm-md 2. 通过命令 search 或 se 搜索软件包 $ zypper se mysql 正在装载安装源数据... 正在读取已安装的包... S | 名称 | 概要 | 类型 --+----------------------------+--------------------------------------------------------------+--------- | libgda-3_0-mysql | mySQL Provider for GNU Data Access (GDA) | 包 | libgda-4_0-mysql | MySQL Provider for GNU Data Access (GDA) | 包 | libmysql55client18 | Shared Libraries for MySQL Community Server | 包 | libmysql55client18-32bit | Shared Libraries for MySQL Community Server | 包 | libmysql55client_r18 | Shared Libraries for MySQL Community Server | 包 | libmysqlclient15 | MySQL Shared Libraries | 包 | libmysqlclient15-32bit | MySQL Shared Libraries | 包 | libmysqlclient_r15 | A True Multiuser, Multithreaded SQL Database Server | 包 | libqt4-sql-mysql | Qt 4 MySQL support | 包 | mysql | Server part of MySQL Community Server | 包 | mysql | Server part of MySQL Community Server | 源代码包 | mysql-client | Client for MySQL Community Server | 包 | mysql-tools | MySQL Community Server tools | 包 | perl-DBD-mysql | Interface to the MySQL database | 包 | perl-DBD-mysql | Interface to the MySQL database | 源代码包 | php53-mysql | PHP5 Extension Module | 包 | postfix-mysql | Postfix plugin to support MySQL maps | 包 | python-mysql | An Interface to the Popular MySQL Database Server for Python | 包 | python-mysql | An Interface to the Popular MySQL Database Server for Python | 源代码包 | rsyslog-module-mysql | MySQL support module for rsyslog | 包 | slessp3-bytefx-data-mysql | Security update for Mono | 增补程序 | slessp3-libmysql55client18 | Security update for MySQL | 增补程序 | slessp3-mysql-12147 | Security update for mysql | 增补程序 | slessp3-mysql-12272 | Security update for mysql | 增补程序 | slessp3-mysql-12386 | Security update for mysql | 增补程序 iZ23i4t4jvzZ:~ # 3. zypper in 安装软件包 $ zypper in mysql 正在装载安装源数据... 正在读取已安装的包... 正在解析包的依赖性... The following items are locked and will not be changed by any action: 已安装 : kernel-default kernel-default-base kernel-default-devel kernel-firmware kernel-source Available: kernel-bigsmp kernel-bigsmp-base kernel-bigsmp-devel kernel-ec2 kernel-ec2-base kernel-ec2-devel kernel-syms kernel-trace kernel-trace-base kernel-trace-devel kernel-xen kernel-xen-base kernel-xen-devel kernelshark 将安装以下新包： mysql 以下包需要其他客户合同以获取支持： mysql 1 要安装的新包. 总下载大小：11.0 MiB。 操作完成后，将使用额外的 42.6 MiB。 是否继续？ [是/否/? 显示所有选项] (是): 正在检索 包 mysql-5.5.47-0.17.1.x86_64 (1/1), 11.0 MiB （解压后 42.6 MiB） 正在检索： mysql-5.5.47-0.17.1.x86_64.rpm [已完成 (960.4 KiB/s)] 正在安装：mysql-5.5.47-0.17.1 [已完成] 4、zypper rm 删除软件包 $ zypper rm mysql 正在装载安装源数据... 正在读取已安装的包... 正在解析包的依赖性... The following items are locked and will not be changed by any action: 已安装 : kernel-default kernel-default-base kernel-default-devel kernel-firmware kernel-source Available: kernel-bigsmp kernel-bigsmp-base kernel-bigsmp-devel kernel-ec2 kernel-ec2-base kernel-ec2-devel kernel-syms kernel-trace kernel-trace-base kernel-trace-devel kernel-xen kernel-xen-base kernel-xen-devel kernelshark 将去除以下包： mysql 1 要删除的包. 操作完成后，42.6 MiB 将被释放。 是否继续？ [是/否/? 显示所有选项] (是): 正在去除 mysql-5.5.47-0.17.1 [已完成] 5、其他相关 zypper 使用说明。 <li>repos, lr ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;列出库</li><li>addrepo, ar ; ; ; ; ; ; ; ; ; ; ; ; ; 添加库</li><li>renamerepo, nr ; ; ; ; ; ; 重命名指定的安装源</li><li>modifyrepo, mr ; ; ; ; ; ; 修改指定的安装源</li><li>refresh, ref  ; ; ; ; ; ; ; ; ; ; ;  ;刷新所有安装源</li><li>clean  ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;  ;清除本地缓存</li><li>install, in ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;  ;安装软件包</li><li>remove, rm  ; ; ; ; ; ; ; ; ; ; ; ; 删除软件包</li><li>verify, ve  ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 检验软件包依赖关系的完整性</li><li>update, up  ; ; ; ; ; ; ; ; ; ; ; ; ; 更新已安装的软件包到新的版本</li><li>search, se ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;安装软件包</li><li>packages, pa ; ; ; ; ; ; ; ; ; ; ;列出所有可用的软件包</li><li>patterns, pt ; ; ; ; ; ; ; ; ; ; ; ; 列出所有可用的模式</li><li>products, pd ; ; ; ; ; ; ; ; ; ; 列出所有可用的产品</li><li>what-provides, wp 列出能够提供指定功能的软件包</li>

"@ <a href=""http://my.oschina.net/shishuifox"" rel=""nofollow"">逝水fox######<span style=""font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:14.65625px;background-color:#F8F8F8;"">log4j.logger.druid.sql=debug,stdout,infolog######<div class=""ref""> 引用来自“wenshao”的答案 log4j.logger.druid.sql=debug,stdout,infolog @wenshao ，这样配置后是可以正常显示，但怎么每条信息都会显示2次呢？ ######怎样的显示两次？###### 引用来自“34176470”的答案 引用来自“wenshao”的答案 怎样的显示两次？ <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ... <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ... <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle   @wenshao ######你配置了两个log filter了吧###### 引用来自“wenshao”的答案 你配置了两个log filter了吧 <!-- 每隔5分钟将监控日志输出到日志文件中，单位是毫秒。 --> <property name="timeBetweenLogStatsMillis" value="300000" /> <!-- 监控数据库 --> <property name="proxyFilters"> <list> <ref bean="stat-filter" /> <ref bean="wall-filter" /> <ref bean="log-filter" /> </list> </property> <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter"> <property name="slowSqlMillis" value="3000" /> <property name="logSlowSql" value="true" /> <property name="mergeSql" value="true" /> </bean> <bean id="log-filter" class="com.alibaba.druid.filter.logging.Log4jFilter"> <!-- <property name="resultSetLogEnabled" value="false" /> --> <!-- <property name="statementExecutableSqlLogEnable" value="true" /> --> </bean> <bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter"> <property name="dbType" value="oracle" /> <property name="config" ref="wall-filter-config" /> </bean> <bean id="wall-filter-config" class="com.alibaba.druid.wall.WallConfig" init-method="init"> <property name="dir" value="META-INF/druid/wall/oracle" /> </bean> ###### @wenshao ，有配置两个 log filter吗？######感觉是配置了两个log filter，你在LogFilter中调试看看，是不是两个LogFilter了。###### 可能是这里： log4j.logger.druid.sql=info,stdout,infolog 导致输出了两次 "

"@ <a href=""http://my.oschina.net/shishuifox"" rel=""nofollow"">逝水fox######<span style=""font-family:Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace;line-height:14.65625px;background-color:#F8F8F8;"">log4j.logger.druid.sql=debug,stdout,infolog######<div class=""ref""> 引用来自“wenshao”的答案 log4j.logger.druid.sql=debug,stdout,infolog @wenshao ，这样配置后是可以正常显示，但怎么每条信息都会显示2次呢？ ######怎样的显示两次？###### 引用来自“34176470”的答案 引用来自“wenshao”的答案 怎样的显示两次？ <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50060} query executed. 94.01312 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50060} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Parameters : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} Types : [] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048, rs-50061} query executed. 11.048239 millis. select ... where 1=1 <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20048, rs-50061} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20048} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-connect <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit false <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Parameters : [20] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} Types : [INTEGER] <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ... <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049, rs-50062} query executed. 25.360907 millis. select * from ... <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} open <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Header: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} Result: [...] <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.ResultSet] - {conn-10031, pstmt-20049, rs-50062} closed <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Statement] - {conn-10031, pstmt-20049} clearParameters. <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} commited <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} setAutoCommit true <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle <2013-07-10 13:29:29> <DEBUG> [druid.sql.Connection] - {conn-10031} pool-recycle   @wenshao ######你配置了两个log filter了吧###### 引用来自“wenshao”的答案 你配置了两个log filter了吧 <!-- 每隔5分钟将监控日志输出到日志文件中，单位是毫秒。 --> <property name="timeBetweenLogStatsMillis" value="300000" /> <!-- 监控数据库 --> <property name="proxyFilters"> <list> <ref bean="stat-filter" /> <ref bean="wall-filter" /> <ref bean="log-filter" /> </list> </property> <bean id="stat-filter" class="com.alibaba.druid.filter.stat.StatFilter"> <property name="slowSqlMillis" value="3000" /> <property name="logSlowSql" value="true" /> <property name="mergeSql" value="true" /> </bean> <bean id="log-filter" class="com.alibaba.druid.filter.logging.Log4jFilter"> <!-- <property name="resultSetLogEnabled" value="false" /> --> <!-- <property name="statementExecutableSqlLogEnable" value="true" /> --> </bean> <bean id="wall-filter" class="com.alibaba.druid.wall.WallFilter"> <property name="dbType" value="oracle" /> <property name="config" ref="wall-filter-config" /> </bean> <bean id="wall-filter-config" class="com.alibaba.druid.wall.WallConfig" init-method="init"> <property name="dir" value="META-INF/druid/wall/oracle" /> </bean> ###### @wenshao ，有配置两个 log filter吗？######感觉是配置了两个log filter，你在LogFilter中调试看看，是不是两个LogFilter了。###### 可能是这里： log4j.logger.druid.sql=info,stdout,infolog 导致输出了两次 "