Znuny and ((OTRS)) Community Edition

Hello to all good people. I would like to make it so that when I set a ticket as "Pending" and set the date and time, I get a notification at the correct time and only once, and after I set the ticket as "Pending" again I get another notification again at the set time only. When ...

Bingo.

I created user and granted all privileges for my db (for otrs.*) only.
Thank You very much.

I had to change character set to utf8. Should I to change collation to utf8_bin, too?

Have a nice day, people.

Sorry for the long pause. I needed to do a lot of other things.

So, Yes. The root password is the same as the password used for "mysql -u root -p".

Could the problem be that I'm not a sudo user?

if your Znuny installation is on the same host as your database it should work very simple Use the Installer UI enter root / mysqlRootPassword and the installer will create for you database + user + permissions have you done/tried this already? also have you tried to use localhost instead of 127.0....

wurzel wrote: ↑16 May 2022, 18:00 hi,

did you read my postings?

Flo

Hello Flo,

Yes, I was looking at it. Thank You for it. I'm still thinking about how to do it. I thought installing Znuny according to the instructions would be easy, but it won't work that way.

Ok. So, I have these databases +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | +--------------------+ and these users +-----------+-------------+----------+-----------------------+ | Host | User | Password | plugin | +-----------+---...

Hello people.

I apologize for the delay in my response.

Here are screen screenshots, including a log listing.

from /var/log/apache2/error.log [Fri Apr 22 12:21:32.895757 2022] [mpm_prefork:notice] [pid 828] AH00163: Apache/2.4.53 (Debian) mod_perl/2.0.11 Perl/v5.32.1 configured -- resuming normal operations [Fri Apr 22 12:21:32.896533 2022] [core:notice] [pid 828] AH00094: Command line: '/usr/sbin/apache2' ...

Hello. Of course, my root has password. And I found in my Debian 11, that bind is localhost (in /etc/mysql/mariadb.conf.d/50-server.cnf) # # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # this is read by the standalone daemon and emb...

Hello. I can't connect or create database during instalation. I did this https://doc.znuny.org/manual/releases/installupdate/install.html and in Firefox go to ...otrs/installer.pl and in the step 2 message appears "Can't connect to database". But it seems, that in instalation manual is not...