Activereport and mysql problems "columns"

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. On a windows server 2003, installed rubycas-server and other 
dependencies, use the command rubycas-server after editing the config.yml

What version of RubyCAS-Server are you using? How is it installed (rubygem,
manual install)? How are you running it (webrick, mongrel, passenger,
etc.)?
RubyCas-server 0.7.1 installed with rubygem.
Running on webrick

If relevant, please paste your RubyCAS-Server config.yml file here.

server: webrick
port: 443
ssl_cert: C:\Documents and Settings\Administrator\Desktop\rubycas-server-
demo.pem

database:
  adapter: mysql
  database: casserver2
  username: ***********
  password: ***********
  host: localhost

authenticator: 
  class: CASServer::Authenticators::ActiveDirectoryLDAP
  ldap:
    host: test.com
    port: 389
    base: dc=test,dc=com
    filter: (objectClass=person)
    auth_user: **********
    auth_password: **********

theme: simple

organization: CAS

infoline: Powered by <a href="http://code.google.com/p/rubycas-
server/">RubyCAS-Server</a>

log:
  file: /var/log/casserver.log
  level: INFO

Please provide any additional information below.

Here is the error message :

C:\Documents and Settings\Administrator\Desktop>rubycas-server -c 
C:\ruby\lib\ru
by\gems\1.8\gems\rubycas-server-0.7.1\config.yml
Using config file C:\ruby\lib\ruby\gems\1.8\gems\rubycas-server-0.7.1
\config.yml

Adding Picnic functionality to CASServer from 
c:/ruby/lib/ruby/gems/1.8/gems/pic
nic-0.7.0/lib...
Loading configuration for CASServer from 'C:\ruby\lib\ruby\gems\1.8
\gems\rubycas
-server-0.7.1\config.yml'...
Initializing CASServer logger...
WARNING: Couldn't create Logger with output '/var/log/casserver.log'. 
Logger out
put will be redirected to STDOUT.

Starting with configuration: --- !map:HashWithIndifferentAccess
ticket_granting_ticket_expiry: 172800
expire_sessions: false
proxy_granting_ticket_expiry: 172800
authenticator: !map:HashWithIndifferentAccess
  ldap: !map:HashWithIndifferentAccess
    auth_user: Administrator
    port: 389
    filter: (objectClass=person)
    auth_password: test123*
    host: clarodns.com
    base: dc=clarodns,dc=com
  class: CASServer::Authenticators::ActiveDirectoryLDAP
ssl_cert: C:\Documents and Settings\Administrator\Desktop\rubycas-server-
demo.pe
m
infoline: Powered by <a href="http://code.google.com/p/rubycas-
server/">RubyCAS-
Server</a>
theme: simple
log: !map:HashWithIndifferentAccess
  level: INFO
  file: /var/log/casserver.log
public_dir: !map:HashWithIndifferentAccess
  dir: c:/ruby/lib/ruby/gems/1.8/gems/rubycas-server-0.7.1/lib/themes
  path: /themes
login_ticket_expiry: 300
port: 443
service_ticket_expiry: 300
uri_path: /
server: webrick
organization: CAS
database: !map:HashWithIndifferentAccess
  username: root
  adapter: mysql
  host: localhost
  password:
  database: casserver2

[2009-03-24 18:44:33] INFO  WEBrick 1.3.1
[2009-03-24 18:44:33] INFO  ruby 1.8.6 (2007-09-24) [i386-mswin32]
[2009-03-24 18:44:33] INFO
Certificate:
    Data:
        Version: 3 (0x2)
        Serial Number:
            cb:51:d1:1a:27:07:80:8a
        Signature Algorithm: sha1WithRSAEncryption
        Issuer: C=CA, ST=ON, L=Toronto, O=RubyCAS-Server, 
CN=fortestingonly.test
/emailAddress=matt@roughest.net
        Validity
            Not Before: Jun  5 21:17:50 2007 GMT
            Not After : Jun  4 21:17:50 2008 GMT
        Subject: C=CA, ST=ON, L=Toronto, O=RubyCAS-Server, 
