- xwiki-users@xwiki.org - lists.xwiki.org

RE: [xwiki-users] xwiki mysql database?
by Roger Rukundo Nzabandora 03 May '06

03 May '06

Sorry for that Claudio :-). Will do that next time -----Original Message----- From: Claudio Miranda [mailto:[email protected]] Sent: Wednesday, May 03, 2006 4:50 PM To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] xwiki mysql database? Dear Roger, please never send a big file through a mailing list. As far 1 MB is big for a mailing list. Use one of free storage services (yousendit.com, megaupload.com) and point the url on the email. As far the reported error, this is a matter of path. Specify the complete xwiki.sql path to the mysql command. Or use // to enter the mysql command console mysql -u xwiki -pxwiki xwiki // load the sql script source 'script sql complete path'; Claudio Roger Rukundo Nzabandora wrote, On 03-05-2006 10:10: > I am trying to install xwiki on my windows XP Pro SP2 computer. I have > managed to follow all the instructions successfully up to the point of > setting up the xwiki database using the command "mysql -u xwiki -pxwiki > xwiki < xwiki.sql". I get an error message; "The system cannot find > specified file". I am using MySQL version 5.0.11 I don't know if this > could be an issue. Plus I seem to have a problem with the Database I > downloaded, when I look through it I find very strange characters which > might suggest that the downloadable DB is corrupted. I have attached a > copy of the data base as a txt file so you can cross check it and see if > there's anything wrong. I am new to this technology, please help. -- Claudio Miranda ___________________________________________________________________ http://www.claudius.com.br/blog claudio|em|claudius.com.br http://www.summa-tech.com Summa Technologies do Brasil http://www.soujava.org.br

1 0

xwiki mysql database?
by Roger Rukundo Nzabandora 03 May '06

03 May '06

I am trying to install xwiki on my windows XP Pro SP2 computer. I have managed to follow all the instructions successfully up to the point of setting up the xwiki database using the command "mysql -u xwiki -pxwiki xwiki < xwiki.sql". I get an error message; "The system cannot find specified file". I am using MySQL version 5.0.11 I don't know if this could be an issue. Plus I seem to have a problem with the Database I downloaded, when I look through it I find very strange characters which might suggest that the downloadable DB is corrupted. I have attached a copy of the data base as a txt file so you can cross check it and see if there's anything wrong. I am new to this technology, please help. Thanks.

2 1

RE: [xwiki-users] xwiki mysql database?
by Roger Rukundo Nzabandora 03 May '06

03 May '06

Thanks, I have managed to restore the DB with the MySQL Administrator tool v1.1. I have used file character set UTF-8. is this okay or I should use another character set? _____ From: Esbach, Brandon [mailto:[email protected]] Sent: Wednesday, May 03, 2006 4:24 PM To: xwiki-users(a)objectweb.org Subject: RE: [xwiki-users] xwiki mysql database? May not relate to your problem, just a few random thoughts: @xwiki.sql upload --The xwiki.sql file should be placed into your MySQL bin directory (usually under C:\Program Files\MySQL\MySQL Server 4.1\bin) before running the command line instruction; and the user "xwiki" with password "xwiki" must be created on MySQL beforehand. @odd characters: --There should be some odd-looking characters if you use notepad (or another text-based editor) to edit the .sql file, so this is most likely not the problem. It is worth comparing a second download of the .sql file in case though. @MySQL version 5.0.11 --Should not affect this step at all; *however* note that 5.0.11 is not really supported yet on XWiki (far as I know), so it may be that you experience other problems once installation is complete. @What I do with new installs: The xwiki.sql file you download can also be 'restored' through the MySQL Administrator tool (downloadable through the MySQL website). This is about the same effort as installing through the command line; BUT you can do all database tasks at once (creating user, setting up a backup process, etc). _____ From: Roger Rukundo Nzabandora [mailto:[email protected]] Sent: 03 May 2006 14:10 To: xwiki-dev(a)objectweb.org; xwiki-users(a)objectweb.org Subject: [xwiki-users] xwiki mysql database? I am trying to install xwiki on my windows XP Pro SP2 computer. I have managed to follow all the instructions successfully up to the point of setting up the xwiki database using the command "mysql -u xwiki -pxwiki xwiki < xwiki.sql". I get an error message; "The system cannot find specified file". I am using MySQL version 5.0.11 I don't know if this could be an issue. Plus I seem to have a problem with the Database I downloaded, when I look through it I find very strange characters which might suggest that the downloadable DB is corrupted. I have attached a copy of the data base as a txt file so you can cross check it and see if there's anything wrong. I am new to this technology, please help. Thanks.

2 1

RE: [xwiki-users] xwiki mysql database?
by Esbach, Brandon 03 May '06

03 May '06

