how to remove log output

[deadspacewii]

how can I remove log output from canal,i will use my own log instead of canal's default log

[cameron-p-m]

Something like this.

	cfg := canal.NewDefaultConfig()
	// disable embedded canal logs
	cfg.Logger = log.NewDefault(&log.NullHandler{})

[deadspacewii]

Something like this.

	cfg := canal.NewDefaultConfig()
	// disable embedded canal logs
	cfg.Logger = log.NewDefault(&log.NullHandler{})

Thanks

[dveeden]

Either with this:

import "github.com/siddontang/go-log/log"
...
        streamHandler, _ := log.NewStreamHandler(io.Discard)
        cfg.Logger = log.NewDefault(streamHandler)

Or this:

import "github.com/siddontang/go-log/log"
...
        nullHandler, _ := log.NewNullHandler()
        cfg.Logger = log.NewDefault(nullHandler)

I think we need to update the docs for this.

Also for me there was still some logging:

$ ./bin/go-canal
[2024/11/22 10:35:42] [info] dumper.go:309 exec mysqldump with [--host=127.0.0.1 --port=3306 --user=root --password=****** --source-data --single-transaction --skip-lock-tables --compact --skip-opt --quick --no-create-info --skip-extended-insert --skip-tz-utc --hex-blob --default-character-set=utf8 --column-statistics=0 --databases test]
mysqldump: [Warning] Using a password on the command line interface can be insecure.
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events. 
insert test.t1 [[1]]
insert test.t1 [[2]]
insert test.t1 [[1]]

• One line is from mysqldump where we probably let it write to stderr.
• One line is from dumper.go:309 and I'm not sure why that's showing

[dveeden]

Note that the import that my tools add is wrong and results in:

$ make build
go build -o bin/go-mysqlbinlog cmd/go-mysqlbinlog/main.go
go build -o bin/go-mysqldump cmd/go-mysqldump/main.go
go build -o bin/go-canal cmd/go-canal/main.go
# command-line-arguments
cmd/go-canal/main.go:54:15: cannot use log.NewDefault(nullHandler) (value of type *"github.com/siddontang/go/log".Logger) as loggers.Advanced value in assignment: *"github.com/siddontang/go/log".Logger does not implement loggers.Advanced (missing method Debugln)
cmd/go-canal/main.go:54:30: cannot use nullHandler (variable of type *"github.com/siddontang/go/log".NullHandler) as "github.com/siddontang/go/log".Handler value in argument to log.NewDefault: *"github.com/siddontang/go/log".NullHandler does not implement "github.com/siddontang/go/log".Handler (wrong type for method Close)
		have Close()
		want Close() error
make: *** [Makefile:10: build] Error 1

The tools add github.com/siddontang/go/log instead of github.com/siddontang/go-log/log. After correcting this by hand everything works fine.