marclaporte: joined #tikiwiki fabricius: joined #tikiwiki chibaguy: joined #tikiwiki Tiki|bot: New Forum Posts: upgrade made all registered users "admins" - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47771 dabright: joined #tikiwiki fabricius: joined #tikiwiki arildb_: joined #tikiwiki goj_killedByISP: joined #tikiwiki arildb__: joined #tikiwiki arildb: joined #tikiwiki arildb_: joined #tikiwiki knatok: joined #tikiwiki
left #tikiwiki fabricius: joined #tikiwiki
joined #tikiwiki arildb: joined #tikiwiki arildb_: joined #tikiwiki arildb__: joined #tikiwiki PenguinMan98: joined #tikiwiki -: PenguinMan98 waves to all PenguinMan98: Tonight I need to troubleshoot an issue that you all may have run into before
But it's not an issue specific to tikiwiki
When I clone the mysql database to another database, the serialized data gets corrupted and the clone install won't run
It's a known php issue
Have any of you run into this yet? I'm sure you have. How did you solve it? arildb: joined #tikiwiki arildb__: joined #tikiwiki arildb_: joined #tikiwiki arildb: joined #tikiwiki arildb_: joined #tikiwiki arildb: joined #tikiwiki arildb_: joined #tikiwiki arildb__: joined #tikiwiki arildb: joined #tikiwiki arildb_: joined #tikiwiki -: PenguinMan98 flicks arildb 's router arildb: joined #tikiwiki arildb_: joined #tikiwiki fabricius: hi PenguinMan98 -> php mysql issue: use the linux shell dump command PenguinMan98: fabricius: thank you for your response. Can you be more clear?
OH, I think I see what you're saying fabricius: do not use phpMyAdmin, but the Sjhell instead
yep PenguinMan98: don't use PHPMyAdmin, use the linux shell command to copy the db
gotcha
I actually have that command saved in a text file around here somewheres... arildb_: joined #tikiwiki arildb: joined #tikiwiki fabricius: take dump from server:
mysqldump -u DBUSER -p'DBPASSWORD' DATABASENAME > MYSQL-DUMP_%Y%m%d.SQL
upload to a new database:
mysqldump -u DBUSER -p'DBPASSWORD' DATABASENAMENEW < MYSQL-DUMP_20130628.SQL PenguinMan98: shouldn't that be a >?
oh, oops
read that wrong fabricius: > takes dump ... < pushes dump up -: PenguinMan98 tries not to giggle at the quasi poop joke fabricius: depending on the server settings, the dump file will be saved into the document root / webroot of the webserver ... dump file to be uploaded will be taken from the same directory where the server saves the dump arildb_: joined #tikiwiki fabricius: %Y%m%d -> strftime -> http://php.net/manual/de/function.strftime.php
have to go out of the house now
bye PenguinMan98: kk thanks! arildb: joined #tikiwiki PenguinMan98: pah. It didn't work
*headdesk*
something else is going on here... arildb: joined #tikiwiki
joined #tikiwiki arildb_: joined #tikiwiki PenguinMan98: the import isn't working at all
I imported using sqlyog but got the same errors with unserialization Telesight: joined #tikiwiki redflo: joined #tikiwiki mikkokoi: joined #tikiwiki
Hey, I have question concerning page versions, Can I assign permissions to a specific version of a wiki page. ie. have multiple versions of usermanual which have version specific instructions and i want to edit them on same wikipage, without showing any unnecessary data to users.
Can I assign permissions to page version or do I need to use the {GROUP} tags? fabricius: mikkokoi: permissions to versions: no ... that would be a very hidden secret feature - never heard about it
mikkokoi: general permissions: group has a permission
mikkokoi: category permission: group has a permission for categorised object - overwrites general permission
mikkokoi: object permission: group has a permission for object - overwrites general permission and category permission
category permissions you set in the category admin and object permissions at the object
group identifies a set of users and category identifies a set of objects mikkokoi: yea i know about the basic permissions but I was wondering if its possible to have wikipage version specific permissions fabricius: nope mikkokoi: yea seems so fabricius: 99,9% not
PenguinMan98: how did you setup the new database before import? did you force a certain collation? which collation has the original one? are you sure, that the original database is not corrupt? mikkokoi: so I will have to add the {group} tags to hide the unnecessary stuff. In the end it may be even the better solution to this case, so my editors dont have to worry so much about version control and permissions. They have to simply add the tags and content there, fabricius: mikkokoi: in edit mode, respectively source coe, all users with view/edit permissions see all content of the page -> {GROUP()} is not feasable to hide parts of a page for editors!
you could use the plugin {INCLUDE()} and include pages instead with less edit prmissions -> then for this content you only see the plugin in edit/source mode mikkokoi: Thx for the tip. I will check that out. fabricius: PenguinMan98: a) are you working on a windows machine? b) does your webserver provides ssh access?
PenguinMan98: {if} a) and b) = y {then} putty.exe
I always forget that not everybody has a local shell to login to webservers, cause I alway forget that only a small portion of people use Linux for personal work, if they know. Most People use Linux/Unix only on their phones and webservers :-) Jyhem_laptop: joined #tikiwiki Tiki|bot: New Forum Posts: Icons on Forums - http://tiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=47777 rodrigoprimo: joined #tikiwiki dabright: joined #tikiwiki Tiki|bot: New Forum Posts: Fwd: Smarty 3.1.14 Released - http://tiki.org/tiki-view_forum_thread.php?forumId=26&comments_parentId=47778 chibaguy: joined #tikiwiki fabricius: joined #tikiwiki Tiki|bot: New Forum Posts: Tiki pour débutant? - http://tiki.org/tiki-view_forum_thread.php?forumId=7&comments_parentId=47780 arildb: joined #tikiwiki marclaporte1: joined #tikiwiki zaki[]: joined #tikiwiki dhazel: joined #tikiwiki dabright: joined #tikiwiki chibaguy: joined #tikiwiki PenguinMan98: fabricius: both servers are on the same windows machine. Using the same server actually, just different folders. One is for my live server which I host out of this machine, and the other is for development
win 7
live: www.mlpnwrp.org
testing: www.mlpnwrp.org:8080
All I want to do is copy the database over so I can test on data that isn't live
I'll double check collations
joined #tikiwiki chibaguy: joined #tikiwiki PenguinMan98: I went to the #mysql channel for help and they were very helpful but I still don't have a solution arildb: PenguinMan98: If you would like to move your live db to your test installation. Why don't you backup the live db and restore it in the test database? PenguinMan98: That's exactly what I've done three different ways now
First through phpmyadmin
Then through SQLYog
lastly through linux shell mysqldump commands
except that the linux dump import command didn't work and I ended up importing with sqlyog
someone suggested that if this information is cached anyway, that I should just wipe the table clean
I don't have much to lose from trying it fabricius: .
PenguinMan98: you did write, that you are on a windows machine and so are your site(s) ... I recon your databases aswell PenguinMan98: yes
all running on a wampserver on a windows 7 machine fabricius: PenguinMan98: if so, Linux shell commands will not be any use for you, as they are for Linux and not for Windows PenguinMan98: It made the dump just fine using the git bash
It just wouldn't import it fabricius: so you have a nice uncorupted dump now?
ah maybe too big PenguinMan98: too big?
No, it's not that big fabricius: where do you store your images and files?
how big it is? PenguinMan98: in the db for now but I'm gonna change that fabricius: more 4MB or more 40MB? -: PenguinMan98 shrugs. Can't tell from here. I'm at work now PenguinMan98: but Text Pad opens it without any hesitation fabricius: you should change from database to directory on the life site PenguinMan98: I know
Just haven't done it yet
nobody is using that feature yet fabricius: then copy the file directories and dump the smaller database -> then import should be no problem (if not any hidden further problem) PenguinMan98: size isn't the issue fabricius: you should NOT have the tikisite installed in the webroot
I do it with containers: PenguinMan98: what do you mean? fabricius: webroot/tikiwebsites/mysite.com
from there:
mysite.com/tikiroot and mysite.com/files
there: PenguinMan98: d:/wamp/www/mlpnwrp/site1webroot fabricius: files/wiki files/tracker files/batch files/gallery etc. -: PenguinMan98 is confused fabricius: site1webroot is you unpacked Tiki = Tikiroot? PenguinMan98: Pretty much, yes fabricius: I shoulkd make up a grafic about that ... frequently I confuse pople with that until they get it PenguinMan98: the files are in a public cirectory fabricius: in a public directory?
so not in the database? PenguinMan98: wait, what? fabricius: and how you mean "public"? PenguinMan98: On my sites I set it up so in the root www/mlpnwrp/ there is a /public folder. That's where the public webroot is. The docroot is back at /mlpnwrp . The tiki install sits in the /public folder. Telesight: joined #tikiwiki PenguinMan98: doh fabricius: joined #tikiwiki PenguinMan98: eb
wb*
<PenguinMan98> On my sites I set it up so in the root www/mlpnwrp/ there is a /public folder. That's where the public webroot is. The docroot is back at /mlpnwrp . The tiki install sits in the /public folder. fabricius: anyway PenguinMan98 ... you should have set it up in a way, that you keep the webroot "clean", not to apply a domain directlly to the webroot, be able to install different cms besides each other, be able to install different Tikis besides each other, have the files directories of each Tiki "besides" the Tiki and NOT in the tikiroot -> in my setup the poath for the features(Linux based installation) would be ../files/feature - for ex..
I believe PenguinMan98 you know what you do anyway PenguinMan98: Well, my reasoning is that Tiki is meant to manage the whole website as a self-contained unit. Anything you add to the site you interface with the tikiwiki.
Are you arguing to move the tiki files out of the public directory and use redirects to access them? fabricius: no
there is a feature "filegallery" in Tiki, you know? PenguinMan98: yes
one I haven't spent much time learning and configuring fabricius: moving them outside the public by applying a different path to the feature seems to be feasible ... could make sense depending on the setup of the server and the control panel ... would not make sense with the control panel my provider uses and no sense on my local server
what you mean with "redirects" PenguinMan98 ? PenguinMan98: Use .htaccess to map all requests to the public directory to files in another directory.
That would allow me to move all my tiki files into a directory that cannot be downloaded fabricius: you have a field in the tiki-admin.php?page=fgal, where you can set the path to the directory
I never did it with Windows, but should be similar to Linux anyway
in Linux ../ means one level up .. something similar must exist for windows aswell? PenguinMan98: same thing fabricius: so in my setup I have the path ../files/gallery and my files all are out of the tikiroot - and not directly accessible by a domain
no htaccess or manual redirect for that PenguinMan98: joined #tikiwiki
Well, thanks. I'll look into that
It's good security practice
However, I'm still stuck with a dead database. fabricius: Ican just recommend to get the files out and to dump again
no idea if there is a way with kind of a windows shell -: PenguinMan98 shruggies PenguinMan98: I can't really fuss with it until I get home tonight Jyhem_laptop_: joined #tikiwiki arildb_: joined #tikiwiki arildb__: joined #tikiwiki marclaporte: joined #tikiwiki Caarrie|away: joined #tikiwiki dabright: joined #tikiwiki Telesight: joined #tikiwiki