<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Is there a script that will migrate the DB from mysql to PG?<br>
<br>
<div class="moz-cite-prefix">On 03/18/2014 12:14 PM, Jason Hall
wrote:<br>
</div>
<blockquote
cite="mid:CA+ejggBQMTsHJv=wzSW7B1dNFE-CCe8w6+M3GoB8L6SgjfAqXA@mail.gmail.com"
type="cite">
<div dir="ltr">The mysql code doesn't work on v3 on firstly
because it's poor handling of CASE statements (basically
converts each clause to a join, and quickly hits its join
limit).
<div><br>
</div>
<div>Switching to PG is worth it. And the development branches
have a lot in store for the future.</div>
<div><br>
</div>
<div>If you *really* want mysql, you would need to do some
pretty heinous rewrites of the Event code.</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Tue, Mar 18, 2014 at 7:54 AM, John
Wilson <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:johnwilson1969@gmail.com" target="_blank">johnwilson1969@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">I am not the dev. but from what I understand
version 2.3.7 is it for mysql. I looked at migrating to
mysql before updating to 3.0, because I already have a
mysql cluster, but shelved plans due to 3.0 not working
with mysql.
<div>
I never had any issues with Freeside 2.3, and for my
use, I didn't really gain anything from the 3.0 upgrade
(as far as new features or functions). BUT, there is
something to be said for running currently supported
code. I have a feeling help/support for 2.3.x will
become harder and harder to get as time goes on. I just
had to bite the bullet and run a separate postgres
server and hope either I or someone else can come up
with the funds to support some mysql code work in the
near future.</div>
</div>
<div class="HOEnZb">
<div class="h5">
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Tue, Mar 18, 2014 at 7:54
AM, Chandrakant Solanki <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:solanki.chandrakant@gmail.com"
target="_blank">solanki.chandrakant@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_default"
style="font-family:verdana,sans-serif">So
MySQL is working with freeside 2.3 version.<br>
<br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">or
please let me know which version I used to
mysql support with freeside<br>
</div>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Fri, Mar 14,
2014 at 9:15 PM, John Wilson <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:johnwilson1969@gmail.com"
target="_blank">johnwilson1969@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex">
<div dir="ltr">
<pre style="white-space:pre-wrap">As far as my understanding (from a mailing list entry from Ivan back in Nov 2013), MySQL is not supported in version 3 and later. Must use Postgres.</pre>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
<div>
<div>On Fri, Mar 14, 2014 at 6:00
AM, Chandrakant Solanki <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:solanki.chandrakant@gmail.com"
target="_blank">solanki.chandrakant@gmail.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div>
<div>
<div dir="ltr">
<div class="gmail_default"><font><span
style="font-family:verdana,sans-serif">Hi All,<br>
<br>
</span></font></div>
<div class="gmail_default"><font><span
style="font-family:verdana,sans-serif">Freeside: 3.2 (with MySQL DB)<br>
<br>
</span></font></div>
<div class="gmail_default"><font><span
style="font-family:verdana,sans-serif">Follow below installation &
configuration URL<br>
<a
moz-do-not-send="true"
href="http://www.freeside.biz/mediawiki/index.php/Freeside:3:Documentation:InstallingOnDebian7"
target="_blank">http://www.freeside.biz/mediawiki/index.php/Freeside:3:Documentation:InstallingOnDebian7</a><br>
<a
moz-do-not-send="true"
href="http://www.freeside.biz/mediawiki/index.php/Freeside:2.3:Documentation:Installation#Installation"
target="_blank">http://www.freeside.biz/mediawiki/index.php/Freeside:2.3:Documentation:Installation#Installation</a><br>
<br>
</span></font></div>
<div class="gmail_default"><font><span
style="font-family:verdana,sans-serif">I have followed all steps one by
one ...<br>
<br>
</span></font></div>
<div class="gmail_default"><font><span
style="font-family:verdana,sans-serif">But, when I execute below command
as freeside user it
gives me error.<br>
<br>
</span></font></div>
<div class="gmail_default"><font><span
style="font-family:verdana,sans-serif"># freeside-setup -d <a
moz-do-not-send="true"
href="http://example.com" target="_blank">example.com</a><br>
</span></font></div>
<div class="gmail_default">
<pre><font><span style="font-family:verdana,sans-serif">freeside-setup -d <a moz-do-not-send="true" href="http://mdusolutions.net" target="_blank">mdusolutions.net</a>
Loading schema objects
Connecting to database
Creating tables and indices
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range decimal NULL ,
PRIMARY KEY (sectornum)
)
ENGINE=InnoDB' at line 10 [for Statement "CREATE TABLE tower_sector (
sectornum INTEGER NOT NULL AUTO_INCREMENT,
towernum int NOT NULL ,
sectorname varchar(80) NOT NULL ,
ip_addr varchar(15) NULL ,
height decimal NULL ,
freq_mhz int NULL ,
direction int NULL ,
width int NULL ,
range decimal NULL ,
PRIMARY KEY (sectornum)
)
ENGINE=InnoDB"] at /usr/local/bin/freeside-setup line 117.
CREATE error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range decimal NULL ,
PRIMARY KEY (sectornum)
)
ENGINE=InnoDB' at line 10
doing statement: CREATE TABLE tower_sector (
sectornum INTEGER NOT NULL AUTO_INCREMENT,
towernum int NOT NULL ,
sectorname varchar(80) NOT NULL ,
ip_addr varchar(15) NULL ,
height decimal NULL ,
freq_mhz int NULL ,
direction int NULL ,
width int NULL ,
range decimal NULL ,
PRIMARY KEY (sectornum)
)
ENGINE=InnoDB at /usr/local/bin/freeside-setup line 117
</span></font></pre>
<font><span
style="font-family:verdana,sans-serif">Any
help plz.<br>
<br>
<font>--<br>
</font></span></font></div>
<div class="gmail_default"><font><span
style="font-family:verdana,sans-serif"><font><font>Chandrakant Solanki</font><br>
</font></span></font></div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
freeside-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:freeside-users@freeside.biz"
target="_blank">freeside-users@freeside.biz</a><br>
<a moz-do-not-send="true"
href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users"
target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
_______________________________________________<br>
freeside-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:freeside-users@freeside.biz"
target="_blank">freeside-users@freeside.biz</a><br>
<a moz-do-not-send="true"
href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users"
target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
freeside-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:freeside-users@freeside.biz"
target="_blank">freeside-users@freeside.biz</a><br>
<a moz-do-not-send="true"
href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users"
target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
freeside-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a><br>
<a moz-do-not-send="true"
href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users"
target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Jayce^<br>
<br>
Preparing Deseret - UtahPreppers<br>
ΜΟΛΩΝ ΛΑΒΕ
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
freeside-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a>
<a class="moz-txt-link-freetext" href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br>
</body>
</html>