today spent a couple of hours working on the website configuration.
got nowhere.
trying to solve this mysterious error 500 and correctly configure the MySQL workbench tool.
beginning to drag on now and taking away from basic activities like making music and doing audio and post.
there seems to be an issue here which is why I’m definitely looking at getting into windows server instead because it just doesn’t seem to work.
one last work around before I quit
I will get Ubuntu desktop on the laptop and try using that instead see if that will help us progress.
So basically the situation is this.
everything works fine up to a point, about 75% say.
The MySql works great, from comandline, from the tool, i can do about 75 percent of the stuff needed, the WordPress is working fine aswell.
we actually upgraded the whole thing today every now and then you have to do the basic Linux upgrades and updates.
spent about 4 hours today on all of this.
wound getting a bit better knowledge of MySQL and have discovered that the MySQL user in ubuntu has to have a few key settings configured via ubuntu server (! ) AND there is some configuration files missing which is stopping this SSL thing from working properly.
Everything mostly works but the point is there feels like there is some invisible line that is stopping us from putting up a strong show of force on the website front which is in effect actively retarding progress because we cant the website we actually want.
So today we got into the MySQL a lot from both the commandline and the MySQL workbench tool as well as some performance testing. However still didn’t resolve the fundamental stumbling block.
it looks there is a triple layer sandwich going on.
the Ubuntu operating system isn’t letting the MySQL read and write to configuration files, and that is stopping MySQL from loading SSL certificates, which in its turn is knocking about 25% off the mysql workbench tool.
At the same time, ubuntu, Apache, PHP, and MySQL, outside of the WordPress thing IS NOT allowing my own code to work when it is live on the webserver, so effectively I’m stuck with WordPress.
Cant figure this out today will get back to making some music and doing some other creative stuff. Will get back to this when I feel like it.