Error when creating a railo datasource in a local environment
26 views
Skip to first unread message
Jeremy
Nov 24, 2009, 2:19:58 PM11/24/09
to Railo
I'm running railo locally on top of tomcat.
but when I try to add a datasource in the admin:
http://localhost:8080/railo-context/admin/web.cfm
I keep getting this error:
: input contained no data
Any ideas? This shouldn't be that hard. When I deploy the environment
to a production server, I can add a datasource simple as pie.
But because my production environment is a cloud environment, the
version that I deploy to production is replicated across servers. So,
I need to create the datasource locally and then push to production.
Thx.
but when I try to add a datasource in the admin:
http://localhost:8080/railo-context/admin/web.cfm
I keep getting this error:
: input contained no data
Any ideas? This shouldn't be that hard. When I deploy the environment
to a production server, I can add a datasource simple as pie.
But because my production environment is a cloud environment, the
version that I deploy to production is replicated across servers. So,
I need to create the datasource locally and then push to production.
Thx.
Todd Rafferty
Nov 24, 2009, 2:25:08 PM11/24/09
to ra...@googlegroups.com
You need to give us more information. I just created a mysql dsn with no issues on my own local tomcat/railo install.
~Todd Rafferty ** Volunteer Railo Open Source Community Manager ** http://getrailo.org/
~Todd Rafferty ** Volunteer Railo Open Source Community Manager ** http://getrailo.org/
Jeremy
Nov 24, 2009, 4:00:02 PM11/24/09
to Railo
I wish I could give you more info. Couldn't create a datasource so i
manually updated WEB-INF/railo/railo-web.xml.cfm and added a node for
the new datasource and restarted tomcat. that worked. but now when i
verify the datasource, it fails...
locally, it fails.
when i push the whole environment to a production server, it works...
On Nov 24, 12:25 pm, Todd Rafferty <t...@getrailo.org> wrote:
> You need to give us more information. I just created a mysql dsn with no
> issues on my own local tomcat/railo install.
>
> ~Todd Rafferty ** Volunteer Railo Open Source Community Manager **http://getrailo.org/
manually updated WEB-INF/railo/railo-web.xml.cfm and added a node for
the new datasource and restarted tomcat. that worked. but now when i
verify the datasource, it fails...
locally, it fails.
when i push the whole environment to a production server, it works...
On Nov 24, 12:25 pm, Todd Rafferty <t...@getrailo.org> wrote:
> You need to give us more information. I just created a mysql dsn with no
> issues on my own local tomcat/railo install.
>
Todd
Nov 24, 2009, 4:34:34 PM11/24/09
to ra...@googlegroups.com
Manually modifying the web.xml.cfm probably isn't recommended. There
is a cfadmin tag that will safely do all this for you and restart
railo without the need to restart tomcat.
Let me find Gert's cfadmin tag documentation for you.
http://www.getrailo.org/index.cfm/documentation/cfadmin-doc/
> --
>
> You received this message because you are subscribed to the Google
> Groups "Railo" group.
> To post to this group, send email to ra...@googlegroups.com.
> To unsubscribe from this group, send email to railo+un...@googlegroups.com
> .
> For more options, visit this group at http://groups.google.com/group/railo?hl=en
> .
>
>
is a cfadmin tag that will safely do all this for you and restart
railo without the need to restart tomcat.
Let me find Gert's cfadmin tag documentation for you.
http://www.getrailo.org/index.cfm/documentation/cfadmin-doc/
>
> You received this message because you are subscribed to the Google
> Groups "Railo" group.
> To post to this group, send email to ra...@googlegroups.com.
> To unsubscribe from this group, send email to railo+un...@googlegroups.com
> .
> For more options, visit this group at http://groups.google.com/group/railo?hl=en
> .
>
>
Jeremy
Nov 24, 2009, 4:36:14 PM11/24/09
to Railo
Here's what gets written to WEB-INF/railo/logs/application.log every
time i try to create a datasource:
"Severity","ThreadID","Date","Time","Application","Message"
"ERROR","web-0","11/24/2009","19:50",""," : input contained no data"
"ERROR","web-0","11/24/2009","19:50",""," : input contained no data"
time i try to create a datasource:
"Severity","ThreadID","Date","Time","Application","Message"
"ERROR","web-0","11/24/2009","19:50",""," : input contained no data"
"ERROR","web-0","11/24/2009","19:50",""," : input contained no data"
Michael Offner-Streit
Nov 24, 2009, 5:01:16 PM11/24/09
to ra...@googlegroups.com
Hi Jeremy
First this message is not throwed by Railo, in other words it is throwed
by the datasource.
when it works in the public enviroment but not in your local, the
enviroment is the problem.
what you can do, use the "other - jdbc driver" to have full control and
not interpreation by railo.
first go to your public env in detail view of your datasource, at top
you find something like this:
Class: org.gjt.mm.mysql.Driver
DNS:
jdbc:mysql://railo.ch:3306/railo?useUnicode=true&autoReconnect=false&CharacterEncoding=UTF8&allowMultiQueries=true
this is the connection string (DNS) and the class defintion (Class)
created by the driver, copy this 2 lines and swich back to your local env.
create new datasource "Other - JDBC Driver".
fill the class and dns in the corespondenting form field and define
username and password.
save it.
when it fails (it will) with the same failure, send the dns definition
to the list.
pherhaps we see a seeting you made that produce the problem
/micha
Jeremy schrieb:
Michael Offner-Streit
CTO
Railo Technologies GmbH
michael...@railo.ch
www.getrailo.com
Mailing List (english): http://groups.yahoo.com/group/railo_talk/
Mailing List (german): http://de.groups.yahoo.com/group/railo/
Linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1
Issue Tracker: http://jira.jboss.org/jira/browse/RAILO
Blog: http://www.railo-technologies.com/blog
First this message is not throwed by Railo, in other words it is throwed
by the datasource.
when it works in the public enviroment but not in your local, the
enviroment is the problem.
what you can do, use the "other - jdbc driver" to have full control and
not interpreation by railo.
first go to your public env in detail view of your datasource, at top
you find something like this:
Class: org.gjt.mm.mysql.Driver
DNS:
jdbc:mysql://railo.ch:3306/railo?useUnicode=true&autoReconnect=false&CharacterEncoding=UTF8&allowMultiQueries=true
this is the connection string (DNS) and the class defintion (Class)
created by the driver, copy this 2 lines and swich back to your local env.
create new datasource "Other - JDBC Driver".
fill the class and dns in the corespondenting form field and define
username and password.
save it.
when it fails (it will) with the same failure, send the dns definition
to the list.
pherhaps we see a seeting you made that produce the problem
/micha
Jeremy schrieb:
> --
>
> You received this message because you are subscribed to the Google Groups "Railo" group.
> To post to this group, send email to ra...@googlegroups.com.
> To unsubscribe from this group, send email to railo+un...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/railo?hl=en.
>
>
>
>
--
>
> You received this message because you are subscribed to the Google Groups "Railo" group.
> To post to this group, send email to ra...@googlegroups.com.
> To unsubscribe from this group, send email to railo+un...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/railo?hl=en.
>
>
>
>
Michael Offner-Streit
CTO
Railo Technologies GmbH
michael...@railo.ch
www.getrailo.com
Mailing List (english): http://groups.yahoo.com/group/railo_talk/
Mailing List (german): http://de.groups.yahoo.com/group/railo/
Linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1
Issue Tracker: http://jira.jboss.org/jira/browse/RAILO
Blog: http://www.railo-technologies.com/blog
Jeremy
Nov 24, 2009, 5:04:34 PM11/24/09
to Railo
Thanks for your help. I did find that on the web:
http://www.getrailo.org/index.cfm/documentation/cfadmin-doc/
However, I didn't see an action for "createDatasource". I did see an
"updateDatasource". but, i had no idea what values to provide for each
variable. for example, custom="#custom#". um, ok.
so anyhow, i found a tomcat/railo deployment that i configured locally
a couple of months ago. at that time i could add a datasource just
fine. so i took a peek at the WEB-INF/railo/railo-web.xml.cfm and
copied the datasource node and pasted it into my new tomcat/railo
project (with some minor modifications). that did the trick. now my
new project had a datasource BUT when i tried to verify it...it
failed...
the funny thing is, the tomcat/railo deployment that i set up a couple
of months ago worked just fine THEN. but it too doesn't work anymore.
i can't create a new datasource and i can't "verify" the existing
one.
i have no idea what changed. maybe my windows vista did an automatic
update and killed something. i really don't know.
jeremy
http://www.getrailo.org/index.cfm/documentation/cfadmin-doc/
However, I didn't see an action for "createDatasource". I did see an
"updateDatasource". but, i had no idea what values to provide for each
variable. for example, custom="#custom#". um, ok.
so anyhow, i found a tomcat/railo deployment that i configured locally
a couple of months ago. at that time i could add a datasource just
fine. so i took a peek at the WEB-INF/railo/railo-web.xml.cfm and
copied the datasource node and pasted it into my new tomcat/railo
project (with some minor modifications). that did the trick. now my
new project had a datasource BUT when i tried to verify it...it
failed...
the funny thing is, the tomcat/railo deployment that i set up a couple
of months ago worked just fine THEN. but it too doesn't work anymore.
i can't create a new datasource and i can't "verify" the existing
one.
i have no idea what changed. maybe my windows vista did an automatic
update and killed something. i really don't know.
jeremy
Jeremy
Nov 24, 2009, 5:06:05 PM11/24/09
to Railo
When you "verify a datasource" in the web administrator and it fails,
is there a way to get some information about why it failed? I just see
"Error"
is there a way to get some information about why it failed? I just see
"Error"
Michael Offner-Streit
Nov 24, 2009, 5:10:24 PM11/24/09
to ra...@googlegroups.com
onMouseOver you see the error message
/micha
Jeremy schrieb:
/micha
Jeremy schrieb:
-- You received this message because you are subscribed to the Google Groups "Railo" group. To post to this group, send email to ra...@googlegroups.com. To unsubscribe from this group, send email to railo+un...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/railo?hl=en.
Jeremy
Nov 24, 2009, 5:21:11 PM11/24/09
to Railo
Michael, I don't see anything like this:
**********
first go to your public env in detail view of your datasource, at top
you find something like this:
Class: org.gjt.mm.mysql.Driver
DNS:
jdbc:mysql://railo.ch:3306/railo?
useUnicode=true&autoReconnect=false&CharacterEncoding=UTF8&allowMultiQueries=true
***********
but, i can guess that this is what i got:
Class: org.gjt.mm.mysql.Driver
DNS: jdbc:mysql://ec2-174-129-9-255.compute-1.amazonaws.com:3306/
fd_logh_db?
zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true&CharacterEncoding=UTF8
based on this manual entry i put into WEB-INF/railo/railo-web.xml.cfm
<data-source allow="511" blob="false" class="org.gjt.mm.mysql.Driver"
clob="false" connectionTimeout="1"
custom="zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true&CharacterEncoding=UTF8"
database="fd_logh_db" dsn="jdbc:mysql://{host}:{port}/{database}"
host="ec2-174-129-9-255.compute-1.amazonaws.com" name="fd_logh_db"
password="XXXXXX" port="3306" username="fd_logh_db"/>
On Nov 24, 3:01 pm, Michael Offner-Streit <michael.off...@railo.ch>
wrote:
> > For more options, visit this group athttp://groups.google.com/group/railo?hl=en.
**********
first go to your public env in detail view of your datasource, at top
you find something like this:
Class: org.gjt.mm.mysql.Driver
DNS:
jdbc:mysql://railo.ch:3306/railo?
useUnicode=true&autoReconnect=false&CharacterEncoding=UTF8&allowMultiQueries=true
but, i can guess that this is what i got:
Class: org.gjt.mm.mysql.Driver
DNS: jdbc:mysql://ec2-174-129-9-255.compute-1.amazonaws.com:3306/
fd_logh_db?
zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true&CharacterEncoding=UTF8
based on this manual entry i put into WEB-INF/railo/railo-web.xml.cfm
<data-source allow="511" blob="false" class="org.gjt.mm.mysql.Driver"
clob="false" connectionTimeout="1"
custom="zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true&CharacterEncoding=UTF8"
database="fd_logh_db" dsn="jdbc:mysql://{host}:{port}/{database}"
host="ec2-174-129-9-255.compute-1.amazonaws.com" name="fd_logh_db"
password="XXXXXX" port="3306" username="fd_logh_db"/>
On Nov 24, 3:01 pm, Michael Offner-Streit <michael.off...@railo.ch>
wrote:
>
> --
> Michael Offner-Streit
> CTO
> Railo Technologies GmbH
> michael.off...@railo.chwww.getrailo.com
> --
> Michael Offner-Streit
> CTO
> Railo Technologies GmbH
Jeremy
Nov 24, 2009, 5:27:52 PM11/24/09
to Railo
same error:
: input contained no data
when i create in my local environment - "Other - JDBC Driver".
using
Class: org.gjt.mm.mysql.Driver
DNS: jdbc:mysql://ec2-174-129-9-255.compute-1.amazonaws.com:3306/
fd_logh_db?
zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true&CharacterEncoding=UTF8
and the username / password
> > For more options, visit this group athttp://groups.google.com/group/railo?hl=en.
: input contained no data
when i create in my local environment - "Other - JDBC Driver".
using
Class: org.gjt.mm.mysql.Driver
DNS: jdbc:mysql://ec2-174-129-9-255.compute-1.amazonaws.com:3306/
fd_logh_db?
zeroDateTimeBehavior=convertToNull&useOldAliasMetadataBehavior=true&CharacterEncoding=UTF8
and the username / password
>
> --
> Michael Offner-Streit
> CTO
> Railo Technologies GmbH
> michael.off...@railo.chwww.getrailo.com
> --
> Michael Offner-Streit
> CTO
> Railo Technologies GmbH
Jeremy
Nov 24, 2009, 5:54:37 PM11/24/09
to Railo
environment settings (not sure if this tells you anything or not):
Production environment:
Version Railo 3.1.1.000 final
Version Name Barry
Release date Aug 12, 2009
ColdFusion® compatibilty version 8.0.0.1
OS Linux (2.6.21.7-2.fc8xen-ec2-v1.0)
Installed tag
libraries - Railo Core Tag Library
Installed function
libraries - Railo Core Function Library
Railo date/time Nov 24, 2009 10:50 PM
Server date/time: Nov 24, 2009 10:50 PM
Java 1.6.0_12 (Sun Microsystems Inc.)
Memory 254mb
Classpath
/usr/lib/snazcat/lib/appserver.jar
Local environment:
Version Railo 3.1.1.000 final
Version Name Barry
Release date Aug 12, 2009
ColdFusion® compatibilty version 8.0.0.1
OS Windows Vista (6.0)
Installed tag
libraries - Railo Core Tag Library
Installed function
libraries - Railo Core Function Library
Railo date/time Nov 24, 2009 10:51 PM
Server date/time: Nov 24, 2009 10:52 PM
Java 1.6.0_13 (Sun Microsystems Inc.)
Memory 254mb
Classpath
C:\Stax\stax-sdk-0.3.6\groovy\lib\groovy-1.6.0.jar
Production environment:
Version Railo 3.1.1.000 final
Version Name Barry
Release date Aug 12, 2009
ColdFusion® compatibilty version 8.0.0.1
OS Linux (2.6.21.7-2.fc8xen-ec2-v1.0)
Installed tag
libraries - Railo Core Tag Library
Installed function
libraries - Railo Core Function Library
Railo date/time Nov 24, 2009 10:50 PM
Server date/time: Nov 24, 2009 10:50 PM
Java 1.6.0_12 (Sun Microsystems Inc.)
Memory 254mb
Classpath
/usr/lib/snazcat/lib/appserver.jar
Local environment:
Version Railo 3.1.1.000 final
Version Name Barry
Release date Aug 12, 2009
ColdFusion® compatibilty version 8.0.0.1
OS Windows Vista (6.0)
Installed tag
libraries - Railo Core Tag Library
Installed function
libraries - Railo Core Function Library
Railo date/time Nov 24, 2009 10:51 PM
Server date/time: Nov 24, 2009 10:52 PM
Java 1.6.0_13 (Sun Microsystems Inc.)
Memory 254mb
Classpath
C:\Stax\stax-sdk-0.3.6\groovy\lib\groovy-1.6.0.jar
Jeremy
Nov 25, 2009, 10:50:42 AM11/25/09
to Railo
any ideas?
Chris Pfeffer
Nov 25, 2009, 10:52:37 AM11/25/09
to ra...@googlegroups.com
Is your MySQL server on you local box?
Jeremy
Nov 25, 2009, 11:32:45 AM11/25/09
to Railo
nope, it's on a remote server. and i can get to it using mysql
administrator just fine.
it's here: ec2-174-129-9-255.compute-1.amazonaws.com
On Nov 25, 8:52 am, Chris Pfeffer <hockeyp...@gmail.com> wrote:
> Is your MySQL server on you local box?
>
> > railo+un...@googlegroups.com <railo%2Bunsu...@googlegroups.com>.
administrator just fine.
it's here: ec2-174-129-9-255.compute-1.amazonaws.com
On Nov 25, 8:52 am, Chris Pfeffer <hockeyp...@gmail.com> wrote:
> Is your MySQL server on you local box?
>
> > > > > > For more options, visit this group athttp://
> > groups.google.com/group/railo?hl=en.
>
> > > > > --
> > > > > Michael Offner-Streit
> > > > > CTO
> > > > > Railo Technologies GmbH
> > > > > michael.off...@railo.chwww.getrailo.com
>
> > > > > Mailing List (english):http://groups.yahoo.com/group/railo_talk/
> > > > > Mailing List (german):http://de.groups.yahoo.com/group/railo/
> > > > > Linked in:http://www.linkedin.com/e/gis/71368/0CF7D323BBC1
> > > > > Issue Tracker:http://jira.jboss.org/jira/browse/RAILO
> > > > > Blog:http://www.railo-technologies.com/blog
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "Railo" group.
> > To post to this group, send email to ra...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > railo+un...@googlegroups.com <railo%2Bunsu...@googlegroups.com>.
> > groups.google.com/group/railo?hl=en.
>
> > > > > --
> > > > > Michael Offner-Streit
> > > > > CTO
> > > > > Railo Technologies GmbH
> > > > > michael.off...@railo.chwww.getrailo.com
>
> > > > > Mailing List (english):http://groups.yahoo.com/group/railo_talk/
> > > > > Mailing List (german):http://de.groups.yahoo.com/group/railo/
> > > > > Linked in:http://www.linkedin.com/e/gis/71368/0CF7D323BBC1
> > > > > Issue Tracker:http://jira.jboss.org/jira/browse/RAILO
> > > > > Blog:http://www.railo-technologies.com/blog
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "Railo" group.
> > To post to this group, send email to ra...@googlegroups.com.
> > To unsubscribe from this group, send email to
Chris Pfeffer
Nov 25, 2009, 11:39:47 AM11/25/09
to ra...@googlegroups.com
Have you tried the railo express version?
To unsubscribe from this group, send email to railo+un...@googlegroups.com.
Jeremy
Nov 25, 2009, 11:55:35 AM11/25/09
to Railo
is railo express tomcat/java/railo?
On Nov 25, 9:39 am, Chris Pfeffer <hockeyp...@gmail.com> wrote:
> Have you tried the railo express version?
>
> > railo%2Bunsu...@googlegroups.com<railo%252Buns...@googlegroups.com>
On Nov 25, 9:39 am, Chris Pfeffer <hockeyp...@gmail.com> wrote:
> Have you tried the railo express version?
>
> > >.
> > > > > > > > For more options, visit this group athttp://
> > > > groups.google.com/group/railo?hl=en.
>
> > > > > > > --
> > > > > > > Michael Offner-Streit
> > > > > > > CTO
> > > > > > > Railo Technologies GmbH
> > > > > > > michael.off...@railo.chwww.getrailo.com
>
> > > > > > > Mailing List (english):http://groups.yahoo.com/group/railo_talk/
> > > > > > > Mailing List (german):http://de.groups.yahoo.com/group/railo/
> > > > > > > Linked in:http://www.linkedin.com/e/gis/71368/0CF7D323BBC1
> > > > > > > Issue Tracker:http://jira.jboss.org/jira/browse/RAILO
> > > > > > > Blog:http://www.railo-technologies.com/blog
>
> > > > --
>
> > > > You received this message because you are subscribed to the Google
> > Groups
> > > > "Railo" group.
> > > > To post to this group, send email to ra...@googlegroups.com.
> > > > To unsubscribe from this group, send email to
> > > > railo+un...@googlegroups.com<railo%2Bunsu...@googlegroups.com><
> > railo%2Bunsu...@googlegroups.com<railo%252Buns...@googlegroups.com>
> > > > > > > > For more options, visit this group athttp://
> > > > groups.google.com/group/railo?hl=en.
>
> > > > > > > --
> > > > > > > Michael Offner-Streit
> > > > > > > CTO
> > > > > > > Railo Technologies GmbH
> > > > > > > michael.off...@railo.chwww.getrailo.com
>
> > > > > > > Mailing List (english):http://groups.yahoo.com/group/railo_talk/
> > > > > > > Mailing List (german):http://de.groups.yahoo.com/group/railo/
> > > > > > > Linked in:http://www.linkedin.com/e/gis/71368/0CF7D323BBC1
> > > > > > > Issue Tracker:http://jira.jboss.org/jira/browse/RAILO
> > > > > > > Blog:http://www.railo-technologies.com/blog
>
> > > > --
>
> > > > You received this message because you are subscribed to the Google
> > Groups
> > > > "Railo" group.
> > > > To post to this group, send email to ra...@googlegroups.com.
> > > > To unsubscribe from this group, send email to
> > > > railo+un...@googlegroups.com<railo%2Bunsu...@googlegroups.com><
Chris Pfeffer
Nov 25, 2009, 11:59:28 AM11/25/09
to ra...@googlegroups.com
Todd Rafferty
Nov 25, 2009, 1:34:05 PM11/25/09
to ra...@googlegroups.com
Jeremy,
Is it possible your Vista firewall is blocking Railo from creating a datasource? You said your tool has access with no issues, but that doesn't mean Railo does.
Is it possible your Vista firewall is blocking Railo from creating a datasource? You said your tool has access with no issues, but that doesn't mean Railo does.
Reply all
Reply to author
Forward
0 new messages