Mailinglist Archive: opensuse (3666 mails)

< Previous Next >
Re: [SLE] Enabling MySQL in Postfix
  • From: Lucky Leavell <susemisc@xxxxxxxxxxxxx>
  • Date: Sat, 19 Mar 2005 20:34:00 -0500 (EST)
  • Message-id: <Pine.LNX.4.61.0503192010320.1170@xxxxxxxxxxxxxxxxxxxx>

On Sat, 19 Mar 2005, Carlos E. R. wrote:

>
> The Friday 2005-03-18 at 21:22 -0500, Lucky Leavell wrote:
>
> > No <db.h> include file found.
> > Install the appropriate db*-devel package first.
> ...
> >
> > I do have mysql-devel v4.0.21 installed BUT the only db.h file I find is
> >
> > /usr/include/htdig_db/db.h
> >
> > What am I missing? Am I going to have to go through the same thing to
> > enable SASL authentication?
>
> You can use "pin" to find missing files from the installation. For
> example, db-devel has two db.h files. db40-devel has another, and
> db41-devel another.
>
> You choose :-)
>

I chose db-devel as it matched the version I had installed and made it
past the makefiles generation, resulting in the following
conf/makedefs.out:

SYSTYPE = LINUX2
AR = ar
ARFL = rv
RANLIB = ranlib
SYSLIBS = -L/usr/lib/mysql -lmysqlclient -lz -lm -ldb -lnsl -lresolv
CC = gcc $(WARN) -DHAS_MYSQL -I/usr/include/mysql
OPT = -O
DEBUG = -g
AWK = awk
STRCASE =
EXPORT = AUXLIBS='-L/usr/lib/mysql -lmysqlclient -lz -lm' CCARGS='-DHAS_MYSQL -I/usr/include/mysql' OPT='-O' DEBUG='-g'
WARN = -W -Wformat -Wimplicit -Wmissing-prototypes \
-Wparentheses -Wstrict-prototypes -Wswitch -Wuninitialized \
-Wunused

But when I tried the make itself, I had two errors:

