From: William L. <le...@k2...> - 2006-05-01 09:46:39
|
Hello Everyone, I have a phpwiki set up at http://www.k2wrpg.org/wiki/ and we've been noticing some odd behaviors on that server. Every once in a while the wiki will become unresponsive. Other parts of the site (that also use php and MySQL) don't seem to be affected right away. Eventually everything using the web service becomes unresponsive. When running a netstat on the machine, there are a thousand or more connections from spiders sitting in a CLOSE_WAIT state. Checking the logs shows that Apache errors with "Server ran out of threads to serve requests." So here is my theory. Something on the server gets a hit that cause the apache child thread to hang. Over time, visitors and spiders hitting this resource cause more threads to start and hang. Eventually the server runs out of threads and the whole server stops responding. Now this seems like it might be some sort of server configuration issue, but I'm not entirely sure thats the case. The reason I am bringing this up on this list is the wiki starts showing symptoms long before other things on the server. For example, the wiki becomes unresponsive, but Mantis at http://www.k2wrpg.org/mantis/ (which also uses PHP and MySQL) remains in working order until the site as a whole stops responding. When it gets to this point static items that are plain HTML, or images are not served. Does anyone have any thoughts on this? Thanks! -William Leader Server Basics: Windows XP SP2 Apache 1.3.34 MySQL 4.1.18 PHP 4.4.2 phpwiki 1.3.12p2 |
From: William L. <le...@k2...> - 2006-05-08 17:57:53
|
Just to follow up on this, It seems that upgrading MySQL to 5.0.21 (Latest as of this writing) cleared up the problem listed below. I did however run into one new problem, But I am going to start a new thread for that. -Will > Hello Everyone, > I have a phpwiki set up at http://www.k2wrpg.org/wiki/ and we've > been noticing some odd behaviors on that server. Every once in a while > the wiki will become unresponsive. Other parts of the site (that also > use php and MySQL) don't seem to be affected right away. Eventually > everything using the web service becomes unresponsive. When running a > netstat on the machine, there are a thousand or more connections from > spiders sitting in a CLOSE_WAIT state. Checking the logs shows that > Apache errors with "Server ran out of threads to serve requests." > > So here is my theory. Something on the server gets a hit that cause > the apache child thread to hang. Over time, visitors and spiders > hitting this resource cause more threads to start and hang. Eventually > the server runs out of threads and the whole server stops responding. > Now this seems like it might be some sort of server configuration > issue, but I'm not entirely sure thats the case. The reason I am > bringing this up on this list is the wiki starts showing symptoms long > before other things on the server. For example, the wiki becomes > unresponsive, but Mantis at http://www.k2wrpg.org/mantis/ (which also > uses PHP and MySQL) remains in working order until the site as a whole > stops responding. When it gets to this point static items that are > plain HTML, or images are not served. > > Does anyone have any thoughts on this? > > Thanks! > -William Leader > > Server Basics: > Windows XP SP2 > Apache 1.3.34 > MySQL 4.1.18 > PHP 4.4.2 > phpwiki 1.3.12p2 > > > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > > |
From: William L. <le...@k2...> - 2006-05-09 01:03:40
|
Ok, as mentioned in my other message I have a new problem. This problem came up when upgrading from MySQL 4.1.18 to 5.0.21. WantedPages now seems to be broken. Anyone should be able to see it at http://www.k2wrpg.org/wiki/index.php/WantedPages. If you do check it out you will see that it bombs out with this error: lib\WikiDB\backend\PearDB.php (In template 'body' < 'html'):1027: Error: wikidb_backend_peardb_mysql: fatal database error * DB Error: no such field * (SELECT page.pagename,linked.pagename as wantedfrom FROM link,page as linked LEFT JOIN page ON (link.linkto=page.id) LEFT JOIN nonempty ON (link.linkto=nonempty.id) WHERE ISNULL(nonempty.id) AND linked.id=link.linkfrom AND linked.pagename NOT IN ('PgsrcTranslation','InterWikiMap') LIMIT 0, 300 [nativecode=1054 ** Unknown column 'link.linkto' in 'on clause']) Now I know just enough SQL to see that this is a really complicated join, and that I don't completely understand what the problem is. What really confuses me is the Unknown column 'link.linkto' because linkto certainly is a column of link, I really would like to help fix this because WantedPages is one of my favorite pages, and I use it frequently to find stuff that needs to be done. Thanks! -Will |
From: Reini U. <ru...@x-...> - 2006-05-09 07:59:24
|
How did you fix it? Reverting back to mysql-4.1.18 ? 2006/5/7, William Leader <le...@k2...>: > Ok, as mentioned in my other message I have a new problem. This problem > came up when upgrading from MySQL 4.1.18 to 5.0.21. WantedPages now > seems to be broken. Anyone should be able to see it at > http://www.k2wrpg.org/wiki/index.php/WantedPages. If you do check it out > you will see that it bombs out with this error: > > lib\WikiDB\backend\PearDB.php (In template 'body' < 'html'):1027: Error: > wikidb_backend_peardb_mysql: fatal database error > > * DB Error: no such field > * (SELECT page.pagename,linked.pagename as wantedfrom FROM link,page > as linked LEFT JOIN page ON (link.linkto=3Dpage.id) LEFT JOIN > nonempty ON (link.linkto=3Dnonempty.id) WHERE ISNULL(nonempty.id) > AND linked.id=3Dlink.linkfrom AND linked.pagename NOT IN > ('PgsrcTranslation','InterWikiMap') LIMIT 0, 300 [nativecode=3D1054 > ** Unknown column 'link.linkto' in 'on clause']) > > Now I know just enough SQL to see that this is a really complicated > join, and that I don't completely understand what the problem is. What > really confuses me is the Unknown column 'link.linkto' because linkto > certainly is a column of link, > > I really would like to help fix this because WantedPages is one of my > favorite pages, and I use it frequently to find stuff that needs to be > done. -- Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: William L. <wi...@pr...> - 2006-05-08 17:17:14
|
William Leader wrote: Alright, I ended up figuring this one out... I got Google lucky. According to http://dev.mysql.com/doc/refman/5.0/en/join.html: | <Quote> INNER JOIN| and |,| (comma) are semantically equivalent in the absence of a join condition: both produce a Cartesian product between the specified tables (that is, each and every row in the first table is joined to each and every row in the second table). However, the precedence of the comma operator is less than than of |INNER JOIN|, |CROSS JOIN|, |LEFT JOIN|, and so on. If you mix comma joins with the other join types when there is a join condition, an error of the form |Unknown column '/|col_name|/' in 'on clause'| may occur. Information about dealing with this problem is given later in this section. </Quote> and sure enough later in the document they explain it. Basically prior to MySQL 5.0.12, Join and the comma operator were treated the same, but in 5.0.12 and later, the join keyword has higher precedence than the comma. So because the wanted pages code simplified is "... From link,page Join page join nonempty ..." MySQLl joins the link table last because it is joined by a comma rather than the join keyword. The Solution: in wiki/lib/WikiDB/backend/PearDB_mysql.php line 127: Change . " FROM $link_tbl,$page_tbl as linked " To . " FROM $link_tbl JOIN $page_tbl as linked " -William Leader > Ok, as mentioned in my other message I have a new problem. This > problem came up when upgrading from MySQL 4.1.18 to 5.0.21. > WantedPages now seems to be broken. Anyone should be able to see it at > http://www.k2wrpg.org/wiki/index.php/WantedPages. If you do check it > out you will see that it bombs out with this error: > > lib\WikiDB\backend\PearDB.php (In template 'body' < 'html'):1027: > Error: wikidb_backend_peardb_mysql: fatal database error > > * DB Error: no such field > * (SELECT page.pagename,linked.pagename as wantedfrom FROM link,page > as linked LEFT JOIN page ON (link.linkto=page.id) LEFT JOIN > nonempty ON (link.linkto=nonempty.id) WHERE ISNULL(nonempty.id) > AND linked.id=link.linkfrom AND linked.pagename NOT IN > ('PgsrcTranslation','InterWikiMap') LIMIT 0, 300 [nativecode=1054 > ** Unknown column 'link.linkto' in 'on clause']) > > Now I know just enough SQL to see that this is a really complicated > join, and that I don't completely understand what the problem is. What > really confuses me is the Unknown column 'link.linkto' because linkto > certainly is a column of link, > > I really would like to help fix this because WantedPages is one of my > favorite pages, and I use it frequently to find stuff that needs to be > done. > > Thanks! > -Will > |
From: William L. <le...@k2...> - 2006-05-09 08:16:08
|
I composed this message once before but it seems to have gotten lost in the ether. I ended up figuring this one out... I got Google lucky. According to http://dev.mysql.com/doc/refman/5.0/en/join.html: <Quote> INNER JOIN| and |,| (comma) are semantically equivalent in the absence of a join condition: both produce a Cartesian product between the specified tables (that is, each and every row in the first table is joined to each and every row in the second table). However, the precedence of the comma operator is less than than of |INNER JOIN|, |CROSS JOIN|, |LEFT JOIN|, and so on. If you mix comma joins with the other join types when there is a join condition, an error of the form |Unknown column '/|col_name|/' in 'on clause'| may occur. Information about dealing with this problem is given later in this section. </Quote> and sure enough later in the document they explain it. Basically prior to MySQL 5.0.12, Join and the comma operator were treated the same, but in 5.0.12 and later, the join keyword has higher precedence than the comma. So because the wanted pages code simplified is "... From link,page Join page join nonempty ..." MySQLl joins the link table last because it is joined by a comma rather than the join keyword. The Solution: in wiki/lib/WikiDB/backend/PearDB_mysql.php line 127: Change . " FROM $link_tbl,$page_tbl as linked " To . " FROM $link_tbl JOIN $page_tbl as linked " -William Leader |
From: Stefan <son...@ba...> - 2006-05-11 12:10:03
|
i need to get the authentification from an other system. When the user is signed in at the forum he should also be signed in at phpwiki. I do have functions which give me the signed in user and membergroups. Where do i have to implement them in phpwiki? I also will check against the external groups if a user can edit, is admin or guest. Thank you for the help Stefan |
From: Manuel V. <man...@gm...> - 2006-05-11 12:49:37
|
2006/5/11, Stefan <son...@ba...>: > i need to get the authentification from an other system. When the user > is signed in at the forum he should also be signed in at phpwiki. You should be able to re-use existing sessions with 'Session' in USER_AUTH_ORDER. There is also 2 other variable. For groups, I think you should look at GROUP_METHOD. Manuel |
From: Reini U. <ru...@x-...> - 2006-05-14 12:44:26
|
2006/5/9, William Leader <le...@k2...>: > I composed this message once before but it seems to have gotten lost in > the ether. I ended up figuring this one out... I got Google lucky. > > According to http://dev.mysql.com/doc/refman/5.0/en/join.html: > > <Quote> > INNER JOIN| and |,| (comma) are semantically equivalent in the absence > of a join condition: both produce a Cartesian product between the > specified tables (that is, each and every row in the first table is > joined to each and every row in the second table). > > However, the precedence of the comma operator is less than than of > |INNER JOIN|, |CROSS JOIN|, |LEFT JOIN|, and so on. If you mix comma > joins with the other join types when there is a join condition, an error > of the form |Unknown column '/|col_name|/' in 'on clause'| may occur. > Information about dealing with this problem is given later in this sectio= n. > </Quote> > > and sure enough later in the document they explain it. Basically prior > to MySQL 5.0.12, Join and the comma operator were treated the same, but > in 5.0.12 and later, the join keyword has higher precedence than the > comma. So because the wanted pages code simplified is "... From > link,page Join page join nonempty ..." MySQLl joins the link table last > because it is joined by a comma rather than the join keyword. > > The Solution: > in wiki/lib/WikiDB/backend/PearDB_mysql.php line 127: > Change > . " FROM $link_tbl,$page_tbl as linked " > To > . " FROM $link_tbl JOIN $page_tbl as linked " Thanks! Fixed now in CVS. According ANSI SQL rules, so it is now: $sql =3D "SELECT p.pagename, pp.pagename as wantedfrom" . " FROM $page_tbl p JOIN $link_tbl linked" . " LEFT JOIN $page_tbl pp ON linked.linkto =3D pp.id" . " LEFT JOIN $nonempty_tbl ne ON linked.linkto =3D ne.id" . " WHERE ne.id is NULL" =09 . " AND p.id =3D linked.linkfrom" . $exclude_from . $exclude . $orderby; mysql uses the derivate: WHERE ISNULL(ne.id) --=20 Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: Stefan <son...@ba...> - 2006-05-12 09:03:24
|
Can't handle it like that I only get a authentificated userid, don't know if it is from a session a database or where it comes from This user should be also fully authentificated (like login with userid and password). here is the possible code to use (from SMF forum software) require("/path to/SSI.php"); if (!$context['user']['is_guest']) { $userid = $context['user']['name']; } now $userid is the authentificated user I don't know where to insert this code that phpwiki is using this $userid and did'nt ask for auth anymore. Thx Stefan Manuel Vacelet schrieb: > 2006/5/11, Stefan <son...@ba...>: >> i need to get the authentification from an other system. When the user >> is signed in at the forum he should also be signed in at phpwiki. > > You should be able to re-use existing sessions with 'Session' in > USER_AUTH_ORDER. There is also 2 other variable. > > For groups, I think you should look at GROUP_METHOD. > > Manuel > > > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=k&kid0709&bid&3057&dat1642 > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > > |
From: Manuel V. <man...@gm...> - 2006-05-12 12:24:07
|
2006/5/12, Stefan <son...@ba...>: > Can't handle it like that > > I only get a authentificated userid, don't know if it is from a session > a database or where it comes from > This user should be also fully authentificated (like login with userid > and password). Actually, whatever authentication your forum is using, it probably use session (cookies) to keep the authentication from one page to another. The 'Session' type of authentication propose to re-use the authentication token issued by another application. You just have to give this token to the AUTH_SESS_USER const. According to config.ini you just have to set USER_AUTH_ORDER =3D Session AUTH_SESS_USER =3D $context['user']['name'] AUTH_SESS_LEVEL =3D 2 USER_AUTH_POLICY =3D first-only (and probably to include /path to/SSI.php in main.php for instance). |
From: Thomas H. <tom...@gm...> - 2006-04-04 03:57:24
|
By the way, if I try to sign in at http://hawsedc.com/phpwiki-1.3.12p2/index.php?action=3Dupgrade I get the first errors again: Fatal PhpWiki Error lib/WikiDB/backend/PearDB.php:1027: Error: WikiDB_backend_PearDB_mysql: fatal database error - DB Error: no such table - (SELECT prefs FROM pref WHERE userid=3D'hawstom' [nativecode=3D1146 ** Table 'XXXXXXX_phpwiki1.pref' doesn't exist]) - *Notice*: Undefined property: WikiRequest::$_user in * /home/XXXXXX/public_html/hawsedc/phpwiki-1.3.12p2/lib/main.php* on line *73= 4 * |
From: Reini U. <ru...@x-...> - 2006-04-04 07:35:00
|
If you use a SQL database you have to configure and initialize the database= . There are some README's about that. In the schemas directory are also upgrade hints for mysql. 2006/4/4, Thomas Haws <tom...@gm...>: > I am a bit embarrassed, but my wiki blues turned out to be largely > self-inflicted. That said, I am still singing them, though I have made a > lot of progress. > > To begin with, the correct URL is (sorry) > > http://hawsedc.com/phpwiki-1.3.12p2/index.php > > That url gives one error that seems to indicate I need to upgrade. > > But when I go to: > > http://hawsedc.com/phpwiki-1.3.12p2/index.php?action=3Dupgrade > > I get a tantalizing view of phpwiki, but it says, "Missing PagePermission= : > change HomePage is disallowed on this wiki for not authenticated user ' > 70.176.232.214' (level: ANON)." > > and > > > > lib/WikiDB/backend/PearDB.php:1027: Error: > WikiDB_backend_PearDB_mysql: fatal database error > DB Error: no such table > (INSERT INTO accesslog > (time_stamp,remote_host,remote_user,request_method,request_line,request_u= ri,request_args,request_time,status,bytes_sent,referer,agent,request_durati= on) > VALUES(1144122753,'ip70-176-232-214.ph.ph.cox.net','-','GET','GET > /phpwiki-1.3.12p2/index.php?action=3Dupgrade > HTTP/1.1','/phpwiki-1.3.12p2/index.php?action=3Dupgrade','action=3Dupgrad= e','03/Apr/2006:23:52:33 > -0400',200,0,'','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0= .1) > Gecko/20060111 Firefox/1.5.0.1','0.327347040176') [nativecode=3D1146 ** T= able > 'jconstru_phpwiki1.accesslog' doesn't exist])So now I guess I am really > close, but still broke. Oh, yeah. -- Reini Urban http://phpwiki.org/ http://spacemovie.mur.at/ http://helsinki.at/ |
From: joel s. <fox...@gm...> - 2006-04-05 03:43:33
|
Perhaps if you're just setting up a wiki for the first time and want to see it running quickly you could try the file based db. It's a little easier and quicker than the other methods if you just want to see your wiki up and running and try it out. Read the notes and it will tell you what you need to know about picking where the wiki saves to, and then making sure the apache (or whatever user runs the website) has write permission to that directory. Joel Schaubert On 4/4/06, Reini Urban <ru...@x-...> wrote: > > If you use a SQL database you have to configure and initialize the > database. > There are some README's about that. > > In the schemas directory are also upgrade hints for mysql. > > 2006/4/4, Thomas Haws <tom...@gm...>: > > I am a bit embarrassed, but my wiki blues turned out to be largely > > self-inflicted. That said, I am still singing them, though I have made > a > > lot of progress. > > > > To begin with, the correct URL is (sorry) > > > > http://hawsedc.com/phpwiki-1.3.12p2/index.php > > > > That url gives one error that seems to indicate I need to upgrade. > > > > But when I go to: > > > > http://hawsedc.com/phpwiki-1.3.12p2/index.php?action=3Dupgrade > > > > I get a tantalizing view of phpwiki, but it says, "Missing > PagePermission: > > change HomePage is disallowed on this wiki for not authenticated user ' > > 70.176.232.214' (level: ANON)." > > > > and > > > > > > > > lib/WikiDB/backend/PearDB.php:1027: Error: > > WikiDB_backend_PearDB_mysql: fatal database error > > DB Error: no such table > > (INSERT INTO accesslog > > > (time_stamp,remote_host,remote_user,request_method,request_line,request_u= ri,request_args,request_time,status,bytes_sent,referer,agent,request_durati= on) > > VALUES(1144122753,'ip70-176-232-214.ph.ph.cox.net','-','GET','GET > > /phpwiki-1.3.12p2/index.php?action=3Dupgrade > > HTTP/1.1','/phpwiki-1.3.12p2 > /index.php?action=3Dupgrade','action=3Dupgrade','03/Apr/2006:23:52:33 > > -0400',200,0,'','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: > 1.8.0.1) > > Gecko/20060111 Firefox/1.5.0.1','0.327347040176') [nativecode=3D1146 ** > Table > > 'jconstru_phpwiki1.accesslog' doesn't exist])So now I guess I am really > > close, but still broke. Oh, yeah. > > -- > Reini Urban > http://phpwiki.org/ > http://spacemovie.mur.at/ http://helsinki.at/ > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642 > _______________________________________________ > Phpwiki-talk mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpwiki-talk > |