@scottalanmiller said in How to tune or optimize MySQL or MariaDB ?:

What kind of extreme resource limits are you under to produce this concern?

the fact that the web is wealthy with documents and variables to speed up mariadb/mysql

things like:
innodb_buffer_pool_size
innodb_log_file_size
innodb_file_per_table
innodb_flush_log_at_trx_commit
query_cache_size
...etc

All this got me thinking what are the defaults of Centos MariaDB installation, and are they enough to handle any load ?

And the VM have 2GB of RAM btw.

Hi,

I can confirm it is working, and it is alive ...

Thanks for the fix, and sorry for the delay.

however If i can nitpick, I am unable to enable memory cache and file locking.

Look at the screenshots and I dont know really where to put those lines:

'memcache.locking' => '\OC\Memcache\Redis',
'memcache.local' => '\OC\Memcache\Redis',
'redis' => array(
'host' => 'localhost',
'port' => 6379,
),

I tried putting them in 3 places, yet everytime it failed after saving and restarting the server, the webserver no longer boots up.

I know those are more of an optional stuff, but if you have quick fix or suggestion, I will be much in your debt.

I ran into this a lot lately, and I dont know what to use as a good base.

I do google search and find many variables and try to understand as many as possible but the thing is you worry that too much changing would affect the integrity of the database.

And since when optimizing database would require 10 performance variables, why cant we select something pre-made, I recall windows versions had something called small.ini/medium/large.

I dont think I should need to learn all that on top of building an application, I think it is stuff like this why people choose Oracle or MS SQL

This whole thing started when I began using centos with openfire, and I noticed everything is working but when pressing the users/groups in openfire it was slow (5 seconds) to show list of users which is like 60 users, and the same openfire in Windows using the integrated database was much faster, thus I reckon I need to optimize mariadb version 5.

So what is the main thing I should put in /etc/my.cnf
I reckon that it comes reconfigured that it will run in small ram environment perhaps ?

What I want to do is the minimalist config changes that will give me the best performance outcome.

Using InnoDB.

Thanks.

@scottalanmiller

+1 to this, cause I once tried backing up ESXi VMDK to an external drive by plugging the external USB drive to the server...

hehe what a laugh that was, apparently after searching ESXi does not allow cases like this, cause it reserves all the USB and ports for passing through the virtual machines.

Hi,

what are your thoughts on this branch, especially since you can easily download the MS image of it via google search, and after checking it out I reckon I might use it for my desktop.

I tried both 2015 and 2016 and found them very stable and mature with all the latest MS innovation but without the spying and nagging.

It is shame that MS is only pushing for this in the enterprise, especially since its very good option for users like me.

Anybody else thinking about using it for their desktop ? if not what are you using it for ?

@JaredBusch

Hehe no surprise there.

@AlyRagab said in Docker Commit:

any advice to solve such thing ?
Thanks

My advice is to manage Docker from web interface UI, their you can see more of what docker is doing, and very helpful for new docker starters.

Launch or Install Docker UI on port 9000

docker pull uifd/ui-for-docker
docker run -d -p 9000:9000 --privileged -v /var/run/docker.sock:/var/run/docker.sock uifd/ui-for-docker

Then navigate from web browser to http://docker IP:9000

Also I think the issue is that when you exit centos, you exit via ctrl-c thus you end the session all together, what you want to do is run the centos as backrgound, and you can connect to it using another ssh client like putty or even from docker via connect:

Connect to an running Container

docker exec -it Ubuntu_1 bash
or
docker exec -it 7e153095b94f bash

@aaronstuder @JaredBusch

Looks like it is time to Q.A all the other articles at this site and start testing them as well !!!

I'm joking, I love this site/forum and the users that are interactive and supportive.

All the thanks to you Jared for the huge effort, and putting this guide/article that got me motivated to deploy and test, I'm certain you will find out what is wrong and it will something silly.

@JaredBusch

But i disabled selinux and the same issue occurred...

I tried more with HTTPS self signed and also enabled SElinux and did your desired changes but same thing.

