cwilson: joined #tikiwiki fabricius: joined #tikiwiki
joined #tikiwiki giesen: joined #tikiwiki fabricius: joined #tikiwiki
joined #tikiwiki Bsfez: joined #tikiwiki fabricius: joined #tikiwiki Bsfez: joined #tikiwiki fabricius: joined #tikiwiki Bsfez: joined #tikiwiki redflo: joined #tikiwiki Bsfez: joined #tikiwiki
joined #tikiwiki Tiki-KGB: 03eromneg r61355 10trunk/tiki-edit_structure.php
[FIX] inadvertent sorting of top level wiki pages in the structure edit screen due to recent changes for the toc plugin fabricius: joined #tikiwiki jonnyb: joined #tikiwiki luciash: polo polo Jyhem_laptop: joined #tikiwiki amette: polom jonnyb: pompom luciash: heya Bsfez: joined #tikiwiki Jyhem_laptop_: joined #tikiwiki Jyhem_laptop: joined #tikiwiki Tiki-KGB: 03jonnybradley r61356 10trunk/lib/prefs/http.php * [FIX] prefs: Should be mode=block, not mode:block apparently (thanks luciash) Jyhem_laptop: joined #tikiwiki amette: Ok, sunwinds were fitting again today... Jyhem_laptop_: joined #tikiwiki amette: ah, jonny's not here luciash: hmm, sunwinds? nelsonko: joined #tikiwiki amette: luciash: the failing dev/doc backups... they only fail every couple of times... which makes debugging a real pita luciash: and that might be affected by sunwinds? :) amette: So far that's the best guess, yep. ;) luciash: lol amette: :) jonnyb: joined #tikiwiki Bsfez: hello amette: heya Bsfez :) luciash: hi b Bsfez: Hi Lu, Amette amette: Saw your e-mail earlier... the next-sites are failing due to the backups failing... haven't read all your e-mail yet.. will do later and answer then. Bsfez: thanks Amette !
Good you are here :) amette: :) Bsfez: At tiki-install.php I see : Schema name
Where we should enter Database Name... Why do we labeled it "Schema Name" ?
<strong>{tr _0=$dbname}Schema name: &quot;%0&quot;{/tr}</strong> Jyhem_laptop: polom amette: Bsfez: no idea, maybe because it the right term to use!? Bsfez: Hi Jean Marc amette: The database is the MySQL instance. And what we call "database" every day, that is actually a schema. Jyhem_laptop: Bsfez: yes! Yesterday I was showing the tiki-install.php new create everything database related and I was confused by this scema thing. I assumed the french translation was the issue :) amette: You could put "Database schema name", if that makes it better. Jyhem_laptop: well, everywhere else in Tiki it's called the database, so I'd prefer consistency. Bsfez: This I know and understand and I'm sure that technically it is correct. I think in term of UX/UI it is super not standard :D amette: then lets rename it everywhere else ;) Bsfez: I think it is named Database everywhere too...
(scanning) amette: yep, I think it might make sense to just call it database... as I said earlier: that's everyday lingo, so probably no harm in being a bit "wrong" here Tiki-KGB: 03luciash r61357 10trunk/lib/wiki-plugins/wikiplugin_prefdoc.php * missing svn:keywords Id property Bsfez: yeah or "Database Name" luciash: db schemas are in installer/schema I thought
i agree it sounds confusing Jyhem_laptop: Hmmm, I just checked: phpmyadmin also calls them databases Bsfez: it is used in 3 .tpl: luciash: ok ok
just rename :) Bsfez: ok ok ok ! :D amette: *g* Bsfez: :p Jyhem_laptop: phpmyadmin does not even call them database names, just databases. Like we do everywhere else in Tiki
except in local.php where it's "dbs_tiki", but let's not change this :)
another thing I noticed with the new db user creation: it gives the new user access from "%" instead of "localhost". This is less secure than the usual hand-made process. jonnyb: joined #tikiwiki Jyhem_laptop: Of course, this means the installer must check the database location. If it's "localhost" or "127.0.0.1" → restrict access jonnyb: repolom amette: Maybe, maybe not... one could have a server cluster and some php processes on the same machine as the database, but some not.
hi jonnyb jonnyb: hi amette and all luciash: wb jonnyb amette: jonnyb: I found the place in which the backup fails... monitorlib.php line 295... if that rings any bells or gives you any ideas, then I'll try them... otherwise I now feel confident enough to write everything I know up for Ricardo. Tiki-KGB: 03icc0rz r61358 10branches/ 10experimental/h5p/lib/filegals/h5plib.php 04experimental/h5p/vendor 10experimental/h5p/lib/core/H5P/H5PTiki.php * [FIX] h5p: prevent database errors + variable name fix jonnyb: nicely tracked down amette - that sounds like the culprit, all that activity/monitoring stuff waas never properly finished imho amette: cheers, thanks
it's weird though.. cause there is not much happening in the case of a backup, I think..!?
and from start of transaction to end of transaction it's not even a second... longer, when I have breakpoints... but even then it often doesn't happen jonnyb: seems odd that on line 275 there is gets the db ok, but then has lost it after those finalHandleEvent calls... Jyhem_laptop: Woohoo! Congrats amette amette: Not completely sure, but I think it doesn't even go into those finalHandleEvent calls, because queue is empty. jonnyb: i wonder if it depends on someone doing something on the site that triggers a notification that makes it fail, which is why it doesn't always happen? amette: Jyhem_laptop: cheers, but not too much reason for relief yet... now we need to figure out why it happens and fix it. jonnyb: but the error happens on the "$tx->commit()" line? not inside it? amette: hmm, to me it looks like happening on that line... it doesn't go into there... maybe I would need some more break points inside the commit() somewhere!? Jyhem_laptop: If one has a server cluster, then one should access the database by name? Or at least create the users by hand, not use the newbie-friendly simple installer. amette: Jyhem_laptop: yep, that is true, but that is making assumptions
we figured in Brussels that it's better not to make too many assumptions and have it "just work" Jyhem_laptop: Oh, definitely an improvement. And it does "just work". But now we can improve security before those security companies come and point this out :) -: Jyhem_laptop gets back to Tiki upgrades. amette: jonnyb: ok, I slapped a break point into the commit function, but might be that I won't get any more information today... the backups work again.. sunwinds seem to have changed meanwhile. jonnyb: yes, it's a tricky one for sure! amette: Jyhem_laptop: fair enough. Yep, we need to find some way to make it obvious to the user what's happening there... some kind of logic in the background and some remarksbox explaining issues/dangers. Though probably explaining issues to the cluster owner is better than scaring the n00b with the dangers. Jyhem_laptop: Yup. Cluster owners could get all the details from a special wiki page. DB user creation is definitely not the hardest part to get right for clusters :) redflo: left #tikiwiki Tiki-KGB: 03icc0rz r61359 03branches/experimental/h5p/vendor * [MRG] Restore accidentally deleted folder?
03jonnybradley r61360 10trunk/lib/user/blacklistlib.php
[FIX] passwords: Storing a copy of the prefs in the library's fields was causing notices after clearing caches as the lib's constructor gets called before prefs are set up, so change to using prefs in the usual way from the $prefs global when they're actually needed. Seems to still work ok.
03jonnybradley r61361 10trunk/templates/admin/admin_navbar.tpl
[FIX] admin: Restore the close button on the dialog regarding ticket timeouts so you can click something else if you need to without reloading the whole page Bsfez: fnuttt
(translating in hebrew sucks !) :D luciash: :) Bsfez: Lu, I found a few inline style in the installer tpl. Once I complete all translation I try to get ride of them (especially those who are breaking the rtl flow) luciash: alrighty Tiki-KGB: 03luciash r61362 10trunk/lib/wiki-plugins/wikiplugin_html.php
[ENH] PluginHTML: introduce new param tohead to insert the HTML tags to HTML head instead of the content of the page
03luciash r61363 10trunk/lib/wiki-plugins/wikiplugin_metatag.php * PluginMetaTag: filter name as text Bsfez: (still in the installer), I see : <strong>{tr _0=$dbname}Schema name: &quot;%0&quot;{/tr}</strong>
&quot; ? luciash: it means " as html entity Bsfez: yes but I thought we use " and not &quot;
beside Tiki 15 installer.tpl = <strong>{tr _0=$dbname}Database name: "%0"{/tr}</strong> luciash: but then you might be in trouble in the language.php maybe because the array strings use ""? or need to escape it using " Bsfez: yes this I understand. But I prefer we stick to a rule. I'll add the " in the translation luciash: ok, test if it works please Bsfez: sure ! luciash: tks Tiki-KGB: 03jonnybradley r61364 10branches/ 10(14 files in 10 dirs) * [MRG] Automatic merge, trunk 61346 to 61363
03chealer r61365 10trunk/lib/wiki-plugins/wikiplugin_html.php
[FIX] tohead parameter description
[REF] Optimize
03chealer r61366 10trim/src/appinfo/tiki.php
removeTemporaryFiles():
[REF] Clarify
Throw an exception if path is unexpected.
[REF] Optimize
03chealer r61367 10trim/src/appinfo/tiki.php * [FIX] removeTemporaryFiles(): Take new (Tiki 17) templates_c/ path into account nelsonko: left #tikiwiki Tiki-KGB: 03luciash r61368 10trunk/lib/wiki-plugins/wikiplugin_metatag.php
[MOD] PluginMetaTag: added option for the body to specify the meta tag attribute values as simple strings separated by pipe character + optimized code little bit
03yonixxx r61369 10trunk/ 10tiki-change_password.php 10templates/tiki-change_password.tpl
[TRA] [FIX] Added missing tr tags on placeholders added condition to use bootstrap-rtl if language isRTL
03luciash r61370 10trunk/lib/headerlib.php
[ENH] HeaderLib: metatags - check if the meta name starts with OpenGraph protocol prefix and use property instead of name if true
03jonnybradley r61371 10trunk/ 10(6 files in 5 dirs)
[NEW] webservices: Initial implementation of a new "engine" for webservices to enable data retrieved to be indexed in the search index without needing Tiki Objects such as Tracker Items to represent it.
03eromneg r61372 10branches/16.x/tiki-edit_structure.php
[FIX] [bp61355] fix inadvertent sorting of top level wiki pages in the structure edit screen due to recent changes for the toc plugin
03jonnybradley r61373 10trunk/ 10lib/ointegratelib.php 10admin/include_webservices.php
[FIX] webservices: Refill the template form when previewing and improve error reporting for misconfigured ones
03eromneg r61374 10branches/15.x/tiki-edit_structure.php
[FIX] [bp61355] fix inadvertent sorting of top level wiki pages in the structure edit screen due to recent changes for the toc plugin
03jonnybradley r61375 10trunk/templates/admin/include_webservices.tpl * [FIX] webservices: A few cosmetic improvements giesen: joined #tikiwiki Telesight: joined #tikiwiki Tiki-KGB: 03yonixxx r61376 10trunk/templates/tiki-install.tpl
[ENH] [FIX] Overall improvement of the UI, removing inline style for base classes, proofwording to clarify, avoid confusion and easy translation, changing html entities for utf-8 character removing Parenthesis for rtl language.
03yonixxx r61377 10trunk/lang/he/language.php
[TRA] Hebrew translation improvement (mainly install pages) - performed after get_string to be sure I work on the last strings. jonnyb: joined #tikiwiki RadoS: Moin... I updated the OS underneath a 15.2 tiki, php7 got updated next to mysql 5.7, now tiki can't connect to the DB "Lost Tiki database connection". The DB works and is still accessible via mysql command-line... I guess the php got b0rked somewhere/-how... how to track it back?
Is there some simple way to test DB connectivity by/from tiki?
Nope, mysql _AGAIN_ biting my ass for local users. :-/
Since I stumbled over this again, ... is that known / documented, that mysql by default auth's by "native_socket" while tiki doesn't install its db-access like that? -: RadoS ... o O ( and I just didn't notice this _again_? ) Tiki-KGB: 03jyhem r61378 10trunk/lib/ckeditor_tiki/tikistyles.js * Add useful info in source luciash: RadoS: not sure 15.x is compatible with php7 yet - I did not try with php7 so far dj-amel: joined #tikiwiki Bsfez: joined #tikiwiki Smartwebs_: joined #tikiwiki
luciash - feel free to kick the other me; not sure why it hung around 2 days
left #tikiwiki was: kicked by luciash: Smartwebs Bsfez: joined #tikiwiki jonnyb: joined #tikiwiki Tiki-KGB: 03rjsmelo r61379 10branches/ 10(15 files in 11 dirs) * [MRG] Automatic merge, trunk 61363 to 61378