[brossow]

Not to hijack the thread by any means, but I can tell you that 3.0 doesn’t work as a drop-in replacement for 2.x in the installation described in the article on this site. When I went from 2.64 to 3.0 yesterday on my OSXS 10.2 server with the latest Exim, spam filtering stopped entirely. Had to revert to the previous version.

[brossow]

I solved the problem on my system by using the following configure command:

[code:1:385416a0c6]./configure –with-modules=mod_sql:mod_sql_mysql –with-includes=/usr/include/mysql –with-libraries=/usr/lib/mysql[/code:1:385416a0c6]

The command suggested in the article on this site doesn’t point to the correct includes location, at least on my system. *shrug* Posting this in the hope that it helps someone else. 🙂

[brossow]

[quote:37d1ce9a0b=”Lukas”]Hi!

Version 1.28 of ProFTPd is out. I tried this one without downloading mod_msql (i.e. using the one enclosed with the source) and everything went well.

Lukas[/quote:37d1ce9a0b]

Just tried this with 1.2.9 on my server (running OSXS 10.2.8 and latest dev tools) and ‘make’ dies with the following:
[code:1:37d1ce9a0b]mod_sql_mysql.c:137: header file ‘mysql.h’ not found
mod_sql_mysql.c:164: undefined type, found `MYSQL’
mod_sql_mysql.c:344: undefined type, found `MYSQL’
mod_sql_mysql.c:345: undefined type, found `MYSQL_RES’
mod_sql_mysql.c:346: undefined type, found `MYSQL_ROW’
cpp-precomp: warning: errors during smart preprocessing, retrying in basic mode
make[1]: *** [mod_sql_mysql.o] Error 1
make: *** [modules] Error 2[/code:1:37d1ce9a0b]

Anyone have any luck? I installed 1.2.7 about a year ago and don’t recall having any problems, but this upgrade to 1.2.9 is going nowhere.

[brossow]

Works fine for me in OSXS 10.2.5 with latest Dev Tools installed. As a starting point, I’d suggest making sure you’re running the latest Dev Tools.

On a semi-related note, though, there’s an important omission: it never tells us to actually unpack the .gz files we downloaded in Step 1. Clearly not a big deal for anyone who should be doing this, but just the same it makes the instructions technically incomplete.

Good luck with the install! It worked fine for me a few minutes ago. 🙂

[brossow]

After another hour of digging on the ‘Net for a resolution to this, I finally discovered that this is a known issue caused by Fink. Here’s the solution: http://archive.develooper.com/[email protected]/msg02447.html

Just in case the page I linked to would disappear, here’s the text of that message:

[code:1:f449a1a2de]perl 5.8.0 issue on Mac OS X w/ fink

* To: [email protected]
* Subject: perl 5.8.0 issue on Mac OS X w/ fink
* From: Adam Foxson <[email protected]>
* Date: Fri, 19 Jul 2002 05:18:03 -0400
* Cc: [email protected], [email protected]
* Delivered-to: mailing list [email protected]
* Delivered-to: moderator for [email protected]
* Mailing-list: contact [email protected]; run by ezmlm
* User-agent: Mutt/1.3.24i

SYNOPSIS:

The release notes for perl 5.8.0 indicate:

"Perl 5.8 is not binary compatible with any earlier Perl release,
XS MODULES WILL HAVE TO BE RECOMPILED!"

Mac OS X users that have fink installed may experience the
following error when executing certain perl operations (see ‘EXAMPLE’).

dyld: perl Undefined symbols:
_Perl_safefree
_Perl_safemalloc
_Perl_saferealloc
_Perl_sv_2pv
_perl_call_sv
_perl_eval_sv
_perl_get_sv

This error is separate from the similar dyld issue mentioned in the
"Mac OS X dyld undefined symbols" section of perldelta[1].

EXAMPLE:

The below is one example of how to reproduce the issue. There are many
other ways to reproduce it. I have experienced the same behavior when
attempting to "perl Makefile.PL" certain modules (such as CPANPLUS
below). CPAN.pm also exhibits the same behavior when attempting
certain operations after configuration.

