similar to: Mysql stored procedures from Rails

I tried to use MySQL stored procedures from dovecot: password_query = CALL user_pass_check('%n', '%d', '%w') user_query = CALL user_info('%n', '%d') This failed with the message: User query failed: PROCEDURE imap.user_info can't return a result set in the given context The root of this problem is that mysql_real_connect() needs to be called with

Hi, I use RMySQL to connect to MySQL server where I have a couple of stored procedures. I know that the function for the stored procedures "is not yet implemented", but I was trying to get around the problem connecting like that: drv <- dbDriver("MySQL") con <- dbConnect(drv,user=MyUser, password=MyPasswd, dbname=MyDBName, host=MyHost, client.flag="196608"

Hi, I've been able to configure --with-mysql in Solaris 10 which has MySQL version 4.0.31 bundled in. Since beta4 build fails due to change in src/lib-sql/driver-mysql.c. I've never used this feature but so I don't need it. This is just a FYI if someone reads mailing list. "driver-mysql.c", line 139: undefined symbol: CLIENT_MULTI_RESULTS "driver-mysql.c",

Hi, I'm trying to install asterisk-addons-1.6.0-beta1 on my machine. But getting following error during make: [root at Cancer asterisk-addons-1.6.0-beta1]# make make[1]: Entering directory `/usr/src/asterisk/asterisk-addons-1.6.0-beta1' [CC] app_addon_sql_mysql.c -> app_addon_sql_mysql.o app_addon_sql_mysql.c: In function `aMYSQL_connect': app_addon_sql_mysql.c:266: error:

Hi, I installed the "kwatch-mysql-ruby" gem on my Debian server but when I try to run the "db:migrate" task I get the following error: ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! uninitialized constant MysqlCompat::MysqlRes

Hi (I''m resubmitting this because First question: This is the rails dev list, correct? I''d like to submit a patch and am following the steps on this page: http://dev.rubyonrails.org/ Here''s what I did (using mysql 5.0.15-nt): created 2 databases: activerecord_unittest activerecord_unittest2 created 1 user: rails (giving all priveleges to both databases) ran

Hi All. I have a question about calling MySQL stored procedures that is a little different from the usual. I know stored procedures are not really the ''Rails way'' but in this case there is no other way to accomplish the same task and I have used them successfully. Background: I am using a query to produce a real-time status of items flowing through a factory. The query

Not sure if this is off topic, but there doesn''t seem to be an obvious place to ask this question. I am trying to use MacPorts to install mysql. I have xcode 3.0 and x11 XQuartz 2.1.6 installed. $PATH: /opt/local/bin:/opt/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/ local/bin:/usr/X11/bi When I sudo port install mysql5-server I receive: ---> Configuring mysql5 Error: Target

I have a recipe that I''m ensuring that I remove rpms that may be installed by CentOS/RHEL before I install the MySQL.com rpms. the recipe and logs are listed below. For testing I have mysql-* rpms already installed. Is there a method to force specific order to run the recipe? What am I doing wrong? # install mysql rpms (not CentOS/RHEL vesions) # PROCESS: # - removes any CentOS/RHEL

Hi, I''m trying to set up Ruby on Rails following Apple''s tutorial with ruby 1.8.4 and mysql 5.0.22. But every time I ran ''rake migrate'' I got the following access denied error: Access denied for user ''root''@''localhost'' (using password: YES) After turning on --trace switch, it showed the error happened at the following

error information occurred when I execute "rails new demo1 -- database=mysql" MY environment below: Mac OS 10.4.11, Ruby 1.8.7 Rails 3.2.1, Gem 1.8.15 mysql5 Ver 14.14 Distrib 5.1.61, for apple-darwin8.11.1 (i386) using readline 6.2 mysql (2.8.1) Please help me, thx! more detail message as follows: Installing mysql2 (0.3.11) with native extensions

Hi, When I try to install "gem install mysql" it throwing error. For your ref, bash-2.05b$ gem install mysql -- --with-mysql-dir=/opt/etrade/p6/share/mysql5 ERROR: http://gems.rubyforge.org/ does not appear to be a repository ERROR: could not find gem mysql locally or in a repository bash-2.05b$ gem install mysql -- --with-mysql-config=/opt/etrade/p6/share/mysql5/bin/mysql_config

Hi, with mysql.rb removed from rails 2.2 I need to install the mysql gem I have mac osx 10.5.5 I have mysql installed in /usr/local/mysql, so, after a bunch of try, I''ve installed the gem with: env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql-config=/ usr/local/mysql/bin/mysql_config the gem seems installed in /usr/local/lib/ruby/gems/1.8/gems/ mysql-2.7/ but

I have a view where I render a partial over a collection. Each instance of the partial includes a <div> with an id specific to that instance. Inside the partial, there is a select tag for "year". I''m trying to change some of the contents of the partial when user changes the year. I''m using this in the view: <%= select_tag :year,

Ok, maybe its a short walk, not a drive... I have it working just fine using smtp in development env from my OSX machine. When I deploy it to the server (which happens to be the same box where the smtp server lives), no email, no errors, nothing in the Postfix logs. I''ve double checked that my production and development action mailer settings are identical. Here''s whats in the

Are there any gotchas with doing a MySQL5 upgrade from the centosplus repostitory? Can this be done as an update via yum or do I need to uninstall and the install? There wasn't anything on this in the readme.txt file. Thanks, John Hinton

So I''m wondering about the origin of "ActiveRecord" and "ActionPack" and the like in Rails. I''ve always thought that perhaps DHH found himself in a suit one day (maybe he had to attend a friend''s wedding or something), and as long as he had the suit on, decided to lapse into a one of the barely lucid frenzies that Marketing people are prone to when

Hi All, Could anyone tell me, how to correctly install MySQL4.1 on Centos 5 ? By default Centos 5 comes with mysql5? If I will compile mysql4 from sources to separate prefix, some features may be unavailable (unix sockets for example). I?m moving some critical application (online booking) based on java, tomcat5, mysql4.1 from old server fedora 4 to new server running Centos 5. So, I don?t

This is my first rails app with a legacy database and I''m having a terrible time getting the models set up correctly. I have an order table that has a primary field named order_number. I have a name table with a primary of item_number. These two tables are liked by the item_number and the order_number, but not as you might think. If the order_number is 2500, then each entry in

Greetings, I am trying to get MySQL to run with Rails, but when I try to get it to run using "rails dbconsole" I get this error: C:\IS410\Programs\sqltest3>rails dbconsole Couldn''t find database client: mysql, mysql5, mysql.exe, mysql5.exe. Check your $PATH and try again. I have MySQL installed, along with the MySQL driver. I read alot of posts in forums saying it might