Running Mailpiler "./configure" keeps failing with error "configure: WARNING: unrecognized options: --with-database"

Issue #116 resolved
John Herrick created an issue

Hi there.

There's a single instance of this error in the "Issues" section, which does not help me. I don't know why I keep getting this error, or if I should just keep going.

Please let me know what I should check for. Google isn't helping much.

See screen shot

Comments (36)

  1. John Herrick reporter

    Okay, so it seems to have worked. But now when trying "sh init.d/rc.piler start", I get:

    starting piler . . . cant connect to mysql server

    Where's the config file for this, please?

  2. Janos SUTO repo owner

    By default it's /usr/local/etc/piler.conf. Look for the mysqlsocket parameter, you may need to fix it.

  3. John Herrick reporter

    Okay, I believe I've fixed that. And now I'm getting a Sphinx error I can't figure out when invoking sh init.d/rc.searchd start:

    rc.searchd start

    I'm on all of a few pages in (still have a ways to go), and I already wish they had one of these in TurnkeyLinux's inventory. I'll be honest, if I could figure out how to build this and get through from start-to-finish, I'd create a "vanilla" ISO/OVF/VM for the general community. Really.

    I've been trying to figure out Sphinx as it is. I've installed, then re-installed, and I still don't see the "test" queries for Sphinx anywhere. And online resources aren't helping, either. I don't know where in there I went wrong.

  4. Janos SUTO repo owner

    I think you are using a wrong sphinx.conf file. You should overwrite the OS shipped version with the piler version of sphinx.conf.

    "mydomains" is no longer a piler.conf variable, rather it's an internal list in piler read from the database.

  5. John Herrick reporter

    So it got further, but there's some config in that sphinx.conf file that it doesn't like:

    root@joc-emailarchiving /tmp/jsuto-piler-c6099145f45c# sh init.d/rc.searchd start
    starting searchd . . .
    Sphinx 2.0.8-id64-release (r3831)
    Copyright (c) 2001-2012, Andrew Aksyonoff
    Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)
    
    using config file '/etc/sphinxsearch/sphinx.conf'...
    listening on 127.0.0.1:9312
    listening on 127.0.0.1:9306
    precaching index 'main1'
    WARNING: index 'main1': preload: failed to open /var/piler/sphinx/main1.sph: No such file or directory; NOT SERVING
    precaching index 'main2'
    WARNING: index 'main2': preload: failed to open /var/piler/sphinx/main2.sph: No such file or directory; NOT SERVING
    precaching index 'main3'
    WARNING: index 'main3': preload: failed to open /var/piler/sphinx/main3.sph: No such file or directory; NOT SERVING
    precaching index 'main4'
    WARNING: index 'main4': preload: failed to open /var/piler/sphinx/main4.sph: No such file or directory; NOT SERVING
    precaching index 'dailydelta1'
    WARNING: index 'dailydelta1': preload: failed to open /var/piler/sphinx/dailydelta1.sph: No such file or directory; NOT SERVING
    precaching index 'delta1'
    WARNING: index 'delta1': preload: failed to open /var/piler/sphinx/delta1.sph: No such file or directory; NOT SERVING
    precaching index 'tag1'
    WARNING: index 'tag1': preload: failed to open /var/piler/sphinx/tag1.sph: No such file or directory; NOT SERVING
    precaching index 'note1'
    WARNING: index 'note1': preload: failed to open /var/piler/sphinx/note1.sph: No such file or directory; NOT SERVING
    FATAL: no valid indexes to serve
    

    Not sure what's going on. I did switch to your sphinx.conf file. I'll try again.

    The base server/OS is just a simple TKL LAMP stack. I can provide the sphinx.conf file upon request.

  6. John Herrick reporter

    Y'know, I've been trying to find a comprehensive build, start-to-finish, for Mailpiler. Honest to goodness, I'm trying really hard to make this work. The instructions say solely all sorts of prerequisites, many of which I haven't installed or configured before piler. So please forgive my stumbling here ... its just a first time for me.

  7. John Herrick reporter

    Trying to add rc.piler to startup doesn't seem to work, either:

    root@joc-emailarchiving /etc/init.d# update-rc.d rc.piler defaults
    update-rc.d: using dependency based boot sequencing
    insserv: script rc.piler is not an executable regular file, skipped!
    
  8. John Herrick reporter

    Okay.

    I've started over (didn't delete, just started new VM). Using Debian 6.0.7, LAMP stack but removing MySQL. Using root. First thing was to install Sphinxsearch (not from repos, straight from http://sphinxsearch.com). I can't even index, I get the following:

    Sphinxsearch_fails

    I'm not even sure if I should continue with the installs after that, or if its not that big a deal. From what I remember, I don't need their conf file, just yours. Is this a big deal?

    I'm going to continue, tbh. You tell me if I should use another distro or something else.

  9. Janos SUTO repo owner

    OK, I have two ideas:

    #1: if you gave me ssh access, then I'd install and configure it for you

    #2: if you have vmware (or vcenter) there's a recent OVA file.

    If none of these is possible than let's do a guided install through teamviewer or something.

  10. Janos SUTO repo owner

    I also noticed that you are trying to install 0.1.23. I recommend you to try the latest master branch. It has new features, bugfixes, etc. worth to try with. And it honors the --with-database=mysql configure option.

  11. John Herrick reporter

    Wait, there's a recent OVA/OVF file? Where? That was the first thing I looked for. I'm building this in vCenter specifically.

    Also, you already linked me to your "master" file, e.g. 0.1.24, which is what I have been using.

  12. John Herrick reporter

    Is this 0.1.23 or 0.1.24?

    Can I add the "highly recommended" components to the VM?

    Is the 2nd .VMDK expandable? Since it's LVM, I'm wondering/assuming we can expand it (from 10GB to, say, the 2TB limit) and be able to add more vDisks to the VM, which will just be added to the LVM ... amirite?

  13. Janos SUTO repo owner

    Sure, you can add any components, it's yours. The 2nd disk is expandable (I think), but you are free to add another one and extend the LVM.

    Its version is closer to 0.1.24 than to 0.1.23. I think it's a good candidate to evaluate piler, and in the meantime I can finish the final 0.1.24.

  14. Janos SUTO repo owner

    All of the post install stuff should be done. You can verify cron jobs by running:

    crontab -l -u piler

    You don't have to reconfigure sphinx, it's ready to use. All you have to do is to fix your network settings (IP-address, etc.), edit the ngnix vhost parameters (/etc/nginx/sites-available/piler), and the gui settings (/var/www/piler.yourdomain.com/config-site.php), and that's it, you are good to go.

  15. John Herrick reporter

    Great. I've attempted the SSO setup, and now I can't get apache2 to reload. First the "no MPM". I got one to install, and now it's not allowing (nginx holding onto the port). Now what?

  16. John Herrick reporter

    SSO wasn't a demand, but another tool I've used recently (Passwordstate) uses it's SSO passthrough via browser, and it picked up pretty quick. That's all I was hoping for.

    I deployed the OVA file, made a bunch of config changes, and I don't have faith in the VM. I'm going to re-deploy, and I'd like to ask you for where exactly to change a few simple (or not) things: - Server IP - Where how to point /var (we're going to use 2TB LUNs, we have over 4TB of mail to use this with and more coming - SSO setup (I realize now that nginx was using port 80, your site's "SSO" instructions didn't mention anything about configuring change ... which is why I just followed their instructions), or guidance as to whether it's a smart or bad idea (in production) - Any tweaks & changes I should make for a production environment

    I want to do this right - and I want you to have full credit for it. I'll re-deploy now.

  17. Janos SUTO repo owner
    1. networking stuff: /etc/network/interfaces

    (set all settings related to eth0 to match your network parameters)

    1. nginx config: /etc/nginx/sites-enabled/piler

    (set the "listen" and "servername" parameters)

    1. /var/www/piler.yourdomain.com/config-site.php

    set the following: SITE_NAME, SITE_URL, SMTP_DOMAIN, SMTP_FROMADDR, ADMIN_EMAIL, PILER_HOST (this is the IP-address of the VM), and SMARTHOST (this is the address of an smtp server willing to relay for piler, perhaps your Exchange server).

    If these are all set, then perhaps it's a good idea to reboot the VM to make sure everything is set.

    If you plan to use several 2 TB disks, then it may be a good idea to relocate the /var/lib/mysql directory to the new (big) disk, probably LVM.

    When the final 0.1.24 is out I'll update or recreate the OVA having the VM. Perhaps it's better to put / and /var to LVM and not to create a separate partition to /var/piler, and this way the mysql data directory is also on LVM.

    Let me know if you need further assistance.

  18. John Herrick reporter

    That actually makes a lot of sense (the /var and / on LVM). Nonetheless, I couldn't have gotten this far without a lot of your help.

    Thank you.

  19. John Herrick reporter

    Have you considered using Webmin? I know trying to get it installed on the VM is like pulling teeth, so many unmet dependencies...

  20. Janos SUTO repo owner

    well, the purpose of the VM is to give users a fast way to deploy and try piler without installing and configuring much. I've installed the most necessary stuff only. If you need munin perhaps, then you are free to install it. So if you need webmin, then go ahead and get it, I personally don't need it.

    However, I beg your pardon, but I recommend the installation service (http://www.mailpiler.org/en/piler-install-service.html) instead of webmin :-)

    But again I'm ok with webmin, and I don't try to prevent you to use it in any means.

    Anyway the next install will feature LVM on / and /var, and perhaps it might be better if you don't just need a test, but rather a permanent install.

  21. John Herrick reporter

    Using your login details found here, can't get in. Tried "@local" and "@<my domain>", no joy. Am I misunderstanding something?

    UPDATE: Nevermind. Totally blew past my own mistake. Tried to point to local MySQL server instead of using built-in. This IS a VM with its own. I'll have to export the DB. Jeez', feel like a *$#(%@ ...

    Which brings me to ... what's the piler MySQL "root" login?

  22. John Herrick reporter

    Yes, I see the local interface.

    Actually, it still shows piler.yourdomain.com status, even though I've changed configs everywhere I can find. And the interface (under "Master Admin" account) doesn't offer me the chance to change it. What am I missing?

  23. John Herrick reporter

    Now it's a graphic logo. Tried, getting a missing icon.

    See broken icon

    Custom IMG here:

    Image Source Code available upon request....

    Just a tweak or two left...

  24. Janos SUTO repo owner

    There should be a directory "images" under the documentroot (/var/www/piler.yourdomain.com). Put the image there, and don't change the branding logo definition in config-site.php

  25. Janos SUTO repo owner

    it's up to you. LHM_IST.jpg is just fine, it's set properly in config-site.php. All you have to do is just move the image to /var/www/piler.yourdomain.com/images, and you are done.

  26. Log in to comment