search for: my_db

Given a directory tree like ... /foo | +-- A | +-- B | +-- C ... what is the best way to index A and C into a single Xapian database? AFAIK the alternatives are: omindex --db /my_db --no-delete /foo /foo/A omindex --db /my_db --no-delete /foo /foo/B or omindex --db /my_A_db /foo /foo/A omindex --db /my_B_db /foo /foo/B xapian-compact /my_A_db /my_B_db /my_db The first alternative does not delete files deleted from the file system from the database. Is there any way around...

...asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass = my_secret dbport = 3306 dbsock = /tmp/mysql.sock - /etc/asterisk/extconfig.conf ; Extconfig.conf for realtime configuration voicemail => mysql,my_db,voicemail_users (Just want to try something simple such as voicemail for the initial testing.) I have removed the [...

Hi all I''d like to create fixtures using Fixtures.create_fixtures But it seems that this one needs .yml files that have the same name like the table they correspond to: countries.yml => my_db.countries readers.yml => my_db.readers Is it possible to use any desired filenames somehow? some_cool_countries.yml => my_db.countries some_other_cool_countries.yml => my_db.countries Thanks for any help, Josh -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~--------...

...with my Access Database, and now im switching to Oracle 9i. I use R 2.0.1 on a Windows XP platform, 1GB ram, 2GHz Intel Processor) When I connect through the Rgui R console, the connection is successful (but through VB the attempt fails): >library(RODBC) >channel <- odbcConnect(dsn="MY_DB", uid="MYUID", pwd="MYPWD", case = "oracle") >channel RODB Connection 4 Details: case=toupper DSN=MY_DB UID=MYUID PWD=MYPWD DBQ=LT10G DBA=W APA=T EXC=F FEN=T QTO=T FRC=10 FDL=10 LOB=T RST=T GDE=F FRL=F BAM=IfAllSuccessful NU...

...code I am creating a connection using the following code: ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :username => "TestUser", :password => "TestUser", :host => "machine.domain.com", :database => "MY_DB,1150") I can connect to the database from my machine using DBVisualizer, using the same parameters. What could be the issue here? --Navjeet -- Posted via http://www.ruby-forum.com/.

...asterisk-addons to ensure that /usr/lib/asterisk/modules/res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass = my_secret dbport = 3306 dbsock = /tmp/mysql.sock - /etc/asterisk/extconfig.conf ; Extconfig.conf for realtime configuration voicemail => mysql,my_db,voicemail_users (Just want to try something simple such as voicemail for the initial testing.) I have removed the [...

Hello, I have write a schema.rb database such as this: ActiveRecord::Schema.define do create_table :arts do |t| t.string :name, :null => false, :limit => 45 end end This file is saved into test/db/schema.rb, and test/config/database.yml is correctly configured with "test_development" database created in a MySQL server. Could you help me to install the content of

...sec) I've specified dict usage for quota, /etc/dovecot/dovecot.conf !include conf.d/*.conf protocols = imap lmtp dict { quota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } created the maps, /etc/dovecot/dovecot-dict-sql.conf.ext connect = host=/var/run/mysql/mysql.sock dbname=my_db user=my_user password=my_pass map { pattern = priv/quota/storage table = PARAMS username_field = MAILBOX_user_domain value_field = quota_bytes } map { pattern = priv/quota/messages table = PARAMS username_field = MAILBOX_user_domain v...

...Accessing the database from the remote machine without using R but the PostgreSQL command line client works fine. The following commands are used on the R prompt: > library(RpgSQL) > con <- dbConnect(pgSQL(), host="server.domain.org", port=5432, user="me", dbname="my_db", passowrd="secret") Selecting data is performed as a test for successful connection: > dbGetQuery(con, "SELECT * FROM my_table") For me it seems like whatever value "host" has, it is simply ignored. Has anyone of you got an idea what might be the reason for th...

...ould like to copy a data.frame of 44 columns to a table of 45 columns (the 45th is an autoincremental column). With the following commands, colnames(df)<- a vector with the names of the 44 columns ch<-odbcDriverConnect(connection="SERVER=localhost;DRIVER=MySQL ODBC 5.1 Driver;DATABASE=my_db;UID=usercount;PWD=my_pwd;case=tolower") sqlSave(ch,my_df, "my_table", append = TRUE, rownames = FALSE, fast=FALSE) odbcClose(ch) I got the following message (in french, sorry): Erreur dans dimnames(x) <- dn : la longueur de 'dimnames' [2] n'est pas ?gale ? l'?te...

Dear list, I'm working with a MySQL-Table and would like to extract selected ids that are stored in a vector: Ids <- c(1,2,3) How do I insert this variable in a for loop like this: For (a in values) { Temp <- dbGetQuery(con, "select * from db Where id = <ID>";) } My problem is to split the select-statement and insert the current id. How can I handle this problem?

...rule2 = Trash:storage=+10%% > ? ? ? ? ? ? ? ?} > > using 'username' rather than 'user' in the user iteration query > > ? ? ? ?/etc/dovecot/sql/virtmail-userdb-sql.cf > ? ? ? ? ? ? ? ?driver = mysql > ? ? ? ? ? ? ? ?connect = host=/var/run/mysql/mysql.sock dbname=my_db user=my_user > password=my_pass > ? ? ? ? ? ? ? ?user_query = CALL UserDBQuery('%n','%d'); > - ? ? ? ? ? ? ? iterate_query = SELECT `MAILBOX_user_domain` AS user FROM `PARAMS`; > + ? ? ? ? ? ? ? iterate_query = SELECT `MAILBOX_user_domain` AS username FROM `PARAMS`; >...

...nstall the postgresql adapter: `gem install activerecord- postgresql-adapter` (pg is not part of the bundle. Add it to Gemfile.) I am trying to connect to a remote postgres server with the following contents in database.yml: common: &common adapter: postgresql host: the_server database: my_db encoding: unicode pool: 5 timeout: 5000 username: me password: mypass development: <<: *common test: <<: *common production: <<: *common Which only adds the host line to what is shown in the tutorial. After confirming that the pg gem is installed I tried two t...

...>> ? ? ? ? ? ? ? ?} >> >> using 'username' rather than 'user' in the user iteration query >> >> ? ? ? ?/etc/dovecot/sql/virtmail-userdb-sql.cf >> ? ? ? ? ? ? ? ?driver = mysql >> ? ? ? ? ? ? ? ?connect = host=/var/run/mysql/mysql.sock dbname=my_db user=my_user >> password=my_pass >> ? ? ? ? ? ? ? ?user_query = CALL UserDBQuery('%n','%d'); >> - ? ? ? ? ? ? ? iterate_query = SELECT `MAILBOX_user_domain` AS user FROM `PARAMS`; >> + ? ? ? ? ? ? ? iterate_query = SELECT `MAILBOX_user_domain` AS username FRO...