no test email in Maildir

[spence]

HI there,

I have completed the install of the 3.39 toaster, there were no complaints as far as I know...

Vpopmail did not create the tables in mysql, so I dumped the vpopmail table structure from an old toaster and put them in. I successfully created a new domain via vadddomain and a user. Checked the vpopmail talbes and they have been updated.

My issues begin when I try to send a test mail. /var/log/mail/send/current shows the following:

@4000000040709182333473ac new msg 303050
@4000000040709182333473ac new msg 303050
@4000000040709182333473ac new msg 303050
@4000000040709182333473ac new msg 303050
@400000004070918233462304 info msg 303050: bytes 234 from <mailto:sa@mail.whitewire.ca" target="_blank">sa@mail.whitewire.ca> qp 64064 uid 0
@400000004070918233462304 info msg 303050: bytes 234 from <mailto:sa@mail.whitewire.ca" target="_blank">sa@mail.whitewire.ca> qp 64064 uid 0
@400000004070918233462304 info msg 303050: bytes 234 from <mailto:sa@mail.whitewire.ca" target="_blank">sa@mail.whitewire.ca> qp 64064 uid 0
@400000004070918233462304 info msg 303050: bytes 234 from <mailto:sa@mail.whitewire.ca" target="_blank">sa@mail.whitewire.ca> qp 64064 uid 0
@4000000040709182338fbec4 starting delivery 23: msg 303050 to local mailto:whitewire.ca-postmaster@whitewire.ca" target="_blank">whitewire.ca-postmaster@whitewire.ca
@4000000040709182338fbec4 starting delivery 23: msg 303050 to local mailto:whitewire.ca-postmaster@whitewire.ca" target="_blank">whitewire.ca-postmaster@whitewire.ca
@4000000040709182338fbec4 starting delivery 23: msg 303050 to local mailto:whitewire.ca-postmaster@whitewire.ca" target="_blank">whitewire.ca-postmaster@whitewire.ca
@4000000040709182338fbec4 starting delivery 23: msg 303050 to local mailto:whitewire.ca-postmaster@whitewire.ca" target="_blank">whitewire.ca-postmaster@whitewire.ca
@400000004070918233a06c4c status: local 1/10 remote 0/255
@400000004070918233a06c4c status: local 1/10 remote 0/255
@400000004070918233a06c4c status: local 1/10 remote 0/255
@400000004070918233a06c4c status: local 1/10 remote 0/255
@400000004070918233f385bc delivery 23: deferral: /usr/libexec/ld-elf.so.1:_Shared_object_"libmysqlclient.so.12"_not_found/
@400000004070918233f385bc delivery 23: deferral: /usr/libexec/ld-elf.so.1:_Shared_object_"libmysqlclient.so.12"_not_found/
@400000004070918233f385bc delivery 23: deferral: /usr/libexec/ld-elf.so.1:_Shared_object_"libmysqlclient.so.12"_not_found/
@400000004070918233f385bc delivery 23: deferral: /usr/libexec/ld-elf.so.1:_Shared_object_"libmysqlclient.so.12"_not_found/
@400000004070918233fe8df4 status: local 0/10 remote 0/255
@400000004070918233fe8df4 status: local 0/10 remote 0/255
@400000004070918233fe8df4 status: local 0/10 remote 0/255
@400000004070918233fe8df4 status: local 0/10 remote 0/255

and no msg in the Maildir folder. I reinstalled mysql40-client and mysql40-scripts and no luck. libmysqlclient.so.12 is present and lives in /usr/local/lib/mysql/.  That directory is located within /var/run/ld-elf.so.hints.  

I don't know if Im going in the right direction for resolving this. Any help is appreciated!  

Kevin

[matt]

R-einstall mysql-client from ports.

Matt

[spence]

Thanks for the suggestion Matt.

I got no luck    ...

From the port (/usr/ports/databases/maysql40-client/) did make deinstall and then a make reinstall. reboot and sent another test mail.  No change, same error.

I will try it again and rebuild all subsequent portions... (for kicks )

[LogicX]

spence

Thanks for the suggestion Matt. I got no luck    ... From the port (/usr/ports/databases/maysql40-client/) did make deinstall and then a make reinstall. reboot and sent another test mail.  No change, same error. I will try it again and rebuild all subsequent portions... (for kicks )

IIRC -- thats the lib version # from mysql41 versions...
so you must've had some mysql41 stuff installed, compiled some package against it, and then uninstalled mysql41...
the really cheap solution would be to locate libmysqlclient.so.10 (the mysql40 version) -- probably in /usr/lib/mysql/libmysqlclient.so.10 or /usr/local/lib/mysql/libmysqlclient.so.10 -- and then just make a symlink to it called libmysqlclient.so.12 in the same dir

