Sorry for that Claudio :-). Will do that next time
-----Original Message-----
From: Claudio Miranda [mailto:claudio@claudius.com.br]
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
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.
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:Esbachb@tycoelectronics.com]
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:RNRukundo@syscorp.co.ug]
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.
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:RNRukundo@syscorp.co.ug]
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:Esbachb@tycoelectronics.com]
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:RNRukundo@syscorp.co.ug]
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.
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:RNRukundo@syscorp.co.ug]
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.
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
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
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?
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
