MLP - The Multi-Lingual Publishing Pack

ruud · 2007-08-18 08:04:39

jmk,
In your MySQL setup, there’s a database called ‘mysql’, containing a table called ‘db’. In that table the privileges mentioned in the error message have to be set to Y (yes) instead of N (No) for the user/db combination that you use for your textpattern install.

see also MySQL documentation on privileges

jmk · 2007-08-18 15:02:14

thanks for your answer, that was my first try, too. but i got this message back from my hoster:
——
Host: %
Db: db23543
User: db23543
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Create_tmp_table_priv:
Lock_tables_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Execute_priv: Y
—-

ruud · 2007-08-18 15:17:14

Create_tmp_table_priv: … that should be set to Y

What happens if you add &debugwiz=1 or ?debugwiz=1 at the end of the query string when visiting the mlp-tab? And also switch your site status to ‘debug’. Both those things might provide some useful debug messages.

Last edited by ruud (2007-08-18 15:29:24)

jmk · 2007-08-18 15:42:54

ruud wrote:

Create_tmp_table_priv: … that should be set to Y

yup, it is, that was just a copy&paste error :)

What happens if you add &debugwiz=1 or ?debugwiz=1 at the end of the query string when visiting the mlp-tab? And also switch your site status to ‘debug’. Both those things might provide some useful debug messages.

finally i got a new method of getting information. thanks! alright, i got this output:

—-

Testing for privs to DB:`db23543` on Server:mysql5.domain.tld, v:5.0.41-log. Connected using user: db23543.

SHOW GRANTS FOR ‘db23543’@‘mysql5.domain.tld’;

Warning: There is no such grant defined for user ‘db23543’ on host ‘mysql5.domain.tld’ SHOW GRANTS FOR ‘db23543’@‘mysql5.domain.tld’; in /kunden/domain.tld/webseiten/subdomain/textpattern/lib/txplib_db.php on line 117

Initial SHOW GRANTS query failed, re-trying.

SHOW GRANTS;

There is no such grant defined for user ‘db23543’ on host ‘mysql5.domain.tld’

array ( 0 => ‘GRANT USAGE ON . TO \‘db23543\’@\‘ip_address\’ IDENTIFIED BY PASSWORD \’****************\’‘,
)

Mathed: string(69) “ privs – or grants on DB (`db23543` as `db23543`) cannot be evaluated”
——

does that help?

ruud · 2007-08-18 16:55:39

Ask your webhost why the SQL commands

SHOW GRANTS FOR 'db23543'@'mysql5.domain.tld';

and.

SHOW GRANTS;

don’t show grants but show this error instead: There is no such grant defined for user 'db23543' on host 'mysql5.domain.tld'

On second thought… is mysql5.domain.tld where your website is hosted or is it a dedicated MySQL server? In that case, try running SQL commands like:

SHOW GRANTS FOR 'db23543'@'name_of_server_where_your_website_is_hosted';
SHOW GRANTS FOR 'db23543'@'IP_number_of_server_where_your_website_is_hosted';
SHOW GRANTS FOR 'db23543'@'domain_name_of_your_website';

PS. if there’s a MySQL guru reading here, feel free to step in, because at this point I’m out of other ideas.

Last edited by ruud (2007-08-18 17:06:01)

jmk · 2007-08-18 19:43:56

thanks for your help so far, ruud, i really appreciate it! i gave my hoster the same error message, and so far no one has responded, so i/we will see.

jmk · 2007-08-20 13:58:35

i got an answer from my webhoster:

as you correctly assumed it, ruud, the mysql server ran on a different machine (dedicated). to quote my webhoster:

since the mysql5 server is running on an external server, the script is trying to find the grants for the wrong host name. we have added the right grant to you, so that the installation of the plugin should work now.
(translated from german original: “Da der MySQL5 Server auf einem externen Server läuft, versucht das Script die Grants für den falschen Hostnamen zu suchen. Ich habe Ihnen soeben den richtigen GRANT hinzugefügt, so dass die Installation nun klappen sollte.” )

well, it does not work. but the error message changed a little:

Testing for privs to DB:`db23543` on Server:mysql5.domain.tld, v:5.0.41-log. Connected using user: db23543.
SHOW GRANTS FOR ‘db23543’@‘mysql5.domain.tld’;
array ( 0 => ‘GRANT USAGE ON . TO \‘db23543\’@\‘mysql5.domain.tld\’ IDENTIFIED BY PASSWORD \’****************\’‘,)
Mathed: string(69) “ privs – or grants on DB (`db23543` as `db23543`) cannot be evaluated”
MLP Pack Detected Version Problems
The MLP Pack cannot operate in this installation because… 1. It requires MySQL Privileges 1 SELECT, INSERT, UPDATE, DELETE, CREATE, CREATE TEMPORARY TABLES, ALTER, LOCK TABLES, INDEX, DROP or above, current install is missing privs – or grants on DB (`db23543` as `db23543`) cannot be evaluated.