CN=fortestingonly.tes
t/emailAddress=matt@roughest.net
        Subject Public Key Info:
            Public Key Algorithm: rsaEncryption
            RSA Public Key: (1024 bit)
                Modulus (1024 bit):
                    00:99:8b:71:e7:55:4d:6a:60:cd:2f:83:e6:43:8a:
                    7c:3b:d8:6e:61:4d:67:4e:a3:90:90:4f:59:0d:26:
                    74:14:17:9a:2e:47:a5:08:b7:fd:8f:e1:72:a7:99:
                    f5:e8:37:50:dc:c8:a6:89:d3:2b:df:5a:55:76:04:
                    03:d4:66:2d:ed:60:45:93:b8:7d:c9:37:af:46:41:
                    67:0f:98:8a:a0:29:b4:09:b9:71:09:fe:e0:99:d7:
                    12:a8:14:1c:09:77:fc:5e:17:e1:0f:ec:f2:4f:e5:
                    64:0e:be:89:f8:af:5e:29:7a:af:06:06:97:3c:21:
                    c9:e4:0e:47:28:d8:f9:da:13
                Exponent: 65537 (0x10001)
        X509v3 extensions:
            X509v3 Subject Key Identifier:
                F9:D4:99:2B:53:FE:00:E9:52:9B:26:BF:5F:BD:C1:F8:BD:C1:F3:C9
            X509v3 Authority Key Identifier:

keyid:F9:D4:99:2B:53:FE:00:E9:52:9B:26:BF:5F:BD:C1:F8:BD:C1:F3:C
9
                DirName:/C=CA/ST=ON/L=Toronto/O=RubyCAS-
Server/CN=fortestingonly
.test/emailAddress=matt@roughest.net
                serial:CB:51:D1:1A:27:07:80:8A

            X509v3 Basic Constraints:
                CA:TRUE
    Signature Algorithm: sha1WithRSAEncryption
        72:f8:2e:06:35:47:82:99:15:cb:3c:e4:0d:00:33:93:56:01:
        25:5b:14:05:af:9f:47:ae:65:1a:ed:70:59:c0:1b:c8:5b:aa:
        fa:89:e1:d5:c1:8f:0f:db:69:e8:f8:fc:7d:86:62:96:4d:9e:
        8c:92:8a:9a:ae:02:bb:c2:2f:15:a1:c4:f1:6f:ef:f4:d8:30:
        58:3a:16:ef:24:dd:58:e1:10:9a:85:72:38:bf:23:63:2c:48:
        d2:9a:cf:12:64:eb:26:82:25:ba:ea:70:21:88:22:75:a3:75:
        ae:13:5f:9b:be:34:ac:f6:fe:af:c4:0f:77:6b:ad:e7:1c:55:
        15:78
I, [2009-03-24T18:44:33.956000 #2524]  INFO -- : Creating RubyCAS-Server...
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-
2.3.2/lib/active_record/connection_a
dapters/mysql_adapter.rb:467:in `columns': undefined method `each' for 
#<Mysql:0
x361a5b4> (NoMethodError)
        from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-
2.3.2/lib/active_record
/base.rb:1276:in `columns'
        from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-
2.3.2/lib/active_record
/base.rb:3008:in `attributes_from_column_definition_without_lock'
        from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-
2.3.2/lib/active_record
/locking/optimistic.rb:66:in `attributes_from_column_definition'
        from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-
2.3.2/lib/active_record
/base.rb:2435:in `initialize'
        from (eval):30:in `new'
        from (eval):30:in `create_schema'
        from c:/ruby/lib/ruby/gems/1.8/gems/rubycas-server-
0.7.1/lib/casserver.r
b:105:in `create'
        from c:/ruby/lib/ruby/gems/1.8/gems/picnic-
0.7.0/lib/picnic/postambles.r
b:74:in `webrick'
         ... 8 levels...
        from c:/ruby/lib/ruby/gems/1.8/gems/picnic-
0.7.0/lib/picnic/cli.rb:117:i
n `handle_cli_input'
        from c:/ruby/lib/ruby/gems/1.8/gems/rubycas-server-
0.7.1/bin/rubycas-ser
ver:26
        from c:/ruby/bin/rubycas-server:19:in `load'
        from c:/ruby/bin/rubycas-server:19

Original issue reported on code.google.com by rousseau...@gmail.com on 24 Mar 2009 at 6:22

GoogleCodeExporter commented 9 years ago

I wonder if this has something to do with ActiveRecord 2.3. Can you try:

gem uninstall activerecord
 (then select 2.3.2 to uninstall it, if the option comes up)
gem install activerecord VERSION=2.2.2

And then try running rubycas-server again.

Original comment by matt.zuk...@gmail.com on 27 Mar 2009 at 6:34

Added labels: Component-Persistence, Type-Defect

GoogleCodeExporter commented 9 years ago

Hi,

Thanks for the answer, but unfortunatly the problem is still the same.

Original comment by rousseau...@gmail.com on 30 Mar 2009 at 7:23

GoogleCodeExporter commented 9 years ago

I'm afraid then that it might be something specific to your system (your Ruby or
ActiveRecord installation). I can't reproduce the problem on my side, and it 
seems to
be working fine for most others.

