Bekijk de volledige versie : PHPBB / MySQL
Better make this question quick and simple:
Is it possible to get a forum like phpBB working on a WL500Gx. (At this moment I am at the point where I installed webserver / PHP / sqlite and click the install button of phpBB - nothing happens except a "page cannot be displayed")
Thanks in advance!
Do ordinary html or simple 'hello world' php pages work? I suggest you start easy and gradually pushing the boundaries because:
I've also tried to run advanced php scripted websites, but there are significant problems when trying to get it to work on an embedded device. This is mainly because many directories are read-only, do not exist, etc. in contrast to ordinary webservers.
I've found that when trying Dokuwiki, as a documentation website for the webtools project, on my WL-500g it reported every problem it encountered in it's html output which was very helpful to me.
There is one major problem though.
MySQL dosnt run on the Wiley, and it seems like tinysql dosnt work too well either.
MySQL dosnt run on the Wiley, and it seems like tinysql dosnt work too well either.
And so I've noticed... The installation of PHPBB fails after having to choose which type of database you are using. I guess this is because MySQL and sqlite are not compatible :(
Would be great though if something like this would be possible... It would expand the possibilities for these devices. I myself am used to programming ASP and not a natural talent when it comes to PHP, but I do recognize the potential of this language.
What would be the best way to get MySQL support for the routers started? I read somewhere that libstdc++ support in the firmware is one of the main prerequisites, but after that? Is there anyone here with enough knowledge to get this working?
The best way would be to try to compile it, and then add it to the official package stream once compiled ;-)
...the problem is hte uclib version used in Olegs Firmware. Maby Oleg should consider trying to implement the same uclib as used in the Slug....Oleg? ;-)
Yes please! :D
Oleg? Would this be possible?
Jean-Fabrice
11-08-2005, 20:54
...the problem is hte uclib version used in Olegs Firmware. Maby Oleg should consider trying to implement the same uclib as used in the Slug....Oleg? ;-)
AFAIK, this is not a problem with Oleg's firmware but with Asus since they only provide binaries (no source code) for some modules of the firmware (like the ethernet module afair). These binaries are linked against the original uclibc used by Asus. You cannot then use a newer uclibc to build the firmware.
JF
Sorry for asking. I have some basic knowledge, but don't know enough about the architecture of the routers and software/firmware.
Does this mean that in order to get a MySQL based website running, the only way is that you need to install something like Debian first on a memory stick and then try it again?
Jean-Fabrice
11-08-2005, 22:27
Sorry for asking.
no problem ;)
Does this mean that in order to get a MySQL based website running, the only way is that you need to install something like Debian first on a memory stick and then try it again?
I think the best way would be.... to buy a slug (http://www.linksys.com/servlet/Satellite?childpagename=US%2FLayout&packedargs=c%3DL_Product_C2%26cid%3D1118334819312&pagename=Linksys%2FCommon%2FVisitorWrapper) and install unslung (http://www.nslu2-linux.org/) on it. There is a mysql optware (package) for it :) The good news is that you can also simply double it's cpu speed, making it a turboslug (http://www.nslu2-linux.org/wiki/HowTo/OverClockTheSlug), running a 266Mhz instead of 133
JF
For an additional 85 euros, that is worth a try. Is the procedure you described documented (cause I'm somewhat hesitating to find everything out by myself since I'm not the *nix guru)
Jean-Fabrice
11-08-2005, 23:21
Everything is documented here : http://www.nslu2-linux.org/wiki/HowTo/OverClockTheSlug
unslung optwares install themselves like on a wiley (oh no ! : wiley optwares installs themselves like on unslung ;)) : using ipkg. So everyting is pretty simple.
JF
Another way could be to go OpenWRT. Im not sure if there is ipk packages available for MySQL, but I think it would be possible to build MySQL for OpenWRT.
I was wondering if anybody is currently running some form of relational database on their wl500 and how are you doing it?
(does not actually need to be sql based)
Thanks :o
I was wondering if anybody is currently running some form of relational database on their wl500 and how are you doing it?
(does not actually need to be sql based)
Thanks :o
Already trying another one, but I think I'll get it working without help :(
http://wl500g.info/showthread.php?t=3022
Already trying another one, but I think I'll get it working without help :(
Well I have a game that I wrote that stores its state using mySQL. I tried a php-flat-file database (db-api) and it is slooooow. Even the game itself takes its time to execute on WL but with al this SQL parsing (preg_match) it is unplayable (30+ seconds to calculate and load). I guess I'll have to rewrite a few aspects to get it to run on my WL500gx.
The game is a port of Carcassonne. Check it out here (http://153.5.16.38:8107/ccn/ccn.php).
Stupid question: how does one install anything on the router? I mean, say I want to install a simple web server, what's the procedure? Feel free to post linkage to pages with info.
I understand from this post that this is possible, but not how.
thanks
Stupid question
Agreed
I understand from this post that this is possible, but not how.
Using the search button or your own curiosity, you would eventually should have come to the WIKI pages or www.macsat.com (the latter has excellent tutorials).
Good luck!
Thanks, that's all I asked. I'm actually not all that stupid either, but I don't hesitate shooting out dumb questions when I feel I have to and Google doesn't come through with the answers. It's all for good cause, anyway.
Asking the question is the only way I can help you mate! ;)
Is it working yet?
Asking the question is the only way I can help you mate! ;)
Is it working yet?
Actually, not quite. I've installed the ipkg, www and RRDTool, but I can't get to the www page. All installs went good, but when rebooting, the newly created disk drive is not mounted as as /opt and nothing goes.
Good tutorials, though. Wish it worked... :confused:
This post was originally intended to answer PHP/MYSQL issues, so if you are having problems working with the packages, I suggest you open another topic.
Nevertheless....:
You should add the mount command to the post-boot file. If it does not exist yet, first follow these steps:
mkdir /usr/local
mkdir /usr/local/sbin
touch /usr/local/sbin/post-boot
chmod +x /usr/local/sbin/*
You can install an editor like NANO with ipkg, then use it to open the file:
/opt/bin/nano /usr/local/sbin/post-boot
Put this on the first lines of your post-boot file:
#!/bin/sh
mount /dev/discs/disc0/part1 /opt (<-change this to your device names)
The router will execute this command on startup, and will mount /dev/discs/dicso/part1 as /opt.
Good luck!
Sorry, didn't mean to shift focus from your issue. New post comming up.
Hope you figure out this one too.
Brennivin
26-08-2005, 11:35
Why don't you use the ipkg package sql-lite, which can be get via "ipkg install sqlite"?
I'm sure there are some forum scripts, which can handle sql-lite databases.
Please post if you had success with this.
Why don't you use the ipkg package sql-lite, which can be get via "ipkg install sqlite"?
If you had read the startpost thoroughly, you would have seen that I have already tried that. Doesn't work with PHPBB. :(
I'm sure there are some forum scripts, which can handle sql-lite databases.
I don't know. Haven't run into any. :(
Brennivin
26-08-2005, 14:06
Sorry,
I must have missed this.
phpBB will have SQLite support within phpBB2.2.x, but I don't know, when this will be released.
Anyhow, a user of phpBB2.0.x managed to get it work with SQLite, please take a look here:
http://www.phpbb.com/phpBB/viewtopic.php?p=1117738#1117738
But anyhow, here are some forums, which can work with SQLite:
http://punbb.org/about.php
http://www.k4bb.org/
http://www.php4scripte.de/flexorum.php (only german)
SQLITE function is included in PHP5, but not in PHP4.
Another thing:
SQLite will be only performant, if max 20 users make server-request simultanously.
For higher performance, we surely need MySQL.
I would also appreciate MySQL in future versions, but until this, I will try SQLite myself.
Brennivin! As of now, you are offcially my hero of the day! Thanks for the links, will try this as soon as I have the time!
Tried PunBB, but as soon as I hit the "install" button from the install.php page, I receive a Page Cannot Be Displayed :(
Brennivin
29-08-2005, 16:50
A further possibility might be to use the postgresql-package.
PostGreSQL is better for higher traffic forums...
I have Easyforum (php only!) and punbb (php+sqlite) working on the Asus.
But on the wl500g, I do have some performance issues with the php-thttpd package. I think it works better on the wl500gx.
Easyforum works fine though....
Peter
Brennivin
31-08-2005, 18:10
[Edit: here also success]
I installed "adduser".
I need some help:
tried to run the postgresql database daemon, but it is only allowed to run this with some other user rights than root.
Anyhow, the firmware do not know the command "su", which is necessary to run a program under another user.
How do I get it running?
Another question:
I tried to install LinPHA as Image Gallery. It requires imagemagick/gd.
I ipkg'd nad installed "libgd". What have I got to do to let LinPHA find the lib?
[Edit: Successfully installed LinPHA]
Hi, I simply forgot to install "php-gd". That did the trick and is working fine with SQLite. I have no imagemagick installed, because I have found no binary...
[Edit: Success with punBB/sqlite]
Finally got it working, chmod 777 to /www did the trick