Programming :: Execute SQLite Db Commands From C++?
Jun 10, 2010Anyone know how to execute SQLite db commands from C++?
View 1 Replies
ADVERTISEMENT
Programming :: Execute Commands After Run Command?
Jan 13, 2011I am executing a run command in a script after that i need to copy files into a directory which are the inputs for the run,on run a new shell is created and the remaining commands in the script does not execute,wot should i do to execute the remaining commands in the script??
View 2 Replies View RelatedProgramming :: Execute Clia Commands At CLI Prompt Through Script?
Feb 18, 2011I have a requirement to execute a series of cli commands and to show the outputs. The problem is with the below script I could able to log in to cli prompt and bring CLI prompt but after that cli commands have just get printed at the cli prompt for e.g. board 2, it never gets executed and terminates the script.
FYI : I am unable to post the script as getting You are only allowed to post URLs to other sites after you have made 15 posts or more. error. I need for throwing some commands at a prompt like ftp prompt through script.
Programming :: Load Multiple Records Into SQLite?
Nov 19, 2008I am using SQLite as my database for some portable cross platform applications I am working on with REALBasic as my IDE. I have an old Sybase 8.0 database that I can access via Microsoft Access and thereby extract the data I need from each table.
Now I know I can create .csv files from each table and load them into SQLite using the import tool, but then I can't define the primary key and other field attributes. So the other option is to load each file via SQL.
Now with most SQL editors I can create multiple queries and they will run just fine. But I can't seem to do that with the SQLite interfaces. I can paste multiple queries but I can only run one at a time. And by that I mean I have to click run.
Ummm that's not acceptable since my biggest table contains over 600,000 records. I have the queries all written, that was easy using a simple interface I wrote in Access.
Code:
INSERT INTO tblMeters(recordId,meterId,meterName,meterSerNum,registerSerNum,mxuSerNum,meterType,manufacture,meterModel,readType,groupId,multiplier,rollover,vendorId,xfrmerCode,bldgCode,CATEGORY,energyType,unitOfMeasure,location,access,comments,dateInstalled,dateCalibrate,pipeSizeIn,pipeSizeOut,elecMeterSpecs)
[Code]...
So is there another method I can use? I can't seem to find anything relating to my particular question at the SQLite web site
Programming :: Variable Substitution In Sqlite Open Db Command?
Jun 15, 2010I have the following TCL code:
if{ [catch {sqlite3 db /path/to/db/file} result] } {
puts stderr $result
} else {
do something
}
What I want is to use a variable for the file name/path. When I put in a variable instead of the absolute path, I get an error: "missing close-brace: possible unbalanced brace in comment while executing"
This is weird because when I run the code with the fully qualified pathname, it works fine. I substitute out the pathname for a variable containing the pathname ($variable) and I get this error.
General :: Execute Different Commands With Same Name?
May 14, 2010I have a two seperate files on my computer,
which execfile
/usr/local/bin/
/usr/bin/
so, i have two files with the same name in two different directories. How can I specify exactly which command to run?
Programming :: Python / Sqlite - Database Locked Despite Large Timeouts?
Apr 8, 2010I'm sure I'm missing something pretty obvious, but I can't for the life of me stop my pysqlite scripts crashing out with a database is locked error. I have two scripts, one to load data into the database, and one to read data out, but both will frequently, and instantly, crash depending on what the other is doing with the database at any given time.I've got the timeout on both scripts set to 30 seconds: cx = sqlite.connect("database.sql", timeout=30.0)and think I can see some evidence of the timeouts in that i get what appears to be a timing stamp (e.g 0.12343827e10 1) dumped occasionally in the middle of my curses formatted output screen, but no delay that ever gets remotely near the 30 second timeout, but still one of the other keeps crashing again and again from this. I'm running RHEL5.4 on a 64 bit HS21 IBM blade, and have heard some mention about issues about multi-threading and am not sure if this might be relevant.
Packages in use are sqlite-3.3.6-5 and python-sqlite-1.1.7-1.2.1, and upgrading to newer versions outside of RedHat's official provisions is not a great option for me. Possible, but not desirable due to the environment in general.I have had autocommit=1 on previously on both scripts, but have since disabled on both, and am now cx.commit()ing on the inserting script and not committing on the select script. Ultimately as I only ever have one script actually making any modifications, I don't really see why this locking should ever ever happen
Programming :: SQLite Read, Write, Select, Compare Statements For C++
Jun 9, 2010I am using C++ with SQLite db in a program that will read read a sub set of records, compare records and write different records to another database. I have a SQLite book, but it only shows examples for the C API. Anyone have code samples in C++ for the following:
Open database
Close
Select *
Read
Write
Or, just show me how to execute a SQL statement with C++ and I can then figure out the various SQL statements I need.
Fedora :: How To Execute Commands On Startup
Aug 11, 2011how to execute commands on startup. I've added lines to /etc/rc.d/rc.local, /etc/rc.local, I've put scripts (with extension .sh) into /etc/init.d/ and I've set the executable permission thing on all of them with chmod -x. I *still* can't get anything at all to execute on startup. The truth is, I'm trying to enable multitouch and button tapping automatically when I startup Fedora. I have the commands
[code]...
Which I want to execute whenever I start Fedora (it's a bit tedious to write them every time, or even to have to execute a script myself whenever I start my computer). Furthermore, if I can figure this out, then I can do all sorts of things. Does anyone have a clear, surefire way in which I can do this? I'm not good with using Linux at all
Ubuntu :: Execute Other Commands In A Row In That Same Newshell
Nov 13, 2010I have a script --> WEP.sh and i want to open severel new processes in a second shell.
gnome-terminal -e "airmon-ng check" #this is working... but is there any possibility to execute other commands in a row in that same newshell for example airmon-ng stop wlan1 or sleep 10 or echo....?
General :: Execute Example.sh Files Like Other Commands?
Jun 23, 2010I just want to know that how can I execute a example.sh (script) from command-line like other Unix commands. Please write full procedure
View 4 Replies View RelatedCentOS 5 Server :: Can't Execute Some Commands?
May 22, 2009I am trying to determine if I should upgrade PHP's PEAR on my server. I am trying to check the version of PEAR currently installed. I am getting the following error when I use the pear -V command:Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s)(/usr/share/pear:/usr/share/php) in System.php on line 459I tried adding /tmp to my php.ini file, but then when I use the pear -V command it doesn't do anything. I do not get any errors or anything.I am also trying to install symfony and have the same situation described above when I use the following command: pear cannel-discover pear.symfony-project.comDoes anyone have any thoughts? If not the solution, does anyone have any suggestions on how to begin troubleshooting this?
View 2 Replies View RelatedGeneral :: How To Execute Multiple Commands When Using Find
Jan 22, 2011I'm trying to run multiple commands on things I have found, how can I achieve this? find . -exec cmd1; cmd2 does not seem to work; it instead runs cmd2 after cmd1 has been executed on every file.
View 2 Replies View RelatedGeneral :: Execute Commands Over SSH In A Batch File?
Feb 17, 2011I'm looking to, all in the course of one batch file:
ssh into a remote computer execute commands (per the batch file) on the remote host.
What options do I need to add to the ssh invocation so that the batch file executes the lines following the ssh invocation over the connection?
e.g., with sftp it's simply adding a -b /dev/stdin and then << EOF at the end; how do I do this with SSH?
Ubuntu :: Screen Wont Execute Commands?
Jan 13, 2011Cant type anything when i attach to my screen by typing screen -r. It doesn't even say neokyle@server, the only thing i can get it to let me do is detach. I cant even kill it.
View 2 Replies View RelatedDebian :: Server Delay To Execute Commands?
Sep 1, 2010I have debian lenny, when I run an application is slow to load (example: iceweacel open and it takes, I can hold him iceweacel work normally), I tried to change from gnome to another and the same thing, went down some services (samba, squid) and nothing. I open a terminal and it takes, I want to duplicate it and do it fast. From a terminal without X (tty1) with root run mc and moves quickly, also run as root "sudo mc" and takes to boot.Any action done with sudo it takes to run.Can not be what it takes to make starting the applications, not the PC because it is new, and from one moment to another I began to pass this
View 2 Replies View RelatedGeneral :: Easier Way To Execute Long Commands?
Jul 29, 2010I use a long mount command to mount a NAS drive but have to retype it every time I need to mount the drive. Because it is on my laptop I only need to mount the drive from time
View 4 Replies View RelatedGeneral :: How To Allow User To Execute All Commands Without Sudo
Apr 30, 2010Customer asked me to create a menu for linux he also asked me to do this: Open like a command like where a user can execute commands...so for this the users have sudo enabled. The code below works OK. But it has an issue when a command is executed but the command does not need sudo
Like for instance
Code:
cd /
sudo: cd: command not found
How can I allow a user to execute all commands when a command does not need sudo
Code:
echo -e "Press Control+C to finish"
#echo -e " "
while true;
do
read whichcmd?"Insert Command: "
sudo $whichcmd
done
Software :: Execute Commands Via Ssh / Working And Failing
Apr 9, 2009I am trying to get F10 installed on L2 so that I can use the system the same way that I have been using L1 with F8. Specifically, I am using unison (with ssh) to crossload files between the desktop and the laptop. Unison works just fine when executed on the desktop crossloading to the F8 Laptop1. But when trying to do the same on L2, it hangs while trying to contact the server.Attempting to diagnose the problem has led me to ssh.I can use ssh to login to any of my systems from the desktop. E.g.,ssh delta
but attempting to execute a command via ssh simply hangs. E.g.,ssh delta "echo $PATH"
Both ssh login and ssh remote execution work fine when done to the F8 laptop 1.
I have installed tcsh on all systems and my login shell is csh (i.e., tcsh) on all machines.I have spent the better part of the last two days trying to find something but have failed. As far as I can tell, both L1 and L2 are configured identically:
firewall disabled
selinux disabled
and while I have not done a character-by-character comparison of the ssh and sshd configuration files, they appear (visually) to be the same, as shipped with the Fedora distribution.
I need some pointers on where to look for problems, etc.
Software :: Using Expect To Execute Remote Commands?
Dec 21, 2010I'm trying to get Expect to execute commands on a remote server using SSH with username/password authenticationMy current expect script is
Code:
#!/usr/bin/expect -f
spawn ssh -tq root@my_hostname "whoami"
[code]...
CentOS 5 :: Where To Put Commands To Execute Just Before Shutdown / Logoff?
Mar 3, 2010Where can I put commands which should be executed just before
- logoff
- shutdown
I think there must be somewhere an opposite script to
.initrc
or
.bashrc
Fedora Networking :: Cannot Move The Mouse, Execute Any Commands?
Oct 17, 2009I just finished installing Fedora 11 on a Dell Inspiron 6000. After some tinkering, I was able to get the Broadcom 4318 wireless card to start working. After a restart, I booted into Fedora and attempted to connect to my wireless network.Five seconds later Fedora freezes. I cannot move the mouse, execute any commands (except hold the power button down), or access any log files. The only confirmation I get is that my router does receive a signal from the wireless card, shortly before dying.
View 1 Replies View RelatedUbuntu :: Loop Through Subfolders And Execute Commands Or Scripts?
Apr 3, 2010Let's say I have 4 subfolders in the folder test as shown below:
drwxr-xr-x 2 muskedear muskedear 4096 2010-04-03 17:11 sub001_p1
drwxr-xr-x 2 muskedear muskedear 4096 2010-04-03 15:38 sub002_p1
drwxr-xr-x 2 muskedear muskedear 4096 2010-04-03 15:38 sub001_p2
drwxr-xr-x 2 muskedear muskedear 4096 2010-04-03 15:38 sub002_p2
I want to loop through the folders and check if they end with *_p1 or *p2. If a given folder ends with *p1, I want to cd to that folder and manipulate certain files in that folder. If the folder ends with *p2, I want to perform different manipulations on certain files.
Ubuntu :: Ssh Commands Execute Locally Instead Of On The Remote Computer?
Jul 12, 2010I can ssh to the remote computer OK, but the commands execute on the local machine, not the remote machine as they should. After much frustration I did the following hoping to clear the problem. I turned off all machines on my LAN, the hub and the router. I then rebooted everything in the reverse sequence - cable modem, router, hub, and then the computers.Then I reinstalled ssh on both machines.
sudo apt-get purge openssh-server openssh-client
sudo apt-get install openssh-server openssh-client
sshd in now running and port 22 shows on both machines. However the problem persists.
Red Hat / Fedora :: Edit In Bashrc File Now Cant Execute Commands?
May 30, 2011recently I did some changes to my bashrc file the changes are as follows
export JAVA_HOME=/usr/java/jre<version>/bin/
export PATH=$PATH:/usr/java/jre<version>/bin
now I'm unable even login to the OS.
General :: Execute Commands After Logging In Into The Ssh Connection Not Locally?
Oct 20, 2010I am creating this script which will login to a server with ssh and check if a particular exists there, if not it will create the user.This is the script:Quote:
ssh 192.168.100.5
cat /etc/passwd|grep -i $1 > /dev/null
if [ $? -eq 0 ];
[code]...
General :: Execute Series Of Grep Commands In Script?
May 10, 2011Executing series of grep commands to get counts in a large file. I'm appending to this file. Series of commands will be;
"greg -ir "May/0504" SentEmails.txt | wc -l >> Stats.txt
"greg -ir "May/0505" SentEmails.txt | wc -l >> Stats.txt
"greg -ir "May/0506" SentEmails.txt | wc -l >> Stats.txt
"greg -ir "May/0507" SentEmails.txt | wc -l >> Stats.txt
General :: Script Which Will Login To Particular User And Execute Some Commands?
Mar 19, 2011I am trying to write one script. Purpose of my script is that it will login to particular user and it will execute some set of commands.What I was trying....
#!/bin/bash
su - tom
ls -lrt
[code]...
General :: Type And Execute Commands In Window From Computer
May 19, 2010ssh to a machine on my network open up a terminal (gnome, xterm, whatever) and have it visible on that machines display be able to type and execute commands in that window, from my computer. i have kind of achieved this. on machine A, i ssh to machine B. on machine B, i open up a terminal and execute screen, C-a :multiuser on. on machine A, i execute screen -x and connect to the term on B. everything i type from A or B can be seen. i just want to be able to set this up without having to physically be at machine B. does that make sense?
View 7 Replies View RelatedSoftware :: Execute Script To Run Commands On Remote Server
Jan 1, 2010I have an immutable script on server A, it executes a maintenance command on the remote servers where elevated privileges are needed. I want the developers on server A to execute the script and run it without being prompted for a password. The script contains scp root@serverB and ssh 'root@serverB', if run as root it runs great since I am using ssh keys. However, as regular users they are prompted for a password. If I do created their group on server B...etc and give the group sudo it would still ask for passwords right? Can I overcome this?
View 1 Replies View Related
