[OpenSIPS-Users] having problems installing opensips-cp opensips.acc doesn't exist

[Paul Snom]

That was it!! As a very new newbie, I was under the impression the 'menuconfig' installation would take care of this. Again THANKS!!P
 Date: Sat, 8 Dec 2012 20:12:15 +0000
From: mimicafe at gmail.com
To: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] having problems installing opensips-cp opensips.acc doesn't exist


  
    
  
  
    Normally you would run
        "opensipsdbctl create"  to create the opensips database
        (including tables) during installation. I believe you can still
        go back and use it to create the tables because they are to
        omany of them and this makes life easier. 

        

        If you run it and it give an error that the db exist, then
        clonsider dropping the existing one (if it doesn't contain data)
        and have opensipsdbctl create it.

        

        Hoper this helps

        

        Mimi

      

      On 08/12/2012 19:59, Paul Snom wrote:

    
    
      
      
        thanks for the input, I will try to create this table manually,
         but at what point/step is this table created? 

         

        thanks

        P

         

        
          Date: Sat, 8 Dec 2012 19:26:36 +0000

          From: mimicafe at gmail.com

          To: users at lists.opensips.org

          Subject: Re: [OpenSIPS-Users] having problems installing
          opensips-cp opensips.acc doesn't exist

          

          Hi, 

              it says table acc does not exist (this is probably true).
              If you have followed all the steps correctly, then you
              shouldn't have this issue. Perhaps,  you should go on and
              create the acc table and then load the SQL again.

              

              Mimi

            

            On 08/12/2012 19:19, Paul Snom wrote:

          
          
            
             Hi;

               

              I'm having problems installing opensips-cp, these are my
              steps

              1. I manually create an empty MySQL 5.5 table 'opensips' I
              execute mysql -D opensips -p < cdrs.mysql  -> this
              creates 1 table 'cdrs'

              2. mysql -D opensips -p < opensips_cdrs_1_6.mysql

               

              when I exucute step 2 I get the error: ERROR 1146 (42S02)
              at line 2: Table 'opensips.acc' doens't exist

               

              Is there something I'm missing or overlooking? 

               

              Thanks

               

               

            
            

            
            

            _______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

          
          

          

          _______________________________________________
          Users mailing list
          Users at lists.opensips.org
          http://lists.opensips.org/cgi-bin/mailman/listinfo/users
      
      

      
      

      _______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    
    

  


_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121208/d1e1f14e/attachment.htm>