Andrea Ted
Posted in Technical Support 3 years ago
Hello everyone!
I have a problem with the database. I created a script external to the server where ossn resides, which should retrieve the data contained in the ossndb-> ossn_users table. When I do the query from my php I can't reach the databases. I tried to create a new user on mysql, but I get the error that tells me I don't have the privileges, I tried to add all the privileges to the existing ossndb user, but this too didn't work out. Anyone know how to help me?
Thank you
Roman Jay Almaza
Replied 3 years ago
Really helpful stuff Michael Zülsdorff. Got it working. I had the same problem.
Michael Zülsdorff
Replied 3 years ago
Can't quite follow. To create new Ossn members remotely or fetch some data of already existing members remotely, all you need is a database user with granted remote access to the Ossn database and not a 'root' user with general access to your mysql server.
Aside from that: Why don't you simply use Ossn's API to handle your requests? See
https://www.opensource-socialnetwork.org/webservices/all?offset=4
Andrea Ted
Replied 3 years ago
Hi Michael thanks for the reply, but I have already followed that documentation and it is not useful, since I need the proivreads of the user mysql to create another user. The bind I have already done but it is useless if I do not enable a root user with all privileges. Thank you
Michael Zülsdorff
Replied 3 years ago
here is a how-to showing the steps to enable remote database access:
https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
Due to the many requests in the past for additonal features and components we have decided to develope a premium version. Features like Hashtags, Videos, Polls, Events, Stories, Link Preview, etc included in it.
$199 (Life Time)