Not sure if UTF-8 will work for you; I use ISO-8859-1 (sufficient for us). Note the configuration changes in the following document: http://www.xwiki.org/xwiki/bin/view/Dev/CharactersSets These changes should be made before you start using the system. ________________________________ From: Roger Rukundo Nzabandora [mailto:[email protected]] Sent: 03 May 2006 14:39 To: xwiki-users(a)objectweb.org Subject: RE: [xwiki-users] xwiki mysql database? Thanks, I have managed to restore the DB with the MySQL Administrator tool v1.1. I have used file character set UTF-8. is this okay or I should use another character set? ________________________________ From: Esbach, Brandon [mailto:[email protected]] Sent: Wednesday, May 03, 2006 4:24 PM To: xwiki-users(a)objectweb.org Subject: RE: [xwiki-users] xwiki mysql database? May not relate to your problem, just a few random thoughts: @xwiki.sql upload --The xwiki.sql file should be placed into your MySQL bin directory (usually under C:\Program Files\MySQL\MySQL Server 4.1\bin) before running the command line instruction; and the user "xwiki" with password "xwiki" must be created on MySQL beforehand. @odd characters: --There should be some odd-looking characters if you use notepad (or another text-based editor) to edit the .sql file, so this is most likely not the problem. It is worth comparing a second download of the .sql file in case though. @MySQL version 5.0.11 --Should not affect this step at all; *however* note that 5.0.11 is not really supported yet on XWiki (far as I know), so it may be that you experience other problems once installation is complete. @What I do with new installs: The xwiki.sql file you download can also be 'restored' through the MySQL Administrator tool (downloadable through the MySQL website). This is about the same effort as installing through the command line; BUT you can do all database tasks at once (creating user, setting up a backup process, etc). ________________________________ From: Roger Rukundo Nzabandora [mailto:[email protected]] Sent: 03 May 2006 14:10 To: xwiki-dev(a)objectweb.org; xwiki-users(a)objectweb.org Subject: [xwiki-users] xwiki mysql database? I am trying to install xwiki on my windows XP Pro SP2 computer. I have managed to follow all the instructions successfully up to the point of setting up the xwiki database using the command "mysql -u xwiki -pxwiki xwiki < xwiki.sql". I get an error message; "The system cannot find specified file". I am using MySQL version 5.0.11 I don't know if this could be an issue. Plus I seem to have a problem with the Database I downloaded, when I look through it I find very strange characters which might suggest that the downloadable DB is corrupted. I have attached a copy of the data base as a txt file so you can cross check it and see if there's anything wrong. I am new to this technology, please help. Thanks.

1 0

RE: [xwiki-users] xwiki mysql database?
by Esbach, Brandon 03 May '06

03 May '06

May not relate to your problem, just a few random thoughts: @xwiki.sql upload --The xwiki.sql file should be placed into your MySQL bin directory (usually under C:\Program Files\MySQL\MySQL Server 4.1\bin) before running the command line instruction; and the user "xwiki" with password "xwiki" must be created on MySQL beforehand. @odd characters: --There should be some odd-looking characters if you use notepad (or another text-based editor) to edit the .sql file, so this is most likely not the problem. It is worth comparing a second download of the .sql file in case though. @MySQL version 5.0.11 --Should not affect this step at all; *however* note that 5.0.11 is not really supported yet on XWiki (far as I know), so it may be that you experience other problems once installation is complete. @What I do with new installs: The xwiki.sql file you download can also be 'restored' through the MySQL Administrator tool (downloadable through the MySQL website). This is about the same effort as installing through the command line; BUT you can do all database tasks at once (creating user, setting up a backup process, etc). ________________________________ From: Roger Rukundo Nzabandora [mailto:[email protected]] Sent: 03 May 2006 14:10 To: xwiki-dev(a)objectweb.org; xwiki-users(a)objectweb.org Subject: [xwiki-users] xwiki mysql database? I am trying to install xwiki on my windows XP Pro SP2 computer. I have managed to follow all the instructions successfully up to the point of setting up the xwiki database using the command "mysql -u xwiki -pxwiki xwiki < xwiki.sql". I get an error message; "The system cannot find specified file". I am using MySQL version 5.0.11 I don't know if this could be an issue. Plus I seem to have a problem with the Database I downloaded, when I look through it I find very strange characters which might suggest that the downloadable DB is corrupted. I have attached a copy of the data base as a txt file so you can cross check it and see if there's anything wrong. I am new to this technology, please help. Thanks.

1 0

how to include external rss feed?
by Brian Knorr 01 May '06

01 May '06

I am trying to include and external rss feed in my xwiki page but it doesn't seem to work. I am trying the rss macro with the following rss feed: http://groups.google.com/group/watij/feed/rss_v2_0_msgs.xml But it just errors out...please help! Thanks, Brian

