Comment 4 for bug 654781

Ah doh! Sounds good. Just lemmie know and I'll be sure to give it a spin!

On Oct 7, 2010, at 8:47 PM, Monty Taylor wrote:

> Oh. Actually - wait. Don't bother - we're ALSO having issues uploading
> new trunk packages to the trunk PPA due to a launchpad bug - I'll ping
> you when that's fixed.
>
> --
> Cannot start Drizzle on an alternate port using init script
> https://bugs.launchpad.net/bugs/654781
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications: New
> Status in Drizzle elliott series: Confirmed
>
> Bug description:
> I am unable to start Drizzle when trying to specify a MySQL port via the config file:
>
> root@mcp:~# cat /etc/drizzle/drizzled.cnf
> datadir = /var/lib/drizzle
> pid-file = /var/lib/drizzle/mcp.pid
>
> #mysql-protocol.port=3307
> [mysql-protocol]
> port = 3307
> bind-address = 127.0.0.1
>
> root@mcp:~# /etc/init.d/drizzle-server start
> * Starting Drizzle database server drizzled
> ...done.
> root@mcp:~# /etc/init.d/drizzle-server status
> * Drizzle is stopped.
> root@mcp:~# tail -5 /var/log/drizzle/drizzled.log
> Listening on :::4427
> bind() failed with errno: 98
> Do you already have another drizzled running?
> Error getting file descriptorsAborting
> /usr/sbin/drizzled: Shutdown complete
>
> Starting drizzle up manually using the config file also fails:
>
> root@mcp:~# drizzled --defaults-file=/etc/drizzle/drizzled.cnf
> InnoDB: The InnoDB memory heap is disabled
> InnoDB: Mutexes and rw_locks use GCC atomic builtins.
> 101004 19:30:44 InnoDB: highest supported file format is Barracuda.
> InnoDB: Log scan progressed past the checkpoint lsn 180594
> 101004 19:30:44 InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the doublewrite
> InnoDB: buffer...
> InnoDB: Doing recovery: scanned up to log sequence number 180840
> InnoDB: Last MySQL binlog file position 0 0, file name UNUSED
> 101004 19:30:44 InnoDB Plugin 1.0.4 started; log sequence number 180840
> Listening on 0.0.0.0:4427
> Listening on :::4427
> bind() failed with errno: 98
> Do you already have another drizzled running?
> Error getting file descriptorsAborting
> drizzled: Shutdown complete
>
> Nothing is listening on 3307 currently:
>
> root@mcp:~# netstat -nptl
> Active Internet connections (only servers)
> Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
> tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 2401/sshd
> tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 11367/apache2
> tcp 0 0 0.0.0.0:3784 0.0.0.0:* LISTEN 10118/ventrilo_srv
> tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 27885/mysqld
> tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 11367/apache2
> tcp 0 0 0.0.0.0:3312 0.0.0.0:* LISTEN 2620/searchd
> tcp6 0 0 :::22 :::* LISTEN 2401/sshd
>
> This is on Lucid (10.04) using nightly built PPA DEBs:
>
> root@mcp:~# lsb_release -a
> No LSB modules are available.
> Distributor ID: Ubuntu
> Description: Ubuntu 10.04.1 LTS
> Release: 10.04
> Codename: lucid
> root@mcp:~# cat /etc/apt/sources.list.d/drizzle.list
> #deb http://ppa.launchpad.net/drizzle-developers/ppa/ubuntu lucid main
> deb http://ppa.launchpad.net/drizzle-developers/trunk/ubuntu lucid main
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/drizzle/+bug/654781/+subscribe
>