Re: [Sequoia] can't connect to the console port

Emmanuel Cecchet Tue, 15 Apr 2008 03:00:14 -0700

Todd,

Try to use the public IP address of the machine to connect with the console.

To make sure that it's not a problem with the console, you can also tryto connect using 'telnet 127.0.0.1 1090' to see if the connection isrefused or not.

Is IPv6 enabled on your machine?


Best regards,
Emmanuel

What if you force the console to connect to 127.0.0.1 instead oflocalhost (in case the name resolution does not work)?


[EMAIL PROTECTED] sequoia]# bin/console.sh -i 127.0.0.1
Launching the Sequoia controller console
Cannot connect to the administration port of the controller. Is a
controller running at 127.0.0.1:1090 ?
Initializing Controller module...
Initializing VirtualDatabase Administration module...
Initializing SQL Console module...
Sequoia driver (Sequoia core v2.10.9) successfully loaded.

Thanks,
Todd

Thanks for the feedback,
Emmanuel

On Sat, 2008-04-12 at 17:33 -0700, Robert Hodges wrote:

Hi Todd,What OS are you on?

Linux - CentOS 5.1 (Redhat EL 5.1 AS)

If Linux, run ‘netstat –a |grep –i LIST’ to make sure the port is

opening.

[EMAIL PROTECTED] sequoia]# netstat -tpan | grep 1090

        tcp        0      0 0.0.0.0:1090                0.0.0.0:*
        LISTEN      14520/java

If not, check the messages in full_cluster.log to see if you can get a

clue why the port is not open.

Also from below, is the 'controller.sh' startup dump, you can see the
JMX server starting on the port.

09:40:02,865 INFO  controller.core.Controller JMX is enabled

        09:40:02,900 INFO  controller.core.Controller Starting JMX
        server on
        host: 127.0.0.1

Thanks,
Todd

Cheers, Robert


On 4/12/08 12:31 PM, "Todd Robinson" <[EMAIL PROTECTED]> wrote:

        Question from a newbie;  I've gotten the basic configuration
        done and
        have started the controller with out any errors.  Sequoia is
        running on
        the same box a the database server.  I can see the connection
        to the
        back end database and it has created the Recovery tables.  But
        when I
        try to connect to the console port I get the following error
        (other
        configuration info follows):

[EMAIL PROTECTED] sequoia]# bin/console.sh

        Launching the Sequoia controller console
        Cannot connect to the administration port of the controller.
        Is a
        controller running at localhost:1090 ?
        Initializing Controller module...
        Initializing VirtualDatabase Administration module...
        Initializing SQL Console module...
        Sequoia driver (Sequoia core v2.10.9) successfully loaded.

Thanks for any help in advance,

        Todd

System Configuration:CentOS 5.1

        Sun JDK 6u5
        Sequoia 2.10.9
        MySQL 5.0.22

[EMAIL PROTECTED] sequoia]# netstat -tpan | grep 1090

        tcp        0      0 0.0.0.0:1090                0.0.0.0:*
        LISTEN      14520/java

[EMAIL PROTECTED] controller]# cat controller.xml

        <?xml version="1.0" encoding="ISO-8859-1" ?>
        <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD
        SEQUOIA-CONTROLLER 2.10.9//EN"
        "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.9.dtd";>
        <SEQUOIA-CONTROLLER>
          <Controller ipAddress="127.0.0.1" port="25322">
            <JmxSettings>
              <RmiJmxAdaptor port="1090"/>
            </JmxSettings>
            <VirtualDatabase configFile="mysqldb-raidb1.xml"
        virtualDatabaseName="zag1DB" autoEnableBackends="force"
        checkpointName="Initial_empty_recovery_log"/>
          </Controller>
        </SEQUOIA-CONTROLLER>

