When you do an installation of Koha (on Debian Linux) what port is mySQL on? Do you need to change anything to access it from another machine? (I'm sure I managed to access it before ...) Thanks, Andrew --- Andrew Buxton, Library Web and Information Systems Manager Direct line: 01273 915795 - International +44 1273 915795 IDS website: http://www.ids.ac.uk/ Library website: http://blds.ids.ac.uk<http://blds.ids.ac.uk/>/ This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS. Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914
Andrew Buxton writes
When you do an installation of Koha (on Debian Linux) what port is mySQL on?
On your mysql default. krichel@trabbi:~$ grep mysql /etc/services mysql 3306/tcp mysql 3306/udp
Do you need to change anything to access it from another machine? (I'm sure I managed to access it before ...)
I think by default it only listens to the loopback address. This is what /etc/mysql/my.cnf for Debian testing says. I am sure I didn't change mine. Cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
Hi Andrew, In my Debian installation I had to comment a line (inside the "/etc/mysql/my.conf" file) From: bind-address = 127.0.0.1 To: #bind-address = 127.0.0.1 Moreover, using a command like "netstat -putna" you can see in what port/ip are listening all services in your system. Regards,
When you do an installation of Koha (on Debian Linux) what port is mySQL on? Do you need to change anything to access it from another machine? (I'm sure I managed to access it before ...)
Thanks, Andrew --- Andrew Buxton, Library Web and Information Systems Manager Direct line: 01273 915795 - International +44 1273 915795 IDS website: http://www.ids.ac.uk/ Library website: http://blds.ids.ac.uk<http://blds.ids.ac.uk/>/
This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS.
Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Andrew, if your question is how to allow remote access to koha database, put bind-address = 0.0.0.0 on /etc/mysql/my.cnf, then restart mysql. AND mysql> grant "SELECT/ALL" on koha.* to 'koharemoteuser'@'192.168.1.XXX' identified by 'XYXYXY'; mysql> flush privileges; where you must specify the exact privileges you need to grant, the ip_address of the remote machine, and the username/password. Regards bgk 2010/3/9 Andrew Buxton <A.Buxton@ids.ac.uk>
When you do an installation of Koha (on Debian Linux) what port is mySQL on? Do you need to change anything to access it from another machine? (I’m sure I managed to access it before …)
Thanks,
Andrew
--- Andrew Buxton, Library Web and Information Systems Manager Direct line: 01273 915795 - International +44 1273 915795 IDS website: http://www.ids.ac.uk/ Library website: http://blds.ids.ac.uk/
This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS. Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Andrew Buxton -
Bernardo Gonzalez Kriegel -
Thomas Krichel -
Toni