root@localhost:/tmp$ perl -MCPANPLUS -e shell

CPANPLUS::Shell::Default — CPAN exploration and modules installation (v0.02)
*** Please report bugs to <[email protected]>.
*** Using CPANPLUS::Backend v0.035. ReadLine support enabled.

CPAN Terminal> o
Checking if source files are up to date
dyld: perl Undefined symbols:
_Perl_safefree
_Perl_safemalloc
_Perl_saferealloc
_Perl_sv_2pv
_perl_call_sv
_perl_eval_sv
_perl_get_sv
root@localhost:/tmp$

CAUSE:

The error is caused by the following sequence of events:

1 – a .bashrc (or other shell rc file) sources /sw/bin/init.[c]sh
2 – init.[c]sh sets PERL5LIB to /sw/lib/perl5
3 – /sw/lib/perl5 contains Storable (the only compiled perl module,
included by default, to my knowledge), and possibly other XS
modules. Since Storable is a compiled XS module that was compiled
with a prior version of perl that is binary incompatible with
perl 5.8.0 it will be necessary to recompile Storable
(see ‘RESOLUTION’).

FURTHER CONSIDERATIONS:

Fink stable currently includes the following six XS modules. If any
of these were installed prior to installing 5.8.0 you will likely
experience the dyld issue.

– DBD::Mysql
– DBI
– Digest::MD5
– MacOSX::File
– Storable
– Term::ReadKey

You will also experience the dyld issue if any other XS modules are
contained within the /sw/lib/perl5 directory. That is, XS modules
from fink unstable or another source.

RESOLUTION:

The following three commands will correct the above issue by removing
the current Storable and replacing it with a recompiled version. These
commands must be executed as the superuser. After these commands are
executed the aforementioned issue will be resolved.

mv /sw/lib/perl5/darwin/Storable.pm /tmp
mv /sw/lib/perl5/darwin/auto/Storable /tmp
fink rebuild storable-pm

It IS first necessary to do the mv’s, before the rebuild, since fink is
a perl script that explicitly adds /sw/lib/perl5 to @INC, and exhibits
the behavior mentioned above.

You will need to execute the above commands for every XS module that
is contained within /sw/lib/perl5.

FOOTNOTES:

[1] http://search.cpan.org/doc/JHI/perl-5.8.0/pod/perldelta.pod#Mac_OS_X_dyld_undefined_symbols

—
Adam J. Foxson (Fox)
CPAN Tester for Mac OS X
Comprehensive Perl Archive Network[/code:1:f449a1a2de]

Following the advice above solved the issue for me. I’m posting this info in the hope that this helps someone else! Wish this info had been posted here earlier….

[brossow]

[quote:fd275f043f=”MacTroll”]that is an “l” as in a lowercase “L” for log not a 1.

Joel[/quote:fd275f043f]

You need to fix that on the how-to page — you’ve got it on the page as the number 1 and not a lowercase L. Copy-n-paste doesn’t work from the page as it currently stands. (I just found that out myself a minute ago, which is kinda how I ended up here right now.)

On a related note, I was having an error downloading the new virus updates using freshclam until i changed the owner/group on the clamav directory as follows: [b:fd275f043f]chown clamav.clamav /usr/local/share/clamav/[/b:fd275f043f]. I don’t think I missed this step in the instructions, so you might want to look at this.

Otherwise, so far so good! 🙂

[brossow]

[quote:43eee70fe5=”Cabbage”]>>still waiting for a printed copy to arrive
I mailed it this week :oops:[/quote:43eee70fe5]

D’oh! That wasn’t intended as a complaint; just an excuse for my not having RTFM. 😉

[brossow]

[quote:dad345be3a=”MacTroll”]With server I would highly recommend that you use the Network database. Certainly that is what Apple would recommend also.[/quote:dad345be3a]

