update 1.6 to 1.6.1

rnervi

I've done all steps.
the config file zenphoto.cfg.php points correctly to host IP: 31.11.39.99
but the log file states: Access denied for user '******'@'89.46.110.127'
why it does not uses the supplied db host address ?
(credentials checked are correct for correct host)
any clues ?
ty

rnervi

more on: removed the cfg file (renamed) zenphoto.cfg.php
it starts with a new setup asking for credential.
But I've stopped as scared to loose data.

to me this means it's reading the correct configuratione file "zenphoto.cfg.php" but misreading the $conf['mysql_host']

rnervi

opened ticket to host too as it's really weird....

acrylian

Sorry for your trouble. I don't remember any changes in these area right now. I don't have any host using an IP for the db server but that should work of course Otherwise try the generic "localhost" perhaps.

Which db handler are you using? MySQLi oder PDO?

But I've stopped as scared to loose data.

You should not loose any data. But in any case backups are always a good idea before updates.

acrylian

We have for sure not any predefined IP address, no IP address at all. Default is if "localhost".

rnervi

MySQLi as was before.
thius should be some hoster issue. wating for their response.
I've backupped either sql than web side.. waiting for hoster answer the wrong IP is in their domains)... or I'll perform a "restart" on a temporary one (just to be safe).
ty will let know updates

rnervi

hoster: check PHP version.
(8.1 --> 8.2 --> 8.3) not solved.

acrylian

We haven't tested 8.3 since we have not yet access to it. But we did everyhing on 8.2. I doubt it is the PHP version.

The updates of our own site and demo site worked also without any issues.

I can only suggest to re-check the credentials for a minor typo or something. A completely filled db config should look like this, just in case:

 $conf['db_software'] = 'MySQLi';   
 $conf['mysql_user'] = 'username';  
 $conf['mysql_pass'] = 'password';  
 $conf['mysql_host'] = 'dbserver;
 $conf['mysql_database'] = databasename'; 
 $conf['mysql_prefix'] = 'zp_'; 
 $conf['mysql_port'] = "3306"; 
 $conf['mysql_socket'] = ""; // you usually don't have to set this

sbillard

Sounds like the following https://www.linuxcloudvps.com/blog/how-to-fix-access-denied-errors-in-mysql/#:~:text=Fixing access denied for 'user'@'ip_address'&text=The most probable cause for,test_db to 'user'@'192.168.

Which would indicate a server configuration issue.

rnervi

installed in a local ubu srv, it works fine. So it's definitely some weird hosting side. As solved, will update here... who knows can help some1 too

rnervi

checked twice and all is ok. the weird side is that it reads an IP address from config but tries to log on another !
wating for hoster to investigate. Is definitely not a zenphoto issue

rnervi

as hoster cannot read what I type....
question: what about if I remove(rename) the config file and run the setup.php ? does the present db is respected and the images folder with structure ? ty

acrylian

Yes, you can rename/delete the config file and re-run setup to have it re-created.

But if editing it manually with the correct credentials still results in that wrong IP address it probably will not fix it.

If the correct IP address results in a different one being used this sounds like some weird redirection is in place. That would be the server/host to fix then…

rnervi

eh I tried, but as wrote, sounds they are not reading words in ticket with necessasry attention ! ty will try tomorro morning

acrylian

Sadly some hosts really provide minimal support of the general things… Hopefully your's will pay atention soon. Perhaps just all in holiday season mode…

rnervi

I hard coded connection data inside the file class-dbmysqli.php and it now works ! very weird
question: can give me a small php that read config data and prints them out ? it smells like "I read x but receive y"
ty

acrylian

But where should the wrong IP come from? We do set "localhost" as a default but if there is config data that should not be used.

The actual db config data is set within functions-basic.php starting line 194. You can write any data to the debug.log using debuglog($somevar); (in 1.6.2 it also supports arrays).
Around line 223 the data should be set within $_zp_db global db handler object.

rnervi

dunno. The onky thing I know checking IP is owned by hoster.
ty will do some test in aseparate subfolder

Ewgeniy

Hello, I installed v.1.6.1. I need to insert the Yandex.Metrika code, on the "gallery" tab there is a field "Insert code:" I inserted and saved. But this code does not appear on any page. (( Then I installed the "defaultcodeblocks" plugin, pasted the code there, and enabled all three types (album, gallery, image). But the code only appeared on the page with the image. (( How do I paste the Yandex.Metrika code so that it is present on all, any gallery pages?
Theme Multiverse v2.2
And I didn't find the possibility of Schema.org or Open Graph markup.

acrylian

The theme must have built in support for code blocks. You will likely have to add printCodeblock() yourself to the theme.

The better but more advanced way would be to create a plugin to include the code via the theme_head or theme_body_close filter (which any proper theme should have built in).

You can enable opengraph via the html_meta_tags plugin.schema.org is not yet available (adding json-ld is planned for sometime in the future).

Ewgeniy

Oh, sorry, I thought the "html_meta_tags plugin" only included the regular "<meta name=" I saw it and turned it on. Thank you! ) Yes, “theme_head” would be good, in “Piwigo” this can be done without any problems. But I want to switch to "Zenphoto". )

acrylian

OpenGraph tags are justs meta tags as well ;-)

A plugin for that "theme_head" filter is relatively simple, depending on your knowledge. You find a general demo plugin on our Github: https://github.com/zenphoto/demo-plugin

Take that as an example. Instead of the demo functions use something like this:

zp_register_filter('theme_head', 'yourplugin::script');

class yourplugin {

   static function script() {
       echo "Your script code here";
   }
}

Ewgeniy

Although I have been in IT since the appearance of the IBM PC XT in the USSR. )) But programming is not my thing, although sometimes I edited the code when there was no other choice. And creating a plugin is beyond me. ) I'll be satisfied for now with the presence of the code on the image page. )

acrylian

Well, that's as long as I am (I started with the C64). Take a look at the demo plugin which is fully commented and with the above example you should get along then;-)

Ewgeniy

Fine. Thank you.