Server :: Auto Increment Primary Key?
Aug 23, 2010
So I have a field in my table called "id" and this is the primary key for the table which is also configured to 'auto_increment' as show below:
Code:
mysql> describe users;
+------------+-------------+------+-----+---------+----------------+
[code]....
View 6 Replies
ADVERTISEMENT
May 31, 2011
I'm running cygwin 1.7.7 on a win2k3R2 Standard edition server. I have a RHEL 4.7 linux host I'm scp'ing files from to the windows system using a simple cygwin scp command from what appears to be OpenSSH_5.5p1 on the cygwin host. When I run the simple scp command on the cygwin host, the counters initially display and increment/decrement, albeit what is at a much slower rate than is actually taking place. After the percent complete reaches a little less than 10%, all the counters from the cygwin console window cease to increment/decrement.
However, when I cd to the directory on the cygwin host where the file is being scp'ed to, the file is continuing to be transferred and a much higher rate than the counters seem to show. Finally, when the file transfer is complete by directly seeing the byte count as equal between the hosts, the scp counters will suddenly jump to 100% complete. This is not the case with my linux to linux scp's. The counters increment/decrement as expected and transfers are about what I'd expect over the same network infrastructure. This appears to be a cygwin ssh/scp implementation issue. I've posited this question to cygwin with no response as yet. The only reference I've been able to find on the 'net refers to buffering causing file transfers to appear to complete later than the transfer really does..........
View 3 Replies
View Related
Mar 17, 2011
How long does unix wait till moving from primary to secondary dns server (in /etc/resolv.conf) if the primary is uncontactable?
Where is this setting, so I can change it?
View 1 Replies
View Related
May 11, 2011
I'm wondering why we can't received email when our primary DNS went down. We have slave DNS but don't know why we can't receive emails. Internet is working properly. The mail file in /etc/configuration on slave dns are there & the zone file is added. I edited the mail zone file to see if it works & restarted the named service. But still we can't received emails using the slave DNS. Do I need to reboot the server?
View 12 Replies
View Related
Jan 22, 2010
I tried searching for this, but everything, for pages and pages, shows me the `if -e filename`. That's not what I'm looking for, at least I don't think I am. I am working on a script that will search a directory for certain file names and increment a variable by one for each result returned. Each time I search this file name, the file found will also be deleted. I would like this script to be run about every 6 hours or so. We'll call this script A.
I also have a script that runs daily that I would like to tack the count to the end of the text file that it outputs. We'll call this script B. I'm confident that I would want to store the count from script A to a text file to be called in by script B, but don't know how to do so. Here's what I have so far:
Code:
#!/bin/bash
SD=0#Resetting variable count for testing purposes, removed this before release #Below, Smith is used for testing purposes as this is the newest backup with instances found
find /cust_backups/Smith -name *Modified Script* && SD=$[SD+1] ;
find /cust_backups/Smith -name *Bitdefender Online Scanner* && SD=$[SD+1] ;
find /cust_backups/Smith -name *ccleaner.exe* && SD=$[SD+1] ;
find /cust_backups/Smith -name *HJT.exe* && SD=$[SD+1] ;
[Code]...
Now, for those of you that know what you're doing, you're already shaking your head because you know that, no matter what, at the end of the script $SD will end up being 14. The problem is I don't know how to tell bash that if there is a result returned, increment by one. If there is no result returned, move to the next command. Beyond that, I'll need to know how to call the text of a file in to a variable so I can plug it in to the text output of script B.
View 1 Replies
View Related
Jul 19, 2010
What is the procedure to increment the number under the cursor ? 12 Which key i have to press to make this 12 to become 13. I know the method of keeping the number in register and incrementing, But am looking for a single key to increment the number under cursor.
View 2 Replies
View Related
Jan 13, 2010
Is there anyway in Linux that can achieve atomic increment/decrement for an integer variable without being interrupted? It means that the thread should not chance for other thread to run until theincrement/decrement is completed.
View 11 Replies
View Related
Apr 25, 2010
Can one of you point me towards a comprehensive print function tutorial in perl? I was under the impression that everything within quotes will get interpolated - but I am running into exceptions where it is not desirable to run some varaibles under quotes.
ordinal.pl
1 #!/usr/bin/perl
2 $idx = 1;
3 foreach $letter (a..z) {
4 print "Letter #",$idx++," is: $letter
";
5 #print "Letter # $idx++ is: $letter
[Code]...
View 9 Replies
View Related
Aug 12, 2009
I have been using Fedora since almost 1 week by now, and I'm really impressed by its features but there is one very small problem that I face everyday.At the first place, I had setup a profile settings for Network so all my static IP, Hosts, DNS servers were all configured in that profile.Now I had filled in something in the Primary DNS Server and then I had saved it. The internet works after that but when I reboot, that Primary DNS server gets deleted. I have to type it all the time and then click on save and then start using the internet again.
View 1 Replies
View Related
Jun 6, 2010
I'm pensioning off my 10-years-old home server and replacing it with an Ubuntu 10.04 box. The two storage devices are a Western Digital Caviar Green 2.0TB HD and an Intel X25-M 34nm Gen 2 80GB SATA II 2.5inch SSD (the box has 8GB RAM and an i5 750, if it matters).
I don't care much about boot times (since I don't plan to reboot all that often;-); the main frequent, performance-demanding task will be (re)building large open source C or C++ software packages from sources (as an open source contributor, I do that often).
So, I thought I'd keep the SSD as the secondary drive and the HD as the primary one, using the SSD mostly for the files that can otherwise demand a lot of seeking (esp. in a parallel make).
However, the friendly vendor (perhaps more experienced in Windows systems than in Linux ones) thinks the "normal" way to configure the machine would be with the SSD as the primary drive. I'm pretty rusty on configuring and tuning systems, so, I thought I'd better double check on SuperUser.
View 2 Replies
View Related
Feb 17, 2011
We have a LAN with mixed Windows workstations win 2000, winxp, vista, win 7, linux servers all in a workgroup. Most applications used on the LAN are windows based, with a growing number of python apps. A friend suggested a Primary Domain Controller would be a better way to manage logins, resources etc. I don't wont to use a Windows based PDC, what would you suggest as a linux based PDC? I have heard about TURNKEY PDC, but it uses Samba 3 and apparently doesn't handle Active Directory in Windows.
View 5 Replies
View Related
Mar 12, 2011
I just installed primary dns server now want to install new slave server so that in case if primary fails secondary can take requests.
View 3 Replies
View Related
Jan 22, 2010
I got some sourcecode written with c++. I found it did not supported by the newer version of gcc. So I wanted to install an older version. But it always comes up with the question like "./read-rtl.c:653: error: lvalue required as increment operand", what should I do now?
View 6 Replies
View Related
May 17, 2010
I have no idea what is going on here and this is the second time it has done this but. I just installed Lucid Lynx Desktop Edition for my Server. I have installed apache php5 mysql binarys. I have 3 ips on the machine 10.0.1.30, 10.0.1.37, 10.0.1.38. .30 is the main ip 10/100 the rest are 10,100,1000 ports. I can only access Apache 2.2 over .37 or .38 but not .30
I have not used Ubuntu alot but I am starting to and this really pisses me off since all my computer have aliases to the machine through .30
View 5 Replies
View Related
May 21, 2011
i have a two node drbd cluster, while drbd1 is primary and drbd2 is slave i should make drbd1 slave and unmount drbd partition and make make drbd2 primary and mount drbd partition to see content on drbd2is it any way to automate it so as drbd1 goes down, drbd1 make itself primary and mount the partition?
View 2 Replies
View Related
May 3, 2011
A question that I've asked myself (and google) many times but never got to an answer.Scenario:ServerA) postfix Primary MXServerB) postfix Backup MXAccording to the rfc a source mailserver can decide where to send email e.g.send an email to backup even is primary is reachable up and running.So my questions are: 1) how do I (live I mean) replicate messages arrived on any server to the other?2) How do I synchronise sent messages, message deletion, folder creation/deletion.Imapsync goes half way towards the solution but it needs to be run manually one off and you must specify source and destination.All I wanted really is a user to be able to use either server without having to worry about primary/secondary or what so ever.
View 4 Replies
View Related
Jun 21, 2010
I'm having a little trouble with ClamAV. Everytime someone sends me an email I get this error in my Webmin Mail Log. Now the mail works and it goes to the quarantine or to the user mail box but this error fills up my mail log and I'm assuming it is not using ClamAV virus definitions to scan the mail? How would I get rid of this error?
I checked in my /etc/clamd.conf and I have AllowSupplementaryGroups yes. What can be causing this error?
I am using ClamAV 0.96.1
Spamassassin 3.3.12
PostFix 2.3.3
CentOS 5.5
Jun 21 09:57:53 localhost amavis[10714]: (10714-03) ask_av (ClamAV-clamd) FAILED - unexpected result: /var/amavisd/tmp/amavis-20100621T090618-10714/parts:
lstat() failed: Permission denied. ERROR
Jun 21 09:57:53 localhost amavis[10714]: (10714-03) WARN: all primary virus scanners failed, considering backups
Jun 21 09:58:01 localhost amavis[10714]: (10714-03) SPAM, <lovelovedsert12@yahoo.com> -> <acruel@email.com>, Yes, hits=20.638 tag=6 tag2=7 kill=7
tests=DKIM_ADSP_CUSTOM_MED=0.001, DRUGS_ERECTILE=2.221, FORGED_YAHOO_RCVD=1.022, FREEMAIL_ENVFROM_END_DIGIT=2.223, FREEMAIL_FROM=0.001,
FREEMAIL_REPLYTO=2.775, FREEMAIL_REPLYTO_END_DIGIT=0.98, FSL_HELO_NON_FQDN_1=0.001, HELO_NO_DOMAIN=0.001, INVALID_DATE=0.432, MISSING_MID=0.14,
NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_BRBL_LASTEXT=1.644, RCVD_IN_BSRN=2.5, RCVD_IN_RELAYS_ORDB=3, RDNS_NONE=1.274, TVD_RCVD_SINGLE=1.213,
T_TO_NO_BRKTS_FREEMAIL=0.01, quarantine spam-9665 (maia-spam-quarantine)
Jun 21 09:58:01 localhost amavis[10714]: (10714-03) Blocked SPAM, [212.96.9.34] [212.96.9.34] <lovelovedsert12@yahoo.com> -> <acruel@email.com>, Hits: 20.638, 8508ms
View 2 Replies
View Related
May 11, 2011
Is there a way I can change the volume increase/decrees increments
View 5 Replies
View Related
Jul 17, 2011
How do I get this loop to stop on each increment? This script does work but I would like it to stop at each increment, remember what the value of $n is, then continue until it gets to 7. I have worked so hard on this. My brain is hurting now.
[Code]...
View 2 Replies
View Related
Feb 2, 2011
I work in a simulations environment. I'm trying to write a bash script that will read fields from a .csv file into an array, the first field being an identifiyng number and the second field being a corresponding url. There are about 1600 of these number/url combinations in the .csv file that i'm reading from. Once that is done i want it to parse a text file and match the number, when it has a match i want it to enter the corresponding url into a particular line in the text file. The script I have written (with the help of the people on this forum a while back) does this well, but now I have a lot more data to parse. I think the script itself is explanatory enough to see what i'm doing. What i would like to do is cut it down to one while loop nested inside another loop so that I don't have 1600 or so elif statements. I can't figure out how to increment the output of the array. for instance, the first cycle would find the number that matches ${record1[2]} and input the url stored in ${record1[3]}. the next cycle would match ${record1[4]} and input the url in ${record1[5]}, and so on, does that make sense? The code is below and a sample .csv and text file are attached.
[Code]...
View 14 Replies
View Related
Nov 30, 2010
I am learning software raid 1 with centos 5.5. I created the raid with out any problems and removed the first drive to check there was no problems and it booted. I have installed the old drive back in the system as hdc and need to resync the drives (used old drive as partitions correct) I thought I could use raidhotadd but id does not seem to exist anymore. how I resync the drives in the array hda primary and hdc secondary using mdadm
View 1 Replies
View Related
Jun 28, 2010
I used to have a log file monitoring script on my server but after an auto update recently it seems to have disapperaed.Can anyone think of some log file analyzers that send outputs of ssh, amount of disk space used etc. as I cannot remember the name of the program at all.
View 1 Replies
View Related
Jul 2, 2010
I setting up a web server on my Linux (Centos) using "Apache" web server. And its working well, it will show my websites. But when i try to put my url in a internet browser (ie. only type "myweb.com" ) is only be [URL]. Usually as i know like the other websites (ie. google.com) it will go to auto replace the name be [URL]. But my url here it's not be replacing like that. How to do this configuration. I don't know where the services that i need to look. (ie; named (bind) or in Apache web server it self)?
View 2 Replies
View Related
Jun 2, 2009
I'm just setting up my first home server with ubuntu and I would like the box to suspend to ram when no one is accessing it for a while (let's say for 1 hour)The wake up task is already done and is working fine so far; but how can I put the machine to sleep automatically?I guess I have to watch for network-traffic but have no clue how to do it.
View 9 Replies
View Related
Jul 20, 2011
where to look for setting up my web server A so that if I have to bring it down for maintenance, all web traffic will go to my backup server B. I thought about changing DNS entry but that will take time to update.
View 2 Replies
View Related
Jan 6, 2010
I'm wondering how to let him logout automatically from server when the user is in idle for a long time after login.
View 1 Replies
View Related
Mar 28, 2010
I need to set an auto response on my linux email server (ubuntu9),for a person who will be on leave, Perfectpol is out office for a while, if urgent please call office number 222 2222 222.how do i go about setting this. The email address of the user who will be away is perfectpol@mycompany.com.
View 1 Replies
View Related
Jun 20, 2011
I am using Mandriva 2010.2 in my server side and in my client side..... When i try to boot one of my clients through ethernet through server it is working and it is booting... After loading vmlinuz and all.rdz it is indicating an error...
Below given is the configuration file for pxelinux.cfg/default
When i remove the line/phrase kickstart=images/auto_inst.cfg.pl, my linux is loading successfully from server and we can get the installation steps/procedure manually... But i am trying for an auto install procedure....
View 2 Replies
View Related
Apr 8, 2011
I am trying to configure Red Hat ES to automatically start WebSphere Application Server (WAS) automatically upon boot after DB2 services (which already start on boot) are loaded to avoid WAS errors. Note that WAS runs under the jvm so there are processes named WAS or WebSphere when it is running.
My question is, do any of you know a way to setup Linux to automatically start WAS after DB2 services have been successfully started? The web apps running under WAS will have errors if DB2 is not up and running when WAS starts up. I think a 30 - 60 min delay between startup of DB2 and startup of WAS would work perfectly. I am not sure which config file would need to be updated with the call to command to start WAS (I have the command, just don't know where to put it) nor do I know how to ensure DB2 is running before WAS starts in a config file. Right now, I have DB2 loading on boot and WAS starting after I login to xterm.
View 2 Replies
View Related
Feb 20, 2010
Does anyone know if there's a way to make nano support auto-complete and auto-bracket closing?
View 1 Replies
View Related