When I try to install Zimbra 7.1.2, the installation fails because it cannot find sqlite. I used strace and found that it uses "rpm -q sqlite" to find the package. But it fails-"package sqlite is not installed". Although I have sqlite installed:
Code:
#rpm -qa | grep sqlite
mono-data-sqlite-2.6.4-2.13.x86_64
[code]....
Based on Product highlights - openSUSE, it would appear that using sqlite3 in gnucash would be available. However, I do not have an option to save an existing book to the database format, nor is it available when creating a new book - only xml is available. Is there anything special that I need to do to enable the sqlite backend?
View 2 Replies View RelatedI am completely new to Ubuntu so please make your answers really simple ! I want to set up a mail server for a home network and have been suggested I use the Ubuntu solutions. I am fairly proficient with Windows programs and even construct databases but I am a complete novice when it comes to command line instructions. Yes, I know I have been spoon fed!
I have been told that it is possible to install Server programs from the Desktop version and that they provide a GUI in most cases. Is that so? I have the desktop version running and up to date but I am unsure what to do next. Starting the Server ISO CD from Desktop seemed logical but when I did I was not sure if it was correct and backed out. I have also read a thread on this forum that suggests the use of Zimbra as a Mail Server, it sounded like my kind of solution so I think I would like to try that.
One last factor. I have an existing P2P network (2 Vista, 1 Mac Book and this Ub' desktop/server) running already which uses the Router for DNS. I suspect I am going to have to do things in a certain order if I am not going to go backwards and ruin the families email and surfing!
Have any one been able to setup zimbra with procmail? Procmail as the filter for zimbra I mean.
View 1 Replies View RelatedIs there some step by step? for ubuntu 10.04 server?
or there is something better ?
if there is something like colaborative email server like gmail will be great.
I'm trying to install Zimbra and Apache. I'm having difficulty setting up DNS (if necessesary) and also configuring my /etc/hosts show me what the /etc/hosts should look like.
View 3 Replies View Relatedi have successfully installed zimbra on Debian machine but am failing to log in to the console admin. i have used my server name as well as my ip address but both do not work.
View 8 Replies View RelatedI am attempting to install zimbra onto Ubuntu Hardy 8.04 x64 bit edition using this tarball:
Code:
zcs-6.0.6_GA_2330.UBUNTU8_64.20100505202919
However when I run the install script I get this error:
Code:
Press Return to continue
Checking for prerequisites...
FOUND: NPTL
FOUND: sudo-1.6.9p10-1ubuntu3.7
FOUND: libidn11-1.1-1
[code]....
Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using "man perl" or "perldoc perl". If you have access to the Internet, point your browser at [URL] the Perl Home Page.
Got a Zimbra server FOSS edition running on CentOS5.5. Everything was running fine until couple of days just found out that web administration interface just does not give the proper status. Web console says that none of the services are running which infact is not true. Only service that is not running is logger. This is the zmcontrol status output
Code:
antispam Running
antivirus Running
imapproxy Running
ldap Running
[code]....
Just the logger service is not running all the others are. But web admin interface shows all are stopped. Also it can be seen that zmlogswatchctl is not running. Starting it manually does not do any good. It does not start and it dies out by itself.I tried to google and found a couple of bugs related to logger and web interface but those were old and should have been done in this version 6.
I want to setup either Zimbra, qmail or sendmail. i have no idea of these three mtas (i am new to these mail servers)but give me the suggestion that which one is better in case of security, fast routing the messages, scalibility and portability and cost.
View 5 Replies View RelatedI installed CentOS 5.5 this morning with zimbra 6.0.7. Everything seemed to go perfectly until at the end the following zimlets failed to install
com_zimbra_phone...failed.
com_zimbra_email...failed.
com_zimbra_dnd...failed.
com_zimbra_url...failed.
I installed zimbra successfully on Fedora 11 before. But I heard how stable CentOS is so I decided to switch. I read a lot online about how a lot of people have had zimbra on CentOS5 without any issues that were not easily solved. Zimbra appears to be working fine. I was able to add my domains, accounts, and send/receive email. So I'm not quite sure how important these zimlets are or if I even need them. But I'd like to know that the software is working the way it's supposed to. Since I'm new to Zimbra I want to make sure I get full exposure so I can learn it well.
I am having trouble configuring Zimbra to restrict sending for some users. A subdomain has been added in the ZCS web page for the domain, resulting in two potential mail addresses:
[URL]
The subdomain needs to be restricted from sending mail to the outside world and to other users on the same subdomain. It should only be able to message users on the main domain. The users on the main domain should be able to email anyone in the world. Is it possible to configure this without installing Zimbra on two machines?
I am trying to install sqlite-python package in my FC11 machine. I couldn't find an rpm to install.
View 2 Replies View RelatedI'm having a bit of trouble with a web server running Fedora 12. Apache works fine, and serves up php content without a hitch. My problem is SQLite -- I thought that it was built into php5, but support is disabled in the repo version. phpinfo shows this as part of the configure command:
Code:
'--without-sqlite' ... '--disable-pdo' ... '--without-sqlite3'
The only solution I've read anywhere is "compile php from source," but I'd like to avoid that if possible, for ease of future upgrades. Is there a way to convince php to use sqlite despite its current state?
Is there a binary available somewhere, even if it's a non-Fedora repo?
View 8 Replies View RelatedWith this sqlite query ? I have these tables:
what is the query to list all cities and its neighboring cities like this?
I am trying to connect to sqlite via perl:
Code:
#! /usr/bin/perl
use LWP::Simple;
use XML::DOM;
use DBI;
[Code]....
Anyone know how to execute SQLite db commands from C++?
View 1 Replies View RelatedHow do I install php-sqlite extension on fedora 14.
View 5 Replies View RelatedI 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
i am trying to compile too the sqlite for arm9 - mini2440.could you please tell me what was the steps you make? im read that book but im still having some trouble while i compile i have been trying to do the compilation.
View 3 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 RelatedThis 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
I want to be able to create an RPM that will install python 2.7.1 along with sqlite 3.7.3, MySQL-Python-1.2.3 on a CentOS 5.5 x86_64 host(s) in a directory (e.g. /opt/python2.7). Once that's done, I want to be able to alias the new python binary in .bash_profile so that my developers can begin using it.
I understand 2.7.1 can't be installed on a CentOS host but I've done the above using a shell script successfully. If you search hard enough, I posted my script on line . However, I need to create the RPM for political reasons. Besides placing the source file(s) in the SOURCES directory, what do I need to do in the spec to be able to successfully create an RPM installer?
Please be gentle with me. I've been drinking the Windows cool-aid for most of my IT career so, this is one of my first attempts of becoming a better DevOps Admin.
I 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.
This is a continuation of the post in [URL].... . What has happened is that I have a huge log of 600 MB + and do not know from when the data is in there.
Code: Select all┌─[shirish@debian] - [~/.config/quassel-irc.org] - [9714]
└─[$] ll -h quassel-storage.sqlite
-rw------- 1 shirish shirish 647M Jun 22 21:15 quassel-storage.sqlite
So I need to know if there is a way to get just the first five or ten entries listed as one can do using head, tail etc. I did try just using head but it was unsuccessful. The second thing would be deleting some days, weeks or months data from the existing sqlite log. I did see URL... but in my case I am deleting old entries in the sqlite log and also do not know if sqlite makes backups of the data or not ?
I get the error when trying to mark tomahawk for installation using synaptics. I googled the error but couldn't find anything on it. could some one help me figure out what's going on?
View 3 Replies View RelatedI'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
I 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.