search for: nvl

...RCHAR2'', data_length, null) as length, decode(data_type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ''USERS'' and syn.synonym_name (+)= cat.table_name and col.table_name = nvl(syn.table_name, cat.table_name) and col.owner = nvl(syn.table_owner, user) I am assuming that this is because development mode can''t cache the models... in production mode it seems to take about 8 seconds the first time but then it''s really fast. To test, I''ve placed t...

Hi, after some experience with Rails on MySQL databases I gave it a try on one of our larger Oracle database. I was facing a problem when Rails tried to detect the columns for a model/table. The appropriate statement ran about 1 min which led to a timeout. Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t helped, he said the only remaining chance is to use a

Dear anyone who knows more about R than me (so everyone). I have been bashing my head on the keyboard all day trying to do something with my table. I have some data, like so: yyyy-mm Rainfall(mm) 1 1977-02 17.4 2 1977-03 34.0 3 1977-04 26.2 4 1977-05 42.6 5 1977-06 58.6 6 1977-07 23.2 7 1977-08 26.8 8 1977-09 48.4 9

..., Cape Town, ZA :) --- SOF ---- #!/bin/sh # ____ # /\/ \/\ # /__________\ # # Simple loop for keeping track of what is happening in a # iptables setup # table_filter(){ echo echo "FILTER TABLE" echo "------------" echo iptables -nvL } table_mangle(){ echo echo "MANGLE TABLE" echo "------------" echo iptables -nvL -t mangle } table_nat(){ echo echo "NAT TABLE" echo "---------" echo iptables -nvL -t nat } foote...

http://bugzilla.netfilter.org/show_bug.cgi?id=631 Summary: Unable to zero packet and byte count for policy. Product: iptables Version: 1.3.5 Platform: i386 OS/Version: RedHat Linux Status: NEW Severity: enhancement Priority: P1 Component: iptables AssignedTo: netfilter-buglog at lists.netfilter.org

I am trying to determine the root of an issue I am having. How can I watch traffic destined to a specific port on my CentOS 5.1 box to see if its even hitting it? It would be udp traffic. Thanks! jlc -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080520/d5066957/attachment-0005.html>

Hello, my current network setup looks like the following: dom2-eth0 (172.30.1.22) netmask /24 | | xen-br1 (no ip) | dom1-eth0 (172.30.1.21) netmask /24 dom1-eth1 (172.30.0.21) netmask /24 | | xen-br10 (172.30.0.1) netmask /24 | dom0 | | xen-br0 (normal IP) | eth0 (same IP as xen-br0) |

..., the package that's been prohibited is the SYNC package that in response of the SYNC sent out by 10.3.3.3, it should match the iptables rule -m state --state RELATED,ESTABLISHED -j ACCEPT, but still be prohibited by the rule -j REJECT --reject-with icmp-host-prohibited. Also, the iptables -nvL output: # iptables -nvL Chain INPUT (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt in out source destination 8258 615K ACCEPT all -- * * 0.0.0.0/0 0.0.0.0/0 state RELATED,ESTABLISHED 1 84 ACCEPT icmp -- * *...

...e %> and create method in error_details controller as def index(task_errore) if !session[:user_id] redirect_to :controller => ''user'', :action => ''login'' else @ngn_errors = NgnError.find(:all, :conditions =>[" task_errore = nvl(?, task_errore) ", task_errore ]) end end But when I click on link he say me: ArgumentError in NgnerrorsController#index wrong number of arguments (0 for 1) and when I check logs Processing NgnErrorsController#index (for 10.139.246.114 at 2009-12-30 15:07:10) [GET] Parameters: {&q...

...dge (2.6.8-rc2), which is apparently not bridging UDP fragments (NFS) when passing packets through iptables, but I do not see in the iptables stats where the packets are dropped. Policies for INPUT, FORWARD, OUTPUT are all "ACCEPT", and I grepped for all REJECT and DROP rules in iptables -nvL, their counters are constant, i. e. they aren't rejecting or dropping packets. Setup: FreeBSD5 Linux Bridge FreeBSD4 xl0 ----10base2---- eth2 eth0 ----100baseTx---- fxp0 The FreeBSD machines are attempting to talk NFS with each other, the machine on...

