Linux Cybercafe Software

Gotdamnit , I can't link it to my MySQL , but I am interested of that project and am continuing trying .

Where exactly your problem with cyborg is ?

I don't know exactly where the problem is, but I can tell you that I think it has to do with my Apache configuration or I'm missing something. After installing Cyborg, I open my browser to my web server ,http://xxxx/cyborg, my script doesn't get executed, instead it just open the scripts. I'm stuck there.

BTW, I think the program was intended to work withe Postgresql, but MySQL should work too. Maybe you can help me to get it you where you are at. Like I said, I can't even the the site up in the first place.

Please let me know,
Thanks,
CNix

Ok , then check first your Apache configuration , is mode_perl loaded , do you have permitions exec to your cgi-bin , etc .

My problem is that I don't have Postgesql in my server and I don't want to install it , cause I see it will work with MySQL , just need to edit scripts a little ...

I'll keep on touch in monday :)

Hi Brabard,

Would you please show me how to check (what command) if mod_perl is loaded. I checked the cgi-bin permission and they are all executeable.

Thanks,
CNix

Hi Brabard,

If you don't mind would you please post your httpd.conf configuration file so I can compare the settings, you can change the pertinent ip info if you like.

Thanks,
CNix

Hi ,
sorry I was in rest for a week .
Now I am testing the interface , leaved db for this time .

I see there is some trouble with Perl libraries that are not included by default , so cgi-scripts can't run on my Apache , but I'll download and compile it and tell you when I will be able to run web interface completely .

How is with your experiments ?

Thanks the replying, I'm still trying to figure out my apache setup, I think I'm not configuring the scriptalias and the ExecCGI correctly. Lots of wasted time but no progress......

I hope you can shed some lights.
CNix

Well , what I have done :
1) Untgzed cyborg-0.10.18 , let it be in /
2) Created an subinterface eth1:1 ip 192.168.0.1 - it is not nessesery , of course , byt I wanted to make a single private network to test the software .
3) Configured httpd.conf as follows :
- Listen 192.168.0.1:80 #in global config section
- Made a virtula host - it is not nessesery , byt I have a few domains supported , so wanted to be a clear part :
<VirtualHost 192.168.0.1>
DocumentRoot /cyborg-0.1.18/htdocs/cyborg/
ScriptAlias /cgi-bin/ /cyborg-0.1.18/cgi-bin/cyborg/
<Dyrectory /cyborg-0.1.18/cgi-bin/cyborg/>
AllowOverride None
Options ExecCGI
Order allow,deny
Allow from all #Sure it is not so security , but we can change it later :)
</Dyrectory>
</VirtualHost>
4)Restarted apache and tried to access the site from a station 192.168.0.2 , looking in /var/log/apache/error.log to see what happen .
5)The cgi scripts now was running , but from logs I saw I needed to compile and install the following packets :
CGI.pm.tar.gz
String-Random-0.20.tzg
Template-Toolkit-2.13.tgz
all was found in www.cpan.org - Note! in some packets #make install will not place the .pm file and the dyrectory in /usr/lib/perl/5.8/ or where is your perl libraries path . So you need to copy it your self .
6)Now it is working till the row where is connection to the database - I told you I leaved connection with MySQL for later :)

Hope this will help you so far .

Regards
Brabard

Hello Brabard,

I tried to set the settings like you have and added the Alias then when I access the server I get the 500 server error telling me to contact the sys admin. When I looked at the log, it said that it can't locate CybOrg/Main.pm in @ /lib/perl5/site_per/5.8.3/i386-linux-thread-multi.....

I already installed Perl-string random, CGI.pm and the tool kit. I think its like you said to copy the .pm files to the /usr/lib/perl/5.8 dir but I dont' know how to check where to see where the .pm files are at to copy it over. Can you help on this, I think I'm almost there.

Thanks for your patience,
CNix

First check your dyrectory tree and locate your perl library . Depending to the version , it can be /usr/lib/perl/... , or /usr/lib/perl5 .
Actually cyborg is looking for perl modules (.pm files) in all possible locations , but you have to watch all needed modules have to be installed in one and the same place .
In my case it is /usr/lib/perl/5.8/
So copy there /cyborg-0.1.18/cgi-bin/cyborg/CybOrg/ directory and try again .

