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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- paublo
- Post #5
- Forum: General UNIX discussion
-
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...- paublo
- Post #3
- Forum: General UNIX discussion
-
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.- paublo
- Thread
- Replies: 4
- Forum: General UNIX discussion
-
merging two mysql DB's but getting duplicate key error
Jpadie, what do you recommend I do? -
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. -
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 -
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... -
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... -
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... -
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... -
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... -
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. -
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... -
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... -
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... -
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... -
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' -
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... -
if statement help
R937, thank you very much that worked out perfect! paul -
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...
