MLP - The Multi-Lingual Publishing Pack

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.

jmk · 2007-08-21 12:32:15

you know what, i tried to figure out where exactly the error is, and i put small “echo br,‘one’;” etc lines in the source. that showed me, that i do get an output from the first routine, namely:

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

which means, $rows isn’t empty, and understandably, the second routine is skiped.

right now i got to these lines (thats around line 4535):

if( !empty( $rows ) )
{
echo br,'one';
$rows = $this->strip_pws( $rows );
if( $debug ) 
{
echo br,'two';
echo dmp( $rows );
echo br,'three';
}

and i get this output

one
two
array (
  0 => 'GRANT USAGE ON *.* TO \'db23543\'@\'mysql5.domain.tld\' IDENTIFIED BY PASSWORD \'****************\'',
)
three

does that make any sense to you?

Last edited by jmk (2007-08-21 12:35:22)

ruud · 2007-08-21 12:43:28

Without spending more time on it, that doesn’t make sense to me. If I were you, I’d just short-circuit the can_install function by making it return ‘true’ at the beginning, since you already know for sure that the grants it checks for are present (your webhost told you).

jmk · 2007-08-21 12:56:34

yup, it is strange indeed! it seems as if this line

$rows = @getThings( $sql )

doesn’t return what is expected. what is that, btw? how should this line look like (maybe others can help)?

the short circuiting is an option, but for the sake of others, i wanted to find the root of the problem.

jmk · 2007-08-21 13:10:29

ah, i found out, that i was a little wrong i my earlier post. the output ist not

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

but it is

array (
  0 => 'GRANT USAGE ON *.* TO \'db23543\'@\'mysql5.domain.tld\' IDENTIFIED BY PASSWORD \'****************\'',
)

non the less, there should evidently be another line which should say something like

array (
  0 => 'GRANT USAGE ON *.* TO \'dbo200884203\'@\'%\' IDENTIFIED BY PASSWORD \'****************\'',
  1 => 'GRANT ALL PRIVILEGES ON `db200884203`.* TO \'dbo200884203\'@\'%\'',
)

usuario · 2007-08-22 11:27:15

I have a clean instalation of TXP 4.0.5 (r2466) but when installed a MLP i get a Fatal error with zem_contact_lang-mlp and clean_url_data_failed

1. Fatal error when active zem_contact_lang-mlp plugin and browsing my site:

Fatal error: Cannot redeclare zem_contact_gtxt() (previously declared in /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs/textpattern/lib/txplib_misc.php(534) : eval()’d code:2) in /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs/textpattern/lib/txplib_misc.php(534) : eval()’d code on line 75

2. clean_url_data_failed with MLP

My Pre-flight check:

Textpattern version: 4.0.5 (r2466)
Last Update: 2007-08-14 11:03:30/2007-08-14 10:58:08
Document root: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs
$path_to_site: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs
Textpattern path: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs/textpattern
Permanent link mode: section_id_title
open_basedir: /var/www/vhosts/xxxx.xx/subdomains/txp/httpdocs:/tmp
Temporary directory path: /tmp
Site URL: txp.xxxx.xx
PHP version: 5.0.4
GD Image Library: bundled (2.0.28 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2007-08-22 12:57:01
MySQL: 4.1.20
Locale: en_GB.UTF-8
Server: Apache/2.0.54 (Fedora)
Apache version: Apache/2.0.54 (Fedora)
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: Linux 2.6.17-1.2142_FC4smp
Active plugins: rss_admin_db_manager-4.3, ign_password_protect-0.4.2d, mem_self_register-0.8.3, asy_wondertag-0.5, zem_contact_reborn-4.0.3.20-t, zem_contact_lang-4.0.3.6, pap_contact_cleaner-0.1, gbp_admin_library-0.4.581, TXPhorum-0.2, l10n-0.6.600

Pre-flight check:
————————————
Some Textpattern files are out of date: /lib/txplib_db.php
clean_url_data_failed: ?
————————————

.htaccess file contents:
————————————
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes

<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/

RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php
</IfModule>

#php_value register_globals 0
————————————

Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
17 Tables: -

PHP extensions: yp, xml, wddx, tokenizer/0.1, sysvshm, sysvsem, sysvmsg, standard/5.0.4, SPL, sockets, SimpleXML, shmop, session, pspell, posix, pcre, mime_magic/0.1, iconv, gmp, gettext, ftp, exif/1.4 $Id: exif.c,v 1.162.2.8 2005/03/17 17:20:35 iliaa Exp $, dio/0.1, dbx, curl, ctype, calendar, bz2, zlib/1.1, openssl, libxml, apache2handler, dom/20031129, gd, imap, ldap, mbstring, mysql, mysqli/0.1, SQLite, xsl/0.1, ionCube Loader

Apache modules: core, prefork, http_core, mod_so, mod_access, mod_auth, mod_auth_anon, mod_auth_dbm, mod_auth_digest, util_ldap, mod_auth_ldap, mod_include, mod_log_config, mod_logio, mod_env, mod_cern_meta, mod_expires, mod_deflate, mod_headers, mod_usertrack, mod_setenvif, mod_mime, mod_dav, mod_status, mod_autoindex, mod_asis, mod_info, mod_dav_fs, mod_vhost_alias, mod_negotiation, mod_dir, mod_actions, mod_speling, mod_userdir, mod_alias, mod_rewrite, mod_proxy, proxy_ftp, proxy_http, proxy_connect, mod_cache, mod_suexec, mod_disk_cache, mod_file_cache, mod_mem_cache, mod_cgi, mod_fpcgid, mod_jk, mod_perl, mod_php5, mod_python, mod_ssl

pretext_data: 376b889940bfa6fd696416dc9d47f083
array ( ‘id’ => ‘’, ‘s’ => ‘’, ‘c’ => ‘’, ‘q’ => ‘’, ‘pg’ => ‘’, ‘p’ => ‘’, ‘month’ => ‘’, ‘author’ => ‘’, ‘request_uri’ => ‘/a13766419129f1c19333cd744a6a14ac/?txpcleantest=1’, ‘qs’ => ‘txpcleantest=1’, ‘subpath’ => ‘\\/’, ‘req’ => ‘/a13766419129f1c19333cd744a6a14ac/?txpcleantest=1’,
)

/include/txp_category.php: r2243 (3706fea923cd77f7053f7803de169df4)
/include/txp_plugin.php: r1917 (c63f72f33986c08367672fc9fe7b42dd)
/include/txp_auth.php: r2356 (33255ec1ea1a825163c78272496d8783)
/include/txp_form.php: r1913 (ecea3fecf9d7d1f8088cda67f097eceb)
/include/txp_section.php: r1891 (1f0121b3e2969d94bc8a7fb98bfdfbd5)
/include/txp_tag.php: r2260 (1bd67bdb9dcfb72e34ea967e39406216)
/include/txp_list.php: r2450 (997a3b1bec7115bf49b76f62b28da146)
/include/txp_page.php: r2099 (56bde34b6c7bcb9123ac91e73065e894)
/include/txp_discuss.php: r2451 (91e0b29ef39a9471ae5c78d0b1bba086)
/include/txp_prefs.php: r2405 (a4b76476930b2376199f23fbfd5f1ac9)
/include/txp_log.php: r2439 (16730c34e2a437dd88b8f5cc7eff8218)
/include/txp_preview.php: r1238 (696728f35f3557b648c011bb4d6496c3)
/include/txp_image.php: r2439 (9fac6ed0d9d4c3d8196492051f38dc9a)
/include/txp_article.php: r2453 (bdac8fcac5df2f93f10afa7e50c3fb6f)
/include/txp_css.php: r2403 (4e8c52bb1cf5bfe2e2f0640892f9b92e)
/include/txp_admin.php: r2403 (f8700a3d453ece08e7f137b47c967eda)
/include/txp_link.php: r2463 (0a0171bf606296106332d3fdcb83a678)
/include/txp_diag.php: r2361 (dccf3269049dd25e59afdd7ad8d235cd)
/include/txp_file.php: r2403 (e62abd5fcadabe629322ed17135d89eb)
/include/txp_import.php: r1238 (70a6207c0f3604ecfc4b20369986c4d7)
/lib/admin_config.php: r1747 (a2eb09f94d7902a6e95750fc4abcea17)
/lib/txplib_misc.php: r2464 (615afd44a10311f1c0b7852d9bc15d24)
/lib/taglib.php: r1535 (9b519f9dc88791e5ee8eacc029dd6975)
/lib/txplib_head.php: r2404 (2e067b25997cf67cddbdd365570e69d5)
/lib/classTextile.php: r2462 (a031e2ea894e339711c601f230c5ee71)
/lib/txplib_html.php: r2403 (97e173da3058b438513df67fd7d1ceca)
/lib/txplib_db.php: r1879 (125d6835470af76be4b0b369533e25cf)
/lib/IXRClass.php: r765 (137b91497628f0058a2fca9eba5c3b7f)
/lib/txplib_forms.php: r2403 (438a734b52acef40b36d8a3ba23987e8)
/lib/class.thumb.php: r2329 (b2a2fda54371dbd6c40ba553941f090e)
/lib/constants.php: r2361 (ab6d51668fab1e3c98e7d520b1a59f0f)
/lib/txplib_update.php: r1239 (10f28a986d23187b436369dc29ab552f)
/lib/txplib_wrapper.php: r2286 (419125ec74a17a70bf1e86ebfcd45253)
/publish/taghandlers.php: r2444 (cc9de8f2018b01398a2ba542c5f5bdc6)
/publish/atom.php: r2402 (46c4402717f695fde0d49d806adfa4c4)
/publish/log.php: r1637 (5254d0f3942086bc55723923307a51db)
/publish/comment.php: r2460 (2d1ae1dec0784f044e7005fa5ed50930)
/publish/search.php: r1748 (8c86ebcb5be08e214d81ca15a32164ca)
/publish/rss.php: r2393 (09aac29bf22ffa71c1e118e851cff3c3)
/publish.php: r2436 (7087864f1e7c6efe096d3b8e07c350b1)
/index.php: r2466 (30ecf35de5c1edc6ef68e780c8c79daa)
/css.php: r944 (8beba8f83a091068723435cdcdc02f2f)

Can anyone help? thanks.

ruud · 2007-08-22 11:33:39

usuario, uninstall the zem_contact_lang plugin, because zem_contact_lang-mlp replaces it.

The clean_url thing may be related to the “BOM” issue (see earlier in this topic).

Last edited by ruud (2007-08-22 11:43:10)

usuario · 2007-08-22 11:44:39

thanks a lot !

usuario · 2007-08-22 17:18:10

ruud wrote:

Hmm.. I’ve just downloaded the MLP pack.
/textpattern/lib/l10n_base.php has a BOM at the beginning. Because that’s before the <?php tag and assuming that file is loaded on each page load before the template is used, that BOM is sent to the browser before the template is parsed (the BOM is at the very beginning of the page as it arrives in the browser, before the DOCTYPE).

Try the notepad trick with that file: open it in notepad -> save as type ANSI (it should be 3 bytes smaller) -> upload it to your site, replacing the original l10n_base.php file.

I follow the instructions ( the file is not 3 bytes smaller) but the clean_url_data_failed with MLP persist.

ruud · 2007-08-22 17:28:21

Is it just the clean url test that fails, or do clean urls not work on your website (the first doesn’t necessarily imply the second).

Textpattern CMS

Textpattern CMS support forum

#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

#337 2007-08-21 12:32:15

Re: MLP - The Multi-Lingual Publishing Pack

#338 2007-08-21 12:43:28

Re: MLP - The Multi-Lingual Publishing Pack

#339 2007-08-21 12:56:34

Re: MLP - The Multi-Lingual Publishing Pack

#340 2007-08-21 13:10:29

Re: MLP - The Multi-Lingual Publishing Pack

#341 2007-08-22 11:27:15

Re: MLP - The Multi-Lingual Publishing Pack

#342 2007-08-22 11:33:39

Re: MLP - The Multi-Lingual Publishing Pack

#343 2007-08-22 11:44:39

Re: MLP - The Multi-Lingual Publishing Pack

#344 2007-08-22 17:18:10

Re: MLP - The Multi-Lingual Publishing Pack

#345 2007-08-22 17:28:21

Re: MLP - The Multi-Lingual Publishing Pack

Board footer