similar to: please add MySQL Support!

trying to structure sql to merge two datasets. structure follows: dbs.possible.combos (all possible combinations of dates and places) Date Place 1/1/10 N-01 1/1/10 S-02 1/2/10 N-01 1/2/10 S-02 etc... dbs.aggregate (the raw data aggregated by date and location) Date Place Days 1/1/10 N-01 6 1/1/10 S-02 10 1/2/10 S-02 5 Trying to merge so I look-up the values for each possible combo dbs.final

It seems that I can never get through a phpmyadmin session w/o it hanging on "Waiting for http://....". The only way I have found to correct this is to cycle Apache. I can always get past the signon portion, but it hangs at various portions of selecting DBs or Tables. CPU is not overly active, all httpd daemons running, no myphpadmin remnants running. Can't find any problems in

I am using the code below to extract census tract information. save.tract$state, save.tract$county and save.tract$tract are returned as factors. In the last three statements, I need to save the actual value of the factor, but, instead, the code is yielding the position of the factor. How do I instead return the value of the factor? By way of example, for Lon=-82.49574 and Lat=29.71495, the code

Hi all, I am about to start a new RoR project. Which version of mysql is the current best one to use? I will be using the soon-to-be-released RoR 1.0 for the project. I really don''t want to start a PostreSQL vs. MySQL vs. Whatever war. I have all databases including Oracle at my disposal. This project will be my testbed for using RoR with mysql. I will be doing other tests with other dbs

Hey all, I've been using ->add_database for a few years to tie sharded DBs together and it works great. Now, I want to be able to search across several DBs which aren't sharded, say: linux-DB, glibc-DB, freebsd-DB. I want to search for something across all of them, but prioritize results to favor one or some of those DBs over others. Is there a way to do that without reindexing? Or

If I try: rsync -lptgoD -e "ssh -i /root/.ssh/rsync-key" --verbose --exclude="/*.*" --exclude="*.xml" --include="+ */Tariff/" 192.168.1.1:/home/e-smith/files/ibays/frogs/files/dbs/ rsync lists the correct files, but if I add the destination like this: rsync -lptgoD -e "ssh -i /root/.ssh/rsync-key" --verbose --exclude="/*.*"

Every now and then when I am working on making the SQL Server adapter pass all the ActiveRecord tests, I notice one that looks like a false positive in the core DBs. Here is one case in relations_test.rb. Can someone look at this and just tell me it is normal for other DBs and just odd for SQL Server? Or maybe it is just my understand of some SQL standard. I''m really not that SQL smart.

I'm trying to add MySQL CDR recording in Asterisk 1.4.6. I'm following the instructions posted here: http://www.voip-info.org/wiki-Asterisk+cdr+mysql I have MySQL installed and it works fine - starts on stratup, I can create DBs, tables and so on and I can connect through php. rpm -qa indicates: MySQL-server-5.0.22-0 MySQL-devel-5.0.22-0 MySQL-client-5.0.22-0 However I still get XXX

I''ve dug thru docs, recipes, wiki, but haven''t found anything quite like what I''m trying to do.. I have 2 databases with the same tables and same models representing them. I want to get an item (of same name) from the 2 dbs for comparison. Now, each example of connecting to multiple dbs I''ve seen (including from Rails Recipes and the wiki) assumes that

Valeri Galtsev wrote: > > On Thu, March 24, 2016 9:48 am, m.roth at 5-cent.us wrote: >> Valeri Galtsev wrote: >>> On Wed, March 23, 2016 10:21 pm, Always Learning wrote: >>>> mysql Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using >>>> readline 5.1 >> <snip>> >>> Indeed. There are several flaws in how mysql handles

Hello, I have a bunch of data files all with "dbs" file extensions. They are generated via a SQL query from another program and source. Does anyone know (or have ideas) how to get the data from a dbs file type into R (or into some other format that can imported to R)? I've searched online for 4 hours now... Thanks! Ben [[alternative HTML version deleted]]

Fri, 17 Jul 2020 18:23:42 +0100 Rowland penny via samba <samba at lists.samba.org>: > On 17/07/2020 17:59, RhineDevil wrote: > > I mean all dbs containing samba ad-dc data > > Forgot to ask something, an LDAP client connecting to samba LDAP implementation can use `cn=mycn,dc=domain,dc=tld` or it's forced to provide DC and CN in uppercase? > > As far as I am aware,

i realise that this goes against the basic idea of the MVC architecture, but i''ve found myself in a situation where i need to get information about the current user in a model & i''m not sure how to do it. Basically, we have a product where each customer has their own profile with data stored in a separate database. There are some tables in a common

Hi, using dovecot 2.0 and I'm using a couple of user DBs, sql/prefetch and pam. Currently if the user logins with username at domain it authenticates off the sql DB and works fine. If the user logins with username with no @domain it fails on the sql lookup and succeeds on the pam user DB. However I was wondering if I can have another sql DB lookup that says when the user logins and fails

* Niklaas Baudet von Gersdorff <niklaas at kulturflatrate.net>: > On Fri, 11 Sep 2015 00:43:16 +0300 > Timo Sirainen <tss at iki.fi> wrote: > > > I've been once in a while over the years thinking about implementing > > CalDAV (and CardDAV) to Dovecot. It might be time to start that soon. > > Does anyone have any suggestions? So far my main goals would

I've been once in a while over the years thinking about implementing CalDAV (and CardDAV) to Dovecot. It might be time to start that soon. Does anyone have any suggestions? So far my main goals would be: - scalable, of course - configurable storage (object storage, regular fs, maybe some key-value dbs, maybe storing as emails) - efficient indexes (potentially using key-value dbs? or maybe

How do I get this set up? spamassassin -D --lint shows me an error... debug: bayes: no dbs present, cannot tie DB R/O: /root/.spamassassin/bayes_toks and with no db present, it doesn't learn. Is there something simple that I'm missing? Craig

I was wondering if there is a way to do tabs easier than most of the tutrials that I have found. I dont realy care if its realy fast just as long as it works. Something sort of like http://code.google.com/webtoolkit/documentation/examples/kitchensink/demo.html#TabsAlso if there is a way where if my viewers want to save something as a link than there is something they can click and it will give

Hi there! I´ve started looking into puppet for about one week now, I have to say that I am NOT a developer, i occasionally write a shellscript or another but thats about it, so maybe my problem is that i dont see the whole picture yet.. I kind of know what i want to do, but at the moment i don´t realy see how i can accomplish that.. :/ thing is, I have (for now "just") about 100

Hello folks, I use to think that a relational databases without foreign keys constraints enforced strictly by the RDBMS were no good, piece of crap, data junk. However, I''ve also learned the hard way that FKs constraints imposes serious difficulties when moving data around, specially between different DBs, or for loading test data or for upgrading DBs schemas, or for porting DBs