Сообщения Valor

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
#memlock

user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /db/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english

skip-external-locking
skip-name-resolve
skip-host-cache
connect_timeout		= 30
bind-address		= 0.0.0.0
old_passwords           = 1
max_connections         = 7000
table_cache             = 3G
net_buffer_length	= 100M
net_read_timeout	= 30
net_write_timeout	= 30
sort_buffer_size        = 912M
join_buffer_size        = 1G
thread_cache_size       = 1100
thread_concurrency      = 24
query_cache_size        = 3G
query_cache_limit       = 100M
query_cache_type        = 1
query_prealloc_size     = 65536
read_rnd_buffer_size    = 724288
bulk_insert_buffer_size = 100M
query_alloc_block_size  = 631072
tmp_table_size          = 940M
max_tmp_tables		= 1024
key_buffer_size         = 8G
wait_timeout            = 28800
max_allowed_packet      = 800M
open_files_limit 	= 100000
read_buffer_size 	= 280M
read_rnd_buffer_size 	= 460M
binlog_format		= row
sync_binlog		= 1
max_write_lock_count 	= 1
#transaction-isolation	= READ-COMMITTED
max_length_for_sort_data = 1G

bulk_insert_buffer_size = 456M
myisam_sort_buffer_size = 712M
myisam_max_sort_file_size = 2G
myisam_repair_threads 	= 12
myisam_recover
myisam_data_pointer_size = 6
myisam-recover          = BACKUP

character-set-server	= cp1251
collation-server	= cp1251_general_ci


#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
general_log             = 0
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#slow_query_log_file	= /var/log/mysql/mysql-slow.log
#log-slow-queries        = /var/log/mysql/mysql-query-slow.log
#long_query_time 	= 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
#log_bin			= /db/mysql-bin-log/mysql-bin.log
#expire_logs_days	= 10
#max_binlog_size         = 1024M
#binlog_do_db		= billing


#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
#skip-innodb
innodb
default-storage-engine = innodb
innodb_file_per_table
innodb_log_group_home_dir = /db/mysql-bin-log
innodb_additional_mem_pool_size = 260M
innodb_buffer_pool_size = 18G
innodb_file_io_threads = 10
innodb_thread_concurrency = 24
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 4M
innodb_flush_method = O_DIRECT
innodb_log_file_size = 256M
innodb_log_files_in_group = 10
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120

[mysqldump]
quick
quote-names
max_allowed_packet	= 800M

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[mysqld_safe]
log-error=/var/log/mysqld.log

[isamchk]
key_buffer	=256M
sort_buffer	=126M
read_buffer	=128M
write_buffer	=128M

[mysqlhotcopy]
interactive-timeout

[client]
#default-character-set=cp1251
#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

new cam51 broadcast enabled
setup cam51 input http://user:password@***.***.***.***/axis-cgi/mjpg/video.cgi
setup cam51 output #duplicate{dst=transcode{vcodec=FLV1,vb=4000,fps=25,samplerate=48000}:http{access=http{mime=video/x-flv},mux=ffmpeg{mux=flv},dst=0.0.0.0:8081/stream51.flv},dst=http{mime=multipart/x-mixed-replace;boundary=IPCamBoundary,vb=4000,mux=mpjpeg,dst=0.0.0.0:8181}}
control cam51 play

[0x7f077c0016b0] [Media: cam51] stream_out_duplicate stream out error:  * ignore unknown option `http'
[0x7f077c0016b0] [Media: cam51] stream_out_duplicate stream out debug:  * adding `http{mime=multipart/x-mixed-replace;boundary=IPCamBoundary,vb=4000,mux=mpjpeg,dst=0.0.0.0:8181}'

[  124.956611] usb 4-2.3: new full speed USB device using ohci_hcd and address 4
[  125.036614] usb 4-2.3: device descriptor read/64, error -62
[  125.242636] usb 4-2.3: New USB device found, idVendor=1686, idProduct=00f3
[  125.242645] usb 4-2.3: New USB device strings: Mfr=0, Product=0, SerialNumber=0
[  125.242865] usb 4-2.3: configuration #1 chosen from 1 choice
[  125.244703] hub 4-2.3:1.0: USB hub found
[  125.246612] hub 4-2.3:1.0: 3 ports detected
[  125.536655] usb 4-2.3.1: new full speed USB device using ohci_hcd and address 5
[  125.645664] usb 4-2.3.1: New USB device found, idVendor=08bb, idProduct=2904
[  125.645672] usb 4-2.3.1: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[  125.645679] usb 4-2.3.1: Product: USB Audio CODEC 
[  125.645683] usb 4-2.3.1: Manufacturer: Burr-Brown from TI              
[  125.645902] usb 4-2.3.1: configuration #1 chosen from 1 choice
[  125.653852] input: Burr-Brown from TI               USB Audio CODEC  as /devices/pci0000:00/0000:00:12.0/usb4/4-2/4-2.3/4-2.3.1/4-2.3.1:1.3/input/input7
[  125.654079] generic-usb 0003:08BB:2904.0004: input,hidraw3: USB HID v1.00 Device [Burr-Brown from TI               USB Audio CODEC ] on usb-0000:00:12.0-2.3.1/input3
[  125.733648] usb 4-2.3.3: new full speed USB device using ohci_hcd and address 6
[  125.851663] usb 4-2.3.3: New USB device found, idVendor=1686, idProduct=00f1
[  125.851673] usb 4-2.3.3: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[  125.851680] usb 4-2.3.3: Product: G2Nu/G2.1Nu Ver.1.00 [947FDA54]
[  125.851686] usb 4-2.3.3: Manufacturer: ZOOM CORPORATION
[  125.851911] usb 4-2.3.3: configuration #1 chosen from 1 choice
[  125.859214] usbcore: registered new interface driver snd-usb-audio