-Mike

[spence]

Thanks for the suggestion LogicX.  I am no where near my mail server to work on it. (Also trying not to work on it on vacation). Ill give it a shot next week and post a reply.

Thanks
spence

[spence]

Hello,

I'm back in the saddle to battle qmail...

I did install mysql41client and then deinstalled it. I also installed mysql40client again. No change in log file. libmysqlclient.so.12 does exist and is within /usr/local/lib/mysql/.  

I read the man page for ld-elf.so.1.  To my understanding it is used to call the libmysqlclient when needed. The directories that it searches are controlled by the /var/run/ld-elf.so.hints file. Within that file, at the end, I can see the /usr/local/lib/mysql directory listed.

Not sure about this next part...

ldconfig is used to configure the hints file that gets processed. I did the following:

          # ldconfig -r |grep mysqlclient.so.12        31:-lmysqlclient.12 => /usr/lib/libmysqlclient.so.12        258:-lmysqlclient.12 => /usr/local/lib/libmysqlclient.so.12        304:-lmysqlclient.12 => /usr/local/lib/mysql/libmysqlclient.so.12

Is this an issue related to lmysqlclient.12 instead of libmysqlclient.so.12? Or am I on a wild tangent beyond the dark side of the moon?  

Kevin

[spence]

Hi All,

I am learning tonnes with this one... But still can't figure this out. I have completely uninstalled all mysql componets, client/server/scripts and p5 module. Did this for both 40 and 41.  Checked folders from /usr onward and there is no sign of and installation of mysql.

Followed the toaster from the toaster_setup -s mysql and onward.

When I was finished, checked installed pkg's...

# pkg_info | grep mysqlmysql-client-4.0.18_1 Multithreaded SQL database (client)mysql-server-4.0.18_1 Multithreaded SQL database (server)p5-DBD-mysql-2.9003 MySQL driver for the Perl5 Database Interface (DBI)

So there is no sign of any other installation of mysql. I am still getting the same error.

limysqlclient.so.12 does exist in /usr/local/lib/mysql, which is also one of the paths located in ldconfig -r (as shown above).  

I don't know... format reinstall?  

thanks,
kevin

[davidcl]

spence

# ldconfig -r |grep mysqlclient.so.12        31:-lmysqlclient.12 => /usr/lib/libmysqlclient.so.12        258:-lmysqlclient.12 => /usr/local/lib/libmysqlclient.so.12        304:-lmysqlclient.12 => /usr/local/lib/mysql/libmysqlclient.so.12

You should not have 3 copies of libmysqlclient.so.12, with three different paths, in your dynamic library hints.

Do all three exist?  If not, there's your problem.  Re-run ldconfig (without any options) so it re-scans the various directories and removes the missing libraries from the hints file.

If all three do exist, you might want to try removing the ones that aren't from your current installation of MySQL.  Remove the library, then re-run ldconfig.

[spence]

Well I got it working for the most part.  I killed all mail related services removed all the mail related packages and installed *almost* from scratch. Mail is in the directory now.

[ozric]

I have a simular problem.  My Toaster was fully functional and working.  I then upgraded MySQL to 4 and get this now when I connect thru squirrelmail or sqwebmail:

Jul 23 19:59:45 ozric imapd: DEBUG: Connection, ip=[::ffff:127.0.0.1]Jul 23 19:59:45 ozric imapd: /usr/libexec/ld-elf.so.1: Shared object "libmysqlclient.so.10" not found, required by "authvchkpw"

However, I can locate that file.
[ozric:/usr/local/etc]# locate libmysqlclient.so.10
/usr/local/lib/mysql/libmysqlclient.so.10

Ran cvssup & portupgrade -ai to be sure not to upgrade qmail, ucspi, etc.
Even ran pkgdb -F to link dependancies to the new version.

I assume this error is because of the previous version of MySQL 3 I had and somehow I can't get it to recognize version 4.

My toaster-watcher.conf variable was changed too:
install_mysql                  = 4

spence (or anyone), can you give more details on how you got this working?

Thanks!

FreeBSD 4.10
Toaster 3.42

[ozric]

What I ended up doing was deinstalling MySQL and reinstalling, making sure the /usr/local/lib/mysql dir was deleted before hand.

Still gave me the error, so I created a sym link from libmysqlclient.so.10 to libmysqlclient.so.12 and it works.

libmysqlclient.so.10@ -> libmysqlclient.so.12

Not sure how this will effect future upgrades though, and seems more like a work-around than a fix.