You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by dee factorial <de...@gmail.com> on 2006/12/08 22:53:22 UTC

mysql connection problems

I'm tring to build jetspeed with mysql support but when I execute the mvn -P
test command I get these errors

[ERROR] BUILD ERROR
[INFO]
------------------------------------------------------------------------
[INFO] Error executing ant tasks

Embedded error: The following error occurred while executing this line:
/home/deefactorial/J2/etc/build.xml:277: The following error occurred while
executing this line:
/home/deefactorial/J2/etc/build.xml:341:
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
        at com.mysql.jdbc.StandardSocketFactory.connect(
StandardSocketFactory.java:156)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
        at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
        at com.mysql.jdbc.NonRegisteringDriver.connect(
NonRegisteringDriver.java:266)
        at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(
JDBCTask.java:304)
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java
:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.tools.ant.Target.performTasks(Target.java:369)
        at org.apache.tools.ant.Project.executeSortedTargets(Project.java
:1216)
        at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(
SingleCheckExecutor.java:37)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
        at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
        at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java
:107)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java
:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.tools.ant.Target.performTasks(Target.java:369)
        at org.apache.tools.ant.Project.executeSortedTargets(Project.java
:1216)
        at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(
SingleCheckExecutor.java:37)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
        at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:382)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java
:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.maven.plugin.antrun.AbstractAntMojo.executeTasks(
AbstractAntMojo.java:108)
        at org.apache.maven.plugin.antrun.AntRunMojo.execute(AntRunMojo.java
:83)
        at org.apache.maven.plugin.DefaultPluginManager.executeMojo(
DefaultPluginManager.java:412)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(
DefaultLifecycleExecutor.java:534)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle
(DefaultLifecycleExecutor.java:475)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(
DefaultLifecycleExecutor.java:454)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures
(DefaultLifecycleExecutor.java:306)
        at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(
DefaultLifecycleExecutor.java:273)
        at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(
DefaultLifecycleExecutor.java:140)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:322)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:115)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:256)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java
:315)
        at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
        at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java
:430)
        at org.codehaus.classworlds.Launcher.main(Launcher.java:375)


** END NESTED EXCEPTION **



my settings.xml file looks like this
<settings xmlns="http://maven.apache.org/POM/4.0.0">

    <!-- Local Repository Location -->


    <localRepository>/root/.m2/repository</localRepository>


    <!-- Jetspeed-2 Profile Configuration -->

    <profiles>

        <!-- Default Profile -->
        <profile>
            <id>settings</id>
            <activation>
                <activeByDefault>true</activeByDefault>
            </activation>
            <properties>

                <!-- Build profiles configuration -->


                <org.apache.jetspeed.env.deploy.target
>tomcat</org.apache.jetspeed.env.deploy.target>
                <org.apache.jetspeed.env.deploy.type
>full</org.apache.jetspeed.env.deploy.type>
                <org.apache.jetspeed.env.deploy.db.psml
>false</org.apache.jetspeed.env.deploy.db.psml>


                <!-- Jetspeed-2 deployment properties -->

                <org.apache.jetspeed.server.home>/home/deefactorial/apache-
tomcat-5.5.20</org.apache.jetspeed.server.home>
                <org.apache.jetspeed.catalina.version.major>5.5
</org.apache.jetspeed.catalina.version.major>
                <org.apache.jetspeed.services.autodeployment.server
>localhost</org.apache.jetspeed.services.autodeployment.server>
                <org.apache.jetspeed.services.autodeployment.port
>8080</org.apache.jetspeed.services.autodeployment.port>
                <org.apache.jetspeed.services.autodeployment.user
>j2deployer</org.apache.jetspeed.services.autodeployment.user>
                <org.apache.jetspeed.services.autodeployment.password
>j2deployer</org.apache.jetspeed.services.autodeployment.password>


                <!-- MySQL database properties -->


                <org.apache.jetspeed.test.jdbc.drivers.path>${
org.apache.jetspeed.server.home}/shared/lib/mysql-
connector-java-3.1.12-bin.jar</org.apache.jetspeed.test.jdbc.drivers.path>
                <org.apache.jetspeed.test.database.default.name
>mysql</org.apache.jetspeed.test.database.default.name>
                <org.apache.jetspeed.test.database.url
>jdbc:mysql://localhost/j2test</org.apache.jetspeed.test.database.url>
                <org.apache.jetspeed.test.database.driver>
com.mysql.jdbc.Driver</org.apache.jetspeed.test.database.driver>
                <org.apache.jetspeed.test.database.user
>root</org.apache.jetspeed.test.database.user>
                <org.apache.jetspeed.test.database.password
></org.apache.jetspeed.test.database.password>
                <org.apache.jetspeed.production.jdbc.drivers.path>${
org.apache.jetspeed.server.home}/shared/lib/mysql-
connector-java-3.1.12-bin.jar
</org.apache.jetspeed.production.jdbc.drivers.path>
                <org.apache.jetspeed.production.database.default.name
>mysql</org.apache.jetspeed.production.database.default.name>
                <org.apache.jetspeed.production.database.url
>jdbc:mysql://localhost/jetspeed</org.apache.jetspeed.production.database.url>
                <org.apache.jetspeed.production.database.driver>
com.mysql.jdbc.Driver</org.apache.jetspeed.production.database.driver>
                <org.apache.jetspeed.production.database.user
>root</org.apache.jetspeed.production.database.user>
                <org.apache.jetspeed.production.database.password
></org.apache.jetspeed.production.database.password>

            </properties>
        </profile>

    </profiles>

    <activeProfiles>

        <!-- Derby embedded database properties -->
<!--
        <activeProfile>jetspeed-db-embedded-derby</activeProfile>
-->
        <!-- Drivers path configured database profile -->


        <activeProfile>jetspeed-db-drivers-path</activeProfile>


        <!-- HSQLDB embedded database profile -->

        <!--
        <activeProfile>jetspeed-db-embedded-hsql</activeProfile>
        -->

    </activeProfiles>

</settings>

Re: mysql connection problems

Posted by David Sean Taylor <da...@bluesunrise.com>.
dee factorial wrote:
> mysql is installed on the standard port, I've tried specifying it
> specifically as well.
> 
Can you connect on that port from a test JDBC program or Squirrel SQL
Maybe the port is locked down
Do you run a personal firewall?

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org


Re: mysql connection problems

Posted by dee factorial <de...@gmail.com>.
mysql is installed on the standard port, I've tried specifying it
specifically as well.


On 12/8/06, David Sean Taylor <da...@bluesunrise.com> wrote:
>
>
> dee factorial wrote:
> > I'm tring to build jetspeed with mysql support but when I execute the
> > mvn -P
> > test command I get these errors
>
> Could it be that you installed MySQL on a non-standard port:
>
> jdbc:mysql://localhost/j2test
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>

Re: mysql connection problems

Posted by David Sean Taylor <da...@bluesunrise.com>.
dee factorial wrote:
> I'm tring to build jetspeed with mysql support but when I execute the 
> mvn -P
> test command I get these errors

Could it be that you installed MySQL on a non-standard port:

jdbc:mysql://localhost/j2test


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org