Original comment by matt.zuk...@gmail.com on 30 Mar 2009 at 8:24

GoogleCodeExporter commented 9 years ago

Hi,

Is it possible to receive a simple 'walkthrough' about the installation of 
RubyCas 
Server on windows, with the versionning of the different components ?
Yesterday i tested with some other version of activerecord//support but still 
the 
same error.
I've also try with an installation of mysql by 'xampp' and a stand alone 
installation.

All my test are made on a Virtual Machine, is it possible that the problem come 
from 
there ? (I dont think but maybe you already read something about it)

Anyway, thanks a lot ;)

Original comment by rousseau...@gmail.com on 31 Mar 2009 at 6:53

GoogleCodeExporter commented 9 years ago

I've installed RubyCAS server on my Windows machine recently and didn't run 
into any
issues... just make sure you use the Github version of the rubycas-server and 
picnic
gems (gunark-rubycas-server and zuk-picnic). Once you install the gems, you 
should be
able to run the server from the directory where the gem is installed (I can't
rememember the path off hand -- I'm on my linux machine at work right now):

ruby bin\rubycas-server

Original comment by matt.zuk...@gmail.com on 6 May 2009 at 1:17

GoogleCodeExporter commented 9 years ago

I encountered the same problem. I was using MySQL 5.1. The ActiveRecord gem 
shipped
with rails 2.3 doesn't work with MySQL client library(libmysql.dll) shipped with
MySQL 5.1. I had to copy an older version of the library (from MySQL 5.0
distribution) to ruby\bin. Now my CASServer runs without any issues.
This particular issue is discussed here: http://www.ruby-forum.com/topic/172158

Original comment by clara.an...@gmail.com on 17 Jun 2009 at 1:25

GoogleCodeExporter commented 9 years ago

Thank you very much, i'll try it as soon as possible.

Original comment by rousseau...@gmail.com on 17 Jun 2009 at 7:58

GoogleCodeExporter commented 9 years ago

I finally found the time to try this solution (on holidays ^^) and it works. 
But now 
it's an other problems. When i try to access to https://localhost/cas, i 
correctly 
see the certificat but after that, the page is not found. Do you have an idea ?

Original comment by rousseau...@gmail.com on 16 Jul 2009 at 8:39

GoogleCodeExporter commented 9 years ago

In reading again the 'quickstart' i see:
--------------------------------------------------------------------------------
---- 
4.Run /usr/bin/rubycas-server (try /usr/bin/rubycas-server -h for a list of 
command-
line options). 
You should now be up and running. The server's output should show you the URL 
where 
you can access the CAS login page. 
--------------------------------------------------------------------------------
----

But the server's output dont show me the url.
In the attach file, the result of server's lauching.

Thanks for the help

Original comment by rousseau...@gmail.com on 16 Jul 2009 at 9:09

Attachments:

rubycas-server-result.txt

GoogleCodeExporter commented 9 years ago

So basically this sounds like an upstream issue. As clara.ann.yih suggests, a 
number
of workarounds are discussed here: http://www.ruby-forum.com/topic/172158

Original comment by matt.zuk...@gmail.com on 30 Sep 2009 at 8:51

Changed state: Invalid

safaacar / rubycas-server

Activereport and mysql problems "columns" #70