[EMAIL PROTECTED] sequoia]# bin/controller.sh

        java version "1.6.0_05"
        Java(TM) SE Runtime Environment (build 1.6.0_05-b13)
        Java HotSpot(TM) Client VM (build 10.0-b19, mixed mode,
        sharing)
        09:40:02,687 INFO  controller.core.Controller Sequoia
         controller
        (2.10.9)
        09:40:02,785 INFO  controller.core.Controller Loading
        configuration
        file: /usr/local/sequoia/config/controller/controller.xml
        09:40:02,865 INFO  controller.core.Controller JMX is enabled
        09:40:02,900 INFO  controller.core.Controller Starting JMX
        server on
        host: 127.0.0.1
        09:40:03,224 INFO  backup.backupers.OctopusBackuper
        OctopusBackuper
        backup compression is set to true
        09:40:03,224 INFO  controller.backup.BackupManager Registering
        backuper
        Octopus to handle format Octopus v3.4.1 database neutral dump
        compressed
        09:40:03,254 INFO  DatabaseBackend.zag1DB.zagamodb Adding
        connection
        manager for virtual user "webuser"
        09:40:03,322 DEBUG sequoia.controller.recoverylog Connection
        to
        jdbc:mysql://localhost:3306/sequoia as user sequser
        09:40:03,658 DEBUG sequoia.controller.recoverylog Log table
        create
        statement: CREATE TABLE RECOVERY (log_id BIGINT NOT
        NULL,vlogin TEXTNOT
        NULL,sqldata TEXT NOT NULL,sqldata_param TEXT,auto_conn_tran
        CHAR(1) NOT
        NULL,transaction_id BIGINT NOT NULL,request_id
        BIGINT,exec_status
        CHAR(1) NOT NULL,exec_time BIGINT,update_count INT,PRIMARY KEY
        (log_id))
        09:40:03,659 DEBUG sequoia.controller.recoverylog Checkpoint
        table
        create statement: CREATE TABLE CHECKPOINT (name CHAR(40) NOT
        NULL,log_id
        BIGINT,PRIMARY KEY (name))
        09:40:03,659 DEBUG sequoia.controller.recoverylog Backend
        table create
        statement: CREATE TABLE BACKEND (database_name TEXT NOT NULL,
        backend_name TEXT NOT NULL,backend_state INTEGER,
        checkpoint_name
        TEXTNOT NULL )
        09:40:03,660 DEBUG sequoia.controller.recoverylog Dump table
        create
        statement: CREATE TABLE DUMP (dump_name TEXT NOT
        NULL,dump_date
        TIMESTAMP,dump_path TEXT NOT NULL,dump_format TEXT NOT
        NULL,checkpoint_name TEXT NOT NULL,backend_name TEXT NOT
        NULL,tables
        TEXT NOT NULL)
        09:40:03,664 DEBUG sequoia.controller.recoverylog Table found:
        BACKEND
        09:40:03,665 DEBUG sequoia.controller.recoverylog Table found:
        CHECKPOINT
        09:40:03,665 DEBUG sequoia.controller.recoverylog Retrieving
        checkpoint
        names list
        09:40:03,684 DEBUG sequoia.controller.recoverylog Checkpoint
        list...
        name=[Initial_empty_recovery_log] log_id=[0]
        name=[last-man-down] log_id=[0]
        09:40:03,684 DEBUG sequoia.controller.recoverylog Table found:
        DUMP
        09:40:03,684 DEBUG sequoia.controller.recoverylog Table found:
        RECOVERY
        09:40:03,723 INFO  controller.RequestManager.zag1DB Request
        manager will
        parse requests with the following granularity: TABLE
        09:40:03,737 WARN  controller.core.Controller Backends enabled
        in force
        mode from checkpoint Initial_empty_recovery_log
        09:40:03,975 INFO  DatabaseBackend.zag1DB.zagamodb Detected
        backend as:
        MySQL
        09:40:03,977 WARN  DatabaseBackend.zag1DB.zagamodb Unable to
        test
        ResultSet.getObject
        09:40:04,016 INFO  controller.RequestManager.zag1DB Setting
        new virtual
        database schema.
        09:40:04,035 INFO  controller.recoverylog.RecoverThread
        Starting
        recovery
        09:40:04,042 INFO  controller.recoverylog.RecoverThread
        Recovery
        completed
        09:40:04,060 INFO  controller.recoverylog.RecoverThread
        Database backend
        zagamodb is now enabled
        09:40:04,069 INFO  controller.core.Controller Adding
        VirtualDatabase
        zag1DB
        09:40:04,080 INFO  controller.core.Controller Waiting for
        connections on
        0.0.0.0:25322
        09:40:04,088 INFO  controller.core.Controller Controller
        started on
        2008.04.12 15 at 09:40:04 AM EDT
        09:40:04,088 INFO  controller.core.Controller Controller
        127.0.0.1:25322
        ready, listening to requests ...


_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Re: [Sequoia] can't connect to the console port

Reply via email to