Post a Reply
2898 views

Missing mysql.db and some other oddities

  1. 10 years ago

    fnbit

    15 Oct 2014
    Edited 10 years ago by fnbit

    Hi,

    Haven't installed FOP2 since 2.26. Was pleasantly surprised to see some new changes with 2.28 and installed it on a new phone system last night.

    CentOS6
    Vanilla Asterisk 11.6-cert6

    I ran into some issues I though I should share (and my workarounds). I followed the installation docs on the fop2.com site.

    • Missing mysql.db from install packages (2.28 CentOS 386 2.28 64 bit tarballs). I ended up downloading the 2.6 package and using the mysql.db and also the install.sql file from the upgrade Asterisk Manager package. I then added a database user and gave him permissions to the tables and database created. It seems to be ok
    • 404 when signing up for these forums (tested twice, page cannot be found after entering in registration details) My account was still approved
    • Users disappear from interface. I tested Fop2 Manager briefly last night, it seemed to work pretty well once I edited the config files mentioned on these forums and updated the manager credentials, etc in the custom files. Every time I would enter a user it would work (allow logon) until i went to the buttons or groups windows and made changes. At that point the user interface would revert to having no users. I checked the user table and saw no entries after, I didn't look before.

    I ended up going back to my autogen scripts to populate the interface as well as the users (and my custom button/group files) that I use for other installs. I just wanted to share any experience with you guys.

    I like the manager interface either way and look forward to it maturing. I prefer the autogen method but I am a consultant so giving power to the client to make changes is always good.

    I also am interested in the plugins listed in the manager interface. Can they be purchased or installed separately?

    Also what does Final mean on the download page? Are you working on 3.0 now?

    Thanks

    F&B IT

  2. admin

    16 Oct 2014 Administrator

    Hi,

    With version 2.28 there is no need to create tables, as the fop2 manager will create them for you. You only need to create the database and have a user created for mysql with the power of creating tables configured in fop2.cfg

    When using the manager in vanilla asterisk, some things will need to be modified in the .php code, mainly functions-astdb.php , to try to match your environment. There is no way to guess what is an extension vs. a trunk, etc, on any potential asterisk setup out there. There are many assumptions being made in there that can be tweaked or modified for your particular environment/setup.

    Whenever you log into the buttons page, some functions will be run in order to get your extensions/queues/trunks/conferences configuration, and update tables based on that (if there are new extensions, you want them incorporated into fop2 tables). However, your users table should not be changed. that seems more like a bug, not sure if I will be able to try to reproduce the issue locally: to try to understand, you create a user, then go to "fop2 buttons" and when going back to "fop2 users" that user is gone ?

    Best regards,

or Sign Up to reply!