2 7

[xwiki-users] Cookies, domains and authentication
by Robin Fernandes 30 Apr '06

30 Apr '06

Hi, I have a couple of questions about cookies. I'm using v0.9.840 on my localhost. The following behaviour is consistently reproducible, and maybe as designed, but I do not understand it. Any help would be much appreciated! The value of xwiki.authentication.cookiedomains value has some effects on persistent login cookie creation, which in turn affects whether XWikiAuthServiceImpl.authenticate(user, password,context) is called on every page view or not. Below is the outcome of some experiments with different cookiedomains values. Between each test I shut down Tomcat, wiped my cookies for localhost, changed xwiki.cfg as described and relaunched tomcat: xwiki.authentication.cookiedomains=localhost . persistent login cookies created: no (only style and JSESSIONID) . authentication on every page view: no, XWikiAuthServiceImpl.authenticate(user, password,context) is ONLY CALLED ONCE (when loging in) xwiki.authentication.cookiedomains= . persistent login cookies created: yes (rememberme, validation, password, username, style and JSESSIONID) . authentication on every page view: yes, XWikiAuthServiceImpl.authenticate(user, password,context) is called on every page view. xwiki.authentication.cookiedomains=calh (or any subtring of 'localhost') . persistent login cookies created: no (only style and JSESSIONID) . authentication on every page view: no, XWikiAuthServiceImpl.authenticate(user, password,context) is ONLY CALLED ONCE (when loging in) xwiki.authentication.cookiedomains=some_other_string (that isn't a substring of 'localhost') . persistent login cookies created: yes (rememberme, validation, password, username, style and JSESSIONID) . authentication on every page view: yes, XWikiAuthServiceImpl.authenticate(user, password,context) is called on every page view. I realise I'm probably using this setting incorrectly, excuse my lack of knowledge of cookies... but even so, this behaviour seems odd to me: 1. Why are the persistent login cookies not created when the cookiedomains value is a substring of the server name? What I think is happening from reading the code: in my examples the cookies are assigned a domain name that doesn't match the actual domain of the server (I guess 'localhost' is not a valid domain name for machine localhost :), so they are never set properly. The XWiki code has a basic check to ensure the desired cookie domain has some correlation with the server name and ignores it not... but it is fooled if the value is a substring of the hostname. Is this a standard way of doing things or is there room for improvement here? 2. Looking at the code I can see we need the persistent login cookies to extract the username & password in order to call XWikiAuthServiceImpl.authenticate with valid params. But the way it's currently written, a user can bypass XWikiAuthServiceImpl.authenticate if the persistent login cookies are not set: if I have a valid session cookie, I can just delete my persistent login cookies and browse the wiki without XWikiAuthServiceImpl.authenticate being called. Is this expected? This thread would suggest not: http://mail-archive.objectweb.org/xwiki-dev/2006-02/msg00027.html I have spent some time looking at the code, but don't have sufficient understanding of the expected flow through (or even the purpose of) the numerous checkAccess, checkAuth, processLogin, checkLogin and authenticate methods, nor their expected interaction with cookies. Thanks for any info! On a side note, is it possible to configure things so that "http://myHostName" and "http://myHostName.myDomain.com" share XWiki cookies? Regards, Robin

1 0

DevGuide.FAQs Tutorial issue
by vtmagnard＠free.fr 30 Apr '06

30 Apr '06

Hi all, I have followed the instruction to create a FAQ using the following page: http://www.xwiki.org/xwiki/bin/view/DevGuide/FAQs+Tutorial When I created my document it was empty, and there was no form to edit. The code in the document was: #includeForm("XWiki.FAQs.FAQClassSheet") Where it should be : #includeForm("FAQs.FAQClassSheet") I fixed this issue when I recreated the FAQ Class with the wizard. I removed XWiki. from the following line #set($defaultparent = "XWiki.${class}Class") Is that a error in the documentation or I did mistake somewhere else?

1 0

can't see blog entries
by Dave Mangot 28 Apr '06

28 Apr '06

I haven't heard anything back, so perhaps my last post wasn't explained very well. When I enter a new page using "Add a News" on the front page of my Xwiki, my page shows up on the front page as a new entry, but never appears in the category I had assigned to it. What could that be? -Dave -- Dave Mangot Terracotta Inc. 650 Townsend St. Suite 325 San Francisco, CA 94103 USA +1 415 738 4059 dmangot(a)terracottatech.com This e-mail incorporates Terracotta's confidentiality policy, which is online at http://www.terracottatech.com/emailconfidentiality.shtml

2 2

any news on 1.0 release date
by Duke Tantiprasut 28 Apr '06

28 Apr '06

Hi All, any news on when the 1.0 candidates will be available? Cheers Duke

3 4