set -e; for i in src/util src/global src/dns src/master src/postfix src/smtpstone src/sendmail src/error src/pickup src/cleanup src/smtpd src/local src/lmtp src/trivial-rewrite src/qmgr src/oqmgr src/smtp src/bounce src/pipe src/showq src/postalias src/postcat src/postconf src/postdrop src/postkick src/postlock src/postlog src/postmap src/postqueue src/postsuper src/qmqpd src/spawn src/flush src/verify src/virtual src/proxymap; do \
(set -e; echo "[$i]"; cd $i; make 'CC=gcc -Wmissing-prototypes -Wformat -DHAS_MYSQL -I/usr/include/mysql' update MAKELEVEL=) || exit 1; \
done
[src/util]
for i in argv.h attr.h base64_code.h binhash.h chroot_uid.h clean_env.h connect.h ctable.h dict.h dict_db.h dict_dbm.h dict_env.h dict_cidr.h dict_ht.h dict_ni.h dict_nis.h dict_nisplus.h dict_pcre.h dict_regexp.h dict_static.h dict_tcp.h dict_unix.h dir_forest.h events.h exec_command.h find_inet.h fsspace.h fullname.h get_domainname.h get_hostname.h hex_quote.h host_port.h htable.h inet_addr_host.h inet_addr_list.h inet_addr_local.h inet_util.h iostuff.h line_wrap.h listen.h lstat_as.h mac_expand.h mac_parse.h make_dirs.h match_list.h match_ops.h msg.h msg_output.h msg_syslog.h msg_vstream.h mvect.h myflock.h mymalloc.h myrand.h name_mask.h netstring.h nvtable.h open_as.h open_lock.h percentm.h posix_signals.h readlline.h ring.h safe.h safe_open.h sane_accept.h sane_fsops.h sane_socketpair.h sane_time.h scan_dir.h set_eugid.h set_ugid.h sigdelay.h spawn_command.h split_at.h stat_as.h stringops.h sys_defs.h timed_connect.h timed_wait.h trigger.h username.h valid_hostname.h vbuf.h vbuf_print.h vstream.h vstring.h vstring_vstream.h watchdog.h auto_clnt.h attr_clnt.h sane_connect.h name_code.h; \
do \
cmp -s $i ../../include/$i 2>/dev/null || cp $i ../../include; \
done
cd ../../include; chmod 644 argv.h attr.h base64_code.h binhash.h chroot_uid.h clean_env.h connect.h ctable.h dict.h dict_db.h dict_dbm.h dict_env.h dict_cidr.h dict_ht.h dict_ni.h dict_nis.h dict_nisplus.h dict_pcre.h dict_regexp.h dict_static.h dict_tcp.h dict_unix.h dir_forest.h events.h exec_command.h find_inet.h fsspace.h fullname.h get_domainname.h get_hostname.h hex_quote.h host_port.h htable.h inet_addr_host.h inet_addr_list.h inet_addr_local.h inet_util.h iostuff.h line_wrap.h listen.h lstat_as.h mac_expand.h mac_parse.h make_dirs.h match_list.h match_ops.h msg.h msg_output.h msg_syslog.h msg_vstream.h mvect.h myflock.h mymalloc.h myrand.h name_mask.h netstring.h nvtable.h open_as.h open_lock.h percentm.h posix_signals.h readlline.h ring.h safe.h safe_open.h sane_accept.h sane_fsops.h sane_socketpair.h sane_time.h scan_dir.h set_eugid.h set_ugid.h sigdelay.h spawn_command.h split_at.h stat_as.h stringops.h sys_defs.h timed_connect.h timed_wait.h trigger.h username.h valid_hostname.h vbuf.h vbuf_print.h vstream.h vstring.h vstring_vstream.h watchdog.h auto_clnt.h attr_clnt.h sane_connect.h name_code.h
[src/global]
for i in abounce.h been_here.h bounce.h bounce_log.h canon_addr.h cfg_parser.h cleanup_user.h clnt_stream.h config.h debug_peer.h debug_process.h defer.h deliver_completed.h deliver_flock.h deliver_pass.h deliver_request.h dict_ldap.h dict_mysql.h dict_pgsql.h dict_proxy.h domain_list.h dot_lockfile.h dot_lockfile_as.h ext_prop.h file_id.h flush_clnt.h header_opts.h header_token.h hold_message.h input_transp.h is_header.h lex_822.h log_adhoc.h mail_addr.h mail_addr_crunch.h mail_addr_find.h mail_addr_map.h mail_conf.h mail_copy.h mail_date.h mail_dict.h mail_error.h mail_flush.h mail_open_ok.h mail_params.h mail_proto.h mail_queue.h mail_run.h mail_scan_dir.h mail_stream.h mail_task.h mail_version.h maps.h mark_corrupt.h match_parent_style.h mbox_conf.h mbox_open.h mime_state.h mkmap.h mynetworks.h mypwd.h namadr_list.h off_cvt.h opened.h own_inet_addr.h pipe_command.h post_mail.h qmgr_user.h qmqp_proto.h quote_821_local.h quote_822_local.h quote_flags.h rec_streamlf.h rec_type.h recipient_list.h record.h resolve_clnt.h resolve_local.h rewrite_clnt.h sent.h smtp_stream.h split_addr.h string_list.h strip_addr.h sys_exits.h timed_ipc.h tok822.h trace.h verify.h verify_clnt.h verp_sender.h virtual8_maps.h xtext.h; \
do \
cmp -s $i ../../include/$i 2>/dev/null || cp $i ../../include; \
done
cd ../../include; chmod 644 abounce.h been_here.h bounce.h bounce_log.h canon_addr.h cfg_parser.h cleanup_user.h clnt_stream.h config.h debug_peer.h debug_process.h defer.h deliver_completed.h deliver_flock.h deliver_pass.h deliver_request.h dict_ldap.h dict_mysql.h dict_pgsql.h dict_proxy.h domain_list.h dot_lockfile.h dot_lockfile_as.h ext_prop.h file_id.h flush_clnt.h header_opts.h header_token.h hold_message.h input_transp.h is_header.h lex_822.h log_adhoc.h mail_addr.h mail_addr_crunch.h mail_addr_find.h mail_addr_map.h mail_conf.h mail_copy.h mail_date.h mail_dict.h mail_error.h mail_flush.h mail_open_ok.h mail_params.h mail_proto.h mail_queue.h mail_run.h mail_scan_dir.h mail_stream.h mail_task.h mail_version.h maps.h mark_corrupt.h match_parent_style.h mbox_conf.h mbox_open.h mime_state.h mkmap.h mynetworks.h mypwd.h namadr_list.h off_cvt.h opened.h own_inet_addr.h pipe_command.h post_mail.h qmgr_user.h qmqp_proto.h quote_821_local.h quote_822_local.h quote_flags.h rec_streamlf.h rec_type.h recipient_list.h record.h resolve_clnt.h resolve_local.h rewrite_clnt.h sent.h smtp_stream.h split_addr.h string_list.h strip_addr.h sys_exits.h timed_ipc.h tok822.h trace.h verify.h verify_clnt.h verp_sender.h virtual8_maps.h xtext.h
[src/dns]
for i in dns.h; \
do \
cmp -s $i ../../include/$i 2>/dev/null || cp $i ../../include; \
done
cd ../../include; chmod 644 dns.h
[src/master]
gcc -Wmissing-prototypes -Wformat -DHAS_MYSQL -I/usr/include/mysql -g -O -I. -I../../include -DLINUX2 -o master master.o master_conf.o master_ent.o master_sig.o master_avail.o master_spawn.o master_service.o master_status.o master_listen.o master_vars.o master_wakeup.o master_flow.o ../../lib/libglobal.a ../../lib/libutil.a -L/usr/lib/mysql -lmysqlclient -lz -lm -ldb -lnsl -lresolv
/usr/lib/gcc-lib/i586-suse-linux/3.3.4/../../../../i586-suse-linux/bin/ld: cannot find -lz
collect2: ld returned 1 exit status
make: *** [master] Error 1
make: *** [update] Error 1

=======================================================================================

Further investigation shows libz and libm files are both found in /usr/lib
(though some files are also in /lib?) Obviously I am NOT a C, make or ld
guru, so please pardon my ignorance and kindly show me how to point the
original make to the appropraite libraries. (PostgreSQL looks a lot
simpler and may become my backup plan.)

Thank you,
Lucky
< Previous Next >