Regards
Brabard

Hi Brabard,

1. After following your instruction and installing String::Random, I got a different error, I think this is a database error, so I think I'm almost there. Here is the error see if you recognize it.

CybOrg::Exception=HASH(0x8c551cc)BEGIN failed--compilation aborted at /usr/lib/perl5/5.8.3/CybOrg/DB.pm line 182.
Compilation failed in require at /home/www/cyborg-0.1.18/cgi-bin/cyborg/cyborg.pl line 30.
BEGIN failed--compilation aborted at /home/www/cyborg-0.1.18/cgi-bin/cyborg/cyborg.pl line 30.

For help, please send mail to the webmaster (root@linux), giving this error message and the time and date of the error.



2.  BTW, somehow I cannot create the cyborg database as user cyborg using this command "createdb -U cyborg cyborg", here is the error I got....

psql: FATAL: IDENT authentication failed for user "cyborg"

Again thanks,
CNix

Yes , in row 182 ends a procedure that require to be linked to the cyborg database . Nothing more can be done before creating db ....

Now I don't think I am able to help , cause I am re-writing it for mysql . But I can tell you how I done it inMySQL :
as root #adduser cyborg
Password for user cyborg : password
#mysqladmin create cyborg
#mysql
>use cyborg;
>source /.../mycyborg.scl; #(I changed a little cyborg.sql for proper MySQL sintax..)
>grant all privileges on cyborg to cyborg@localhost identified by password;

So you can discover postgresql for simular commands .

Regards
Brabard

You know I really don't mind using mysql as the database, I just want to have it working. Currently I'm still researching and trying to understand postgres. I guess I'll have to open up another question about postgres, but have this one open to see if your re-writing to use mysql is successful. I'll keep you posted if I have any progress.

Thanks,
CNix

Sorry again , I told you before , I don't want to use pgsl driver(s) , but don't close that post , I am interested in that CyberCafee and will help in progres if I can ..

Regards
Brabard

Hi Bradard,

I have some progress, everything seems to be ok except I can't login to the admin page, I would type a username and passwd and it would act like it refresh itself and the name and passwd box is blanked out. Nothing happened. No error. Here is how the log looks like... Hope you can give me some ideas...

[Wed Apr 28 02:16:41 2004] [notice] Digest: generating secret for digest authentication ...
[Wed Apr 28 02:16:41 2004] [notice] Digest: done
[Wed Apr 28 02:16:42 2004] [notice] Apache/2.0.40 (Red Hat Linux) configured -- resuming normal operations

Thanks,
CNix

Hmm , where is this logging from ? It seems like messages ..
I don't know , I'll try it later today on another machine with postgresql , the only thing I can tell you by now is to look at all possible log files in the moment of login - messages , daemon.log , postges.log , /apache/error.log , /apache/access.log ..

Oops , I understood , it is from /val/lib/httpd/error_log generated by Apache under RH9 default configuration .
Sorry , I prefere Debian with manualy compiled servers , so I did mistake . Actually , these 3 rows are not error messages , just httpd notices .

Check the rest log files for errors .  I have a machine with RH9 , but have to install some additional servers to try cyborg .

Regards
Brabard

Hey , may be you have just didn't type proper user/password ! :)
May be stupid , but at the first look in cyborg login scripts , in case of right username/password it will leave you to continue , in case of wrong ones , it will take you back to the login screen with no error message !

I am not so sure , it was just at first look , bur remember the version is very rough .. 0.1.18 :)

Hi Brabard,

I gave up on trying. Its not working out. But I want to give you a few hundred points for trying to help me. I don't know how to do this so I can close out the question.

Hi CNix ,

thank you , but I don't think I hepled you even just a little :)
Btw , after our talk I have never tried to do somethink with this software , but now I see it' s a new version - 0.1.19 , may be some bugs were killed ?

If you think here is some useful information for other person , you can close the question with grade of C , if you don't just post a request for deleting the question in suport topic .

BR !
Brabard