my hoster responded to this with:

all grants have been registred. one from the ip-address, one from the hostname etc
(orig. german: “Es wurden bereits alle GRANTs eingetragen. Einer von der IP Adresse, einer vom Hostnamen aus. etc.”)

does anybody have an idea, how i could get this installation to work? i will gladly donate to the mlp-fund to get this plugin further on track, but right now, i am not sure if that will happen anytime soon…

thanks for all your help, so far!
jmk

Last edited by jmk (2007-08-20 14:03:42)

ruud · 2007-08-20 14:07:44

Try editing the file /textpattern/lib/l10n_admin_classes.php
On line 4477 it says:

$host  = $txpcfg['host'];

Change that to (depends on which hostname or IPnr your ISP granted access for on the mysql server):

$host  = 'example.com'; # replace example.com with your host name / domain name

or

$host  = '1.2.3.4'; # replace 1.2.3.4 with the IPnr of your website or the IPnr of the server hosting your website.

Last edited by ruud (2007-08-20 14:09:30)

jmk · 2007-08-21 07:27:51

well, i asked my hoster this question, and he responded that there is a grant installed for ‘mysql5.domain.tld’. when i changed the &host to mysql5.domain.tld the error message stayed the same. (which only makes sense, because it detected this address already by itself). btw, as you might remember, i am trying to get this to work on a subdomain (subdomain.domain.tld) which in reality is a subfolder of my domain, but that shouldn’t be a poblem, should it?.

isn’t there a way to get around this check? (maybe comment it out just to try if the installation works then?) and why is that check there at all? whats the necessity?

ruud · 2007-08-21 10:40:22

I think the check is there to detect at the beginning of the installation if you can use MLP at all. Otherwise you’d spend a lot of time setting it up only to find out that it won’t work. You can disable the check by adding a line return TRUE; at the beginning of the can_install function (line 4476).

jmk · 2007-08-21 11:50:21

well, that did it. :| but of course that isn’t very satisfying…

i am still wondering, why

$sql  = "SHOW GRANTS FOR '$user'@'$host';";
if( $debug )
$rows = getThings( $sql , 1 );
else
$rows = @getThings( $sql );

isn’t giving me any output. if that wouldn’t work, shouldn’t textpattern fall back to the next routine?

if( empty( $rows ) )
{
if( $debug ) echo br , "Initial SHOW GRANTS query failed";
if( version_compare( $version, '4.1.2' , '>=') )
{
$sql  = "SHOW GRANTS;";
if( $debug )
{
echo ', re-trying.';
$rows = getThings( $sql , 1 );
}
else
$rows = @getThings( $sql );
}
}

and tell my that it faild the first time?

non the less, thank you for your help. at least i can try it out now…

ruud · 2007-08-21 12:12:05

It does fall back to that second routine, but that one fails as well.

Textpattern CMS

Textpattern CMS support forum

#325 2007-08-18 08:04:39

Re: MLP - The Multi-Lingual Publishing Pack

#326 2007-08-18 15:02:14

Re: MLP - The Multi-Lingual Publishing Pack

#327 2007-08-18 15:17:14

Re: MLP - The Multi-Lingual Publishing Pack

#328 2007-08-18 15:42:54

Re: MLP - The Multi-Lingual Publishing Pack

#329 2007-08-18 16:55:39

Re: MLP - The Multi-Lingual Publishing Pack

#330 2007-08-18 19:43:56

Re: MLP - The Multi-Lingual Publishing Pack

#331 2007-08-20 13:58:35

Re: MLP - The Multi-Lingual Publishing Pack

#332 2007-08-20 14:07:44

Re: MLP - The Multi-Lingual Publishing Pack

#333 2007-08-21 07:27:51

Re: MLP - The Multi-Lingual Publishing Pack

#334 2007-08-21 10:40:22

Re: MLP - The Multi-Lingual Publishing Pack

#335 2007-08-21 11:50:21

Re: MLP - The Multi-Lingual Publishing Pack

#336 2007-08-21 12:12:05

Re: MLP - The Multi-Lingual Publishing Pack

Board footer