# ls -l /usr/local/libexec/xtables/lib
libip6t_ah.so          libip6t_REJECT.so      libipt_MIRROR.so       libxt_CHECKSUM.so      libxt_CT.so            libxt_limit.so         libxt_pkttype.so       libxt_standard.so      libxt_TOS.so
libip6t_dst.so         libip6t_rt.so          libipt_NETMAP.so       libxt_CLASSIFY.so      libxt_dccp.so          libxt_mac.so           libxt_policy.so        libxt_state.so         libxt_TPROXY.so
libip6t_eui64.so       libipt_addrtype.so     libipt_realm.so        libxt_cluster.so       libxt_dscp.so          libxt_mark.so          libxt_quota.so         libxt_statistic.so     libxt_TRACE.so
libip6t_frag.so        libipt_ah.so           libipt_REDIRECT.so     libxt_comment.so       libxt_DSCP.so          libxt_MARK.so          libxt_rateest.so       libxt_string.so        libxt_u32.so
libip6t_hbh.so         libipt_CLUSTERIP.so    libipt_REJECT.so       libxt_connbytes.so     libxt_esp.so           libxt_multiport.so     libxt_RATEEST.so       libxt_tcpmss.so        libxt_udp.so
libip6t_hl.so          libipt_DNAT.so         libipt_SAME.so         libxt_connlimit.so     libxt_hashlimit.so     libxt_NFLOG.so         libxt_recent.so        libxt_TCPMSS.so        
libip6t_HL.so          libipt_ecn.so          libipt_SNAT.so         libxt_connmark.so      libxt_helper.so        libxt_NFQUEUE.so       libxt_sctp.so          libxt_TCPOPTSTRIP.so   
libip6t_icmp6.so       libipt_ECN.so          libipt_ttl.so          libxt_CONNMARK.so      libxt_IDLETIMER.so     libxt_NOTRACK.so       libxt_SECMARK.so       libxt_tcp.so           
libip6t_ipv6header.so  libipt_icmp.so         libipt_TTL.so          libxt_CONNSECMARK.so   libxt_iprange.so       libxt_osf.so           libxt_set.so           libxt_TEE.so           
libip6t_LOG.so         libipt_LOG.so          libipt_ULOG.so         libxt_conntrack.so     libxt_LED.so           libxt_owner.so         libxt_SET.so           libxt_time.so          
libip6t_mh.so          libipt_MASQUERADE.so   libipt_unclean.so      libxt_cpu.so           libxt_length.so        libxt_physdev.so       libxt_socket.so        libxt_tos.so    

FATAL: Module ipt_DROP not found.
[root@hellmachine iptables-1.4.10]# modprobe ipt_drop
FATAL: Module ipt_drop not found.
[root@hellmachine iptables-1.4.10]# iptables -m drop -h
iptables v1.4.10: Couldn't load match `drop':/usr/local/libexec/xtables/libipt_drop.so: cannot open shared object file: No such file or directory

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/sklad">
    <Resurse name="jdbc/sklad" auth="Container" type="javax.sql.DataSource"
		maxActive="100" maxIdle="30" maxWait="10000" username="root" password="*******"
		driverClassName="com.mysql.jdbc.Driver" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
		removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"
		url="jdbc:mysql://localhost:3306/sklad" />
</Context>

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" metadata-complete="true" version="2.5"
 xmlns="http://java.sun.com/xml/ns/javaee"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
 <display-name>Sklad</display-name>
 <welcome-file-list>
  <welcome-file>index.jsp</welcome-file>
 </welcome-file-list>
 <error-page>
  <error-code>404</error-code>
  <location>/WEB-INF/jsp/error.jsp</location>
 </error-page>
 <error-page>
  <exception-type>java.lang.Throwable</exception-type>
  <location>/WEB-INF/jsp/throw-error.jsp</location>
 </error-page>
 <resource-ref>
  <description>DB Connection</description>
  <res-ref-name>jdbc/sklad</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
 </resource-ref>
</web-app>

public class SkladDataSource {
	
	public SkladDataSource() {
	}
	
	public static Connection getConnect()
	{
		Connection conn = null;
		
		String jndiContext = "java:/comp/env/jdbc/sklad";
		
		try{
			InitialContext ic = new InitialContext();
			
			DataSource ds = (DataSource) ic.lookup(jndiContext);
			
			if (ds == null)
			{
				throw new SQLException("Data source not found :"+jndiContext);
			}
			
			conn = (Connection) ds.getConnection();
			
		}catch (NamingException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
}

javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'"
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)