Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. paublo

    awk to sed equivalent

    yeah After looking at it i figured it out for myself what you did and came to same breakdown as you did. It's very clever, i guess once you look at its simple but putting the logic together is the tricky part when you dont see sed all the time. I will look at awk also so im more rounded on both...
  2. paublo

    awk to sed equivalent

    Sam, impressive, i got as far as sed -e 's/[^:]*:[^:]*:\([^:]*\).*/ \1/' /etc/passwd which basically just displays the UID. I however see what you did, you didnt use logic just got rid of what we didnt need. After doing some research on sed it seems like awk more powerful and simple to use...
  3. paublo

    awk to sed equivalent

    How would you convert the following awk command to sed, i can't seem to figure it out. edquota -p bob `awk -F: '$3 > 499 {print $1}' /etc/passwd` thansk P.
  4. paublo

    merging two mysql DB's but getting duplicate key error

    Jpadie, what do you recommend I do?
  5. paublo

    merging two mysql DB's but getting duplicate key error

    I just went with the ignore syntax which if it finds a duplicate it will not insert it. The dups are email address mostly.
  6. paublo

    merging two mysql DB's but getting duplicate key error

    Chris I read that but im still not sure what syntax i need to use to, im looking for someone to give me the syntax i need based on the tables. thanks, P
  7. paublo

    merging two mysql DB's but getting duplicate key error

    Hi, 1st off thanks for looking at this issue. I have two databases that have the same structure and I want to be able to merge the databases together however im getting a duplicate key error. I'm trying, insert into squirrelmail_merged.address select * from squirrelmail.address; but im getting...
  8. paublo

    setting the DF bit to 0 on a cisco 6500 not working

    nevermind i found the issue, after using wireshark it was clear that i was testing wrong. On my pc the ethernet has an mtu of 1500 and i was ping with 1510 with the DF bit set, to it was not even leaving the local ethernet. After i lowered the mtu (a value higher than the tunnel MTU but lower...
  9. paublo

    setting the DF bit to 0 on a cisco 6500 not working

    I have a GRE tunnel that im clearing the DF bit between two routers. No matter what i do its doesn't seem to be working when i test it. I'm testing it by sending ICMP echo packets greater than 1500 with the DF bit set to 1, hoping that when the packet hits the physical outgoing interface it...
  10. paublo

    class-default low offered rate!?

    Hi i have a cisco 6500 what im doing qos on. I have an 1 gig upstream interface that i have applied a policy-map to. this map seems to be working fine however when i look at the class-default class map the 5 min offered rate is very low even while the interface is using 75 megs of traffic. How...
  11. paublo

    strong DS3 signal

    Hi I have a fiber mux that converts the signal into DS3 which is terminated on a cisco 6513, IOS 12.2(18)SXF14, WS-X6582-2PA module. From the Mux to the Cisco its about 10 feet, I have no control of the mux fyi. Out of this Mux I have 3 DS3, two of them have a lot more C-bit/P-bit errors...
  12. paublo

    weird frame-relay issue

    turned out to be memory issues with the flexwan cards that the frame-relay were being terminated. I was having some memory issues with the flexwan which causes all sorts of issues including CEF issues because we were running out of memory.
  13. paublo

    cisco memory issues

    FYI - i had another issue and this time i looked at it closely and i think the issue is one of running low on memory and not so much a memory fragmentation issue although its possible its both. below is the error log from the flexwan and the sh mem, you will notice that a task called VIP Encap...
  14. paublo

    cisco memory issues

    Hi recently I had an issue with two flexwan cards on a cisco 6509 reporting memory issues at the exact same time. On the 6509's log I notice some memory allocation messages related to the flexwan on ports 8/1 and 9/1, it complaints that it can't allocate memory and then disables Dcef. The log...
  15. paublo

    weird frame-relay issue

    Hi i have a 6500 terminating frame-relay. Recently we consolidated some T1 frame circuits from one T3 to another. While moving these circuits to the new interface on the new T3, we made sure to configure the new interface excatly like the old interface and nothing changed with the CPE on the...
  16. paublo

    query help joining two statements

    Hi, i have the following in a php script that is currently working, HOWEVER... 'default' => array('query_set' => 'REPLACE INTO vacation (email, subject, body, domain, created, active) VALUES (\U, \S, \M, \D, NOW(), 1)', 'query_unset' => 'UPDATE vacation SET...
  17. paublo

    mysql query help - if and

    i think i got it. password_query = SELECT username as user, password, \ if('%d' IN ('domain1.com', 'domain2.com') AND '%s'='imap', or password_query = SELECT username as user, password, \ if('%d' IN ('domain1.com', 'domain2.com') AND '%s'!='imap'
  18. paublo

    mysql query help - if and

    Hi, I have a mysql query that I need help on and hoping someone can give me a hand with this. currently I have a query that works and the query is: password_query = SELECT username as user, password, if('%d' IN ('domain1.com', 'domain2.com'), 'quota imap_quota acl imap_acl',null) as...
  19. paublo

    if statement help

    R937, thank you very much that worked out perfect! paul
  20. paublo

    if statement help

    Hi i have a query below that checks if the variable %d equals the domain virttest1.xxxxxxx.net and works just fine however i can't seem to figure out how to check to see if %d equals virttest1.xxxxxxx.net OR virttest2.xxxxxxx.net OR virttest3.xxxxxxx.net etc and then is if does carry on by...

Part and Inventory Search

Back
Top