This query is giving "Unable to open data base" can anybody suggest what's wrong with this query.
sudo echo "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id;" | sqlite3 moz_places.sqlite, moz_historyvisits.sqlite
With this sqlite query ? I have these tables:
what is the query to list all cities and its neighboring cities like this?
I want to install mysql query browser in debian
View 1 Replies View RelatedIs there a binary available somewhere, even if it's a non-Fedora repo?
View 8 Replies View RelatedI am running Ubuntu 10.04 LTS. I am trying to run a query browser for mysql but keep receiving the following error:
X11 connection rejected because of wrong authentication.
The application 'mysql-query-browser-bin' lost its connection to the display localhost:10.0; most likely the X server was shut down or you killed/destroyed the application.
In ssh_config, I do have ForwardX11 set to yes.
Is it possible to locate the Firefox file that retains "Search" history (not particularly "Browser" history)?I have lost a hardcopy list of authors and titles of books/ebooks that I search the web for. However, most of the time when I would enter a name or title a drop down list would have that entry I wanted, and I could just click on it. That drop down list is what I am calling "Search" history.
View 8 Replies View RelatedCan query browser be installed in 11.4??
I've tried to use workbench but it's such a big step backwards in that you can't easily edit the output from a "select x,y,z from table" query. I'd have thought that was a pretty basic requirement...
i have MySQL on my CentOS server and have installed it and got it up and running through the command line.
I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'.When i try to log in it gives me error 1130 and says connection from myhostname not allowed.
I have installed mysql package in ubuntu 9.04 .I have also installed the query browser software can someone tell me how to configure the connection dialogue box in query browser. also my friend is using ubuntu 8.04 when he writes mysql in terminal he can directly execute database queries there but when i try the same thing on 9.04 i get an error as "Access denied for user 'ravi'@'localhost' (using password: NO)"
View 1 Replies View RelatedDoes anyone know where I can get a link to download MySql query browser(windows version)?
I want to query my database on my fedora box in windows to make life easier... I can not seem to find a link to download the query browser though
I am using squid proxy server for sharing Internet in my internal network. I would like to know that how can I check the browsing history by individual users web surfing history by their IP addresses?
View 1 Replies View RelatedOnce upon a time when I started sqlite from the command line I could using the tabbing autocomplete to enter the database name. This has not worked for a while now.
View 1 Replies View RelatedI have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records in them? Of course I could just wipe them completely, but that's not my goal - I just want to minimize the size of those files while keeping the newest records.
View 2 Replies View RelatedMy goal is to download a .deb package(e.g vlc) from the cmd line so that I do not always need to connect to the internet using the normal apt-get install cmdFrom the cmd line I typed sudo apt-get -d install vlc. After the operation is completed, is the downloaded file in a .deb form and where is it downloaded to?
View 3 Replies View RelatedI have an application in my company PC running on Fedora Linux.Can dyndns be used to access from outside world?
View 5 Replies View RelatedI'm using Net::Bluetooth to create an RFCOMM socket on my Linux box. I need for it to register with SDP with a specific UUID. The perl code can be viewed in this link. I am unable to make the connection from a remote device however. This remote device (my Android phone) is able to connect to other RFCOMM devices using this UUID. I would like to troubleshoot the problem, but I can't find a way to browse the LOCAL SDP records of my PC where the Perl script is running (and waiting for incoming BT connections). how to browse the SDP records on the local PC?
View 1 Replies View RelatedI configured ldap server & client on centos,then i connected centos and suse with network.now want to get group of any user from this server via suse.is it possible with perl scripts? or i need to install other modules on suse or centos?(such as : pam,nss)
View 8 Replies View Relatedi want to know how to view tamil websites in redhat linux EL5.pls assist to know the detail.
View 5 Replies View Relatedhow to applied permission on /etc directory. i want to deny all permission except me(owner).....is this possible?
View 1 Replies View RelatedI have the following mysql query which works great.
Code:
SELECT msg FROM `logs` WHERE ((`host` = 'aaa.bbb.ccc.ddd') OR (`host` = 'aaa.bbb.ccc.ddd')) AND `msg` REGEXP CONVERT( _utf8 'physical addresses' USING latin1 ) COLLATE latin1_swedish_ci
I need to refine this query so that I can query the last # hours using the `datetime` field in the database. I have researched the DATE_SUB function and can query for example the last 1 hour like this:
[Code]....
i have a server which was handover me, it has redhat 4 u3.but i cant find the machine model no, it is hp g4 server, so this info from linux where can i see
2nd if i want to know what is the bios version and date how can i see from linux.
3rd if any hardware failing like network card, ram memory, hard disk how we come to know hardware.
I am on a CentOS 64 bit and used webmin to rotate MySQL slow query log. Now the thing is although logs are being rotated daily but the new log files being created are empty which means MySQL is unable to write them due to some reason. I have checked using "ls -l" that both permission and owner of files is same but still MySQL is not writing logs. What could be the reason?
View 10 Replies View RelatedI have Fedora11 machine : 192.168.0.3 ( Bare metal )--> vinay.linux.com
Another Fedora 11 machine : 192.168.0.4 ----> test.linux.com
Virtual Machine on FC11 : 192.168.0.6 ( VM )-----> centos.linux.com
I have DNS configured on Fedora11 machine, Also I have checked the connectivity of centos.linux.com to port 53 of DNS.
Here is my /etc/named.conf file of FC11 machine code...
I have a ClarkConnect (CentOS based) box running as my home router on a RR connection. I had the DNS servers set up to use Google's DNS server. I want to change them back to the local DNS servers but I can't find an obvious/easy way to get those address short of a) reconfiguring the router's network to DHCP them (would rather not interrupt everyone) or b) calling their tech support (kill me now!). Is there a command line tool/command I can use to query the DHCP server on the external NIC to see what DNS servers it would set me up with w/o munging my existing setup?
View 1 Replies View RelatedI am connecting to MySQL DataBase using shellscript and writing a select statement like select attachmentid from attachments where pageid=10175 I want to store the output of the select statement into a shellvariable or a file. How can i do it using shellscript.
View 4 Replies View RelatedI have a logfile which looks like:
tableabc 1786rows
tabledfg 8374rows
tablefhd 726rows
[code].......
Now i have to writ a script which takes this log as input and quesries the DB for each table. So,I want to: input the logfile
start a while loop.So,while read LINE This variable LINE would store the table name by CUT using a delimiter once the table name is ready it makes a connection to DB and queries the table for its rowcount writes the rowcount to an O/P file.
I am using "if" to force a word under the condition that the first letter of that word must be a letter of the alphabet, regardless of capitalization, using the " "" != "" " syntax.
Like so:
Code:
if [[ "$interface" != "WHAT DO I PUT HERE?" ]] ; then
echo "Invalid input"
exit 1
fi
How to clear history in LINUX?
Which command?
And how to remove permissions which is given for a user to be group admin? by this command- gpasswd -A ram sales
Where ram is user sales is group
How to deselect him as admin?
I have inherited our Linux packaging and as the number of versions increase, the number of conflicts is starting to get a bit unmanageable. I believe the easiest way would have been to keep the package names the same and just change the release in the spec file but unfortunately I am past that as a lot of these packages are rolled out to our estate. (I am told there were reasons for not keeping the package name the same and incrementing the version/release)
Is it possible to wildcard conflicts so I don't need to keep adding as new versions are created. For example, instead of using all the conflicts below, have something along the lines of AAtest45* <= 1.4 & BBtest45* <= 1.4 Meaning that all I would need to do was change this to 1.5 at the next release (the packages below version matched the release in the spec file)
[Code]....
I am working on a x86 target running fedora 9.
Whenever I reboot it, my history returns to some state, and I do not have commands I did in the sessions before the reboot.
What I have to change to have updated history I had before reboot?