I highly believe that if you start from fresh centos and did the above the same scenario will occur.

Lenovo IBM servers have the same thing, free only gives you basic stuff and health monitoring, while paid allows you to remote connect to console.

I checked the license and its around ~300 USD.

They all learn from each other.

@JaredBusch

I think its something related to HTTPS at this moment.

@JaredBusch

Thanks this will help, will give it a detailed look but since its nearing night time where I live, I might try that tomorrow.

@JaredBusch said in Install NextCloud 11.0.2 on CentOS 7 with PHP 7.1 from Remi:

ide are you?

Finished it completely.

@JaredBusch @scottalanmiller

Log have not been created

Hi,

I did the above steps starting from Centos 7 1611 minimal updated.

Got the above results ...

I tried disabling selinux
Changing permissions to 0777 on /var/www/html/nextcloud
disabling the firewalld
same results

I made sure that I am doing everything as above

Thank you for your hard work, and guide. I prefer using it cause your are using PHP7 unlike the rest.

Hi,

I want to ask how normal is this, I have 2008 R2 Guest OS (please let us hold on or at least delay the comments on how old this is) and it is running on ESXi 6.5
With ParaVirtual Network + Disk activated + VMware guest Tools

And when If I boot into safe mode from inside the Guest OS, it will due infinite reboot loop. I reckon this is due to safe mode blocks the driver for the Paravirtual of the disk, not sure. I never noticed (cause I rarely boot into safemode) this but I can recreate it easily by snapshot before I restart into safemode.

Anybody ever experienced the same ?

NVM this was fixed after a last ditch of founding this :

https://www.igniterealtime.org/projects/openfire/plugins-beta.jsp

Do note although the versions and history of the beta plugins look the same, but after downloading them and using the BETA file import/export everything worked as it should.

I was using the latest stable OF which is 4.1.3 and latest stable import/export plugin 2.6.0 however using the one at BETA page shown above fixed the issue.

I have Openfire Installed on Windows Server using the local embedded DB which is Hsqldb

And now after much usage, and getting to know it more and what it can perform using Jingle plugin, it is time to properly treat it and install it on Centos 7 server.

I have successfully finished that task and have Prod server running on Windows with all the users, and Centos fresh install with no user but admin, so I want to copy the users to the Linux server, Do note that Centos OpenFire is using MariaDB.

The Plugin is failing with ''The import file does not match the user schema''

I tried:

Do a search and replace and take out all the extra <Password/> (But I didnt have any extra)
Removing the <roster> element
Using DB visualizor and having access to the local embedded Hsqldb DB, which I did get access but failed to extract any useful data.
Replacing the previous domain with the new domain in the exported XML file.

Nothing worked.

I just want to find a way to export the
User with

his username/password/name to the Centos Openfire

No need for Rooster/Groups

Hello,

I created software VPN VM inside ESXi Host, and its working neat, but I sometimes run into rare situations where I need to turn off all VMs and work on the ESXi host.

And ofcourse if the VM is turned off I no longer can VPN using my client.

What happens is I then I have to rely on (pre-configured) Port forward directly and the not VPN to connect to host, I wonder if its standard for VPN to be created on machine level, and not virtualized level.

Like dedicate small machine just for that, I am eyeing AMD AM1 platform, cause I dont think I will need CPU or DISK I/O amazing speeds, and invest only a good NIC cards.

Does that make any sense, and do you the same ?

I know i can do the VPN on network device like modem/router level, but those are expensive, going for my alternative would be cheaper, correct ?

If I can drop in, and ask something:

I use OpenFire with Pidgin for text chat communication, then I changed to Jitsi client, and Added plugin with openfire to support XMPP Jingle:

The purpose of Jingle is to enable one-to-one, peer-to-peer media sessions between XMPP entities, where the negotiation occurs over the XMPP signalling channel and the media is exchanged over a data channel that is usually a dedicated non-XMPP transport.

This allows users to communicate and audio call also video call each other in LAN environment, is this considered VOIP system/structure ?