Any easy way to move all my users over from local to network? What I have is working just fine right now (with the exception of the LDAP issue here) so I hate to mess anything up. I was in a time crunch when I set up the server and didn’t have a lot of time to research. I admittedly haven’t read the manual (still waiting for a printed copy to arrive) and was flying by the seat of my pants when I set it up. If it’s major work, I’ll just get by without LDAP. Just would be convenient to have available.

THANKS!

[brossow]

If I run slapd using the network database, I at least get some results back using an empty search base. When I switch to the local database per the instuctions, I get absolutely nothing despite the fact I have 100-odd local users. Here is the entire output of debug mode starting up using local:

[quote:504f3ae0af][www:~] admin% sudo /usr/libexec/slapd -d 1
@(#) $OpenLDAP: slapd 2.1.X (Sun Jul 28 15:04:21 PDT 2002) $
root@nikon:/private/var/tmp/OpenLDAP/OpenLDAP-15.obj~1/servers/slapd
daemon_init: listen on ldap:///
daemon_init: 1 listeners to open…
ldap_url_parse_ext(ldap:///)
daemon: initialized ldap:///
daemon_init: 1 listeners opened
slapd init: initiated server.
slap_sasl_init: initialized!
/etc/openldap/slapd.conf: line 14: schema checking disabled! your mileage may vary!
==> netinfo_back_db_init
<== netinfo_back_db_init

>> dnPrettyNormal: <>
<<< dnPrettyNormal: <>, <>
(DSSTORE_FLAGS_ACCESS_READONLY: OFF)
(DSSTORE_FLAGS_ACCESS_READWRITE: ON)
(DSSTORE_FLAGS_SERVER_CLONE: ON)
(DSSTORE_FLAGS_SERVER_MASTER: OFF)
(DSSTORE_FLAGS_CACHE_ENABLED: ON)
(DSSTORE_FLAGS_CACHE_DISABLED: OFF)
(DSSTORE_FLAGS_REMOTE_NETINFO: OFF)
(DSSTORE_FLAGS_OPEN_BY_TAG: OFF)
(DSENGINE_FLAGS_NETINFO_NAMING: ON)
(DSENGINE_FLAGS_X500_NAMING: OFF)
(DSENGINE_FLAGS_POSIX_NAMING: OFF)
(DSENGINE_FLAGS_DEREFERENCE_IDS: OFF)
(DSENGINE_FLAGS_NATIVE_AUTHORIZATION: ON)
<=> ad_to_dsdata_type attribute=uid type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=cn type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=uidNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=gidNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=homeDirectory type=DataTypeCStr
<=> ad_to_dsdata_type attribute=loginShell type=DataTypeCStr
<=> ad_to_dsdata_type attribute=shadowExpire type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=shadowLastChange type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=apple-user-class type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-user-homeurl type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-user-homequota type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-user-mailattribute type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-user-printattribute type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-user-adminlimits type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-user-picture type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-user-authenticationhint type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=authAuthority type=DataTypeCStr
<=> ad_to_dsdata_type attribute=sn type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=givenName type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=st type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=postalCode type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=street type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=telephoneNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=memberUid type=DataTypeCStr
<=> ad_to_dsdata_type attribute=gidNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=apple-group-realname type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-group-homeurl type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-group-homeowner type=DataTypeCStr
<=> ad_to_dsdata_type attribute=cn type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=ipHostNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=macAddress type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=bootFile type=DataTypeCStr
<=> ad_to_dsdata_type attribute=bootParameter type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=apple-machine-serves type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-machine-suffix type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=apple-machine-hardware type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=apple-machine-software type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=ipProtocolNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=oncRpcNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=ipServicePort type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=ipServiceProtocol type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=ipNetworkNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=ipNetmaskNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=mountDirectory type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=mountType type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=mountOption type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=mountDumpFrequency type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=mountPassNo type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=apple-printer-attributes type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=rfc822MailMember type=DataTypeCaseCStr
schemamap_add_oc: Could not add objectClass mapping for directory /computers: Invalid Path
schemamap_add_at: Could not add attribute mapping for NetInfo attribute comment: Invalid Path
schemamap_add_at: Could not add attribute mapping for NetInfo attribute en_address: Invalid Path
schemamap_add_at: Could not add attribute mapping for NetInfo attribute groups: Invalid Path
schemamap_add_oc: Could not add objectClass mapping for directory /computer_lists: Invalid Path
schemamap_add_at: Could not add attribute mapping for NetInfo attribute computers: Invalid Path
schemamap_add_at: Could not add attribute mapping for NetInfo attribute groups: Invalid Path
<=> ad_to_dsdata_type attribute=apple-password-server-location type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-config-realname type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-data-stamp type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-group-realname type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=gidNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=apple-group-homeurl type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-group-homeowner type=DataTypeCStr
<=> ad_to_dsdata_type attribute=memberUid type=DataTypeCStr
<=> ad_to_dsdata_type attribute=gidNumber type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=homeDirectory type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-user-homequota type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-user-mailattribute type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-user-printattribute type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-user-adminlimits type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-user-picture type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=loginShell type=DataTypeCStr
<=> ad_to_dsdata_type attribute=shadowLastChange type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=shadowExpire type=DataTypeCaseCStr
<=> ad_to_dsdata_type attribute=authAuthority type=DataTypeCStr
<=> ad_to_dsdata_type attribute=apple-preset-user-is-admin type=DataTypeCStr
schemamap_add_oc: Could not add objectClass mapping for directory /people: Invalid Path
<=> ad_to_dsdata_type attribute=userPassword type=DataTypeBlob
<=> ad_to_dsdata_type attribute=cn type=DataTypeCaseUTF8Str
<=> ad_to_dsdata_type attribute=apple-mcxflags type=DataTypeUTF8Str
<=> ad_to_dsdata_type attribute=apple-mcxsettings type=DataTypeUTF8Str
slapd startup: initiated.
==> netinfo_back_db_open
==> netinfo_back_get_ditinfo
>> dnPrettyNormal: <ou=www,dc=cesa12,dc=k12,dc=wi,dc=us>
=> ldap_bv2dn(ou=www,dc=cesa12,dc=k12,dc=wi,dc=us,0)
<= ldap_bv2dn(ou=www,dc=cesa12,dc=k12,dc=wi,dc=us,0)=0
=> ldap_dn2bv(272)
<= ldap_dn2bv(ou=www,dc=cesa12,dc=k12,dc=wi,dc=us,272)=0
=> ldap_dn2bv(16)
<= ldap_dn2bv(ou=www,dc=cesa12,dc=k12,dc=wi,dc=us,16)=0
<<< dnPrettyNormal: <ou=www,dc=cesa12,dc=k12,dc=wi,dc=us>, <ou=www,dc=cesa12,dc=k12,dc=wi,dc=us>
>> dnPrettyNormal: <dc=cesa12,dc=k12,dc=wi,dc=us>
=> ldap_bv2dn(dc=cesa12,dc=k12,dc=wi,dc=us,0)
<= ldap_bv2dn(dc=cesa12,dc=k12,dc=wi,dc=us,0)=0
=> ldap_dn2bv(272)
<= ldap_dn2bv(dc=cesa12,dc=k12,dc=wi,dc=us,272)=0
=> ldap_dn2bv(16)
<= ldap_dn2bv(dc=cesa12,dc=k12,dc=wi,dc=us,16)=0
<<< dnPrettyNormal: <dc=cesa12,dc=k12,dc=wi,dc=us>, <dc=cesa12,dc=k12,dc=wi,dc=us>
<== netinfo_back_get_ditinfo
(Canonical suffix ou=www,dc=cesa12,dc=k12,dc=wi,dc=us)
(Parent naming context dc=cesa12,dc=k12,dc=wi,dc=us referred to cldap://broadcasthost/)
<== netinfo_back_db_open
slapd starting
[/quote:504f3ae0af]

Look at all the errors (e.g. “schemamap_add_oc: Could not add objectClass mapping for directory /computers: Invalid Path”.) Another thing that concerns me is this line: “(Parent naming context dc=cesa12,dc=k12,dc=wi,dc=us referred to cldap://broadcasthost/)” — when running with the network DB, I get this line instead, which makes more sense (to me): “(Child naming context ou=www,dc=cesa12,dc=k12,dc=wi,dc=us referred to ldap://www/)”. I don’t know enough about this to know what’s important, but it seems odd that it would be referring to ‘broadcasthost’ instead of ‘www’.

When I do a search from Address Book, here’s what debug mode ouputs:

[quote:504f3ae0af]sasl_server_new failed: -7
connection_get(7): got connid=0
connection_read(7): checking for input on id=0
ber_get_next
ber_get_next: tag 0x30 len 12 contents:
ber_get_next
ber_get_next: tag 0x30 len 353 contents:
deferring operation
ber_get_next
ber_get_next on fd 7 failed errno=35 (Resource temporarily unavailable)
do_bind
ber_scanf fmt ({imt) ber:
ber_scanf fmt (m}) ber:

>> dnPrettyNormal: <>
<<< dnPrettyNormal: <>, <>
do_bind: version=2 dn=”” method=128
send_ldap_result: conn=0 op=0 p=2
send_ldap_response: msgid=1 tag=97 err=0
ber_flush: 14 bytes to sd 7
do_bind: v2 anonymous bind
do_search
ber_scanf fmt ({miiiib) ber:
>> dnPrettyNormal: <cn=users,dc=cesa12,dc=k12,dc=wi,dc=us>
=> ldap_bv2dn(cn=users,dc=cesa12,dc=k12,dc=wi,dc=us,0)
<= ldap_bv2dn(cn=users,dc=cesa12,dc=k12,dc=wi,dc=us,0)=0
=> ldap_dn2bv(272)
<= ldap_dn2bv(cn=users,dc=cesa12,dc=k12,dc=wi,dc=us,272)=0
=> ldap_dn2bv(16)
<= ldap_dn2bv(cn=users,dc=cesa12,dc=k12,dc=wi,dc=us,16)=0
<<< dnPrettyNormal: <cn=users,dc=cesa12,dc=k12,dc=wi,dc=us>, <cn=users,dc=cesa12,dc=k12,dc=wi,dc=us>
ber_scanf fmt ({m) ber:
ber_scanf fmt (m) ber:
ber_scanf fmt ({m) ber:
ber_scanf fmt (m) ber:
ber_scanf fmt ({m) ber:
ber_scanf fmt (m) ber:
ber_scanf fmt ({m) ber:
ber_scanf fmt (m) ber:
ber_scanf fmt ({M}}) ber:
==> netinfo_back_referrals dn=cn=users,dc=cesa12,dc=k12,dc=wi,dc=us ndn=cn=users,dc=cesa12,dc=k12,dc=wi,dc=us
<== netinfo_back_referrals
==> netinfo_back_search base=cn=users,dc=cesa12,dc=k12,dc=wi,dc=us nbase=cn=users,dc=cesa12,dc=k12,dc=wi,dc=us scope=2
==> dnMakeLocal dn=cn=users,dc=cesa12,dc=k12,dc=wi,dc=us
<== dnMakeLocal (not local to store)
<== netinfo_back_search
==> netinfo_back_op_result dsstatus=2007 rc=10 msg=DSA2007: Path Not Local to Datastore
send_ldap_result: conn=0 op=1 p=2
send_ldap_response: msgid=2 tag=101 err=9
ber_flush: 82 bytes to sd 7
<== netinfo_back_op_result
connection_get(7): got connid=0
connection_read(7): checking for input on id=0
ber_get_next
ber_get_next: tag 0x30 len 5 contents:
ber_get_next
ber_get_next on fd 7 failed errno=35 (Resource temporarily unavailable)
do_unbind
connection_closing: readying conn=0 sd=7 for close
connection_resched: attempting closing conn=0 sd=7
connection_close: conn=0 sd=7[/quote:504f3ae0af]

I know this is a ton of info, but I don’t know what’s important and what’s not. If anyone could help, I’d appreciate it. I could really use this functionality!

[Author]

Posts