FB Twitter YouTube LinkedIn GitHub G+
James Joseph

Profile Details

Toggle Sidebar
Recent updates
  • Patrick de Brabander wrote:

    The configuration file is working, but not backing up my Zarafa.

    I've check in phpmyadmin and there are 2 databases: 'Main Database' and 'System Database'
    Zarafa is stored in the 'System Database'.



    The script is now only backing up the 'Main Database'


    How to backupo the system-database ?


    IIRC system-mysql is not on the standard mysql port it is on 3308 instead you can check this by doing lsof -i:3308 or netstat -l -n -t |grep 3308

    In the conf file you'll see this line: #CONFIG_mysql_dump_port=3306

    un comment it and change the dump port to 3308 instead that should back up the zarafa database.

  • Patrick de Brabander wrote:

    James Joseph wrote:


    You didn't put in the location of your sandbox mysql also as I stated make sure you do this in path:

    PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump

    Also did you link the mysql.conf file to the automysql backup script?


    Sorry. I've copied the wrong config output.





    How do you link mysql.conf to the autobackupscript ?


    At the top of the first script it should tell you about the .conf file location either put it in /etc/ where it tells you to or you might be able to change the location of where it should be.

  • Patrick de Brabander wrote:

    James Joseph wrote:


    You didn't put in the location of your sandbox mysql also as I stated make sure you do this in path:

    PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump

    Also did you link the mysql.conf file to the automysql backup script?


    Sorry. I've copied the wrong config output.





    How do you link mysql.conf to the autobackupscript ?


    At the top of the first script it should tell you about the .conf file location either put it in /etc/ where it tells you to or you might be able to change the location of where it should be.

  • Patrick de Brabander wrote:

    Somehow the autobackup script is not working with Zarafa.
    Backing up the other database is not working.





    Backup with standard command is working


    You didn't put in the location of your sandbox mysql also as I stated make sure you do this in path:

    PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump

    Also did you link the mysql.conf file to the automysql backup script?

  • Patrick de Brabander wrote:

    James Joseph wrote:

    [quote]Patrick de Brabander wrote:

    i've managed to change de LDAP settings with ApacheDirectoryStudio.

    Thanks James.


    Now trying to get the migration-tool working.


    Glad it's working, if you ever get time I'd consider testing backing up and restoring with mysql instead of PST files. This is the backup script I use for mysql: http://sourceforge.net/projects/automysqlbackup/

    It's much easier then you think it is and for an administrator and company it saves an massive amount of downtime especially if something bad goes wrong it pays to have backups of the database for things like this :).

    Hope your migration goes well.


    Thanks for your help.
    Unfortunately the migration-tool is not working. Can not comnect to the server.
    The user has zarafa admin rights...... beats me...

    The backup script looks goods and i will definitely install it shortly
    Does this work directly with the zarafa database or do i need to change a lot of parameters ?[/quote]


    Sorry for the late reply, it depends on what mysql you're using.

    If you're using the standard mysql from the repos then all you need to do is:

    * put in either the root mysql username and pass or the zarafa mysql user and pass and select the database of zarafa or you can get backups of all databases by selecting all.

    If you are using the clearos system-mysql then you will need to change a few things...


    There's a conf file that comes with this script you'll see this:

    # Edit $PATH if mysql and mysqldump are not located in /usr/local/bin:/usr/bin:/bin:/usr/local/mysql/bin
    #PATH=${PATH}:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQL:FULL_PATH_TO_YOUR_DIR_CONTAINING_MYSQLDUMP

    You'll need to change it to:


    PATH=${PATH}:/var/lib/system-mysql:/usr/clearos/sandbox/usr/bin/mysqldump

    Then in the conf put in the zarafa mysql user and password and the name of the zarafa database in the databases you want to backup.

    Try to see if that works when backing up it should. Then once you backup you simply need to import the database just follow that link that Ben posted for restoring the database onto the new server.

  • Patrick de Brabander wrote:

    i've managed to change de LDAP settings with ApacheDirectoryStudio.

    Thanks James.


    Now trying to get the migration-tool working.


    Glad it's working, if you ever get time I'd consider testing backing up and restoring with mysql instead of PST files. This is the backup script I use for mysql: http://sourceforge.net/projects/automysqlbackup/

    It's much easier then you think it is and for an administrator and company it saves an massive amount of downtime especially if something bad goes wrong it pays to have backups of the database for things like this :).

    Hope your migration goes well.

  • Patrick de Brabander wrote:

    Well, i've installed ClearOS 7 and purchased the Zarafa Home edition.
    All is working, but importing the old-emails back in to the zarafa server is a bit difficult.
    Since MAPI is not supported in the home edition (my mistake to choose this version) and copying the emails back form the .pst files using IMAP or EAS does not work properly.

    All the mails form local users are misformed in the email address. for example john@mail.com (John Doe) is now in JohnDoe als email address.

    Now i'm trying to use the migration-tool, but i don't have a user who is an Admin. :( :(

    After spending hours getting this to work, i've found out that you need to install LDAPADMIN.
    I've install LDAPADMIN, but when i'm trying to access this, i het the following error:

    Forbidden

    You don't have permission to access /phpldapadmin on this server.


    made some changes to phpldapadmin.conf


    and changed Deny from All in to Allow from All, etc...
    Still no access:(

    Who can help me to give a user admin privileges


    Is this from zarafa to a zarafa server?

    If it is why don't you do a mysqlpdump of the database import the database and rsync the attachments to the /var/lib/zarafa/attachments folder?

    That should work perfectly fine and it's what I've used to move zarafa from one server to another.

    If this is from a differen't e-mail server all together and not zarafa I use apache directory studio to access ldap on the server: https://directory.apache.org/studio/

    do a ssh tunnel of secure ldap to your localhost :


    Then open up apache directory studio create a new ldap connection.

    The server is: localhost
    Connection security: SSL
    port is: 636

    Put in your bind username and then password, your clearos home should have those details in the directory information, click on test connection. Accept untrusted certificates and you should be connected. Click on finish and you'll have access to your ldap server.

    Then go to your user account you want to enable zarafa admin rights to right click on a field and add attribute and search something like zarafaAdmin or something like that.

    Set the value to: 1

    Restart zarafa server and when you check out the details of the user:



    You should get an output like this
    Administrator: yes

    Hope this helps. However I would strongly recommend doing the mysql dump and import and syncing the attachments folder if it is an zarafa server you are moving from it's the quickest and painless migration you will do.

    You may need to unhook and re-hook mailboxes though as they may not be attached to the right users.

    For that problem I simply go onto the old server and do zarafa-admin --details user and make sure it's the right size.

  • Patrick de Brabander wrote:

    James Joseph wrote:

    [quote]Patrick de Brabander wrote:

    I've tried yesterday to install the new ClearOS 7.1 on my test server and found out that you need pay for Zarafa yearly.

    Does this mean that the payment i've alredy made for the previous version of zarafa expired ?
    I thought this was one time payment for community users.


    When I asked this in another thread it's a new change for ClearOS you need to pay a yearly fee even if you already have a subscription to Zarafa on clearos 6.

    However you can still keep your version of zarafa and it won't stop working if you don't elect to pay, I assume it just means you will no longer get updates?

    Personally we are a re-seller for zarafa so we only used the clearos version as it provided a nice app plugin and we updated zarafa ourselves manually. I'm happy for there to be a one off version which just does the initial install and configures the app in the web interface personally without having any further updates.




    How did you install Zarafa within ClearOS 7 ?
    In the marketplace you can add Zarafa to your installation, but i expect you have pay before installation.

    I don't mind to pay for an app, but €50,00/year is a lot for a community package.
    Also what are getting for this money.[/quote]

    I've tried both options installing zarafa manually using packages and installing using the app. I've elected to go install using the app as it's less fiddly and I don't need to use an ldap browser to manually configure things like enabling users in zarafa etc and setting quotas for e-mail accounts.

    I don't plan to renew the app after the year expires as I'll update zarafa myself. Yes you do have to pay for the app before downloading it onto your system.

    The yearly cost covers getting the latest versions of zarafa, last year Zarafa announced they no longer plan to provide quality tested binaries for non paying customers and anyone using the community version will need to build from source they are currently still providing packages at the moment but I think they plan to provide only source code soon and let the OS maintainers provide the packages themselves: https://community.zarafa.com/pg/blog/read/28386/the-important-role-of-the-zarafa-community-in-zarafas-business-model

    To be fair I think it's a reasonable cost considering it most likely will take a considerable amount of time and effort to re-compile from source into binaries for them to deploy to the clearOS community but as I can get the paid binaries I don't really need that kind of service.

  • Patrick de Brabander wrote:

    I've tried yesterday to install the new ClearOS 7.1 on my test server and found out that you need pay for Zarafa yearly.

    Does this mean that the payment i've alredy made for the previous version of zarafa expired ?
    I thought this was one time payment for community users.


    When I asked this in another thread it's a new change for ClearOS you need to pay a yearly fee even if you already have a subscription to Zarafa on clearos 6.

    However you can still keep your version of zarafa and it won't stop working if you don't elect to pay, I assume it just means you will no longer get updates?

    Personally we are a re-seller for zarafa so we only used the clearos version as it provided a nice app plugin and we updated zarafa ourselves manually. I'm happy for there to be a one off version which just does the initial install and configures the app in the web interface personally without having any further updates.

  • Ldap no longer working "Transport endpoint is not connected" [Resolved but questions to ask]

    This matter is now resolved however I had an issue where Ldap was no longer working.

    I got a call from a client saying they couldn't access e-mails when looking further into it, the ldap was no longer working.

    It seemed that there was an update to clearos to 6.6 that seemed to cause the issue as it got updated on the 28th

    I couldn't go back to backup configs unless it was the 29th due to the new clearos changes (I personally think that minor milestones from 6.5 to 6.6 should allow config file restoration).

    I tried a few tips from these threads:

    https://www.clearos.com/clearfoundation/social/community/failed-to-bind-to-ldap-server
    https://www.clearos.com/clearfoundation/social/community/openldap-not-starting-anymore-today-on-several-systems

    None seemed to work, in the end I was lucky I had rdiff backups of /var/lib/ldap from a few days ago that allowed me to recover the data (Thank god for backups!).

    To do the recovery process I did:



    While this matter is resolved it is concerning that if it was a problem to begin with. Happy to help with any information someone wants to ask regarding this.