nebulo
-
Posts
20 -
Joined
-
Last visited
Posts posted by nebulo
-
-
It looks like it is working again. I suspect it works after I've created an export via the WebUI which worked immediately. I'll keep an eye on this.
-
5 minutes ago, d00p said:
is "froxlor" an admin-user in your froxlor installation?
Yes froxlor is actually the admin-user. I am pretty sure that it worked in the past.
-
Hello everybody,
I am creating a nightly export of the froxlor-settings using a cronjob:
/var/www/html/froxlor/bin/froxlor-cli froxlor:api-call froxlor Froxlor.exportSettings > /var/customers/froxlor-settings.backup.jsonUnfortunately today I recognized the file just contains:
Internal PHP error: #2 Undefined array key "groups"Any idea what could be the reason for this?
-
After some evaluation and tinkering with sympa which I finally got it working. Nevertheless I decided to give mailman3 a try because sympa just felt a little unwieldy. I just want to mention the api based on web-services.
I've installed mailman3 using https://github.com/galaxyproject/ansible-mailman3. This worked more or less. There was some issue with the python/django version and the latest release of mailman3 which has been resolved with the latest release 3.3.9 of mailman3.
There is only one thing you need to do manually after applying the role ansible-mailman3 first which is to add 'allauth.account.middleware.AccountMiddleware' in the MIDDLEWARE array in /opt/mailman3/lib/python3.10/site-packages/mailman_web/settings/base.py and run the role again.
I've created an additional ansible-role to do the necessary postfix changes: https://codeberg.org/ansible-galaxy/ansible-role-postfix-mailman
-
It looks like Ubuntu 22.04 is missing a proper apt-package for mailman3. Probably I'll try sympa.
-
Thank you for your feedback! I don't care that it is not manageable via froxlor it should just not interfere with it ;). So from your perspective/experience adding the required config to postfix-config should not be a problem or do you expect any obstacles?
-
Are there any recommendations? Is anybody here who tried mailman3, sympa, ... on top of froxlor postfix-setup? Are there any good guides available?
-
Hm very strange. After I've opened "System Settings" and enabled "Hide incompatible settings" it works. But I had some problem to save "System Settings" again afterwards. I got the message: "Invalid MySQL host address: [<public ipv6>]". The latter seemed to be caused by one or more entries in "MySQL-Access-Hosts". After I've removed all public ips (v4 and v6) - which are not reachable anyway because of firewall-rules - I am able to change and save settings again.
-
Hello everybody,
I am currently facing an issue using the froxlor-cli. I am not able to export my settings via froxlor-cli. I am trying to do it via:
/var/www/html/froxlor/bin/froxlor-cli froxlor:api-call froxlor Froxlor.exportSettingsThis produces the error:
QuoteInternal PHP error: #2 Undefined array key "groups"
The export via the admin-panel works fine.
Quote- Froxlor: 2.0.23-1 (202304260)
- froxlor update-channel: stable
- Serversoftware: Apache/2.4.52 (Ubuntu)
- PHP-Version: 8.1.2-1ubuntu2.14
- MySQL server version: 5.5.5-10.6.12-MariaDB-0ubuntu0.22.04.1
- Webserver interface: APACHE2HANDLER
- Kernel: 5.15.0-83-generic (x86_64)
- OS: jammyCan somebody confirm whether this is working and my individual problem or a bug.
-
Thanks for the amazing fast feedback!
Of course the '-s' is a mistake but I struggeled with how to provide the parameters in the array.
Just for documentation: The following works.
Quotefroxlor-cli froxlor:api-call froxlor Customers.add '{"email": "info@example.com", "company": "example inc", "new_loginname": "example"}'
-
Can someone please tell me how to use the froxlor-cli for api-calls e.g. to add a customer?
I tried the following and several other ways to provide the parameters but it doesn't seem to work.
bin/froxlor-cli froxlor:api-call -s froxlor Customers.add '{"email": "mail@example.com", "company": "example-inc", "new_loginname": "example"}'Thanks in advance!
-
Thank you! This seems to fix it. At least I got:
Successfully imported settings from 'froxlor-settings.json'
-
One addition that might be as well related and is not fixed with the above changes. If I execute `/var/www/html/froxlor/bin/froxlor-cli froxlor:config-services -i froxlor-settings.json` I am getting:
PHP Warning: Trying to access array offset on value of type null in /var/www/html/froxlor/lib/Froxlor/Domain/IpAddr.php on line 78 PHP Warning: Trying to access array offset on value of type null in /var/www/html/froxlor/lib/Froxlor/Domain/IpAddr.php on line 82 PHP Fatal error: Uncaught TypeError: implode(): Argument #1 ($pieces) must be of type array, string given in /var/www/html/froxlor/lib/Froxlor/Domain/IpAddr.php:82 Stack trace: #0 /var/www/html/froxlor/lib/Froxlor/Domain/IpAddr.php(82): implode() #1 [internal function]: Froxlor\Domain\IpAddr::getIpPortCombinations() #2 /var/www/html/froxlor/lib/Froxlor/UI/Form.php(200): call_user_func() #3 /var/www/html/froxlor/lib/Froxlor/UI/Form.php(219): Froxlor\UI\Form::prefetchFormFieldData() #4 /var/www/html/froxlor/lib/Froxlor/SImExporter.php(177): Froxlor\UI\Form::processForm() #5 /var/www/html/froxlor/lib/Froxlor/Cli/ConfigServices.php(138): Froxlor\SImExporter::import() #6 /var/www/html/froxlor/lib/Froxlor/Cli/ConfigServices.php(80): Froxlor\Cli\ConfigServices->importSettings() #7 /var/www/html/froxlor/vendor/symfony/console/Command/Command.php(298): Froxlor\Cli\ConfigServices->execute() #8 /var/www/html/froxlor/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run() #9 /var/www/html/froxlor/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand() #10 /var/www/html/froxlor/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun() #11 /var/www/html/froxlor/bin/froxlor-cli(66): Symfony\Component\Console\Application->run() #12 {main} thrown in /var/www/html/froxlor/lib/Froxlor/Domain/IpAddr.php on line 82 -
This seems to fix it. I am able to login, now.
And you're right with your assumption:
Quotetotally clean fresh install without any customers / domains / etc.
-
I've applied the change, but I am still getting the same Uncaught exception. Do I need to apply this before the installation?
-
mysql --version mysql Ver 15.1 Distrib 10.6.12-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper -
I am experiencing the same or a similar issue with a new installation.
Distributor ID: Ubuntu Description: Ubuntu 22.04.3 LTS Release: 22.04 Codename: jammyTried it multiple-times with cli only and using the wizard. I am always getting:
Uncaught exception 500 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `d`.`email_only` = '0' AND `d`.`id` NOT IN ()' at line 3 #0 /var/www/html/froxlor/lib/Froxlor/Database/Database.php(124): Froxlor\Database\Database::showerror() #1 /var/www/html/froxlor/lib/Froxlor/Database/Database.php(102): Froxlor\Database\Database::pexecute() #2 /var/www/html/froxlor/lib/Froxlor/Api/Commands/SubDomains.php(1074): Froxlor\Database\Database::pexecute_first() #3 /var/www/html/froxlor/lib/Froxlor/UI/Collection.php(132): Froxlor\Api\Commands\SubDomains->listingCount() #4 /var/www/html/froxlor/lib/Froxlor/CurrentUser.php(156): Froxlor\UI\Collection->count() #5 /var/www/html/froxlor/lib/navigation/00.froxlor.main.php(84): Froxlor\CurrentUser::canAddResource() #6 /var/www/html/froxlor/lib/Froxlor/PhpHelper.php(235): include('...') #7 /var/www/html/froxlor/lib/init.php(271): Froxlor\PhpHelper::loadConfigArrayDir() #8 /var/www/html/froxlor/admin_index.php(27): require('...') #9 {main}
Internal PHP error: #2 Undefined array key "groups"
in General Discussion
Posted
No I don't have any custom files in
The issue is that it doesn't work if the command is not executed from withhin the froxlor-base directory even if the path to the froxlor-cli is absolute.