[Radiant] setup_database error

[jlopez at hpcf.upr.edu]

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
>