...h1 group 200 root at JIKE-GATEWAY ~>iptables -I FORWARD -m devgroup --src-group 100 -m devgroup --dst-group 200 -j ACCEPT root at JIKE-GATEWAY ~>iptables-save |grep devgroup -A FORWARD -m devgroup --src-group 0x64 -m devgroup --dst-group 0x0/0x0 -j ACCEPT root at JIKE-GATEWAY ~>iptables -nvL |grep src-group 0 0 ACCEPT all -- * * 0.0.0.0/0 0.0.0.0/0 src-group 0x64 dst-group 0x0/0x0 ### dest-group 0x0/0x0 was not just as my set ### 2nd test root at JIKE-GATEWAY ~>ip lin set dev eth3 group 300 root at JIKE-GATEWAY ~>ip lin set dev et...

https://bugzilla.netfilter.org/show_bug.cgi?id=849 Summary: 172.245.13.X doesn't appear properly in output of iptables -L Product: iptables Version: 1.4.x Platform: x86_64 OS/Version: Debian GNU/Linux Status: NEW Severity: minor Priority: P5 Component: iptables AssignedTo:

...ache even if the rule didn't matched at all. I think it's better to show some example. (I changed the hostnames and IP addresses, they are sensitive data). eth0 - 2001:1234:f001::/64 - Internet eth1 - 2001:1234:11::/64 - DMZ The non-working scenario: root at ipv6-test:# ip6tables -t nat -nvL Chain PREROUTING (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt in out source destination 0 0 LOinet all eth0 * ::/0 ::/0 /* Internet */ ADDRTYPE match dst-type LOCAL limit-in Chain INPUT (policy AC...

Trying to use the policy drop rule with the bridged firewall, when I removed the first line the transparent proxy works great? It seems a bit strange as from reading several articles on it I thought the following occurs. 1st line - if it doest match it gets dropped on the local filter input. 2nd line - redirects the traffic off the link layer into the network layer ready for line 3. 3rd line -

...is the SYNC package that > in response of the SYNC sent out by 10.3.3.3, it should match the > iptables rule -m state --state RELATED,ESTABLISHED -j ACCEPT, but > still be prohibited by the rule -j REJECT --reject-with > icmp-host-prohibited. > > > > Also, the iptables -nvL output: > > > > # iptables -nvL > > Chain INPUT (policy ACCEPT 0 packets, 0 bytes) > > pkts bytes target prot opt in out source > destination > > 8258 615K ACCEPT all -- * * 0.0.0.0/0 > 0.0.0.0/0 state RELATED,ESTABLISHED...

...', data_length, null) as length, decode(data_type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ''#{NAME_OF_TABLE}'' and syn.synonym_name (+)= cat.table_name and col.table_name = nvl(syn.table_name, cat.table_name) and col.owner = nvl(syn.table_owner, user) At first glance, the query looks okay. Oracle should apply the WHERE clause on the FROM tables and then apply the DECODE on the results. Unfortunately, that''s not the case. The decode is making the query very e...

Hi All, I''m using iptables-1.2.7a on RedHat8 kernel 2.4.20. I wanted to limit the file-sharing traffic to the internet. I marked the packets with iptables: iptables -A FORWARD -t mangle -p tcp -s 192.168.1.1/24 -d ! 192.168.1.1/24 --dport 1024:1862 -j MARK --set-mark 1 iptables -A FORWARD -t mangle -p tcp -s 192.168.1.1/24 -d ! 192.168.1.1/24 --dport 1864:65535 -j MARK --set-mark 1

Hi, I would like to get some inputs on how to configure iptables. I have referred to CentOS wiki http://wiki.centos.org/HowTos/Network/IPTables and it has been very helpful. I have configured iptables with the help of this tutorial, but I haven't understood few things about default firewall config. - What does 'RH-Firewall-1-INPUT' chain means? This also seems to be a predefined

...mac --mac-source 00:10:B5:01:AA:D0 -j ACCEPT ... Should note that the default policy of filter->forward is DROP. All other chains are defaulting on ACCEPT Now, no users can connect through the gateway. Our test traffic for the shapping works perfectly, but no internet traffic works. iptables -nvL output shows that the packets move through the forward chain in filter, but it doesn''t reach the mangle table for marking the packets. It''s as if the packets disappear... Anybody got some ideas? I still have to test the shaping using u32 matching, using iptables to do forwarding....

...ited is the SYNC package that in > response of the SYNC sent out by 10.3.3.3, it should match the iptables > rule > -m state --state RELATED,ESTABLISHED -j ACCEPT, but still be prohibited by > the rule -j REJECT --reject-with icmp-host-prohibited. > > > > Also, the iptables -nvL output: > > > > # iptables -nvL > > Chain INPUT (policy ACCEPT 0 packets, 0 bytes) > > pkts bytes target prot opt in out source > destination > > 8258 615K ACCEPT all -- * * 0.0.0.0/0 > 0.0.0.0/0 state RELATED,ESTABLISHED...