nebulo
Members-
Posts
20 -
Joined
-
Last visited
Everything posted by nebulo
-
Internal PHP error: #2 Undefined array key "groups"
nebulo replied to nebulo's question in General Discussion
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. -
Internal PHP error: #2 Undefined array key "groups"
nebulo replied to nebulo's question in General Discussion
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. -
Internal PHP error: #2 Undefined array key "groups"
nebulo replied to nebulo's question in General Discussion
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.json Unfortunately today I recognized the file just contains: Internal PHP error: #2 Undefined array key "groups" Any idea what could be the reason for this?
-
I am planning to setup a mailinglist-manager along with my froxlor-setup
nebulo replied to nebulo's question in General Discussion
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 -
I am planning to setup a mailinglist-manager along with my froxlor-setup
nebulo replied to nebulo's question in General Discussion
It looks like Ubuntu 22.04 is missing a proper apt-package for mailman3. Probably I'll try sympa. -
I am planning to setup a mailinglist-manager along with my froxlor-setup
nebulo replied to nebulo's question in General Discussion
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? -
Export of settings via froxlor-cli doesn't work
nebulo replied to nebulo's question in General Discussion
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.exportSettings This produces the error: The export via the admin-panel works fine. Can somebody confirm whether this is working and my individual problem or a bug.
-
How to use froxlor-cli for api-calls / how to provide parameters?
nebulo replied to nebulo's question in General Discussion
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. -
How to use froxlor-cli for api-calls / how to provide parameters?
nebulo posted a question in General Discussion
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! -
Update 2.0.21 to 2.0.22 failed Sql Exception
nebulo replied to MeinerEiner's question in General Discussion
Thank you! This seems to fix it. At least I got: Successfully imported settings from 'froxlor-settings.json' -
Update 2.0.21 to 2.0.22 failed Sql Exception
nebulo replied to MeinerEiner's question in General Discussion
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 -
Update 2.0.21 to 2.0.22 failed Sql Exception
nebulo replied to MeinerEiner's question in General Discussion
This seems to fix it. I am able to login, now. And you're right with your assumption: -
Update 2.0.21 to 2.0.22 failed Sql Exception
nebulo replied to MeinerEiner's question in General Discussion
I've applied the change, but I am still getting the same Uncaught exception. Do I need to apply this before the installation? -
Update 2.0.21 to 2.0.22 failed Sql Exception
nebulo replied to MeinerEiner's question in General Discussion
mysql --version mysql Ver 15.1 Distrib 10.6.12-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper -
Update 2.0.21 to 2.0.22 failed Sql Exception
nebulo replied to MeinerEiner's question in General Discussion
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: jammy Tried 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}