Pages (2): 1 2   
Member
Member
rnervi   22-12-2023, 07:33
#1

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

Member
Member
rnervi   22-12-2023, 07:48
#2

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']

Member
Member
rnervi   22-12-2023, 09:23
#3

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

Administrator
Administrator
acrylian   22-12-2023, 09:29
#4

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.

Administrator
Administrator
acrylian   22-12-2023, 09:49
#5

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

Member
Member
rnervi   22-12-2023, 10:22
#6

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

Member
Member
rnervi   22-12-2023, 10:28
#7

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

Administrator
Administrator
acrylian   22-12-2023, 12:54
#8

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
Member
Member
Member
rnervi   23-12-2023, 10:27
#10

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

Member
Member
rnervi   23-12-2023, 11:51
#11

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

Member
Member
rnervi   30-12-2023, 11:38
#12

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

Administrator
Administrator
acrylian   30-12-2023, 12:07
#13

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…

Member
Member
rnervi   30-12-2023, 16:36
#14

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

Administrator
Administrator
acrylian   30-12-2023, 19:35
#15

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…

Member
Member
rnervi   01-01-2024, 17:03
#16

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

Administrator
Administrator
acrylian   01-01-2024, 19:42
#17

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.

Member
Member
rnervi   02-01-2024, 10:18
#18

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

Member
Member
Ewgeniy   12-01-2024, 17:31
#19

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.

Administrator
Administrator
acrylian   12-01-2024, 18:05
#20

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).

Pages (2): 1 2   
  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.