Server :: Accessing Database In FBD Data File
Feb 19, 2011
We purchased a new database system at work last October, ditching the old system because of a lack of support from the vendor. This is a retail Point of Sale and Backoffice database system. I am not sure what system the new one runs on, but the system we replaced was a Firebird data base. The reason I am posting is because we are now in need of the information contained in the old database which was not completely imported into the new system. Unfortunately, we parted company with the old vendor under extremely hostile conditions, and they are not a source of help for this problem, nor are the new vendors.
Basically the problem is this: The database in on a Windows XP system and I found a copy of SQL Manager Lite 2008 on the system, which after quite a bit of studying, I figured out how to extract the database into a removable file. I have this file (178MB) on a USB stick in a file called Backoffice.fbd. I can get into this database with MySQL. All I want to be able to do get into the database and create tab deliminated spreadsheet files for each of the database sections (Customers, Repairs, Sales History, stock files, etc.) Is it possible to do this with Ubuntu and MySQL and if so, can an expert suggest one or two things to get me started.
View 3 Replies
ADVERTISEMENT
Nov 16, 2010
Is it possible to setup apache to normally block an IP from accessing a site until that IP is in a database/file?More or less, I need a login system that another script can add/remove the IPs and the site can be accessed by only those IPs.
View 1 Replies
View Related
Aug 26, 2010
I have a CSV called source1 with data like:
Date12:00:00 AM12:30:00 AM01:00:00 AM01:30:00 AM02:00:00 AM02:30:00 AM03:00:00 AM ...
07/31/1051.5252.4852.6452.863.3663.8445.6 ...
08/01/1049.4449.9261.2860.1652.6449.1247.52 ...
08/02/1049.1248.9648.9650.7260.1658.0851.04 ...
08/03/1060.3260.6459.260.9637.9233.2832.8 ...
[Code].....
Also, the CSV file is updates every few hours and I need to load any new data from the file to the database without creating duplicates of data that has already been loaded to the database.
View 6 Replies
View Related
May 29, 2010
I have a LAMP server. I know sql but I'm currently learning PHP.
Correct me if I'm wrong, but you're supposed to use PHP to insert/select data from the database, right? If so, SQL shouldn't need a port at all.
Apache uses port 80, but it's listening for connections. MySQL uses port 3306, but I've never logged into it from anywhere besides 127.0.0.1/localhost. I have mysqladmin installed and it demands that I give it an IP so I used localhost.
I'm not interested in doing anything remote, so can I block this port? When I say "block" I mean on the router, not locally through iptables. Obviously I have to foward port 80 because that's how people would connect to my server. But once they connect and send something, my server would interpret the data locally and send it back on port 80.
View 8 Replies
View Related
Mar 4, 2010
I have try to sync my MySQL Server database and HLDS Data on lan,one is windows server 2008 and one is Ubuntu Linux 9.10 i have try to use the remote address(192.168.0.4:3306) but can't connect and say the error code is 10060 i have check the connect is normal and ok,the accont is can let any address to contro.
View 1 Replies
View Related
May 12, 2011
i get some trouble setting up good environment in linux.i have problem regarding connecting php(under linux) to a sybase server(under windows)is there anyway connecting this two technologies?.
View 1 Replies
View Related
Mar 10, 2011
I have an application running on a centOS machine that needs to access a database on a CentOS server. I granted access to all users with a certain user name and password.i opened up port 3306 as well with the following command: /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPTbut whenever i try to connect from my machine i get an error:ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.102.129' (113)I am using mysql version 5.0.77 on centOS 5.5.
View 1 Replies
View Related
Jul 16, 2010
i have two machines at home running ubuntu linux and windows connected by lan. on ubuntu machine i have mysql installed, how do i go about accessing ubuntu mysql database on my windows machine.
View 2 Replies
View Related
May 12, 2011
I get some trouble setting up good environment in linux.. i have problem regarding connecting php(under linux) to a sybase server(under windows),,, is there anyway connecting this two technologies?..
View 7 Replies
View Related
Mar 22, 2010
I mean, isn't that exactly how normal home users can visit search engines such as Google or Bing and search for information?
View 7 Replies
View Related
Jun 19, 2010
I have 3 linux systems configured for running applications in each, named system1, system2 and system3. I have around 100 GB of space in system3 under /usr but not much being used. In System1 very less space is there but mostly hits coming here and need to have proper backup, as the system1 is quite old and not planned partitons properly. So I want to use a disk having more space for backup requirements.
View 17 Replies
View Related
Nov 1, 2010
i am having a problem while hosting a website on rhel apache server.when i write the url on browser than its doesnt show any page ,neither it displays any error.However when i am hosting a simple php webpage apart from that website its works fine.i also want to know how can i import a databe file in mysql which is a part of that website.
View 3 Replies
View Related
Jan 25, 2010
I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard
100m ext2 boot
2000m swap
* / ext3
now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?
View 11 Replies
View Related
Jun 23, 2011
We have Nagios and Pnp4nagios which saves performance data in hostperfdata and serviceperfdata files.Now we are migrating our system to centreon which will have NDO.
This will save the performance data to Mysql database.The requirement here is to feed current performance data file to NDO mysql database.
View 1 Replies
View Related
Mar 30, 2011
I just received a 2 tb drive for my server to be. The pc is a P4 3.06 ghz with 4 gb of ram. I have found a number of posts on this forum, as well as on the net in general, about setting up a file/print server at home. What I want to be able to do is to access my server through the internet from my office computer (windows 2000) How can I do that? I have not yet spent much time trying to decide which distro I will use. It seems that a number of them are suitable for this purpose, so I just plan to try several from a live cd and then choose one.
View 1 Replies
View Related
Oct 31, 2010
Code:
kenny_strawn@kenny-AOA110:~$ sqlite3 -html -line /var/www/fluxbb/ProprietarySuckware 'select o_base_url from memos'
Error: unable to open database "/var/www/fluxbb/ProprietarySuckware": unable to open database file
kenny_strawn@kenny-AOA110:~$
This database was automatically generated by FluxBB, so I am wondering just why it isn't opening.
View 2 Replies
View Related
Jun 21, 2011
iam trying to sync file server data into backup server machine by command- rsync -avu path/of/data ipaddress-of-backup-server:/path/where/to/save after running it ask for root password and manually it is successful.but i want to make it automatic.for that i also tried cronjob and also generated authentication key but iam not successful in login automatically..anybody know how to authenticate root to login for storing data in backup server.
View 14 Replies
View Related
Jan 25, 2011
I've got 4 identical 1 TB drives and would like to use them in a software RAID configuration on my home server. I'm running Debian Linux using 'mdadm' utility to manage the software RAID. I don't know how much I've read is fact or dated or even false so I decided I would ask here to get help from people who know more about this than I do. This is essentially just a file server machine to store all my data so being that I've got four identical SATA hard drives, I was thinking about doing RAID level 5. I guess I'll start here and ask if that is the recommended level of RAID. I think RAID level 5 will be fine for my general server usage. My second issue is partitioning the four individual drives to get maximum performance / space from them. Basically just asking here how would you or you recommend I partition the drives? I was thinking about doing three seperate partitions per drive:
/dev/sda1 = 4 GB (swap)/dev/sda2 = 1 GB (/boot)/dev/sda3 = 995 GB (/)Now from that partition schema above, obviously all the types will be 'fd' for RAID and the partition for /boot is going to be bootable. My confusion is that I read Grub doesn't support booting from RAID 5 since Grub can't handle disk assembly. If /dev/sdx2 (sda2, sdb2, sdc2, sdd2) are partitioned for /boot (bootable), how would you guys configure this RAID to match up equally? I don't think I do a RAID level 1 on 4 identical partitions, right?
View 1 Replies
View Related
Jul 15, 2010
I backed up my windows hard drive using dd and turned it into one huge image file. I didn't realize this beforehand, but this image is not an ISO equivalent type. However, it would be nice if I could access everything on the image just by mounting it instead of having to transfer it back to /dev/sda or something.
View 5 Replies
View Related
Apr 10, 2010
I'm using ext3 and I have my / partition on sda3. This is a full install, it has /bin /home etc etc on it, the only thing I have is sda1 is /boot and sda2 is swap.
I've configured my system to mount sda4 as /home/user as the system boots up, which puts all of my data on sda4.
My question is this. How do I access any data left in (sda3) /home/user? (Because trying that won't work). Is there some way to use a direct path? Like /device/sda3/home/user?
View 1 Replies
View Related
Feb 18, 2011
I use ubuntu lucid 10.4. I would like to monitor stock prices in realtime with a web browser and generate spreadsheets. Is there a program to scrape the data from the screen and put it into an openoffice spreadsheet so that I can categorize the data appropriately? I would like to do this in realtime if possible. Perhaps a firefox addon or chrome extension. I have searched for this for a while and think I may have to write my own code, which would be okay, but I imagine that there is some open source code out there that would work or can be changed a little to suit my needs.
View 3 Replies
View Related
May 3, 2010
I have written an application which has more than 6 threads.Two threads share a common linked list. Out of two threads one thread reads the linked list node and other thread writes to linked list node.I am using pthread_mutex_lock() API to achieve synchronisation between having access to common linked list. The problem is the first thread which reads the linked list accesses the mutex faster making other thread to starve.
I want both the thread to have an access to mutex. It should not happen that always first thread locks, releases and relocks it. The first thread almost require to access the link list every 5 msec which is causing second thread not to gain the mutex.How should I fix this? For information, I am running this application on PXA270 ARM platform.
View 4 Replies
View Related
Jan 10, 2011
I started using Ubuntu's chat tool the other day, I gave it my Gmail username and password,and lo! it found my list of CONTACTS FROM INSIDE GMAIL!Facebook has done the same thing as well! Was this in Google's terms? Can't something be done about this? This is SCARY.But also, a small part of me wants to know how it was done (only a small part, this protocol sh*t is not particularly challenging, right?
View 14 Replies
View Related
May 29, 2011
Please tell me spesification if i want buid mail server on ubuntu 10.04 with good features :
1. For MTA ??
2. For Mail Filtering ??
3. For MDA ??
3. For Webmail ??
4. For Mailling List ??
View 3 Replies
View Related
Jul 19, 2010
I have set up a MySQL database which has only three fields for user-name, password and index number. But there is a LOT of data (thousands of columns) which would take too long to enter manually. I'm sure MySQL must have a file format whereby a single large file containing different data types can be successfully automatically imported and the various data elements distributed to their intended fields. Does anyone know which characters MySQL uses as field seperators for this formatting of data, or is there a program already written which can take raw data and organize it into a SQL compatible file?
View 8 Replies
View Related
Apr 13, 2011
I have a need of a database, and the information to go into it. I know how I want to organise my data for optimal cross referencing, but what I know is merely what I know and I do not know if what I know is what is known...
Madness to say... looking at my database I see this is the best way to organise the data, but what I do not know is how the computer will respond to my methodical madness.
Is it quicker to have one table with many fields or many tables with few fields?
We've got information for 10 users with 17 idiosyncrasies.
So, would one table with 17 columns and 10 rows... or... a group of 50 tables with one column and 3 rows and one table with 4 columns and 5 rows...
Be more efficient concerning:
QUERIES...?
Searching?
Comparison?
Insertion?
Deletion?
Modification?
The queries and modifications will be daily, and constant. These numbers are really much larger but the math is easier for me to articulate on a smaller scale. I use Perl, php, and C with SQL for management.
View 14 Replies
View Related
Aug 3, 2010
I have a laptop dual booted with windows vista and ubuntu.I downloaded certain movies and music files while using windows vista,which are there in my hard disk,My question is can i access these music and video files when i boot into ubuntu,and can i play them?
View 5 Replies
View Related
Jun 28, 2010
I am using an embedded platform in which I have connected an external harddisk (/dev/sda). The SCSI driver is present and I am using the SG_IO interface for performing the SMART commands with the Hard Disk. (Unfortunately not all the HDIO ioclts are present. So I opted for the SG_IO ioctl). But the data transfer (reading/write data from/to sector) is not working with the SG_IO ioctls. So I searched for some other options. Later in one of the places, I found that we can actually mount the /dev/sda to some mount point in /mnt and then make a XFS file system (mkfs.xfs) of this.
And then we can create the directories and do file operations on this mounted directory. Here the simple read/write systems calls can be used for this. I was thinking about this implementation. But I am confused how I can map the actual LBA (Logical Block Address) to the device file offset. I mean if I want to write to the sector 5, there will be a LBA for it. So I can do lseek on my device and then write the data there. So how the mapping between LBA and device file offset can be calculated.
View 4 Replies
View Related
Jun 11, 2010
I have a php script that creats some files and moves them into certain directories. When the files are created, the ownership is www-data:www-dataWhen they are moved to the appropriate directories the maintain that. But, I need the files' ownership to be changed to asterisk:asteriskHowever, www-data doesn't have permissions to do this. I don't want to run a cron as root that does this (I'm already doing that). I really wish there was a way for my files to be created via my php script and in that same file do something like:
system("chown asterisk:asterisk /home/test/test.call");
View 7 Replies
View Related
Oct 20, 2010
i've been using php/fwrite to add text to a file using the below code but how do i remove text from a file? note that i don't know what line it's on as there will be other content in the file.
View 5 Replies
View Related
