[Radiant] setup_database error

jlopez at hpcf.upr.edu jlopez at hpcf.upr.edu
Thu Oct 19 15:57:22 CDT 2006 

Sorry for the spam : (

But I solved the problem. I was pointing to the wrong place to look for
the libraries.

It wasn't /usr/bin but /usr/local/mysql/bin/

Sorry for the spam again next time I'll wait a couple of days of
persistent errors before writing.

Jose.

> If I ruby extconf.rb --with-mysql-config=/usr/bin/mysql_config
> like I did before to make it work I get
>
> ruby extconf.rb --with-mysql-config=/usr/bin/mysql_config
> checking for mysql_ssl_set()... no
> checking for mysql.h... no
> checking for mysql/mysql.h... no
> *** extconf.rb failed ***
>
> It looks I'm missing some files. I've seen the mysql.h in
> /usr/local/mysql/include
>
> but haven't seen the mysql_ssl_set
>
> jose.
>
>> Hi,
>>
>> Now I'm having a similar problem with the mysql gem on a different
>> server.
>> When I /gem install mysql and choose 2 there is an error.
>>
>>> 2
>> Building native extensions.  This could take a while...
>> /usr/local/ruby/lib/ruby/1.8/fileutils.rb:243: command not found: ruby
>> extconf.rb install mysql
>> ERROR:  While executing gem ... (RuntimeError)
>>     ERROR: Failed to build gem native extension.
>> Gem files will remain installed in
>> /usr/local/ruby/lib/ruby/gems/1.8/gems/mysql-2.7 for inspection.
>>   ruby extconf.rb install mysql\n
>>
>> Results logged to
>> /usr/local/ruby/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out
>>
>> Then, when I try to reconfigure /mysql-2.7/extconf.rb
>>
>> [flmm][/usr/local/ruby/lib/ruby/gems/1.8/gems/mysql-2.7]$ ruby
>> extconf.rb
>> checking for mysql_query() in -lmysqlclient... no
>> checking for main() in -lm... yes
>> checking for mysql_query() in -lmysqlclient... no
>> checking for main() in -lz... yes
>> checking for mysql_query() in -lmysqlclient... no
>> checking for main() in -lsocket... no
>> checking for mysql_query() in -lmysqlclient... no
>> checking for main() in -lnsl... yes
>> checking for mysql_query() in -lmysqlclient... no
>> *** extconf.rb failed ***
>> Could not create Makefile due to some reason, probably lack of
>> necessary libraries and/or headers.  Check the mkmf.log file for more
>> details.  You may need configuration options.
>>
>> I know I've to use configuration options but feel totally lost again.
>>
>> Jose : (
>>
>>> Thenks Bohdi!
>>>
>>> I got Radiant installed succesfully after struggling with the mysql
>>> gem.
>>> I
>>> followed http://www.rubyforums.com/showthread.php?t=132
>>>
>>>
>>> Thanks!
>>>
>>> ......
>>>
>>>> I tried gem install mysql -- --with-mysql-include=/usr/include/mysql
>>>> --with-mysql-lib=/usr/lib/mysql
>>>>
>>>> Whis is supposed to work on Fedora 3.
>>>>
>>>> Select which gem to install for your platform (i686-linux)
>>>>  1. mysql 2.7.1 (mswin32)
>>>>  2. mysql 2.7 (ruby)
>>>>  3. mysql 2.6 (ruby)
>>>>  4. mysql 2.5.1 (ruby)
>>>>  5. Cancel installation
>>>>> 1
>>>> Successfully installed mysql-2.7.1-mswin32
>>>> Installing ri documentation for mysql-2.7.1-mswin32...
>>>> Installing RDoc documentation for mysql-2.7.1-mswin32...
>>>> While generating documentation for mysql-2.7.1-mswin32
>>>> ... MESSAGE:   Unhandled special: Special: type=17, text="<!-- $Id:
>>>> README.html,v 1.18 2006/06/04 14:39:53 tommy Exp $ -->"
>>>> ... RDOC args: --op
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/doc/mysql-2.7.1-mswin32/rdoc
>>>> --exclude ext --main README --quiet ext README
>>>> docs/README.html(continuing
>>>> with the rest of the installation)
>>>>
>>>> Now, when I -bash-3.00$ ruby script/setup_database
>>>> Run `setup_database --help` for information on additional options.
>>>>
>>>> Loading development environment...OK
>>>>
>>>> WARNING! This script will overwrite information currently stored in
>>>> thedatabase "Cybrary_dev". Are you sure you want to continue? [Yn] Y
>>>>
>>>> Creating tables...
>>>> -- drop_table("config")
>>>> -- create_table("config", {:force=>true})
>>>> FAILED
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
>>>> `log': Mysql::Error: Lostconnection to MySQL server during query:
>>>> CREATE
>>>> TABLE config (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
>>>> `key`
>>>> varchar(40) DEFAULT '' NOT NULL, `value` varchar(255) DEFAULT '')
>>>> ENGINE=InnoDB (ActiveRecord::StatementInvalid)        from
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:184:in
>>>> `execute'        from
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:104:in
>>>> `create_table'
>>>>         from
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:297:in
>>>> `create_table'        from
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:273:in
>>>> `send'
>>>>         from
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:273:in
>>>> `method_missing'
>>>>         from
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:257:in
>>>> `say_with_time'
>>>>         from
>>>> /home/cybrary/source/ruby/lib/ruby/1.8/benchmark.rb:293:in
>>>> `measure'
>>>>         from
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:257:in
>>>> `say_with_time'
>>>>          ... 6 levels...
>>>>         from script/setup_database:99:in `create_tables'
>>>>         from script/setup_database:19:in `run'
>>>>         from script/setup_database:9:in `run'
>>>>         from script/setup_database:297
>>>>
>>>> Error!!
>>>>
>>>> If I choose 2,
>>>>
>>>>> 2
>>>> Building native extensions.  This could take a while...
>>>> /home/cybrary/source/ruby/lib/ruby/1.8/fileutils.rb:243: command not
>>>> found: ruby extconf.rb install mysql --
>>>> --with-mysql-include=/usr/include/mysql
>>>> --with-mysql-lib=/usr/lib/mysql
>>>>
>>>> ERROR:  While executing gem ... (RuntimeError)
>>>>     ERROR: Failed to build gem native extension.
>>>> Gem files will remain installed in
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/mysql-2.7 for
>>>> inspection.
>>>>
>>>>
>>>> Results logged to
>>>> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out
>>>>
>>>> Doesn't even install. I've no clue.
>>>>
>>>> jose.
>>>>
>>>>> Carlos,
>>>>>
>>>>> Thanks for the info. I had already read that post elsewhere but It
>>>>> wasn't
>>>>> so detailed as the one you sent me. I'll be trying that out today on
>>>>> Fedora 3. I have a doubt though.
>>>>>
>>>>> What do the following lines mean?
>>>>>
>>>>> -- --with-mysql-include=/usr/include/mysql
>>>>> --with-mysql-lib=/usr/lib/mysql
>>>>>
>>>>> If they mean I'l be writing to that /usr/ directory It won't work
>>>>> because
>>>>> I'm on a shared host and lack root access.
>>>>>
>>>>> I feel like a total noob.
>>>>>
>>>>>
>>>>> Jose.
>>>>>
>>>>>> Jose,
>>>>>>
>>>>>> I had a similar problem a few days ago. I found out that some
>>>>>> connection problem with the database are due to the Ruby MySQL
>>>>>> bindings.
>>>>>>
>>>>>> Maybe you can get an answer for your problem here:
>>>>>> http://wiki.rubyonrails.com/rails/pages/Mysql+Connection+Problems
>>>>>>
>>>>>> - Carlos
>>>>>>
>>>>>> 2006/10/5, jlopez at hpcf.upr.edu <jlopez at hpcf.upr.edu>:
>>>>>>> Hi,
>>>>>>>
>>>>>>> In response to Bodhi.
>>>>>>>
>>>>>>> Im running mysql  Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu
>>>>>>> (i686)
>>>>>>> using readline 4.3.
>>>>>>>
>>>>>>> I viewed the file
>>>>>>> /ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor
>>>>>>> d/connection_adapters/mysql_adapter.rb but I didn't see the
>>>>>>> version.
>>>>>>>
>>>>>>> How can I get its version?
>>>>>>>
>>>>>>>
>>>>>>> I've installed Ruby 1.8.5, Gems 0.9.0, Rails 1.1.6, and Radiant
>>>>>>> 0.5.2
>>>>>>>
>>>>>>>
>>>>>>> Jose.
>>>>>>>
>>>>>>>
>>>>>>> >
>>>>>>> > On Oct 5, 2006, at 12:28 PM, jlopez at hpcf.upr.edu wrote:
>>>>>>> >
>>>>>>> >> Hi,
>>>>>>> >>
>>>>>>> >> I'm having an installation problem with Radiant.
>>>>>>> >
>>>>>>> > <snip>
>>>>>>> >
>>>>>>> >> Creating tables...
>>>>>>> >> -- drop_table("config")
>>>>>>> >> -- create_table("config", {:force=>true})
>>>>>>> >> FAILED
>>>>>>> >> /home/cybrary/source/ruby/lib/ruby/gems/1.8/gems/
>>>>>>> >> activerecord-1.14.4/lib/active_record/connection_adapters/
>>>>>>> >> abstract_adapter.rb:120:in
>>>>>>> >> `log': Mysql::Error: Lost connection to MySQL server during
>>>>>>> query:
>>>>>>> >> CREATE
>>>>>>> >> TABLE config (`id` int(11) DEFAULT NULL auto_increment PRIMARY
>>>>>>> KEY,
>>>>>>> >> `key`
>>>>>>> >> varchar(40) DEFAULT '' NOT NULL, `value` varchar(255) DEFAULT
>>>>>>> '')
>>>>>>> >> ENGINE=InnoDB (ActiveRecord::StatementInvalid)
>>>>>>> >
>>>>>>> > ^^^^^ Last line is your problem, ActiveRecord::StatementInvalid.
>>>>>>> I
>>>>>>> > think it means that the database didnt understand the command
>>>>>>> that
>>>>>>> > rails sent to it.
>>>>>>> >
>>>>>>> > Could you give us some more info about your system? What version
>>>>>>> of
>>>>>>> > mysql are you running? And what ruby-mysql adapter? I think I
>>>>>>> > remember reading that one of the ruby-mysql adapters is broken,
>>>>>>> but
>>>>>>> I
>>>>>>> > only have experience with Postgresql and SQLite.
>>>>>>> >
>>>>>>> > Bodhi
>>>>>>> > _______________________________________________
>>>>>>> > Radiant mailing list
>>>>>>> > Post:   Radiant at lists.radiantcms.org
>>>>>>> > Search: http://radiantcms.org/mailing-list/search/
>>>>>>> > Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>>>>>>> >
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Radiant mailing list
>>>>>>> Post:   Radiant at lists.radiantcms.org
>>>>>>> Search: http://radiantcms.org/mailing-list/search/
>>>>>>> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> -------------------------------------------------
>>>>>> Carlos David González Abraham
>>>>>> www.gonzalez-abraham.com.mx
>>>>>> _______________________________________________
>>>>>> Radiant mailing list
>>>>>> Post:   Radiant at lists.radiantcms.org
>>>>>> Search: http://radiantcms.org/mailing-list/search/
>>>>>> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Radiant mailing list
>>>>> Post:   Radiant at lists.radiantcms.org
>>>>> Search: http://radiantcms.org/mailing-list/search/
>>>>> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>>>>>
>>>>
>>>> _______________________________________________
>>>> Radiant mailing list
>>>> Post:   Radiant at lists.radiantcms.org
>>>> Search: http://radiantcms.org/mailing-list/search/
>>>> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>>>>
>>>
>>> _______________________________________________
>>> Radiant mailing list
>>> Post:   Radiant at lists.radiantcms.org
>>> Search: http://radiantcms.org/mailing-list/search/
>>> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>>>
>>
>> _______________________________________________
>> Radiant mailing list
>> Post:   Radiant at lists.radiantcms.org
>> Search: http://radiantcms.org/mailing-list/search/
>> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>>
>
> _______________________________________________
> Radiant mailing list
> Post:   Radiant at lists.radiantcms.org
> Search: http://radiantcms.org/mailing-list/search/
> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>

More information about the Radiant mailing list