Xibo

Xibo Database

Asked by Carl Wharton

Hi. We are looking to use Xibo for a new community project, and would like some advice on a current issue.

At present we have a website and a mysql database hosted by a Fasthosts which will store all our client infomation on. What we would like to do is have Xibo database talking to our database.
Basically our comcept is that you go to our website, choose a screen you would like to have your advert displayed, then you pay and then the info goes from our database to Xibo.

Would grateful of any help on this.

Many Thanks

Carl Wharton

The first problem we have is using the installer. We want to put the Xibo datasets into an existing database. Although I am using a root password, the installer keeps coming back with a mysql error - Access denied for user 'root'@'88.208.252.205' (using password: YES) - Yep that old chestnut. Although I have looked at the documentation I am still at a loss at what the installer actually wants on the input setup screen.

Question information

Language:
English Edit question
Status:
Answered
For:
Xibo Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Josef Biehler (gabbersepp) said : 		#1

Have the advertisments always the same type?
e.g. always banner or always flash files?
Because if you do so, all you need is following:

The booked ads are stored in your database.
A php Script "display.php" gets included into a region of every screen.
Lets say you have 3 displays than every display should have a region including display.php by using a parameter.
Display1: display.php?displaynumber=1
Display2: display.php?displaynumber=2
Display3: displ,ay.php?displaynumber=3

The script will then get the current ad, based on the displaynumber.

The display.php's logic will be something like:

$ads = get_add_for_display_that__is_booked_for_timespan($displaynumber, $start =time(), $end = time()+5minutes);
echo build_output_for_ad($ads);

should work. And you won't have to customize your existing Xibo Installation (thats better at all, because you can update to the next release without having in mind all the changes you have made to let xibo synchronize your ad data from your database).

Hope you understand, my english isn't very good.

Revision history for this message
Carl Wharton (carl-wh) said : 		#2

Now I'm getting 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'. Regards

Revision history for this message
Alex Harrington (alexharrington) said : 		#3

You almost certainly don't want to install in to an existing database unless it's empty.

Installing Xibo in shared hosting is almost always a bad idea. It just isn't really suitable. You ideally need a VPS or a hosted instance of Xibo from a company that specialises in that kind of thing.

Alex

Revision history for this message
Carl Wharton (carl-wh) said : 		#4

Hi Alex, which the preferred method?
Are you saying that I need a Offce based Server with Xibo Server installed?
Can I then link the 2 databases together??

Revision history for this message
Dan Garner (dangarner) said : 		#5

Linking Xibo to a 3rd party data source is certainly possible - however you will be needing programming skills to achieve this.

Shared hosting (like fasthosts) is not always a good idea with Xibo, although it can work. I very much doubt they will allow remote access to MySQL though (you probably have to use it from root@localhost)

Sounds like you'd be better of asking someone to take on this work for you.

Can you help with this problem?

Provide an answer of your own, or ask Carl Wharton for more information if necessary.

To post a message you must log in.